PostgreSQL in 100 Seconds

Рет қаралды 669,494

11 ай бұрын

Try Postgres with Neon bit.ly/neon-fireship right now. Postgres is one of the most popular open-source SQL databases. It is an object-relational database that supports a wide range of datatypes and design patterns. Learn the basics in this fast intro tutorial.
#programming #database #100SecondsOfCode
💬 Chat with Me on Discord
/ discord
🔗 Resources
Postgres Docs www.postgresql.org/docs/
Futuristic Databases • 15 futuristic database...
SQL in 100 Seconds • SQL Explained in 100 S...
🔥 Get More Content - Upgrade to PRO
Upgrade at fireship.io/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?

Пікірлер: 695

@Fireship 11 ай бұрын

Neon has been my goto Postgres host recently. Get a free database here bit.ly/neon-fireship

@shelby255 11 ай бұрын

cap

@fgclue 11 ай бұрын

are you telling fireship that his favorite postgresql host, inst his favorite postgresql host??

@PascalxSome 11 ай бұрын

Don't need autoscaling for my 5 individually started projects, that have each five tables with 10 entries each, and never will be touched again x)

@bobsmithy3103 11 ай бұрын

I've kinda been procrastinating from learning postgres, you guys got any good resource recommendations?

@Ashwin_1198 11 ай бұрын

dont lie

@h_maina 11 ай бұрын

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.

@fgclue 11 ай бұрын

same

@fabiandrinksmilk6205 11 ай бұрын

I was also a bit confused, but I think it's because he has covered it before in his databases rundown videos where he compares different databases or goes through them one by one. I'm glad he's making seperate videos for them though.

@theworldismine7788 11 ай бұрын

I also have expectations for a Django in 100 seconds video I wish it happens 😁

@h_maina 11 ай бұрын

@@theworldismine7788 I second this!

@redpillsatori3020 11 ай бұрын

#MandelaEffect

@7heMech 11 ай бұрын

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

@fgclue 11 ай бұрын

yea

@varadrane7 11 ай бұрын

He will never run out of content because front end frameworks exist.

@CyberKnightProbably 11 ай бұрын

The world of computer science is a mysterious place.

@fgclue 11 ай бұрын

@@varadrane7 true, like every week there's 3 new js or ts frameworks

@vikingthedude 11 ай бұрын

He still hasn’t done clojure

@amdgg1 11 ай бұрын

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

@dingdongmus 11 ай бұрын

Yeah I thought it was just sql for mac

@Stonium 11 ай бұрын

@@dingdongmus LOL

@muhdiversity7409 11 ай бұрын

OO = Bad.

@isurujn 11 ай бұрын

Same! That was a total 🤯 moment for me.

@poulet_malassis7607 11 ай бұрын

@@muhdiversity7409 Your comment = Worse.

@vulpo 11 ай бұрын

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.

@brucewayne2480 11 ай бұрын

Thanks for the info

@sfermigier 11 ай бұрын

The "Postgres + SQL" version was actually called "Postgres95" and released in 1994, according to the "Brief History of PostgreSQL" page in the official docs. It was renamed to "PostgreSQL" in 1996 for obvious reasons. When I started using Postgres in 1997 or 1998, the doc was severely lagging, and still called it "Postgres95".

@fred.flintstone4099 11 ай бұрын

Michael Stonebreaker then went on to create the databases Aurora (commercialized through StreamBase), C-Store (commercialized through Vertica) and H-Store (commercialized as VoltDB), and SciDB.

@EddieDemon 11 ай бұрын

Explains why old folk call it Postgres.

@MelkMan7 11 ай бұрын

Thanks for Googling this for us 👍

@Kevin-kf9ct 11 ай бұрын

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

@biomorphic 11 ай бұрын

This is not true, it really depends by the use case.

@anthonysteinerv 11 ай бұрын

For mf that only store data in databases yeah, for actual ppl with knowledge on databases, then no.

@hmmm....1910 11 ай бұрын

@@anthonysteinervcould you elaborate? Why is it not good as other sql databases?

@aguy278 11 ай бұрын

@@hmmm....1910 Speed, for one. Which is critical. People that see videos like this and are blind to real use cases all look like "But MongoDB is webscale" guy to me.

@neutralenull 11 ай бұрын

@@aguy278 Speed is not speed. You need to eleborate, write speed, read speed, query speeds... That is one of the many strenghts of postgres to be easy customisable. You need sharding, easy peasy use something like timescale. Need fast lookup for geodata, postgis it is.

@fgclue 11 ай бұрын

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

@aryushgupta8680 11 ай бұрын

for how long have you been using this software?

@buriburihighmon6385 11 ай бұрын

lmao got the video suggestion while I was writing a query in the pgadmin

@rohitaug 11 ай бұрын

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"?

@jazzymichael 11 ай бұрын

That's SQL, which is still used by postgres. The examples in this video are using an ORM that creates those queries under the hood.

@nahuelpiguillem2949 11 ай бұрын

They only teach Microsoft sql server, why so blind uni?

@bryceblankinship 11 ай бұрын

@@jazzymichael that is not true at all. he is using psql syntax to query a postgres database directly. no ORM is being used.

@wigglesworthmcgubbins5837 11 ай бұрын

@@nahuelpiguillem2949 The idea is to teach you the general theory. Postgres is great, but plenty of places don't use it. Better to teach SQL that at least somewhat resembles what you'll use everywhere, than focus too much on a single implementation just to come out to the real world where it's completely irrelevant a lot of the time. MSSQL may not be feature-rich in comparison to Postgres, but its syntax is close enough to other popular choices that learning it doesn't force you into a bubble

@plaintext7288 11 ай бұрын

Why learn what variables and constants are when you can write react?

@truthmatters7573 11 ай бұрын

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

@kenfreeman8888 11 ай бұрын

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!

@motherlove8366 11 ай бұрын

Talking about spreadsheets, I believe google doc allows you to use sql to get data from spreadsheets if you define specific table locations

@benniestudiospiano 11 ай бұрын

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

@45g4rerf45f45 11 ай бұрын

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

@harrywang4769 11 ай бұрын

operator overloading is the devil

@Keisuki 11 ай бұрын

@@harrywang4769 Operator overloading is lovely... But not in the database

@lawrencedoliveiro9104 11 ай бұрын

Not sure why I would want to use custom structured data types in a DBMS. That breaks normalization.

@45g4rerf45f45 11 ай бұрын

@@lawrencedoliveiro9104 This is the best for simple structured types when it makes no sense to give them an id. Think about complex numbers, colors, maybe money (value + currency), time (value + timezone), jsonb etc. I don't have experience with PostGIS but it probably also has custom types for shapes like polygons. Then, it makes sense to define custom operators for them, and then custom indexing.

@YeasinRafio 11 ай бұрын

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

@tammodirksen1408 11 ай бұрын

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.

@jl_117 8 ай бұрын

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

@SoCalledIvan 11 ай бұрын

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

@aryushgupta8680 11 ай бұрын

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

@driedpotatoes 11 ай бұрын

Whenever you think you need a new special purpose database, first check if postgres already does it

@romannasuti25 11 ай бұрын

Funnily enough, this also applies to Postgres’s own problems: Need to scale out or a better way to handle failovers? YugabyteDB literally lifts most of the storage-agnostic part of PSQL and staples it on top of an ACID distributed K/V store. It’s so compatible that frameworks like Django literally can’t tell they’re not talking to normal PostgreSQL (things literally only break when you try to use certain extensions like PostGIS because they don’t have GiST indexing yet).

@RealCaptainAwesome 11 ай бұрын

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

@captainkite 11 ай бұрын

This 100s videos are just gold.

@ryanvelbon Ай бұрын

Exactly 100 seconds ago I didn't know anything about PostgreSQL. Now I've added it to my CV.

@markanthonyponce9484 11 ай бұрын

Another quality minutes of content. Thank you Fireship!

@prajwalabraham9146 11 ай бұрын

After all these years, You finally made a video on Postgres.

@fellowabhi 11 ай бұрын

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

@choonyongtan5671 11 ай бұрын

It's crazy he still has content for his videos

@1_PieceOfCode 11 ай бұрын

I love watching this for fun now; when I really need to understand PostgreSQL, I will know exactly where to return.

@snailedlt 11 ай бұрын

Suggestions for the 100 seconds of code series: - Payload CMS ( A free and open-source, highly customizable code-first Content Management System ) - -Zig- - Vite - Vercel - Turborepo - FastAPI - Django - Edge Computing

@snailedlt 11 ай бұрын

Zig was covered fast!

@Famelhaut 3 ай бұрын

Also vite

@errap9523 11 ай бұрын

I hope this 100 seconds videos not to stop

@mohammedgazi786 11 ай бұрын

I am glad you made this video

@tadtakuma 11 ай бұрын

Cool to have one of these about a topic I actually know something about for once

@atalatal 11 ай бұрын

Thanks, added to my Resume!

@Robin_Goodfellow 11 ай бұрын

We use PostGres for a project at work. There's some mapping involved, so PostGIS proved really useful for that. Also, the JSON data type is great. If there are parts of your application that change really quickly, it can be much faster to put complex data in a JSON column rather than change the table schema every few weeks. Just make sure all of your data doesn't end up in there.

@candylook50 9 ай бұрын

What does PostGIS do?

@Robin_Goodfellow 9 ай бұрын

@@candylook50 It adds some GIS related functions to the database, like the ability to measure distances according to particular map projections, or check if a coordinate point is within some defined region.

@JosephHenryDrawing 11 ай бұрын

Wow I didn't know that postgres was object oriented, still learning this is crazy!

@samuelperez5211 11 ай бұрын

I was just learning about it yesterday lol, you read my mind

@fgclue 11 ай бұрын

same

@koketso_dithipe 11 ай бұрын

It's almost like you knew I was looking to learn a new DB technology

@NogCube 11 ай бұрын

Just when it's needed! 🔥🔥🔥

@YeasinRafio 11 ай бұрын

Bro can read my mind, uploads postgres in 100 secs just when I am interested in

@serdar_k 11 ай бұрын

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

@candylook50 9 ай бұрын

What is a strap project?

@jackbrabham 11 ай бұрын

Postgres is so cool that makes databases exciting to learn

@_Mackan 11 ай бұрын

Damn, I've been using postgres for ages and I learnt a ton of new stuff, lfg

@GeordiLaForgery 9 ай бұрын

Fascinating always wondered about postgres thanks

@bn8ws 11 ай бұрын

You overdid it with the sponsoring in this video

@stixels 11 ай бұрын

This is literally the first video I searched for when I was learning PostgreSQL and Prisma and I was so surprised it didn't exist before.

@candylook50 9 ай бұрын

What is prisma?

@stixels 9 ай бұрын

@@candylook50 It's an ORM that helps model your postgres database. He actually has a video on prisma in 100 seconds.

@blurtblaxter2708 10 ай бұрын

I built an entire ERP from scratch for my business, and now the database is already 2 GB and has 30 tables. The database is in MySQL because I couldn’t for the life of me understand PostgreSQL and I found your MySQL video very easy to understand. I always wished I did it all in PostgreSQL because I can see the limitations of MySQL. Now, when my ERP has thousands of lines of code and hundreds of columns, you post a PostgreSQL video… I’m not sure if I want to watch and risk remaking my entire database and backend.

@TomDoesTech 11 ай бұрын

Neon is really good, great sponsorship for the video!

@JohnnyMayHymn 11 ай бұрын

ooh, I was looking at it like Oracle DB-lite, now I can take your transcript and make yet another TODO list, thank you!

@MongoVFR 11 ай бұрын

This guy is a mind reader, I was just googling about Postgres the other day 😂

@mrrolandlawrence 9 ай бұрын

postgres is awesome & i love stored procedures / functions.

@atemrandyasong5710 11 ай бұрын

Jeff you took me out on Tables, Columns and Rows 😂😂. Like how did you take those literally 😂

@gytisbl 11 ай бұрын

great NEON ad. Enjoyed it! :D

@smallant. 11 ай бұрын

Just started using Supabase. This vid came at the best time.

@brianevans4 11 ай бұрын

I've used postgres quite a lot, but I had no idea that object syntax was possible or inheritance on tables. I guess I mostly stuck to the sql standard features, interesting to see those

@biomorphic 11 ай бұрын

Bro, PostgreSQL has had support for user-defined composite types, which are essentially lightweight object types, since version 7.1 which was released in 2001. However, more full-featured and robust object-relational capabilities were introduced in version 8.0. Oracle, instead, introduced some initial object-oriented capabilities like support for inheritance and REFs (object references) in 1992, and later on with version 8 in 1997. You really need to catch up with the world.

@aka5 11 ай бұрын

@@biomorphicrelational DBs == the world

@mandokir 11 ай бұрын

They are not _good_ features.

@-boiadeiro- 11 ай бұрын

Same. And what's interesting is orm like hibernate don't utilize this features, it generates basic tables for entities, then uses standard sql select's and joins, feels weird...

@fred.flintstone4099 11 ай бұрын

You can also create columns with the datatype JSON and then use JSON functions to query those columns.

@ann_uken 10 ай бұрын

Awesome explanation!

@johnvandenberg1448 11 ай бұрын

Great video, actually learned something new about Pg 🎉

@randerins 11 ай бұрын

Developing with Rails and PostgreSQL feels pretty smooth

@AnandSukumaranNair 11 ай бұрын

Well explained in 100s 👏🏻

@amithbhagat Ай бұрын

Thanks 🙏, you covered a lot in 2:30 minutes.

@_EDM115 11 ай бұрын

can't wait to see Fireship in 100 seconds

@ibendover4817 11 ай бұрын

Hade a case of the mandela effect thinking I already watched a PostgreSQL video from this channel. Was surprised to see this was recently posted.

@vinitgurjar957 11 ай бұрын

Loved this video 😍 As I use PSQL

@starship9874 11 ай бұрын

WE NEED a video about Googles Web Integrity API, which will most likely block Adblockers in any chromium based browser, it got merged into the chromium repo yesterday

@toxaq 11 ай бұрын

Ok, don’t use hstore or JSON types. hstore was the original key value type in v9.2 and was quickly replaced by JSON. JSON was then replaced by JSONB (a binary version which basically enables full document features). For me some of the amazing things about Postgres is the ability to use it to run queries that return full JSON which you can pipe out of an API. The JSON functions are super powerful and with CTE you can make amazing and insanely fast things.

@romannasuti25 11 ай бұрын

Hasura abuses the hell out of that JSON output feature, and while it’s awesome it does put more strain on a component that doesn’t scale horizontally. I guess there’s nothing stopping you from just using Yugabyte instead and saying “f**k it”

@jamesfoo8999 10 ай бұрын

@@romannasuti25 yeah careful putting your app functionality into the DB. Like everything it depends on the scenario

@candylook50 9 ай бұрын

Is histore called as H when shortened? I’ce heard it at work but I don’t get what it does.

@stith_pragya 10 күн бұрын

Thank You So Much for this wonderful video...........🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻

@calebvaccaro 11 ай бұрын

I needed this

@JayaTemara 6 ай бұрын

BRILIANT EXPLANATION EVER

@cm3462 6 ай бұрын

Awesome as usual

@avalacos 11 ай бұрын

I've used PG as a data analyst in multiple companies for more than a decade and have never seen these features... Mind blown

@tony_mushah 11 ай бұрын

I don't even know that postgres is an object oriented database. Thanks fireship

@DuncanBassBoost 11 ай бұрын

damn I was just using it as any other regular SQL database but it has so many more features, I'll have to take a closer look at it

@yewo.m 11 ай бұрын

I've used Postgres for a number of years but I never knew it's actually an Object-Relational Database

@jaysonp9426 11 ай бұрын

Same

@TheMyszeek 11 ай бұрын

Same xD

@nodidog 11 ай бұрын

Literally the first line of the first page of the documentation 😂

@jaysonp9426 11 ай бұрын

@@nodidog who reads that? :P

@demolazer 11 ай бұрын

Wow. As someone still learning, ive only used mysql for the most part, and am rather excited to use these postgres features now.

@candylook50 9 ай бұрын

What’s the main difference between the two? Trying to follow.

@philamonhemstreet8632 11 ай бұрын

Plus put the sponsorship disclosure at the front of you next amazing video! Thanks!

@tranceyy 11 ай бұрын

The beauty is that you can use postgresql for your basic RDBMS needs, but the more you know about it, the cooler it becomes.

@candylook50 9 ай бұрын

What is RDBMS?

@haliszekeriyaozkok4851 11 ай бұрын

I'm currently using postgres in an express.js project, it works so fast, i'm so happy with it. I'll probably use it with any kind of programming, except mobile, php or python.

@candylook50 9 ай бұрын

What is express.JS?

@haliszekeriyaozkok4851 9 ай бұрын

@@candylook50 it's a javascript http framework

@_EDM115 11 ай бұрын

that sponsoring is seamless and not boring 👏

@ArnoldsKtm 11 ай бұрын

surprised a video on pg was made only now

@BabaDka 11 ай бұрын

My favorite place to store data outside of VSAM.

@raideduela 11 ай бұрын

U got the golden content

@YeasinRafio 11 ай бұрын

Perfect! I was just thinking of learning postgres :)

@fgclue 11 ай бұрын

same

@F38U 11 ай бұрын

tbf you learn more about postgres working with postgres than trying to learn postgres

@F38U 11 ай бұрын

also, basically all your sql works

@YeasinRafio 11 ай бұрын

@@F38U thx for the suggestion buddy

@paprikar 11 ай бұрын

same bro

@dandogamer 11 ай бұрын

Definitely need a beyond 100s for postgres

@pandoraeeris7860 11 ай бұрын

This means nothing to me, but I really enjoy watching the videos!

@esteban-alvino 3 ай бұрын

It is a great video , informative and enterteined , citus interesting and other extensions worth the time to look at them I guess

@ThePotatoChronicler 11 ай бұрын

I didn't know most of that, even though I've used Postgres before, cool

@_gamma. 11 ай бұрын

PostGIS is awesome, love postgres!

@simondoesstuff 11 ай бұрын

The only man who can reasonably put **everything** on his resume

@justmrmendez 11 ай бұрын

Giving neon a try

@TheIronMan9 11 ай бұрын

Thanks for this video on PostgreSQL. Please make a video on Scala programming language.

@richardwhitehead4684 11 ай бұрын

Post GIS and scripting with Python is pure magic for spatial data science

@Anas_Alaqeel 11 ай бұрын

As a postgresql and postgresql ORMs user, I can confirm that the PostgreSQL is the one

@StephenRayner 11 ай бұрын

Make a video on Inngest events / queues. Looks sick!

@philipmurphy2 11 ай бұрын

Great video.

@SharatS 11 ай бұрын

Damn, I just started studying PostgreSQL today.

@RohanKumar-vx5sb 11 ай бұрын

postgre thank god an amazing open source alternative

@DereC519 11 ай бұрын

woa i was just learning this

@moritz_p 11 ай бұрын

It's crazy how much I didn't know about this even though I use it every day. Probably because I resort to ORMs so much

@Emekaelo 4 ай бұрын

The song that came up at "0 results found" is sending me😁

@azhagurajaallinall126 6 ай бұрын

Thank you for this 😊 Though i thought in past about "why DataBase handling is in limitted structure,syntax & why not/how to implement great features from programming languages" (and real life inspirations) + simple is often quite useful,though complex needs tools & talent,mind to look for that 😅 + Though Database is needed for simple storage,though in business case,it may increase,but just like pipelines or simply "Transporatation", All we have to do is "carry the object,message,document,etc,,." or so and programming languages are for working natively (mostly,even network means native work in cloud,passed via internet or some client sync) We should work around "available" tools,to squeeze it into work 😅 Still gotta know why/what/how to GraphQL & need to learn/create own,integrations,clean support to easily switch over,translate to one another tool (kinda good passion ideas 😊) Thank you for this again (though history to fill up time,well academics are this way 😅 getting college,sister kani to many memories) Wish all be well 😃🌟✨🙌 22.12.2023 09:01/2 pm ist (679th comment,25k+ likes,4,82,625+1 views)