MMuhammad Ali Mughal3h ago · 9 min readSaaS Backup & Disaster Recovery: RPO, RTO and PITRA nightly pg_dump to the same VPS is not a backup strategy. It is a file that disappears with the disk, the compromised root account or the provider incident that took the server down in the first plaresume-ai.hashnode.dev
AAnish Ansari1d ago · 7 min readSystem Design Drill Day 11: The Transactional Outbox PatternAlmost every Laravel checkout controller has the same two lines: save the order, then dispatch a job. It works nearly every time. If Redis hiccups between those two lines, the order is paid and the emblog.anishansari.com.np
Mmuthuselvi3d ago · 6 min readManaged Database Pricing Explained: What You Actually Pay ForPicking a managed database usually starts with a pricing page and ends with a surprise invoice. Egress fees, backup charges, SSL add-ons, and per-query billing can turn a "$20 database" into somethingantryk.hashnode.dev
WWaqas Shahid3d ago · 2 min readMySQL Explained: The Database Behind Much of the WebIntroduction When you learned SQL, you learned a language, but a language needs a database to run in. MySQL, first released in 1995 and now owned by Oracle, is the most widely used open-source relatiopracticaldevblog.hashnode.dev
SSnapDeploy4d ago · 10 min readPostgres, MySQL, MariaDB or MongoDB next to your container: how the managed add-ons workTL;DR: SnapDeploy runs PostgreSQL, MySQL, MariaDB and MongoDB as add-ons next to your containers. Pick an engine and a tier (Mini $29, Standard $49, Pro $89 a month, or a $1 DB Sprint Pack for 12 hoursnapdeploy.hashnode.dev
MMuhammad Ali Mughal6d ago · 9 min readComposite Indexes in PostgreSQL & MySQL: Column Order GuideAdding three separate single-column indexes on tenant_id, status, and created_at will not make a multi-filter dashboard query fast—in fact, putting columns in the wrong order inside a composite B-Treeresume-ai.hashnode.dev
AAnish AnsariOct 24 · 7 min readSystem Design Drill Day 6: Sharding and Partitioning a MySQL Orders TableThe orders table has grown too big for one server, and another replica won't help. Replicas spread reads, but each one still holds all the data, and every write still lands on the same primary. Past ablog.anishansari.com.np
AAnish AnsariOct 22 · 7 min readSystem Design Drill Day 4: Read Replicas and Replication LagA customer places an order, gets redirected to "My Orders", and the list is empty. They refresh and the order appears. Anyone who has added read replicas to a busy app will recognise that support tick14KAblog.anishansari.com.np
VV. VaidehiOct 20 · 9 min readBuilding BCB CRM: A Lead Management System with Laravel and MySQLIntroduction For my second MCA mini project, I worked on BCB CRM & Lead Management System, a web application designed to help a business organize and manage its interactions with potential customers. 2Kvaidehi.hashnode.dev
DDalya AkramOct 19 · 15 min readWhat I learned from analyzing more than 1M online retail transactionsWhen I started looking for a new data analysis project, I didn’t want another small and already-clean dataset where I could immediately tell what charts I was supposed to make. I wanted something closdalya.hashnode.dev
