data subTLDR week 33 year 2026

City2Graph is a well-received Python library transforming geospatial data into analysis-ready graphs for spatial and network analysis, and Graph Neural Networks. It effectively models cities as heterogeneous graphs, accommodating different elements like buildings, streets, and various transportation modes. The library allows for simple conversion to tensors for machine learning models and supports conversion to formats like GeoPandas, NetworkX, PyTorch, etc. The overall sentiment towards City2Graph is highly positive, with users appreciating its innovative approach to urban data modeling and its potential use in various research scenarios.

A user manually set the weights of a transformer to perform exact arithmetic, such as multiplication, showing that transformers can indeed compute accurately if their weights are directly chosen. This approach, which bypasses the need for training, achieved 100% accuracy even with longer number strings, unlike other models. Some commenters likened the work to 'The Game of Life' study and the 'Lottery Ticket Hypothesis,' suggesting that pre-existing subnets within neural networks may already perform tasks well, and training simply amplifies these. Others noted this method's relevance to state tracking tasks, which transformers typically struggle to learn. The overall sentiment was positive, with users appreciating the innovative approach.

SSOG (Sum Of Separable Gaussians) offers a faster, more memory-efficient alternative to Scaled dot-product attention (SDPA) in image processing, reducing complexity from O(N²·d) to O(N·√N·d). It performs better on small data and has equivalent performance on larger datasets. The method uses Gaussian atoms, steered based on query tokens. Suggestions from the community include approximating the Gaussian kernel with a box kernel for efficiency and exploring Gaussian processes literature. However, there are concerns about the gradients provided by box kernels. The use of AI in the project's code and blog-post raised some questions, but the creator stands behind the work. Overall, the sentiment is positive with appreciation for efforts to improve learning efficiency.

The majority of Reddit users support the idea of leaving the current company for the new offer, citing the fact that the current company only increased the salary after the decision to leave. The sentiment is negative towards the current company due to their delayed reaction in recognizing the employee's worth. Users highlighted that the new company not only offered a higher salary, but also showcased their value for employees. They emphasized that the employee's guilt over leaving the boss should not hinder their career progression. They also suggested that the current employer's sudden counter-offer indicates a lack of genuine appreciation for the employee's contributions.

The developer successfully compiled Doom's rendering algorithm into a 21 billion-parameter transformer, a significant feat that demonstrates the potential of machine learning in graphic rendering. Despite running at only 35 frames per day, the project is impressive as a proof of concept. It is suggested that increased parallelism could significantly improve performance as the current model requires a complete transformer pass for each operation. While some questioned the impact of model quantization, it was clarified that in this scenario, it would likely lead to data corruption and gibberish output due to the direct operation in the space of digital logic.

The thread primarily emphasizes that transitioning from a mid to senior level position is less about years of experience and more about problem-solving, dealing with ambiguity, and demonstrating leadership—traits considered essential for senior roles. Many commenters opined that the ability to identify and solve problems independently, especially in ambiguous situations, is a core competency expected in senior roles. The concept of 'known unknowns' and the ability to navigate them proficiently was also touched upon. Some commenters noted potential issues with the original poster's communication and perspective, emphasizing the importance of effective articulation and a collaborative mindset. A prevalent suggestion was to discuss a defined plan for promotion with the manager. The sentiment was mixed, with a focus on constructive advice for career advancement.

Both 's-q-l' and 'seequal' are considered correct pronunciations for SQL, reflecting the language's naming history from SEQUEL (Structured English Query Language) to SQL due to a trademark conflict. The pronunciation can also vary depending on the Database Management System (DBMS) and individual guides. For example, 'seequal' is used for Oracle and Microsoft SQL Server, while 's-q-l' is common for SQLite and MySQL. Ultimately, the pronunciation can depend on personal preference or workplace convention. The thread sentiment was mixed, reflecting the lack of a definitive answer and the variations in personal and professional usage.

The community showed a highly positive response towards the data analysis-themed cat doodle. The creative and fun approach was widely appreciated, with many users expressing their enjoyment and requesting more of such content. Some even expressed a desire to display these doodles in their own spaces. There was also a playful comment recognizing an unintended narrative in the doodles, suggesting a 'fight club' scenario of an overworked single cat. Overall, the sentiment was supportive and encouraging towards the creator's unique approach and the quality of the artwork.