#queryset

[ follow ]
Node JS
fromhowtocenterdiv.com
3 weeks ago

Database Performance Bottlenecks: N+1 Queries, Missing Indexes, and Connection Pools

Database issues, like missing indexes and N+1 queries, are often overlooked in software engineering, leading to persistent performance problems.
#django
Django
fromRealpython
3 weeks ago

Getting Started With Django: Building a Portfolio App Quiz - Real Python

The quiz tests understanding of core Django concepts essential for building a portfolio app.
Django
fromLoopwerk
3 weeks ago

Building modern Django apps with Alpine AJAX, revisited

Simplifying the web development stack with an all-Django approach and Alpine AJAX improves efficiency and reduces unnecessary complexity.
Django
fromRealpython
3 weeks ago

Getting Started With Django: Building a Portfolio App Quiz - Real Python

The quiz tests understanding of core Django concepts essential for building a portfolio app.
Django
fromLoopwerk
3 weeks ago

Building modern Django apps with Alpine AJAX, revisited

Simplifying the web development stack with an all-Django approach and Alpine AJAX improves efficiency and reduces unnecessary complexity.
Python
fromRealpython
3 weeks ago

Understanding CRUD Operations in SQL - Real Python

CRUD operations are essential for creating, reading, updating, and deleting data in applications.
fromDjangocentral
3 weeks ago

DRF Serializer: Handling OrderedDict and Converting It to a Dictionary or JSON

The use of an OrderedDict ensures that the order of fields in the serialized representation matches the order of fields defined in the serializer class.
Data science
fromInfoWorld
1 month ago

The revenge of SQL: How a 50-year-old language reinvents itself

SQL has experienced a major comeback driven by SQLite in browsers, improved language tools, and PostgreSQL's jsonb type, making it both traditional and exciting for modern development.
Artificial intelligence
fromInfoWorld
2 months ago

With AI, the database matters again

AI turns databases from passive stores into critical context-assembly layers; reliable data infrastructure, consistency, and fast context retrieval are essential to prevent model hallucinations.
fromPaolo Melchiorre
1 month ago

Django ORM Standalone: Querying an existing database

For a long time I wanted to document something I have done many times in production systems but never explained clearly: using Django ORM as a standalone module to connect to an existing database. In my work I have often dealt with legacy systems where the only reliable source of truth was the database itself. In those situations, Django ORM became my Swiss army knife.
Web frameworks
Software development
fromMedium
2 months ago

The Complete Database Scaling Playbook: From 1 to 10,000 Queries Per Second

Database scaling to 10,000 QPS requires staged architectural strategies timed to traffic thresholds to avoid outages or unnecessary cost.
Java
fromMedium
3 months ago

I Ignored These JPA Methods for Years-Now Spring Boot Application 10 Faster

Using JpaRepository.existsById and saveAll with proper batching reduces queries, memory use, and can improve application performance up to tenfold.
Django
fromRealpython
1 month ago

Introduction to Python SQL Libraries Quiz - Real Python

A 9-question interactive quiz assesses proficiency in Python SQL libraries for database connectivity, query execution, and cross-database scripting with SQLite, MySQL, and PostgreSQL.
fromInfoQ
2 months ago

VillageSQL Launches as an Extension-Focused MySQL Fork

A new open-source project, VillageSQL, has been introduced as a tracking fork of MySQL aimed at expanding extensibility and addressing feature gaps increasingly relevant to AI and agent-based workloads. Announced by founder Dominic Preuss, VillageSQL Server for MySQL is positioned as a drop-in replacement that maintains compatibility with upstream MySQL while adding a structured extension framework. The alpha release is now available for experimentation.
Software development
fromPythonbytes
2 months ago

A bolt of Django

About the show Sponsored by us! Support our work through: Connect with the hosts Join us on YouTube at pythonbytes.fm/live to be part of the audience. Usually Monday at 11am PT. Older video versions available there too. Finally, if you want an artisanal, hand-crafted digest of every week of the show notes in email form? Add your name and email to our friends of the show list, we'll never share it.
Python
Software development
fromInfoWorld
2 months ago

4 self-contained databases for your apps

XAMPP provides a complete local web stack (MariaDB, Apache, PHP, Mercury SMTP, OpenSSL) while PostgreSQL can be run standalone or embedded via pgserver in Python.
Python
fromTreehouse Blog
1 month ago

Python for Data: A SQL + Pandas Mini-Project That Actually Prepares You for Real Work

Effective data analysis requires combining SQL and Python skills in integrated projects that mirror real-world workflows, not learning them in isolation.
fromLoopwerk
2 months ago

Django's test runner is underrated

Readable failures. When something breaks, I want to understand why in seconds, not minutes. Predictable setup. I want to know exactly what state my tests are running against. Minimal magic. The less indirection between my test code and what's actually happening, the better. Easy onboarding. New team members should be able to write tests on day one without learning a new paradigm.
Web frameworks
Python
fromThepythoncodingstack
2 months ago

What's The Point of `itemgetter()` in Python? * [Club]

itemgetter provides a concise callable to extract items from sequences or mappings, offering clearer and often faster alternatives to equivalent lambda functions.
Python
fromRealpython
2 months ago

TinyDB: A Lightweight JSON Database for Small Projects - Real Python

TinyDB is a lightweight, pure-Python, document-oriented NoSQL database storing JSON documents and offering simple CRUD for small, local, single-process projects.
[ Load more ]