pgtk - Pure SQL diagnostic functions for PostgreSQL
Zero-install Postgres diagnostics, but pg_stat_statements and pgAdmin already exist.
MegaHAL in pure SQL
MegaHAL chatbot runs in pure SQL—no PL/pgSQL escape hatches, just CTEs and recursive queries.
Database enthusiasts, SQL hobbyists, constraint-challenge programmers
sql.js-httpvfs · DataWeave
Learning is a single ~560-line SQL statement that splits text, interns symbols, and updates two 5th-order Markov tries (forward and backward) using depth-unrolled writable CTEs. A recursive query that generates N candidate replies in parallel. It performs bidirectional weighted random walks, evaluates them for information-theoretic surprise, and formats the winner as a sentence-cased string.
I provided a `docker-compose.yml` and convenient Python driver script so you can try it out quickly, and there's also a web-based demo where I bundled it with PGlite (WASM PostgreSQL) at https://tgies.github.io/megahal-sql/. These are provided for convenience, but you can also just run the schema initialization SQL and `SELECT megahal_converse('hello from hn.');`
Zero-install Postgres diagnostics, but pg_stat_statements and pgAdmin already exist.
Pure SQL chess engine that actually plays, not procedural extensions or C bindings.
Pure SQL introspection means zero driver hell when exporting Postgres schemas to DBML.
Pure SQL 6502 emulation with opcodes as stored procedures—no external code anywhere.
Terraform for PostgreSQL roles—convergent diff engine prevents privilege drift.
Local-first natural language SQL beats cloud alternatives, but text-to-SQL is a crowded space.