</>CodexBash
All articles
Databases

PostgreSQL for beginners

Get started with PostgreSQL: installing it with Docker or natively, connecting with psql, creating databases, users and tables, essential data types, inserting and querying data, indexes, constraints, JSONB, backups, and the psql commands you will use every day.

CodexBash, , 5 min read

PostgreSQL, often just called Postgres, is a free, open-source relational database known for correctness, rich features and steady performance. It is the most loved database among developers in recent surveys and the default choice for many new applications, from student projects to large companies. This guide takes you from nothing to a working database: installation, connecting, creating tables, querying, indexes, a taste of its JSON support, and backups.

Sign in to read the rest

The whole 5 minute article is free with an account, along with every problem, lesson and tutorial. No card.