News for hackers. Stuff that matters.
Re:Apache Age, a PostgreSQL Extension with Graph Database Fu... by mradek on Thursday November 03, 2022 @12:29AM (#33447004)
Interesting. What are some good extensions for pg? I have only used UUID and postgis.
Re:Apache Age, a PostgreSQL Extension with Graph Database Fu... by somebee on Thursday November 03, 2022 @12:52AM (#33447161)
The ltree extension is fantastic if you have data like comments or any other hierarchical structure.
Re:Apache Age, a PostgreSQL Extension with Graph Database Fu... by jschrf on Thursday November 03, 2022 @01:05AM (#33447238)
TimescaleDB
Re:Apache Age, a PostgreSQL Extension with Graph Database Fu... by hans_castorp on Thursday November 03, 2022 @05:40AM (#33448855)
> I have only used UUID and postgis.

If you used "uuid-ossp" to get uuid_generate_v4(), then this is no longer necessary since Postgres 13 as there is now a built-in gen_random_uuid()

https://www.postgresql.org/docs/current/functions-uuid.html

Re:Apache Age, a PostgreSQL Extension with Graph Database Fu... by mradek on Thursday November 03, 2022 @08:04AM (#33449763)
Oh wow TIL thank you
Re:Apache Age, a PostgreSQL Extension with Graph Database Fu... by ellisv on Thursday November 03, 2022 @09:09AM (#33450392)
pg_stat_statements
Re:Apache Age, a PostgreSQL Extension with Graph Database Fu... by Dowwie on Thursday November 03, 2022 @10:00AM (#33451092)
Re:Apache Age, a PostgreSQL Extension with Graph Database Fu... by rdevsrex on Thursday November 03, 2022 @10:35AM (#33451631)
Well, I wouldn't call it interesting, but I like the citext extension for case insensitive comparison.