· software
Supabase vs Firebase: What I Chose and Why
My Requirements as a Solo Developer - Fast MVP development - Relational data modeling - SQL flexibility - Clean auth + role‑based access - Open‑source‑friendly...
-
- · software
Optimizing PostgreSQL Queries for Large-Scale Data Applications
Scaling PostgreSQL for a High‑Traffic Application Over the past two years we’ve reduced query times from > 15 seconds to = '2024-01-01' ORDER BY o.created_at D...
- · software
Publishing Pipeline v1.2.0 – backlinks and X support
New Feature: Tweeting on X The pipeline now supports tweeting on X in addition to WordPress and Dev.to. WordPress remains the canonical source, meaning: - A po...
- · software
New PostgreSQL Features I Developed in 2025
Introduction I started contributing to PostgreSQL around 2020. In 2025 I wanted to work harder, so I’ll explain the PostgreSQL features I developed and committ...
- · software
How to Change a Column Datatype Without Affecting Existing Users Postgresql
!Cover image for How to Change a Column Datatype Without Affecting Existing Users Postgresqlhttps://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,...
- · software
Instant database clones with PostgreSQL 18
Article URL: https://boringsql.com/posts/instant-database-clones/ Comments URL: https://news.ycombinator.com/item?id=46363360 Points: 23 Comments: 0...
- · software
The Ultimate Guide to Prisma ORM + PostgreSQL (2025 Edition)
Project Initialization Start by setting up your Node.js environment with TypeScript. We use tsx for modern, fast execution. bash mkdir prisma-postgres-2025 cd...
- · software
JSONB vs. BSON: Tracing PostgreSQL and MongoDB Wire Protocols
There is an essential difference between MongoDB’s BSON and PostgreSQL’s JSONB. Both are binary JSON formats, but they serve different roles. JSONB is purely an...
- · devops
Access AWS RDS without Password - use IAM
Backstory When setting up or debugging a database we usually need to log in with a password. In our case the database authentication was configured to use an A...
- · software
Go ahead, self-host Postgres
Article URL: https://pierce.dev/notes/go-ahead-self-host-postgresuser-content-fn-1 Comments URL: https://news.ycombinator.com/item?id=46336947 Points: 7 Comment...
- · software
**8 Python Database Optimization Techniques to 10x Your Application Performance**
📚 About the Author As a best‑selling author, I invite you to explore my books on Amazonhttps://www.amazon.com/stores/Aarav-Joshi/author/B0DQYNVXZ7?ref=ap_rdr&...
- · software
Postgresus is live on Product Hunt — the open source PostgreSQL backup tool
Managing PostgreSQL backups has always been a pain point for developers. Manual pg_dump scripts, scattered cron jobs and no visibility into what's actually bein...