#PostGresql

Your API returns 10 million orders. The frontend asks for "page 5." Offset 40, limit 10. Simple...

What determines whether a database is suitable for a production environment is not the fancy...

Happy to announce HeliosProxy !! Far beyond a pooling tool, HeliosProxy ** is a next-gen programmable...

According to the latest DB-Engines ranking, PostgreSQL firmly holds the fourth position globally and...

When deciding between MongoDB and PostgreSQL, the biggest difference is how the data is...

I'm a huge fan of graphs, they tend to simplify a lot of problems (permissions that inherit, content that relates, entities for RAG, etc.) and preserve optionality when the data modeling is uncertain.…

I built a Postgres RLS linter. Not asking for stars or anything (it's MIT). What I actually want is to expand the rule set, and I figured this sub has seen the kinds of RLS bugs that don't show up in tutorials.…

I never thought of data governance as a sexy topic. My main focus has always been on performance, insights, cost reduction. That is, until I joined a startup as the sole data engineer.…

Curious how others handle this - running into it across three different shapes of project: Legacy schemas where someone never added the FK constraint, so the column is just an int.…

Good afternoon community, My application is mainly used on sap ase and oracle but more and more client are moving to postgres. One of the feature is the ability to define a table columns with datatype and datalength) that is fed through SQL also defined…

Wrote a fully stateless API server in Elixir that can run multiple CRUD operations against Postgres in a single, atomic, RLS-aware transaction using a highly expressive JSON format (chaining results etc).…

I recently went through a fairly painful PostgreSQL 17 migration involving async replication, WAL retention issues, replica rebuilds, and long-running restore operations getting interrupted by timeout/configuration problems.…

The Postgres Chainguard image is distroless (in fact, it's very small), but unfortunately it doesn't support io_uring. Do you know of anything similar? submitted by /u/Wise_Stick9613 [link] [comments]

This is a TLE-compliant alternative to pg_later, which basically means you can easily load it in a managed Postgres instance from Supabase or AWS RDS. It hackily uses pg_cron as the underlying job dispatcher.…

RSVP Free here Running stateful applications can provide many of the same advantages as stateless applications. In this talk, Stephen will share some thoughts on managing stateful applications as part of a CD Pipeline so that applications - and the…

If you looking for some TablePlus, DBeaver or Beekeeper alternative maybe this app for you Link: https://orca-q.com/ Github: https://github.com/cin12211/orca-q submitted by /u/tlovemusic [link] [comments]

Im building a SaaS app and working on the database schema right now. The app needs to support multiple tenants, and I plan to use PostgreSQL with RLS for data isolation. I have one main table called "group".…

Hey All, apologies in advance as my SQL knowlege is thin and this is going to likely get a bit intertwined. I run a small business making bags and offer custom colors on all products through my website.…

Built a tool called MigrationSafe that checks Postgres migration files for risky operations before production. It catches things like: NOT NULL columns without DEFAULT DROP COLUMN indexes without CONCURRENTLY foreign keys without NOT VALID and other risky…