Databases

• You can now ask your database questions and get answers without writing a single SQL query

  15/07/2026

  Say you run a small online store. Its database holds hundreds or thousands of orders, customers and products. All that information is genuinely valuable, yet until now, looking anything up meant opening a SQL client, knowing the table schema and writing queries by hand.

• Where do spam callers get my data? The truth behind massive data theft

  15/12/2025

  Where do spammers get my data from? If you’re one of those people receiving calls from unknown numbers offering products you don’t want, dozens of spam emails daily, or promotional text messages you never signed up for, you’ve probably asked yourself more than once: where the hell did they get my data from?

• 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.

• An overview of the most common commands in relational databases with SQL

  01/12/2024

  In the previous chapter, we reviewed the origins and fundamentals of databases. We took a brief journey through the different types of databases, including relational ones.