Results for Postgres · 1.249s

Sponsored
News for “Postgres”
20 results • 1243 ms server time
Moozonian News
github.com• Aug 11, 2026• 1 min read
Show HN: Dbctx – Compile a PostgreSQL database into compact, queryable contextHi HN, I've been finding increasing need for helping our users chat with the underlying application data in postgresql directly using LLMs, visualize results and so on.A major obstacle to this is -- traditional sql schema doesn't contain enough information for an LLM to easily query things in one shot.For example, traditional schema doesn't say what is the expected/allowed value set in a state field, or what are the paths available embedded in a jsonb field.Also -- given a user query -- only a small fraction of the whole schema is relevant for an LLM to construct SQL queries. So filtering parts of schema relevant to construct a prompt is important.dbctx solves all these by inspecting a postgresql database and turning the results into an sqlite backed ".dtx" file. You can pass your natural language query to dtx, and get relevant tables in a compressed schema format along with field/json intelligence embedded in it. This leads to much better responses from the LLM from the getgo.I have a
Advertisement
Moozonian News
widen.dev• Jul 31, 2026• 1 min read
Show HN: Widen – Open-source Mac Postgres GUI with local or cloud text-to-SQLGithub: https://github.com/betocmn/widenI was paying for DataGrip for several years as my desktop database GUI but if I wanted text-to-SQL with LLMs I'd have to pay even more on top. So I decided to build my own and I've been using it for a few weeks now.At any time I'm usually working with 3 to 6 databases, and having them set up in something like Conductor (for parallel agentic coding), but for Postgres databases, lets me quickly start a session, ask questions to my database in plain English, get a data export, move on and close the session. It's been working well and I thought I would share it here.It's a native Mac app (Swift), free and open source (MIT). For the LLM you bring your own OpenRouter key, or there's an experimental on-device mode using Apple's local model, where nothing leaves your Mac. Cloud mode only sends the question and schema metadata, not your data, unless you explicitly turn that on per connection.
Moozonian News
github.com• Jul 27, 2026• 1 min read
Show HN: Otlet – Local LLM inference "inside" PostgresI’ve been working on Otlet, a Postgres extension for running local LLM inference “inside” Postgres (inference runs in a background worker, while Postgres stores the jobs, inputs, outputs, and receipts)I started it while working on an entity resolution problem (determining which rows in a table refer to the same entity). The data was already in Postgres, but using a model meant pulling rows into another process and then writing the results back. I wanted to see whether I could keep more of that workflow in the database right next to where the data livesRight now Otlet lets you start model work from SQL, require structured output, keep a record of each run, review proposed writes before they touch source data, etc. The example in the repo uses a small model for the first pass and a stronger model for uncertain casesThis is just something I've been hacking on, not something I would recommend attempting to use in production yet. There’s a Docker demo if anyone wants to try it. I’m mostly p
Moozonian News
learnpg.xyz• Jul 19, 2026• 1 min read
Show HN: PostgreSQL course with database running in your browserI wanted to brush up my SQL skills and was looking for an online course that included a live DB.Most PostgreSQL courses require you to create an account or pay. This is probably because they have to bear the costs of running a full server-side database.So I created learnpg.xyz, a collection of PostgreSQL SQL exercises that run client side.Sharing here because it might be of use to people!
Moozonian News
github.com• Jul 12, 2026• 1 min read
Show HN: Pgnudge - tell your app which Postgres tables just changedGenuinely unsure if this is crazy or cool: looking for feedback.pgnudge is a small async Python library that tells you which tables just changed in Postgres, so a cache or read model can refetch the moment the data moves. No row data - it tells you when and what to reload, you already know how to load it.It leaves nothing persistent on the server (temp replication slot, dropped when the session ends) and needs no database driver — it speaks the walsender protocol itself. One dependency.Not CDC (no before/after rows), not a queue (no durability). It moves wakefulness, not rows or work.Repo: https://github.com/janbjorge/pgnudge
Moozonian News
news.ycombinator.com• Jul 5, 2026• 1 min read
Show HN: Pgconverge – An experimental multi-master PostgreSQL framework in GoHi HN,Over the past few months I've been building pgconverge, an experimental open-source framework for operating multi-master PostgreSQL clusters.The project started as a learning exercise to better understand distributed databases rather than as an attempt to replace PostgreSQL's existing replication model. My goal was to explore what it would take for multiple PostgreSQL nodes to accept writes independently while eventually converging without relying on a designated primary database. Over time, the experiment evolved into a working open-source framework.Some of the areas I explored include:full-mesh replication topology conflict resolution using Last-Write-Wins Hybrid Logical Clocks for ordering concurrent writes bootstrapping new nodes into an existing cluster declarative cluster configurationGithub Link: https://github.com/sobowalebukola/pgconvergeAlong the way I documented the design decisions in a seven-part engineering series:Why Multi-Master? The Problem with Single-Writer Dat
Advertisement
Advertisement
Sponsored