GoKawiil - Tech News

1.

Training a 4B model to produce 81% faster query plans than Postgres (news.ycombinator.com)

2026-09-16 | tags: query optimizers, postgres, join ordering

2.

The Most Valuable AI Search Data in Your Business Is Already Sitting in Your Sales Calls (feeds.feedburner.com)

2026-09-14 | by Meghna Deshraj | tags: ai visibility, sales calls, buyer questions

3.

Sixteen Locks Ought to Be Enough for Anybody (news.ycombinator.com)

2026-09-14 | tags: postgresql, accesssharelock, lock contention

4.

QueryBrew: System-Agnostic SQL-to-SQL Query Optimization [pdf] (news.ycombinator.com)

2026-09-11 | get SQL Performance Explained Markus Winand → | tags: querybrew, sql, query optimization

5.

Every Millisecond Counts (news.ycombinator.com)

2026-09-09 | get Designing Data-Intensive Applications Kleppmann → | tags: clickhouse, replacingmergetree, query optimization

6.

Solving the 1+N Query Problem (news.ycombinator.com)

2026-08-25 | get Designing Data-Intensive Applications Kleppmann → | tags: 1+n query, database, sql

7.

DuckDB V2 PEG-based SQL parser (news.ycombinator.com)

2026-08-21 | by Daniël Ten Wolde | tags: duckdb, peg parser, sql

8.

Making Postgres 300x faster for analytics: batching, operator fusion, and SIMD (news.ycombinator.com)

2026-08-07 | tags: plan, postgres, query

9.

Show HN: SirixDB 1.0 Beta – Git-Like Versioning, Diffs, Time-Travel Queries (news.ycombinator.com)

2026-07-15 | tags: node, query, revision

10.

YouTrackDB is a general-use object-oriented graph database (news.ycombinator.com)

2026-07-14 | tags: query, repository, server

11.

Show HN: Sqlsure – deterministic semantic checks for AI-generated SQL (news.ycombinator.com)

2026-07-11 | tags: docs, join, model

12.

Pruning RAG context down to what the answer actually needs (news.ycombinator.com)

2026-07-06 | get AI Text Summarizer Tool → | tags: answer, chunk, chunks

13.

sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25) (news.ycombinator.com)

2026-07-05 | by Simon Willison | get SQLite Database Management Tool → | tags: claude, commits, fable

14.

Designing DB partitions you don't have to babysit (news.ycombinator.com)

2026-07-01 | by Ruslan Tolkachev | get Partition Management Tool → | tags: partition, partitioning, query

15.

What ORMs have taught me: just learn SQL (2014) (news.ycombinator.com)

2026-07-01 | get SQL for Beginners Book → | tags: need know, object, orms

16.

I rewrote PostHog's SQL parser, 70x faster, while barely looking at the code (news.ycombinator.com)

2026-06-24 | get PostHog SQL Parser Tool → | tags: posthog, sql parser, clickhouse

17.

The new HTTP QUERY method explained (news.ycombinator.com)

2026-06-23 | get HTTP Query Method Guide → | tags: http query method, restful apis, rfc 10008

18.

Show HN: Graphical SQL Builder and Debugger (news.ycombinator.com)

2026-06-22 | get SQL Query Builder Tool → | tags: mysql, sql builder, query debugger

19.

RFC 10008: The new HTTP Query Method (news.ycombinator.com)

2026-06-17 | by J. Reschke | get HTTP Query Method Guide → | tags: http query method, http, rfc 10008

20.

Referer Reality (news.ycombinator.com)

2026-05-10 | tags: chris, email, query

21.

I’ve banned query strings (news.ycombinator.com)

2026-05-09 | by Chris Morgan | tags: query strings, urls, referer header

22.

pg_flight_recorder: Continuously sample PostgreSQL system state via pg_cron (news.ycombinator.com)

2026-05-07 | get PostgreSQL Monitoring Toolkit → | tags: pg_flight_recorder, postgresql, pg_cron

23.

How to Optimize MongoDB Query Performance with Indexes (news.ycombinator.com)

2026-05-06 | by Roxana-Maria Haidiner | get MongoDB Indexing Guide → | tags: mongodb, indexes, visualeaf

24.

LFM2-24B-A2B: Scaling Up the LFM2 Architecture (news.ycombinator.com)

2026-04-30 | get LFM2 Architecture Model Kit → | tags: lfm2, mixture of experts, hugging face

25.

I built ten custom subagents to tame a 500K-line Clojure codebase (news.ycombinator.com)

2026-04-29 | get Clojure Programming Book → | tags: metabase, clojure, subagents

26.

Postgres's lateral joins allow for quite the good eDSL (news.ycombinator.com)

2026-04-27 | get PostgreSQL Lateral Join Guide → | tags: postgres, lateral joins, query language

27.

Design and implementation of DuckDB internals (news.ycombinator.com)

2026-04-10 | by Torsten Grust | get DuckDB Developer Guide Book → | tags: duckdb, database internals, university course

28.

Good CTE, Bad CTE (news.ycombinator.com)

2026-03-30 | by Radim Marek | get CTE Awareness Bracelet → | tags: postgresql, cte, query optimization

29.

PgAdmin 4 9.13 with AI Assistant Panel (news.ycombinator.com)

2026-03-10 | by Dave Page | get Pageant → | tags: pgadmin, sql, ai assistant

30.

Show HN: Pg-typesafe – Strongly typed queries for PostgreSQL and TypeScript (news.ycombinator.com)

2026-02-17 | get Pg-typesafe → | tags: bigint, field, pg typesafe