🔍 Query Optimization - widget101 · Scour

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

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

Database Performance Strategies and Their Hidden Costs 📇Indexing Strategies

blog.bytebytego.com

·9h·

new world: writing complex queries in seconds 🧮Apache Calcite

alodb.com·5d·r/programming·

What if SQL could search by meaning? Meet VelesQL 💾Databases

dev.to·7h·DEV·

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

github.com·1d·Hacker News·

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

thenewstack.io·6d·

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

schemity.com·14h·DEV·

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

docs.google.com·4d·DEV·

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

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

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·5d·

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·

A database toolkit with auditable schema versioning 🧊Iceberg Tables

chameleondb.dev·3d·Hacker News·

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

dev.to·1d·DEV·

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

sourceforge.net·5d·Hacker News·

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

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

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

dev.to·1d·DEV·

NPoco vs UkrGuru.Sql: When Streaming Beats Buffering 📊Column Stores

dev.to·6h·DEV·

PostgreSQL Row-Level Security for Multi-Tenant SaaS 🛡️Memory Safety

dev.to·1d·DEV·

Loading more...