Database
Design and manage data systems with PostgreSQL, Redis, and SQLite — from fundamentals to production-ready architectures.
Python includes a powerful built-in database package called sqlite3, which provides direct access to SQLite.
SQLite is one of the most practical technologies in software engineering. It forms the bridge between plain files and full database servers.
This introduction explains how PostgreSQL works as a relational database server and why it is widely used for web applications. It covers SQL, tables and relationships, indexes, transactions, MVCC, constraints, query planning, storage, replication, data types, performance, security, and how PostgreSQL works underneath Django’s ORM.
Join the Newsletter
Practical insights on Django, backend systems, deployment, architecture, and real-world development — delivered without noise.
Get updates when new guides, learning paths, cheat sheets, and field notes are published.
No spam. Unsubscribe anytime.
There is no third-party involved so don't worry - we won't share your details with anyone.