🔍 Query Optimization - hello · Scour

Database Optimization Strategies That Cut Query Execution Time by 60%: A Practical Guide 📇Index Selection

dev.to·2d·DEV

Horrila: Cost-Based Placement of Semantic Operators in Hybrid Query Plans 🗺️Query Planning

Article: Lakehouse Tower of Babel: Handling Identifier Resolution Rules Across Database Engines 🔥DataFusion

Non-Custodial Polymarket Execution Engine ⚙️LMAX Architecture

tamkocluk.com·5h

Things you didn't know about indexes 📇Index Selection

jon.chrt.dev·2d·Lobsters, Hacker News, Hacker News, r/programming

Spring Boot + PostgreSQL 🐘Pgx

pub.towardsai.net

·13h

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

glassflow.dev·3d·r/programming

The ORM Is Over: AI-Written SQL Is the New Data Access Layer ⛽Diesel

dzone.com·1d·Lobsters

DigitalOcean Shares Gain as AI Startups Report Faster Training, Lower Latency - News and Statistics 📊VictoriaMetrics

indexbox.io·4h

Chao Gao 📊Data Science

stat.uchicago.edu·18h

Pawansingh3889/OpsMind: On-prem AI query tool for manufacturing. NL-to-SQL in 5 seconds. LangGraph agent, pgvector + ChromaDB RAG, Gemma 3 12B via Ollama. 19 tables, read-only. ✅SQLx Compile-Time Verification

github.com·2d·DEV

Timeseries indexing at scale 📈Time-Series Databases

datadoghq.com·6d

The Index: Issue #178 📇Index Selection

piccalil.li·20h

Zillow Home Value Index: 'Real' Home Values Continue To Fall ⚡Polars Expression API

seekingalpha.com

·7h

PostgreSQL Explained: A Complete Beginner-to-Advanced Guide 🐘PostgreSQL Internals

digitalocean.com·2d

An AI Haters Guide to Code with LLMs (Philosophy & Personal Politics) 🤖Cyberpunk

aredridel.dinhe.net·3h

Index-based pruning in ClickHouse 👁️ClickHouse MaterializedViews

clickhouse.com·3d

UK BioCoin: swift trait-specific summary statistics regression for UK Biobank 📊HyperLogLog

nature.com·13h

Building Distributed Systems for the Real World: How Becca Taft Engineers for Scale 🏗️System Design

cockroachlabs.com·2d

Navigating a Turbulent Career 👥Engineering Management

humbledollar.com·3h

Loading more...