Journal
Writing
Opinionated engineering notes—security, scalability, correctness, and the interfaces between humans and machines. No listicles—just explanations you can reuse in prod and in interviews.
Filter
#API design#authentication#backend#backups#booking systems#caching#CDN#CI/CD#Cloudflare#concurrency#connection pooling#consensus#correctness#CORS#cPanel#cryptography#data consistency#data integrity#data migration#database connection#database migrations#date handling#decimal arithmetic#deployment#DirectAdmin#disaster recovery#distributed-systems#DNS#Docker#Edge#environment variables#Express#fallacies#FastAPI#file uploads#forms#Google Analytics 4#HTTP/2#image optimization#invoicing#JavaScript#JWT#Kubernetes#latency#messaging#Multer#Nepal VAT#networking#NetworkManager#Next.js#next/image#Nginx#Node.js#Nodemailer#OAuth#observability#passwords#performance#pg_restore#PM2#PostgreSQL#Prisma#production debugging#Python#query-plans#range types#React#Redis#refresh tokens#reliability#sagas#scaling#schema drift#schema management#Search Console#security#SEO#sessions#shared hosting#SMTP#SSE#staleness#storage#Tesseract OCR#time zones#TLS#transactions#Ubuntu#Vercel#web security#WebSocket#WordPress
Matching posts
Showing 2 of 35. Clear filters
- DatabaseAugust 8, 20269 min read
PostgreSQL Connection URL Explained, Piece by Piece
A component-by-component breakdown of the PostgreSQL connection URL — user, password, host, port, database, and query parameters — plus safe environment-variable handling.
PostgreSQLPrismadatabase connectionenvironment variables - DatabaseAugust 8, 20266 min read
How to URL-Encode Special Characters in PostgreSQL Connection Strings
Encode PostgreSQL usernames and passwords safely without breaking the scheme, host, port, database name, or query parameters.
PostgreSQLPrismaNode.jsdatabase connection