FastAPI + SQLAlchemy Best Practices
by Post Views: 3,567 Most long-term problems, both in development and in production come from rushed model design, scattered logics, and patterns that feel convenient at …
Category: Database
Computer Science / Database / Django / Java / Python / Spring Boot / SQL
Improve Pagination Performance in SQL Queries Using Keyset Pagination
Post Views: 1,099 Pagination is a common requirement in web applications dealing with datasets. Developers often use SQL queries with OFFSET and LIMIT to fetch …
PostgreSQL Function Error During Backup and Restore
Post Views: 630 In a recent project, I encountered a frustrating issue while working with PostgreSQL. I had implemented a custom function that called another …
Database / Django / html table / Programming / Python / SQL
Generate HTML Table Report From SQL Query In Django
Post Views: 2,018 Creating reports is an essential part of software development, but it can also be a challenging task. Django developers often struggle with …
Computer Science / Database / mysql / Optimization / Programming / SQL
Complex Update In A Single SQL Query Using CASE Statements
Post Views: 1,298 SQL update statement is an important area in optimizing database queries. Optimizing update queries in large tables can reduce query time and …