Open-source relational database known for SQL compliance, extensibility, JSON support and reliability in production workloads.
Pricing: 0 USD · Updated 2026-09-03
dataPostgreSQL is free to use (price checked 2026-09-03).
PostgreSQL is a data — best for open-source relational database known for sql compliance, extensibility, json support and reliability in production workloads.
Pricing was verified on 2026-09-03 from the official PostgreSQL website.
SQL vs NoSQL compared: how relational and non-relational databases store data, the ACID and BASE trade-offs, and how to choose between them.
A database index is a data structure that lets a database find rows without scanning the whole table, usually a balanced tree (B-tree) ordered by the indexed columns. It makes equality, range, sort and join queries fast, at the cost of write overhead and storage. This guide explains how indexes work, clustered vs non-clustered, and when (and when not) to create one.
SQL injection is one of the most common web vulnerabilities — this guide explains how it works, the main attack types, and the secure coding practices that prevent it.
A database transaction bundles several operations into one all-or-nothing unit. This guide explains transactions, the ACID properties (atomicity, consistency, isolation, durability), and isolation levels.
Open source licenses decide how others can use, modify, and distribute your code. This guide explains permissive licenses (MIT, Apache 2.0), copyleft licenses (GPL, AGPL), and how to choose the right one for your project.
A relational database stores data in tables of rows and columns connected by keys, using SQL to query and manage it. This guide covers the relational model, normalization, transactions, and when to choose an RDBMS.
A SQL query is a declarative statement that asks a relational database for data. This guide explains the SELECT statement, WHERE filtering, JOIN across tables, GROUP BY aggregation, and how to read a query plan.
Database normalization is the process of structuring a relational database according to a series of normal forms to reduce data redundancy and improve data integrity. This guide explains why normalization matters, walks through 1NF, 2NF, 3NF, BCNF, 4NF, and 5NF with worked examples, and when denormalization is the right trade-off.
