Live data from Hacker News

Postgres with Builtin File Systems

db9.ai

21–26 of 26 posts

Re: Postgres with Builtin File Systems

#21

The carousel overflows on mobile, extending past the screen

Fixed by our agent. Thank you!

It forgot all other locations where the lines are too long to read and you cannot scroll (e.g. the part about embeddings) - from Firefox on Android.

Re: Postgres with Builtin File Systems

#22
post #20
post #6

Earlier quoted context omitted.

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

it has nothing to do with TiDB, db9 is built from scratch.A good way to think about it is that db9 is similar to tidb-server, it provides a PostgreSQL wire protocol and SQL layer, while the actual data lives in the underlying KV layer.

If it is based on TiKV, why is it built from scratch when TiDB exists? To achieve faster boot times? I think the bigger offering here is distributed-, not serverless Postgres!

Re: Postgres with Builtin File Systems

#25

> 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

Doltgres actually is a true versioned Postgres under the hood (or MySql). This sounds really interesting, and I like the ease with which I could spin something up here and get embeddings for sure! But I would think the actual runtime perf of this would be “fine” for some text, but nowhere near Postgres level for all sorts of other stuff, right? I am a huge fan of Postgres as a database, and of SQL, etc. but I don’t t…

> I don’t think I understand the benefit of using Postgres’ wire format here since it’s not Postgres behind the scenes. I guess that lets you use psql as the client?

clients can continue using PG drivers, so author doesn't need to build and distribute his own drivers for N programming languages and M OSes.

Post reply on HN