How to use Postgres for everything • Hacker News Board

Re: How to use Postgres for everything

#31

Post by jascha_eng » Sat, Dec 07, 2024, 8:35 AM UTC

The markdown is a bit broken. But I agree with the message.

Created a PR to update some of the vectordb links and also fixed the markdown: https://github.com/Olshansk/postgres_for_everything/pull/1

Re: How to use Postgres for everything

#32

Post by rozenmd » Sat, Dec 07, 2024, 8:36 AM UTC

I've been running my project as a business for almost four years now and I think my Postgres DB is the only thing that I haven't changed.

Easily the most stable part of the stack (100% uptime on RDS since 2021/02/01).

Re: How to use Postgres for everything

#33

Post by joeevans1000 » Sat, Dec 07, 2024, 8:37 AM UTC

Great repo! Thanks!

I'm wondering, any approach for bitemporal dbs, like xtdb?

Re: How to use Postgres for everything

#34

Post by ianpurton » Sat, Dec 07, 2024, 8:42 AM UTC

I can see a lot of benefits of having 1 API to access a lot of functionality.

For example instead of integrating with a message queue I can just do an INSERT this is great. It lowers the friction.

Vector search is a no brainer too. Why would I have 2 databases when 1 can do it all.

Using Postgres to generate HTML is questionable though. I haven't tried it but I can't image its a viable way to create user interfaces.

Re: How to use Postgres for everything

#35

Post by malux85 » Sat, Dec 07, 2024, 8:42 AM UTC

anonzzzies wrote: post #20

Is there a local-first postgres solution?

What do you mean local first? Postgres is an executable that you can run on your machine if you wish

Re: How to use Postgres for everything

#36

Post by seanhunter » Sat, Dec 07, 2024, 8:58 AM UTC

joeevans1000 wrote: post #33

Great repo! Thanks! I'm wondering, any approach for bitemporal dbs, like xtdb?

You definitely don’t need a special database for bitemporal data. Just a datetime and as of data time column, your value column and whatever metadata you want (or a jsonb col for metadata if you want more flexibility at the cost of some speed of filtering by metadata)

Re: How to use Postgres for everything

#37

Post by wiseowise » Sat, Dec 07, 2024, 9:04 AM UTC

s/postgres/sqlite/g

Re: How to use Postgres for everything

#38

Post by natmaka » Sat, Dec 07, 2024, 9:07 AM UTC

feverzsj wrote: post #17

jjallen wrote: post #14

Earlier quoted context omitted.

I always wonder if postgrest works well after growing quite a bit. I really should google the largest companies using it.

In my experience, without careful tunning, postgres performance starts dropping significantly around 10 million rows.

Without any consideration for I/O?

In my experience performance is often directly related to the ratio (total RAM available to Postgresql, shared buffer and buffercache included / total size of tables and indices ), save any weird usage pattern.

Re: How to use Postgres for everything

#39

Post by jankovicsandras » Sat, Dec 07, 2024, 9:09 AM UTC

Can you please add this shameless plug?

https://github.com/jankovicsandras/plpgsql_bm25

Opensource BM25 search in PL/pgSQL (for example where you can't use Rust extensions), and hybrid search with pgvector and Reciprocal Rank Fusion.

Re: How to use Postgres for everything

#40

Post by qpiox » Sat, Dec 07, 2024, 9:09 AM UTC

ianpurton wrote: post #34

I can see a lot of benefits of having 1 API to access a lot of functionality. For example instead of integrating with a message queue I can just do an INSERT this is great. It lowers the friction. Vector search is a no brainer too. Why would I have 2 databases when 1 can do it all. Using Postgres to generate HTML is questionable though. I haven't tried it but I can't image its a viable way to create user interfaces.

> Using Postgres to generate HTML is questionable though. I haven't tried it but I can't image its a viable way to create user interfaces.

Check https://apex.oracle.com/ which does that.