AmicoderDev's profile picture. Building a Centralized Portfolio API

Making database concepts less scary for developers

Husband to None

Dev Awais

@AmicoderDev

Building a Centralized Portfolio API Making database concepts less scary for developers Husband to None

"What the hell is database sharding?" I asked my senior engineer 3 years ago. He said, "I'll explain it tomorrow." That tomorrow never came. So I figured it out myself. Here's the explanation he never gave me: Sharding = splitting your massive database into smaller pieces…

AmicoderDev's tweet image. "What the hell is database sharding?" 
I asked my senior engineer 3 years ago. 
He said, "I'll explain it tomorrow." 
That tomorrow never came.

So I figured it out myself. 
Here's the explanation he never gave me:

Sharding = splitting your massive database into smaller pieces…

I wrote Netlify, auto-corrected corrected and opened Netflix.


How did you use your Cursor last month? I’ve been running it on auto mode, and honestly, it’s working really well for me.

AmicoderDev's tweet image. How did you use your Cursor last month? 

I’ve been running it on auto mode, and honestly, it’s working really well for me.
AmicoderDev's tweet image. How did you use your Cursor last month? 

I’ve been running it on auto mode, and honestly, it’s working really well for me.
AmicoderDev's tweet image. How did you use your Cursor last month? 

I’ve been running it on auto mode, and honestly, it’s working really well for me.

Can you still code a whole MERN stack ecommerce app without AI help? If you can't, maybe don't call yourself an engineer yet 🤷‍♂️ Look, + auto-complete (ai) is fine. + stackoverflow and Github issues? Sure. + studying other engineers's code? Absolutely. But straight up AI…


If PostgreSQL is the "king," like everyone says, then why does MongoDB still serve millions of users daily? Here's where relational DBs actually break: Fixed schemas: - Your users table has 15 columns, but premium users need 5+ extra fields. - Now you're either adding…

AmicoderDev's tweet image. If PostgreSQL is the "king," like everyone says, then why does MongoDB still serve millions of users daily?

Here's where relational DBs actually break:

Fixed schemas: 
- Your users table has 15 columns, but premium users need 5+ extra fields. 
- Now you're either adding…

What actually happens when you run "SELECT * FROM users" in your database? Your simple query goes through a multi-step journey inside the DBMS before you get results. It's like ordering food - seems instant, but there's a whole kitchen operation behind it. Here's the backstage…

AmicoderDev's tweet image. What actually happens when you run "SELECT * FROM users" in your database?

Your simple query goes through a multi-step journey inside the DBMS before you get results. It's like ordering food - seems instant, but there's a whole kitchen operation behind it.

Here's the backstage…

Why ACID matters in databases (and why it's not just chemistry class) You know that moment when you transfer money online and your bank app crashes mid-transaction? Without ACID properties, you might lose $500 and the recipient gets nothing. Fun times. ACID isn't just a…


I get confused: "Is MongoDB a database or DBMS?" MongoDB is a DBMS - the software that manages your data. Your actual collections and documents are the database. Just like: PostgreSQL = DBMS (manages relational data) MongoDB = DBMS (manages document data) Redis = DBMS (manages…


Just got a call for an interview. She asked me about my work experience, and I told her it's over three years. We went through some basic questions, and then she asked, "Awais, I don't see your degree listed." I replied, "I haven't graduated yet. I only completed high school."…


What's the difference between a Database and a DBMS? Database: Just the data itself - tables, records, files sitting somewhere DBMS (Database Management System): The software that manages the data Think of it like: - Database = Your music collection - DBMS = Spotify Why you…


Real talk on Nuxt hosting options I see so much Vercel hate from frontend devs, but let's be honest - when Netlify fails to deploy, Cloudflare Workers hit payment limits, and VPS setup with Coolify takes hours, Vercel just works for getting demos live quickly. The Nuxt…


Building a subscription payment system with Stripe. Considering MongoDB for: - Flexible schema for different subscription tiers - Easy horizontal scaling - Strong consistency with replica sets But financial data demands ACID compliance. PostgreSQL might be better for strict…


So, who’s actually using Turso in real-world apps? It has a nice free tier and pretty reasonable pricing, which is a plus. But here’s the catch: Turso is based on LibSql, which runs on SQLite. This setup means it can struggle with multiple write requests at the same time. So,…


Serious question: Why do we only use Postgres, MySQL, and MongoDB in production? CouchDB, ScyllaDB, ArangoDB, CockroachDB exist. Some are actually better for specific use cases. Is it just network effects? Fear of being the one who picked the 'weird' database? What's your…


Why PostgreSQL is the database king (and it's not even close): - ACID compliance that actually works - JSON support (eat your heart out, MongoDB) - Extensions for everything (PostGIS, TimescaleDB) - Performance that scales - Community that doesn't gatekeep MySQL has speed,…


United States Tendances

Loading...

Something went wrong.


Something went wrong.