📄️ Using extensions
Extensions in PostgreSQL are additional packages that provide functionalities that are not included in the core PostgreSQL. They can enhance the database's capabilities, offering features such as data types, functions, operators, aggregate functions, and more. In this tutorial, we will learn how to use extensions in PostgreSQL.
📄️ Understanding Postgresql data types
PostgreSQL is a powerful, open-source relational database system that uses and extends the SQL language. It offers a variety of built-in data types. Understanding these data types can help you build robust and high-performing databases. In this article, we will explore the various data types offered by PostgreSQL.
📄️ Full-text search
Full-text search is a technique for searching text content in database systems. It is a powerful feature in PostgreSQL that allows users to perform complex word searches against character-based data.
📄️ Spatial and Geographic objects
In this tutorial, we will be covering Spatial and Geographic objects; one of the advanced features in PostgreSQL. By the end of this tutorial, you should have a good understanding of how spatial and geographic objects work in PostgreSQL, and how to use them in your database projects.
📄️ Window functions
Window functions are a powerful feature of PostgreSQL that allow you to perform calculations across a set of table rows that are somehow related to the current row. This is akin to an advanced type of aggregation where you can look at surrounding rows to compute a value. In this article, we will learn about the usage and advantages of window functions in PostgreSQL.
📄️ Common Table Expressions (CTEs)
Common Table Expressions, or CTEs, are one of the advanced features in PostgreSQL. They offer a more readable and organized way to write complex SQL queries. CTEs can be thought of as temporary views created just for one query. They can be especially useful when working with recursive queries, or when a subquery is needed multiple times in a larger query.