Postgres with Builtin File Systems

> db9 is a PostgreSQL-compatible distributed SQL database. Your data is stored in a distributed TiKV cluster, and each database (tenant) gets its own isolated keyspace. [0]

I feel like the lede is a bit buried here, bordering on deceptive.

That or the architecture doc is wrong. Both plausible I guess, in this day and age.

[0] https://db9.ai/docs/sql

▲

c4pt0r 2 hours ago | parent [-]

Hello, the developer of db9 here. You’re right, that section is indeed a bit too brief. We will add more architecture documentation later. What I wanted to convey is that, unlike a standard PostgreSQL, db9 is more like a pg SQL-compatible layer built on top of a large distributed KV store. I also shared a brief introduction in this tweet, which might help clarify things. https://x.com/dxhuang/status/2032016443114733744

▲

esafak an hour ago | parent [-]

If you're using TiKV why not use TiDB too, which is MySQL compatible?

	▲	nullpoint420 31 minutes ago \| parent [-]
		Wonder if that’s what it is, with a few changes to make it postgres wire compatible

▲

clark1013 26 minutes ago | parent | prev | next [-]

I like the idea of combining the file system and the database. It's really useful when people don’t want to manage files and structured data separately.

▲

hintymad 2 hours ago | parent | prev | next [-]

I think what’s really interesting is that the first version of db9.ai is done by a single person by commanding AI. There must be tons of invaluable lessons learned.

	▲	c4pt0r an hour ago \| parent \| next [-]
		yes, it’s quite a journey
	▲	gfygfy an hour ago \| parent \| prev [-]
		AI is an instant turnoff and should be banned from HN. Unfortunately it is artificially promoted because of @sama despite not only providing no value but also making the world worse.

▲

nullpoint420 30 minutes ago | parent | prev [-]

The carousel overflows on mobile, extending past the screen