looker.com
A window into the soul (of your data)
9 min · · A lesser known feature of some SQL dialects is the · Shared by 5, including Evan (he/him)
postgresqltutorial.com
PostgreSQL Window Functions
7 min · · Summary: in this tutorial, you will learn how to use the PostgreSQL window functions to perform the calculation across a set of rows related to the current row.Setting up sample tablesFirst, create… · Shared by 6, including Evan (he/him)
postgresql.org
Window Functions
20+ min · · Window functions provide the ability to perform calculations across sets of rows that are related to the current query row. See Section 3.5 for an introduction to this feature. The built-in window… · Shared by 4, including Evan (he/him)
citusdata.com
Fun with SQL: Window functions in Postgres
3 min · · Yet another 'Fun with SQL' post from the engineers at Citus Data, this post is about window functions in PostgreSQL. Super valuable for when you want to compare & contrast data, window functions are key in analytics use cases. SQL is so expressive. When it comes to analyzing your data, we believe there really isn't any better option. · Shared by 9, including Evan (he/him)
help.looker.com
A Window Into the Soul (of Your Data)
5 min · · A lesser-known feature of some SQL dialects is something called the "window function." While MySQL users will be left out in the cold, most other SQL dialects can take advantage of their ... · Shared by 5, including Evan (he/him)
confluent.io
Using Kafka to Discover Events Hidden in your Database
· Shared by 7, including Evan (he/him)
MongoDB
DaaS with MongoDB and Confluent
8 min · · An Operational Data Layer (or ODL) is an architectural pattern that centrally integrates and organizes siloed enterprise data, making it available to consuming applications · Shared by 9, including Evan (he/him)
medium.com
Breaking into Big Data at SnapTravel
15+ min · · Big Data. The Two Favourite Words of Every Data Engineer! · Shared by 6, including Evan (he/him)
Uber
Revolutionizing Money Movements at Scale with Strong Data Consistency
8 min · · Uber as a platform invites its users to leverage it, earn from it, and be delighted by it. Serving more than 18 million requests per day, in 10,000+ cities, has enabled people to move freely and to think broadly while earning a livelihood on it. As one of the underlying engines, Uber Money fulfills some of the most important aspects of people’s engagement in the Uber experience. A system like this should not only be robust, but should also be highly available with zero-tolerance to downtime, after our success mantra: “To collect and disburse on-time, accurately and in-compliance”. While we · Shared by 12, including Evan (he/him)
medium.com
How should our company structure our data team?
18+ min · · Real-life learnings from five data team iterations: centralized, embedded, full-stack, pods and business domains. · Shared by 13, including William El Kaim, Evan (he/him)
martinheinz.dev
Advanced SQLAlchemy Features You Need To Start Using
11+ min · · Working with SQL in Python can be easy with SQLAlchemy and its hybrid properties, nested queries, table metadata, dialects and more! · Shared by 13, including Evan (he/him), Real Python
pgmetrics.io
pgmetrics
1 min · · Collects information about WAL archiving, BG writer, backends (waiting, idling, transaction too long), vacuum progress, replication (primary, standby, publications, subscriptions), replication slots… · Shared by 8, including Evan (he/him), Golang Weekly
Uber
Why Uber Engineering Switched from Postgres to MySQL
20+ min · · The early architecture of Uber consisted · Shared by 16, including Matt, Evan (he/him), Dr. Ganapathi Pulipaka 🇺🇸, Ahrbil
github.com
dhamaniasad/awesome-postgres: A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql
· awesome-postgres - A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql · Shared by 26, including Brian, Helmi, yawniek 📯, Evan (he/him), Jon Thompson, Francis DB
tatiyants.com
How To Navigate JSON Trees in Postgres using Recursive CTEs
4 min · · Tutorial on using Postgres recursive Common Table Expressions (CTEs) to navigate a JSON tree structure. · Shared by 4, including Evan (he/him)
Uber
Why Uber Engineering Switched from Postgres to MySQL
20+ min · · Uber Engineering explains the technical reasoning behind its switch in database technologies, from Postgres to MySQL. · Shared by 294, including César Suárez, Jacob Jarnvall, Evan (he/him), Dominik Grolimund, Diogo Mónica, PotHix, Jens-Christian Fischer, Cameron Yick ~ @hydrosquall@vis.social on mastodon, Emerson Macedo, Thomas Power, Florian Hanke 🍎, Charles Kubicek, Christophe Jean, Simone Corsi 💻🚀, Marius Bleuer, CarloZen