Database Archive

Postgres sql database cheatsheet

In this post, I am installing postgres on ubuntu and then will perform different sql operations on it. Installation commands may vary with other distributions like CentOS or Mac. To install: [crayon-5d5f4ac9e00d5777681867/] This will also install other dependencies. To connect to Postgres: [crayon-5d5f4ac9e0102778694711/] To check the login info, use the following command [crayon-5d5f4ac9e011b425333561/] By default, PostgreSQL will

Database Notes

  Relational database management system (RDBMS) A relational database like SQL is a collection of data items organized in tables. ACID is a set of properties of relational database transactions. Atomicity – Each transaction is all or nothing Consistency – Any transaction will bring the database from one valid state to another Isolation – Executing transactions concurrently has the same