Postgresql

• Master REST APIs with FastAPI and PostgreSQL: End-to-end tutorial with source code

  15/09/2025

  Disclaimer This article is intended for learning and experimentation purposes. Please note:The code and approaches shown may not be production-ready or follow all security best practices.

• Master Docker containers, volumes and networks

  01/08/2025

  Master the lifecycle of your containers, networks and volumes before taking the leap to production. If you’ve followed the series this far, you’ve already covered considerable ground.

• Automation and advanced logic in your database with functions and triggers

  15/04/2025

  In the previous chapters of this series, we’ve explored everything from foundational concepts of database design to more advanced SQL use cases using PostgreSQL. We’ve built a system to manage a public transportation network and covered how to define relationships between entities, perform complex queries, and even build views to simplify access to key data.

• Database views: What are they and how to use them?

  10/02/2025

  As databases grow larger and more complex, managing and accessing data efficiently becomes increasingly challenging. This is where database views come into play. A view acts as a “window” into the data stored in your database.

• Introduction to PostgreSQL, one of the most popular database engines

  15/01/2025

  In this series, we’ve explored various database engines, such as SQLite, and the fundamental concepts of the relational model. Now, we’ll dive into PostgreSQL, a relational database management system (RDBMS) widely recognized for its robustness, scalability, and extensibility.