PostgreSQL in 100 Seconds

#programming #database #100SecondsOfCode

💬 Chat with Me on Discord

🔗 Resources

🔥 Get More Content - Upgrade to PRO

Use code YT25 for 25% off PRO access

🎨 My Editor Settings

- Atom One Dark
- vscode-icons
- Fira Code Font

🔖 Topics Covered

- What is Postgres?
- Postgres quickstart tutorial
- Postgres vs MySQL
- Postgres vs SQLite
- Postgres vs Oracle
- What makes postgres different?
- What is an object-relational database?

[h_maina]

Before now, I would absolutely swear that there's already a 100 seconds of Postgres by fireship. Guess this is due to the level of expectations I have for jeff.

[amdgg]

I genuinely had no idea you could define types (objects) in Postgres. Always learning something in these

[heMech]

I'm surprised he still has content to make after so many videos.

[truthmatters]

That blew my mind. I had no idea it had all these amazing features !

[kenfreeman]

Your visual of an actual table with architectural columns on top crossed by oars (for "rows") is one of the most helpful things. Spreadsheets finally make sense. Thank you for that!

[vulpo]

Clarification: Michael Stonebraker created Postgres in 1985 as the successor to Ingres (which was a proprietary commercial DB). However, it did not use SQL as its query language. It used a variation of the QUEL query language called POSTQUEL. This may have stymied its adoption somewhat. It did not have a SQL interpreter until the mid-1990s after which it was renamed PostgreSQL in 1996 to emphasize that it did support SQL.

[fgclue]

It's great that all the Fireship videos about a software I'm using only get published when I need them

[Kevin-kfct]

Blows every other SQL database out of the water. And PostGIS is a whole thing in itself

[benniestudiospiano]

You literally made this video exactly when I needed it. Thank you so much!😀

[rohitaug]

The more videos I watch, the more I realize how little university actually teaches us. PostgreSQL seems so awesome, why did we only write stuff like "SELECT * FROM TABLE"?

[grerff]

As for custom types, Postgres also allows to easily define own custom operators ("User-Defined Operators" in documentation).

[tammodirksen]

I just love this channel. He always manages to pack a short video with usable visual information and it always gets me excited about the technology. And it never lacks humor.

[aryushgupta]

This semester I'm going to learn about this.
Thanks you Fireship for the good intro about Postgre SQL😁

[jl_]

0:00 I love the epic intros to these videos. the visuals and that music

[SoCalledIvan]

Thank you. I appreciate the content and the time you spent on making it.

[YeasinRafio]

How come he always makes the content just when I need it the most.

[RealCaptainAwesome]

Thank you. I am working on a personal project and this will help quite a bit.

[markanthonyponce]

Another quality minutes of content. Thank you Fireship!

[fellowabhi]

About damn time, just started a project with it and this notification was a heaven send cuz it's my first time with the 🐘

[serdar_k]

Your timing is impeccable! I was looking for a database host for my Strapi project!