🔍 Query Languages & APIs

SQL, T-SQL, PL/pgSQL, SPARQL, Cypher, Gremlin, XQuery, Query, Join, Subquery, Aggregate Functions, Window Functions, Stored Procedure, Trigger, View

pg_stat_plans: Track per-plan call counts, execution times and EXPLAIN texts
github.com·2d·
Discuss: Hacker News
⚡Query Optimization
Flag this post
Make Lightweight, Mixed-Source Reports without Logical Data Warehouse--SPL Reporting
dev.to·1d·
Discuss: DEV
💾Database
Flag this post
Lowering in Reverse
buttondown.com·1d
⚡Query Optimization
Flag this post
AI Function Calling: Composing and Decomposing Functions for Complex Tasks
lightcapai.medium.com·5h·
Discuss: Hacker News
🤖AI
Flag this post
Snowflake builds new intelligence that goes beyond RAG to query and aggregate thousands of documents at once
venturebeat.com·7h
🏗️Data Engineering
Flag this post
You Shouldn't Use ORMs
diploi.com·11h·
Discuss: Hacker News
💾Database
Flag this post
Show HN: Extrai – An open-source tool to fight LLM randomness in data extraction
github.com·1d·
Discuss: Hacker News
🏗️Data Engineering
Flag this post
Google’s new query builder to tackle SQL complexity in cloud workload monitoring
infoworld.com·17h
⚡Query Optimization
Flag this post
From Vibe Coding to Informed Development: How Codalio PRD Transforms Your Cursor Workflow
codalio.com·59m·
Discuss: DEV
🔧Feature Engineering
Flag this post
Fast Answering Pattern-Constrained Reachability Queries with Two-Dimensional Reachability Index
arxiv.org·18h
⚡Query Optimization
Flag this post
1 billion JSON records, 1-second query response: Apache Doris vs. ClickHouse, Elasticsearch, and PostgreSQL
dev.to·4h·
Discuss: DEV
⚡Query Optimization
Flag this post
Hans-Juergen Schoenig: Counting Customers in PostgreSQL
cybertec-postgresql.com·17h
🗃Database Models & Concepts
Flag this post
Taming the Billion Dollar Mistake: Maarten Balliauw’s Guide to C# Nullable Reference Types
blog.jetbrains.com·10h
💾Database
Flag this post
Optimizing nested JSON array processing using AWS Step Functions Distributed Map
aws.amazon.com·47m
💾Database
Flag this post
Graph RAG vs SQL RAG
towardsdatascience.com·3d
🕸️Graph Databases
Flag this post
CloudEvents as a Data Product
codesimple.blog·1d
🏗️Data Engineering
Flag this post
Devlog: Dynamo Browse - Item View Annotations and Asynchronous Tasks
lmika.org·13h
💾Database
Flag this post
LangChain vs LangGraph: A Beginner’s Guide to Building Smarter AI Workflows
hackernoon.com·1d
🤖AI
Flag this post
xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - Cardinality Misestimates)
tanelpoder.com·1d
⚡Query Optimization
Flag this post
A new SQL-powered permissions system in Datasette 1.0a20
simonwillison.net·2h
🗄Databases
Flag this post