Should I use SQLAlchemy Core or Psycopg 3 for a PostgreSQL dashboard?
I'm building a business dashboard with a Python backend and am migrating from MongoDB to PostgreSQL. The tables are already designed, and I'm comfortable writing SQL, but I'm…
ORM
Should I Use an ORM for My Project?
I'm trying to decide if using an Object-Relational Mapping (ORM) tool makes sense for my project. For those who don't use ORMs, what are your main reasons against…
Best Practices for Handling Aggregated Data in REST APIs
I'm diving into API design and running into some challenges while trying to build realistic projects. Right now, I have a basic CRUD API that handles Posts and…
Why is Automatic Migration Generation Not Standard Across Frameworks?
I've been working with Spring Boot for a while, and I've just started learning Symfony at university. In my job, we always use Liquibase or Flyway and manually…
What SQL Skills Do I Need for Web Development and Job Interviews?
I'm curious about how much SQL knowledge is necessary for a web development career and what topics are usually covered in interviews. I can pick any course or…
Considering a Move from Django to FastAPI: Need Advice
We're currently stuck with a legacy Django monolith that's handling about 45,000 requests per minute and managing over 1,500 database tables. The synchronous ORM calls have become a…
Prisma vs TypeORM: Which One Should I Pick for My Project?
I'm currently working on a backend setup using NestJS, Fastify, and Supabase PostgreSQL. As part of this project, I'm trying to decide between Prisma and TypeORM as the…
Do I Need Math Skills for Building an HTTP Server or ORM?
Hey everyone! I'm diving into the world of programming and I'm excited to develop my own HTTP server and ORM (Object-Relational Mapping) library. Before I get started, I'm…
Is Writing Raw SQL a Smart Move for Serious Projects in 2025?
I've been diving into building a todo app without using any ORM, opting for better-sqlite3 instead. This choice has made me realize just how vital it is to…
Why Is My Django API So Slow on AWS RDS?
I'm dealing with a frustrating performance issue on one of my Django API endpoints that connects to AWS RDS PostgreSQL. The endpoint takes a ridiculous 8-11 seconds to…