Best of Data Management — August 2024

1. 1
   Article

   Community Picks·2y

   Bring Postgres relationships to light

   Entity-relationship diagrams (ERDs) are invaluable for visualizing and managing complex Postgres databases. ERDs showcase entities, attributes, and relationships, making database structures more accessible, especially for non-technical team members. Tools like Outerbase simplify the creation and maintenance of ERDs by automatically generating and updating diagrams for Neon databases. This democratization of data aids developers in understanding, communicating, and scaling database schemas efficiently.

   49
2. 2
   Article

   Spotify Labs·2y

   Unlocking Insights with High-Quality Dashboards at Scale - Spotify Engineering

   Spotify's decentralized approach to dashboard creation involves data scientists using tools like Tableau and Looker Studio to produce over 4,900 dashboards used by 6,000 employees in 2023. To ensure consistency and quality, Spotify employs a Dashboard Quality Framework comprising automatic checks and a best practices checklist. Dashboards are accessible through a searchable Dashboard Portal, which supports curation and displays quality labels to help users trust the data. The approach empowers employees to make informed, data-driven decisions and optimize dashboard usage.

   12

   1
3. 3
   Article

   Hacker News·2y

   SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL

   SQL, while a widely-used standard for data querying, has significant design issues. GoogleSQL tackles these by introducing piped data flow syntax, which makes SQL more flexible, easier to learn, and simpler to extend. This approach improves SQL without needing a new language or extensive migrations, enhancing productivity within the existing SQL ecosystem.

   11
4. 4
   Article

   Last9·2y

   Control Plane: A centralized place to manage your data and its settings

   Control Plane centralizes the management of data policies and settings for ingestion, storage, and queries. It also aids in debugging with tools like Cardinality Explorer and Slow Query Logs. Recent updates include support for Logs, Traces, Metrics, and Events pipelines, as well as segregation of settings by organization and user. Notification Channels are now managed in Alert Studio alongside other alert configurations.

   11