Relational Database At A Glance With PostgreSQL

Database 101

A database stores data

  1. Searches
  2. Simultaneous updates and reads
  3. Access control
  1. Traffic management for the data
  2. Manage concurrency
  3. Provide other features

ACID compliance

Atomicity — Store data in an all-or-nothing approach.

Database transactions

A transaction is a unit of work.

Beginning (BEGIN;)
Work (INSERT/UPDATE/DELETE/SELECT)
Ending (END;) results in one of the following:
COMMIT; (save everything)
ROLLBACK; (undo all changes, and save nothing)

PostgreSQL 101

PostgreSQL meets all the requirements to be a fully ACID-compliant, transactional database. To accomplish this, many database and computer science concepts are implemented. The focus of the course is to illustrate PostgreSQL internals and the effects they have on the end user.

PostgreSQL features

ACID compliant
Transactional (uses WAL/REDO)
Partitioning
Multi version concurrency control (readers don’t block writers)

Postgres Database limitations

Limitations
Terminology

Summary

PostgreSQL is an enterprise class, open source relational database management system.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Rajdeep Das

Rajdeep Das

Passion about Computer Science,Software Engineering. I help brands and Startups with software development.