Indexing, Hashing & Query Optimization in SQL — A Practical Guide
dev.to·3d·
Discuss: DEV
📊Query Optimizers
semab tariq: Don’t Skip ANALYZE: A Real-World PostgreSQL Story
stormatics.tech·1d
🗃️Query Compilation
Strategic Pagination Patterns for APIs
roxeem.com·6h·
Discuss: Hacker News
📊Query Optimizers
PostGIS Performance: Indexing and EXPLAIN
crunchydata.com·1d
📊Query Optimizers
Can an LLM Be a Black-Box Optimizer?
posgeo.wordpress.com·12h·
Discuss: Hacker News
⚡Partial Evaluation
**7 Essential GraphQL Patterns That Transformed My Data Fetching Performance**
dev.to·7h·
Discuss: DEV
📮Message Queues
Beyond Indexes: How Open Table Formats Optimize Query Performance
jack-vanlightly.com·3d·
Discuss: Lobsters, Hacker News, r/programming
📊Query Optimizers
Homomorphism Problems in Graph Databases and Automatic Structures
arxiv.org·1d
🔗Unification Algorithms
We Benchmarked DuckDB, SQLite, and Pandas on 1M Rows: Here’s What Happened
kdnuggets.com·1d
🗄️Database Engines
The B2B Sales Funnel as a State Machine: An Engineer's Guide to Revenue Growth
getmichaelai.com·9h·
Discuss: DEV
🎮Language Ergonomics
AAS: The Metric for Monitoring DB Performance
kylehailey.com·17h·
Discuss: Hacker News
📈Performance Tools
Better vector search with graphs and spectral indexing
tuned.org.uk·1h·
Discuss: Hacker News
📐Succinct Data Structures
Scaling Time-Series Data for AI Models
singlestore.com·1d
🔢Algebraic Datatypes
Joint optimization of maintenance and resource preparation of system with multi-indicator degradation based on multiple failure mode division
sciencedirect.com·1d
🗺️Region Types
An enough week
blog.mitrichev.ch·2d·
Discuss: blog.mitrichev.ch
🧩Constraint Solvers
CRUD, reps, repeat - My Database Grind
dev.to·49m·
Discuss: DEV
🎓Educational Databases
Why do CPUs have multiple cache levels?
fgiesen.wordpress.com·2h·
Discuss: Hacker News
⚡Cache Optimization
DataWave: General purpose framework for both structured and unstructured data
code.nsa.gov·5h·
Discuss: Hacker News
🔍Lens Libraries
Innovative Recommendation Applications Using Two Tower Embeddings at Uber
uber.com·4h·
Discuss: Hacker News
🌿Trie Structures
7x faster JSON in SQL: a deep dive into Variant data type
e6data.com·4h·
Discuss: Hacker News
🎭Polymorphic Variants