🔍 Query Optimization - hello · Scour

Not all index scans are equal: How we cut query latency by over 99% 📇Index Selection

datadoghq.com·4d·Hacker News

Mastering the Basics: A Deep Dive into SQL Fundamentals 🔥DataFusion

dev.to·11h·DEV

Decoupling Vector Data and Index Storage for Space Efficiency 📋Columnar Storage

arxiv.org·1d

A Guide for Advanced SQL Joins: ASOF, SEMI, and ANTI joins in ClickHouse 🔗Join Algorithms

glassflow.dev·8h·r/programming

Traversing JDBC Results 🌊SeaORM

chuggid.bearblog.dev·1d

SkardiLabs/skardi: Run SQL across Relational DBs, Data Lakes, S3, MongoDB, Redis, and vector stores. Turn any query into a REST API. Built on Rust + Apache DataFusion. 🐢Turso

github.com·4h·Hacker News

Introducing Metrics SQL: A SQL-based semantic layer for humans and agents 📈Prometheus PromQL

rilldata.com·5d·Hacker News

How AI Writes SQL for You ✅SQLx Compile-Time Verification

pub.towardsai.net·16h

SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL (2024) 🔥DataFusion

research.google·1d·Lobsters, Hacker News

I made a SQL query engine for DynamoDB ⚡DynamoDB

dynamosql.com·8h·Hacker News

Claude Code Routines 🤖Automation

code.claude.com·4h·Hacker News

New Visual Rule Manager: Configure SQL Code Analysis Without Editing XML ✅SQLx Compile-Time Verification

erikej.github.io·1d

Pre-Compiled Filter Sets and Query-Time Specialization in Temporal Databases 🐻‍❄️Polars Lazy

blog.minns.ai·6d·r/rust

Programming LLM's as a SQL database 📊Datalog

youtube.com·19h·r/LLM

The Missing Context Layer: Why Your LLM Agent Can't Do More Than Text-to-SQL 🦙Ollama

airbyte.com·4h·Hacker News

Rapid Delivery Analytics ⚡ClickHouse

producthunt.com·2d

DuckDB: Friendly SQL 🦆DuckDB Extensions

duckdb.org·6h·Hacker News

Building a Text-to-SQL Agent with DuckDB, MotherDuck and LangChain 🔥DataFusion

motherduck.com·5d·r/Python

My 14-Year Journey Away from ORMs - How I Built pGenie, the SQL-First Postgres Code Generator ⛽Diesel

nikita-volkov.github.io·11h·r/rust

Why I Built My Own MySQL Client for macOS (SQL Gnome) 🐘PostgreSQL Internals

sqlgnome.com·1d·DEV

Loading more...