Back
PostgreSQL
PostgreSQL
Open source object-relational database system for reliable application data storage.
Mentions per month
Loading...
Recent todos mentioning PostgreSQL
pick jsonb for postgres when a column has multiple translations instead of using multiple columns
#thecompaniesapi
#resilienceclub
Migrated from MySQL to Postgres in every project.
What made me switch:
- Rich Types: Native UUIDs, Arrays & JSONB eliminate messy workarounds.
- Safety: Strict data integrity & transactional DDL (no broken migrations).
- Future-proof: Built-in AI (pgvector) & Geo (PostGIS).
#saasmakers
#resilienceclub
#thecompaniesapi
Now that the new
#telebugs version is out, I can focus on
#telesink.
The goal is to build an MVP that’s good enough to launch.
It doesn’t need to be pretty or complete, but it must do one thing well: display real-time events in a feed.
I’m still deciding on the tech stack. Rails is a no-brainer, but the database is trickier. As much as I’d like to use SQLite, my gut says PostgreSQL is the safer choice.
The reason is SaaS support. SQLite won’t scale well here, and ActiveRecord Tenanted being abandoned rules it out for me. If this were a self-hosted-first app like Telebugs, SQLite would be perfect. But it isn’t.
🤖 built out my own postgres server admin to let me more easily create databases and users over a small fleet of postgres boxes for my new server farm
#servers
🎙 streamed again with my friend Jay yesterday on Postgres + AI + Django + Transcriptions + Search
Crazy results with Cursor in less than 30 minutes:
- Installed psql on macOS
- connected to Dockerized Postgres
- created pgSQL function for snaphosts
- adjusted TypeScript calls
- wrote & pass all snapshot/rollback unit tests!
Fixed issue with Postgres destination not syncing data, now pulling data every hour
#ddswitch