🔍 Query Optimization - widget101 · Scour

Ace Your SQL Interview, Part 2: Querying Like a Pro ⚙️Database Internals

betterengineers.substack.com·2d·r/programming·

new world: writing complex queries in seconds 🧮Apache Calcite

alodb.com·4d·r/programming·

ProjectASAP/ASAPQuery: Drop-in Acceleration of SQL/PromQL queries 🧮Apache Calcite

github.com·23h·Hacker News·

B+Tree vs LSM Tree: Why Your Database's Data Structure Is Everything 🗃️Database Storage

dev.to·17h·DEV·

Show HN: An Interactive Text to SQL Agent Benchmark 📊Columnar Engines

sql-benchmark.nicklothian.com·2d·Hacker News·

Database Performance Bottlenecks: N+1 Queries, Missing Indexes, and Connection Pools ⚙️Database Internals

howtocenterdiv.com·6d·Hacker News, r/coding, r/programming·

Schemity vs dbdiagram.io: When Your ERD Tool Needs to Outlive the Meeting 🧊Iceberg Tables

schemity.com·6h·DEV·

A C# vector database using TurboQuant from Google Research 🧭Vector Databases

turboquant.relatude.com·2d·Hacker News·

The reason your pgvector benchmark is lying to you 📊Columnar Engines

thenewstack.io·6d·

Understanding Data Modelling in Power BI: Joins, Relationships, and Schemas Explained 📐Data Modeling

docs.google.com·3d·DEV·

Architecting for Speed: Advanced SQL Performance Tuning in the Lakehouse 🏛️Lakehouse Architecture

hackernoon.com·6d·

Debugging PostgreSQL Query Plan Instability in Production 📊Column Stores

dev.to·2d·DEV·

GA4 Data Quality Monitoring with BigQuery SQL ⏱️Real-time Analytics

paolobietolini.com·4d·

Dux: Distributed DuckDB-native DataFrames for Elixir 🌟spark

dux.now·5d·Hacker News·

Hybrid Search System, glue included 🧮Apache Calcite

amgix.io·4d·Hacker News·

Build a Production‑Ready SQL Evaluation Engine for LLMs ⚙️Query Compilers

dev.to·2d·DEV·

A database toolkit with auditable schema versioning 🧊Iceberg Tables

chameleondb.dev·3d·Hacker News·

DB Explorer – free Java desktop SQL client with live DB health dashboard 🎯Materialized Views

sourceforge.net·4d·Hacker News·

Oracle & SQL Server to PostgreSQL – Migration Tooling Gotchas No One Warns You About! 💾Databases

databaserookies.wordpress.com·6d·

Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas Explained 📐Data Modeling

dev.to·1d·DEV·

Loading more...