3 ms·
Interesting. What are some good extensions for pg? I have only used UUID and postgis.
by mradek 4y ago
Interesting. What are some good extensions for pg? I have only used UUID and postgis.
- ellisv 4y agopg_stat_statements
- somebee 4y agoThe ltree extension is fantastic if you have data like comments or any other hierarchical structure.
- jschrf 4y agoTimescaleDB
- hans_castorp 4y ago> 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 https://www.postgresql.org/docs/current/functions-uuid.html
- mradek 4y agoOh wow TIL thank you
- Dowwie 4y agoaws_s3: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_...
- rdevsrex 4y agoWell, I wouldn't call it interesting, but I like the citext extension for case insensitive comparison.