GoKawiil - Tech News

1.

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

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

2.

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

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

3.

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

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

4.

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

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

5.

Geosql: A Claude/Codex skill for geospatial data (news.ycombinator.com)

2026-07-08 | tags: agent, bigquery, dekart

6.

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

2026-07-06 | tags: answer, chunk, chunks

7.

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

2026-07-05 | by Simon Willison | tags: claude, commits, fable

8.

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

2026-07-01 | by Ruslan Tolkachev | tags: partition, partitioning, query

9.

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

2026-07-01 | tags: need know, object, orms

10.

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

11.

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

12.

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

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

13.

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

14.

Referer Reality (news.ycombinator.com)

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

15.

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

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

16.

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

17.

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

18.

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

19.

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

20.

Video service Vimeo confirms Anodot breach exposed user data (bleepingcomputer.com)

2026-04-28 | get Vimeo User Data Security Kit → | tags: vimeo, anodot, shinyhunters

21.

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

22.

The modern data stack was built for humans asking questions. Google just rebuilt its for agents taking action. (venturebeat.com)

2026-04-22 | get Google Bard AI Assistant → | tags: google, cloud next, bigquery

23.

CadQuery is an open-source Python library for building 3D CAD models (news.ycombinator.com)

2026-04-14 | get CadQuery 3D CAD Library → | tags: cadquery, python, 3d cad

24.

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

25.

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

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

26.

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

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

27.

Show HN: Vertex.js – A 1kloc SPA Framework (news.ycombinator.com)

2026-03-01 | get React → | tags: vertex.js, react, ractive-load

28.

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

29.

I asked Claude Code to remove jQuery. It failed miserably (news.ycombinator.com)

2026-02-13 | get HTML → | tags: html, jquery, just

30.

How to turn 'sfo-jfk' into a suitable photo (news.ycombinator.com)

2026-01-28 | get Adobe Lightroom → | tags: beautiful, database, place