Please enable JavaScript.

Coggle requires JavaScript to display documents.

Section 27: Database, In order to use Postgres we need to create a…

- - - - It is a collection of programs which allows us to access databases and work with data. And it also allows controlled access to database users.
      - So DBMS is a tool or piece of software that allows us to communicate with the database, store information that is useful for us and also allows us to update , insert, delete, look up whatever in the database.
      - There are 2 types of Database that are really popular and these are represented really well by Postgres and MongoDB
        
        Postgres
        
        Relational database, other example :- Oracle, SQL, MySQL, SQLite
        
        Relational Database are consists of two or more tables with columns and rows
        
        MongoDB
- - - - 1st install Psequel - GUI for Postgres
      - 2nd Install Postgres
        
        Where are many ways of installing Postgres but we will install from home-brew - it a way to download packages from internet from your terminal.
        
        Whenever you install something from home-brew
        
        Run => brew update - to make sure everything is updated.
        
        Run => brew doctor - which will make sure that everything is working in your system.
        
        brew install postgresql
        
        To start using it => brew services start\stop postgresql
- - - - CREATE TABLE table_name (column_1 datatype, Column_2 datatype, column_3 datatype);
      - GO To PostgreSQL site and check the datatypes.
      - CREATE TABLE users (name text, age smallest, birthday date);
      - => \d - to see all the tables in your Database.
      - => \q - to quit/exit from Postgres