Contents
What is Postgres good for?
Postgres allows you to store large and sophisticated data safely. It helps developers to build the most complex applications, run administrative tasks and create integral environments. We’ll compare Postgres with other SQL and NoSQL databases to see why choose PostgreSQL over other options.
What can you do with Postgres?
5 Interesting Things You Can Do With PostgreSQL
- Create Your Own Data Types.
- All DDL Is Transactional.
- You Can Query XML Data.
- Streaming Replication Is Baked In.
- Supports 12 Authentication Systems.
What are the features of PostgreSQL?
PostgreSQL feature highlights
- User-defined types.
- Table inheritance.
- Sophisticated locking mechanism.
- Foreign key referential integrity.
- Views, rules, subquery.
- Nested transactions (savepoints)
- Multi-version concurrency control (MVCC)
- Asynchronous replication.
Why is PostgreSQL a good tool for a developer?
In addition, PostgreSQL integrates easily with standard operating system backup and monitoring tooling. For these reasons, Postgres is a great enabler for developers across the entire application lifecycle — from prototyping to production.
What are the advanced topics in PostgreSQL DBA?
Advanced topics: transactions, CTE, subqueries, lateral join, grouping, set operations. DDL queries: managing tables and schemas (create, alter, drop). Import and export data using COPY. Get understanding of the main aspects of how Postgres could be configured.
What are the high level concepts of PostgreSQL?
Get basic understanding of Postgres key terms and basic RDBMS concepts. Object model: data types, columns, rows, tables, schemas, databases, queries. Relational model: domains, attributes, tuples, relations, constraints, NULL. Databases high-level concepts: ACID, MVCC, transactions, write-ahead log, query processing.
What’s the best way to manage a Postgres database?
Managing Postgres service using systemd (start, stop, restart, reload). Managing Postgres service using pg_ctl, or OS-specific tools (like pg_ctlcluster ). Connect to Postgres using psql. Deploy database service in cloud environment (AWS, GCE, Azure, Heroku, DigitalOcean, etc…).