Hacker News
- Setting up PostgreSQL for running integration tests https://gajus.com/blog/setting-up-postgre-sql-for-running-integration-tests 46 comments
- Multi-tenant queues in Postgres https://docs.hatchet.run/blog/multi-tenant-queues 45 comments
- Self-hosting a high-availability Postgres cluster on Kubernetes https://ryan-schachte.com/blog/ha_postgres_zolando/ 90 comments
- Show HN: Hydra - Open-Source Columnar Postgres https://www.hydra.so/blog-posts/hydra-1-generally-available 33 comments
- Postgres Notify for Real Time Dashboards https://blog.arctype.com/postgres-notify-for-real-time-dashboards/ 2 comments
- Jepsen: PostgreSQL 12.3 http://jepsen.io/analyses/postgresql-12.3 140 comments
- Using PostgreSQL Arrays the Right Way http://blog.heapanalytics.com/dont-iterate-over-a-postgres-array-with-a-loop/ 17 comments
- Amazon RDS for PostgreSQL http://aws.typepad.com/aws/2013/11/amazon-rds-for-postgresql-now-available.html 12 comments
Lobsters
- SQLite-based databases on the postgres protocol? Yes we can https://blog.chiselstrike.com/sqlite-based-databases-on-the-postgres-protocol-yes-we-can-358e61171d65 2 comments databases
- OpenStreetMap Import In Postgres In Under 4 Hours https://www.crunchydata.com/blog/loading-the-world-openstreetmap-import-in-under-4-hours 4 comments postgresql
- How are you running PostgreSQL on Kubernetes? None 73 comments kubernetes
- Multi-tenancy implementation with Postgres https://blog.logto.io/implement-multi-tenancy/ 5 comments programming
- Why ZITADEL Moved from CockroachDB to PostgreSQL https://zitadel.com/blog/move-to-postgresql 4 comments postgresql
- How to Find and Stop Running Queries on PostgreSQL https://adamj.eu/tech/2022/06/20/how-to-find-and-stop-running-queries-on-postgresql/ 3 comments postgresql
- 8 Fascinating Things You Probably Didn't Know PostgreSQL Can Do! https://www.enterprisedb.com/blog/8-cool-interesting-facts-things-postgresql-can-do 11 comments postgresql
- IvorySQL: Open Source Oracle compatible PostgreSQL https://www.ivorysql.org/blog/ivorysql/ 5 comments postgresql
- StaticBackend v1.2.0 released featuring PostgreSQL (open-source Firebase alternative) https://github.com/staticbackendhq/core/releases/tag/v1.2.0 2 comments webdev
- Dumb question: how do you pronounce "postgres"... https://www.postgresql.org/community/survey/33-how-do-you-pronounce-postgresql/ 32 comments sql
- Faceted navigation using PostgreSQL full text search https://bun.uptrace.dev/postgres/faceted-full-text-search-tsvector.html 3 comments postgresql
- Slow queries "select distinct" after upgrading PostgreSQL 12 + TimescaleDB to version 14 with pg_upgrade. WCGW? https://docs.timescale.com/timescaledb/latest/how-to-guides/update-timescaledb/update-timescaledb-2 6 comments postgresql
- Deploying a PostgreSQL Rails app to the GCP AppEngine: a guide. This was a pain in the arse to put together, I hope someone finds it useful. https://empydoodle.blogspot.com/2021/06/rails-gcp-appengine-deploy.html 7 comments rails
- Which Is The Best PostgreSQL GUI? 2021 Comparison https://scalegrid.io/blog/which-is-the-best-postgresql-gui-2019-comparison/ 19 comments postgresql
- How to show PostgreSQL data on Google Maps? https://www.reddit.com/r/webdev/comments/ithhbk/how_to_show_postgresql_data_on_google_maps/ 3 comments webdev
- Flask REST API with PostgreSQL, JWT Token and Swagger UI (flask_restx) https://www.reddit.com/r/flask/comments/i7267b/flask_rest_api_with_postgresql_jwt_token_and/ 7 comments flask
- How to deserialize queried Postgres rows into JSON? https://www.reddit.com/r/rust/comments/clv6ou/how_to_deserialize_queried_postgres_rows_into_json/ 16 comments rust
- Lessons learned scaling PostgreSQL database to 1.2bn records/ month https://medium.com/@gajus/lessons-learned-scaling-postgresql-database-to-1-2bn-records-month-edc5449b3067 148 comments programming
- Why We Moved From NoSQL MongoDB to PostgreSQL https://dzone.com/articles/why-we-moved-from-nosql-mongodb-to-postgresql 1094 comments programming
- Load-balancing read-only DB transactions with transparent retry and rerouting triggered by a specific DB error: seeking Java community feedback on proposed PostgreSQL feature https://www.reddit.com/r/java/comments/6kwqe2/loadbalancing_readonly_db_transactions_with/ 11 comments java
- Uncertain with Postgres https://www.reddit.com/r/webdev/comments/68vqcu/uncertain_with_postgres/ 3 comments webdev
- A Look at How Postgres Executes a Tiny Join http://patshaughnessy.net/2015/11/24/a-look-at-how-postgres-executes-a-tiny-join 12 comments programming
- Postgres 9.5 - The feature rundown http://www.craigkerstiens.com/2015/12/27/postgres-9-5-feature-rundown/ 31 comments programming
- UPSERT on Postgres 9.5 http://blog.andrebarbosa.co/upsert-on-postgres-9-5/ 16 comments programming
- Postgresql JSON data type - The best of both the NoSQL and SQL worlds! http://www.jumpingbean.co.za/blogs/mark/postgresql-javascript-native-json-support 6 comments programming
- What's new in PostgreSQL 9.5 https://wiki.postgresql.org/wiki/what%27s_new_in_postgresql_9.5 61 comments programming
- PostgreSQL Indexes http://leopard.in.ua/2015/04/13/postgresql-indexes/ 5 comments programming
- Fastest way to talk to PostgreSQL https://blog.dsl-platform.com/fast-postgres-from-dotnet/ 7 comments programming
- Pgcli - A Postgres CLI with Auto-completion and Syntax Highlighting http://pgcli.com 22 comments programming
- How To Migrate 50MM+ Records From Mongo To PostgreSQL In Less Than A Day http://tech.plug.dj/2014/09/24/how-to-migrate-50mm-records-from-mongo-to-postgresql-in-less-than-a-day/ 17 comments programming
- PostgreSQL security issue "sufficiently bad that we need to take extra measures to prevent it from becoming public" http://www.postgresql.org/message-id/14040.1364490185%40sss.pgh.pa.us 241 comments programming
- Rails 4.0 Sneak Peek: Expanded ActiveRecord Support for PostgreSQL Datatypes http://reefpoints.dockyard.com/ruby/2012/05/18/rails-4-sneak-peek-expanded-activerecord-support-for-postgresql-datatype.html 8 comments ruby