PostgreSQL, also called PostgreSQL, is one of the most popular SQL database management systems (DBMS) ever.
It is Open Source, free for personal and commercial use, and it has a long history that started in 1996, building on top of other software that dates back to the 1980’s.
PostgreSQL is a really complete and full-featured general purpose relational database.
It provides support for most of the SQL standard, and also builds on top of it its unique set of features, to provide us a great tool.
You can find the project homepage at https://www.postgresql.org.
We can interact with a PostgreSQL database using many different programming languages. Internally, being a relational database we’ll use SQL to insert, query and manipulate the data.
More PostgreSQL tutorials:
- How to install PostgreSQL
- PostgreSQL user permissions
- How to list all users in PostgreSQL
- How to list all databases using PostgreSQL
- How to switch database using PostgreSQL
- How to create a PostgreSQL database
I am going to write a lot of PostgreSQL tutorials in the near future. I will link them here.
One more thing! ⚠️ ✋
It's a 10-weeks long cohort online course where I will guide you to becoming a Web Developer.
It's not "just a course". It's a big event I organize once a year.
We'll start from zero, learn the fundamentals of Web Development, HTML CSS, JavaScript, Tailwind, Git, using the command line, VS Code, GitHub, Node.js, we'll then learn React, JSX, how to use PostgreSQL, Astro, Next.js, Prisma, deploying on Netlify/DigitalOcean/Fly/Vercel and much more!
At the end of the first 10 weeks you'll know how to create web sites and web applications and I'll unlock you the 2nd phase of the Bootcamp: you will get access to a large number of projects exclusive to the Bootcamp graduates, so you can follow my instructions to build things like private areas with authentication, clones of popular sites like Twitter YouTube Reddit, create e-commerce sites, and much much more.
Because once you got the fundamentals, you only learn by working on real, exciting projects.
To find out more, visit bootcamp.dev