Wait... PostgreSQL can do WHAT?

Рет қаралды 184,412

Күн бұрын

Is it even a database anymore?.. I'll show you how PostgreSQL ALONE can replace ALL your backend stack components.
0:00 - is it even a database anymore?
1:15 - the quickest history of PostgreSQL
2:34 - object-relational database
4:38 - table inheritance
6:03 - pg_trunk: a package manager for PostgreSQL extensions
7:31 - stored procedure that uses python's pandas
7:55 - your database is not a DUMB store
8:38 - PostgreSQL's FEATURE OF FEATURES
9:04 - pg_cron & hstore: replacing redis cache
10:53 - NOTIFY/LISTEN: replacing redis pub/sub
11:51 - pgmq: replacing message queue like SQS
13:10 - JSONB: replacing MongoDB
13:29 - NoSQL vendors mimic SQL
14:26 - Apache AGE & TimescaleDB: replacing graph and time series databases
15:09 - FTS: replacing ElasticSearch
16:20 - pgml: LLM and chatbots running in PostgreSQL
16:39 - Postgrest: no-code REST API for your DB tables
18:06 - pgtap: unit-testing for PostgreSQL
18:42 - pg_graphql: no-code GraphQL API for your DB tables
19:06 - Omnigres: PostgreSQL as a platform
19:25 - "boring technology" and "radical simplicity" with PostgreSQL
20:03 - trying to play pg_doom (Doom in PostgreSQL)
Code & links from the episode: github.com/vivus-ignis/the-ar...

Пікірлер: 550

@ZedZark 2 ай бұрын

PostgreSQL is my favorite OS

@Septumsempra8818 2 ай бұрын

Wait til you use it as a compiler.

@creativecraving 2 ай бұрын

Is it better than Emacs?

@kratosgodofwar777 2 ай бұрын

PostgreSQL is my favorite motherboard

@Danielo515 2 ай бұрын

It just needs a nice editor, just like emacs (emacs also needs a great editor)

@dasistdiewahrheit9585 2 ай бұрын

@@creativecraving Both operating systems, PostgreSQL and Emacs have the same problem: they lack a good editor.

@robertbarta2793 2 ай бұрын

The chosen terminal width should be counted as war crime.

@TheArtOfTheTerminal 2 ай бұрын

I hear you. That will change in the next video.

@U20E0 2 ай бұрын

echoed

@unixtreme Ай бұрын

Relic of a past time. Thankfully we have better tech now 😂

@maksimmuruev423 Ай бұрын

Yes especially terrible on ultrawide monitors.

@szlomobronsztajn3115 Ай бұрын

@@TheArtOfTheTerminal also could you go a little slower when showing the examples? It's like you type, execute and promptly switch to another thing - maybe some commentary during the typing?

@Bozebo 2 ай бұрын

I was in the MariaDB IRC to report a bug back in 2014, one of the devs said "I dunno I use postgres", so I switched the project I was working on at the time to postgres (equivalent connector API usage worked instantly without the bug) and it's been my go to ever since :P

@TheArtOfTheTerminal 2 ай бұрын

Niice

@MatheusCamposdaSilva Ай бұрын

lol

@mixed7991 Ай бұрын

😂

@TheTwober 2 ай бұрын

"But can it run Do..." "Yes." I am sold!

@mast_g Ай бұрын

Omg it's real. jfc

@tetrahedralone 2 ай бұрын

The problem with many plugins is the significant lack of documentation and support. Numerous plugins are written with awful documentation leading to considerable time spent trying to figure out how it works, only to find that there are undocumented issues to deal with. That is the downside of having people develop what they feel like and then walk away.

@FaberFedor 2 ай бұрын

@caty863 There's one reason.

@TheArtOfTheTerminal 2 ай бұрын

That's the problem of opensource in general imo. Remember corejs story? www.theregister.com/2020/03/26/corejs_maintainer_jailed_code_release/

@JayLooney 2 ай бұрын

@@TheArtOfTheTerminal Happened shortly after I started using ReiserFS as well. "BDFL/Primary Developer goes to prison" is not a new story for Open Source. One of the reasons major projects transition to some sort of foundation stewardship model

@cybernetic-ransomware1485 Ай бұрын

@@TheArtOfTheTerminalnot only in opensource code

@benwatson5211 Ай бұрын

100% agree. frustrating as fuck.

@herzog0 2 ай бұрын

Never get rid of these sounds you used. The soundtracks, typing sounds etc.. it's awesome

@TheArtOfTheTerminal 2 ай бұрын

ASMR for nerds :) Thanks for the feedback!

@wenbozhao4325 2 ай бұрын

25 years ago I learned that stored procedures are bad. Now I'm seeing this 😂🎉

@nandesu 2 ай бұрын

Why are Stored Procedures bad? They make life so much easier. $.02

@andrejss 2 ай бұрын

@@nandesueasy to make your future much more difficult. maintaining & remembering who did what where and debugging it all will be a nightmare.

@TheArtOfTheTerminal 2 ай бұрын

Stored procedures should be treated just like any other code: with CI/CD practices. Debugging is always hard and imo the best you can really do to troubleshoot issues is to have great logging.

@cptmorgan92 2 ай бұрын

I don’t like to couple any logic to the database. In my opinion stored procedures should just be used to extend the functionality. In the company I work they implemented a lot of logic in the oracledb to convert imported csv/excel and more to their own datastructure, Sync data between customers Do calculations for orders Scheduled jobs like emails And other stuff. These are things I would have decoupled in external services or in a middleware. In my opinion a database should just be used as a sink and source of data. The only reason to touch a db is to improve performance. Anything else should be done in a middleware.

@sir_no_name1478 2 ай бұрын

I am coding for 5 years and managed a Database with 10k lines of code because of the procedures. It was very nice because once it is setup it is stable af. I used mariadb and it was the first time. We also made a lot of mistakes but the procedures were not one of them. The main Problem was using an SQL db for a web scraper with very heterogenic data ^^, but that is just a tangent.

@05xpeter 2 ай бұрын

At my former job our postgres was the message queue, with pub/sub and triggers. The caching layer, with tables with json columns, where triggers invidated the cache. The caching layer to slow on prem oracle servers, with materialized views and oracle-foreign datawrapper, a time traveled database producing data as it was using views and the temporal extension and a cron job orchestrator using pg_cron and stored procedures.

@TheArtOfTheTerminal 2 ай бұрын

Interesting. Could you share your experience in terms of pros and cons for such an infra?

@05xpeter 2 ай бұрын

@@TheArtOfTheTerminal We had very good experiences allot of the trigger logic and the CI/CD part was not a problem. We were a small team of 4 developers. So we did not have big problems of resource sharing and silos. That would be something I would expect happen in larger setups. Generally my experience was that it worked fine overall. Generally I like the minimalistic setup, so you don't need 5 gb of ram to have a local system up and running and the fact that all your services can talk to each other unhindered. If we had 2-3 times as many developers, I would probably have suggested to split it more up.

@i_dont_want_a_handle 2 ай бұрын

Respect, that's a lean company

@05xpeter Ай бұрын

@quanghuynh9300 We experienced that the users network was the bottleneck using AWS aurora postgres. In inter data center traffic is much faster than network calls, so we could see that there where limited gains even for a faster in memory solution

@dtoad5576 3 күн бұрын

I have no idea what I just read here lol

@martinoserri8814 2 ай бұрын

Proud to have been using Postgresql since 1998

@dest5218 2 ай бұрын

Hey this might be really random, but I am about to graduate from Uni, and I want to know what I can do to get a job in the tech field. You seem like you got experience so I'd like some advice, cause I've been watching videos on how to get a job and tbh it's scaring me a bit lol. Any help would really be appreciated ❤

@lhpl 2 ай бұрын

I believe I began looking into it when it still used the rather "perishable" name Postgres95...

@lumipakkanen3510 2 ай бұрын

Sometimes the recommendation algorithm is scary accurate. This was exactly what I needed, and I didn't even have to search for it. Great video!

@sandworm9528 2 ай бұрын

My thoughts and prayers are with you brave traveller

@home1250 2 ай бұрын

How I’m kinda feeling rn

@TheBenjaminsky Ай бұрын

My main thought reading these type of comments is "please don't have a great business idea and build it this way."

@AdityaYada Ай бұрын

true The online course I follow. this is what I read in the notes. "We've moved away from Mongo to Postgres because our research on tech recruitment showed us that companies are looking for more SQL-based DB competence and moving away from Mongo and NoSQL." Now KZfaq recommended this to me. SCARY isn't it ?

@andud Ай бұрын

Be carefull what You wish for :). It is heading for "my wish exactly, as I wanted it... turned nightmare".

@senjaz 2 ай бұрын

The reason MySQL was fast was that it was missing a lot of basic features and wasn’t even ACID compliant. At that point it could hardly be considered a real database. Still glad I took the time to evaluate different databases and found PostgreSQL, instead of blindly following the LAMP crowd. I’ve been a happy PostgreSQL user for over 20 years.

@ScottEdwards2000 2 ай бұрын

yeah used to make me so mad back then to hear devs at work go on and on about MySQL. When I would bring up ACID and ISO SQL Standard compliance -- and how that MIGHT be useful if they ever need to switch databases -- I was just met with blank stares. It's like all they wanted was a "bit bucket" or something. What's worse is, who paid the price for this stupidity? I have yet to hear of anyone's business or career ruined for being so ignorant of these critical issues. If anyone knows of any good stories, please share 🙂 It's like they all got away scott-free and moved on -- now all those guys would probably talk about how much they love PSQL!

@beepbop6697 Ай бұрын

Fast? We dumped MySQL because of all the performance issues with it.

@CalifornianViking Ай бұрын

Postgres is faster than MySQL. I switched in 2016 and never looked back.

@jeffspaulding9834 Ай бұрын

@@CalifornianViking It wasn't faster in the late 90s or early 2000s, when LAMP was the hot new thing and everyone was using it. Or earlier than that when Mod Perl was the backend of choice for "real" developers. But more to the point MySQL had more tools built around it and was easier to get into. Everyone learned it because it was easy to learn. PostgreSQL had more functionality but a bit more of a learning curve. Obviously things have changed since then.

@senjaz Ай бұрын

@@beepbop6697 It was considerably faster than Postgres back in the 90s, for the reasons I stated. Postgres has always been a reliable database, mySQL hasn't.

@LightningMcCream 2 ай бұрын

As a Postgres fanboy who's never spent much time with postgres plugins, this has made me so excited to try to use my PG databases to replace some of the other services I'm using! Thanks for the awesome video, easiest subscribe I've clicked in a long time!

@Schisek 2 ай бұрын

Postgres + HTMX incoming

@edism 2 ай бұрын

😂

@Manwithnoname838 2 ай бұрын

On it

@Alguem387 2 ай бұрын

The GigaChad web stack

@okie9025 Ай бұрын

The "I made a grifting NFT pyramid scheme in 20 lines of code" tech stack

@caderzo 2 ай бұрын

I'm glad the algorithm brought me here, what a gem. I use PostgreSQL every day and did not know it was this extensible. I enjoyed the video format and wish you success with the channel, subscribed!

@TheArtOfTheTerminal 2 ай бұрын

Thank you for support!

@Levi_OP 2 ай бұрын

Great video! Loved everything about it! The way you presented was great, the pacing was good, and the trippy terminal display with the typing sounds was just awesome. Subscribed!

@TheArtOfTheTerminal 2 ай бұрын

Thank you so much!

@plaintext7288 2 ай бұрын

Postgres is one of the best operating systems ever! Good thing they even ship a decent database with it🎉 (I have only ever used Postgres for big projects and not more than 10% of features)

@BradleyKieser Ай бұрын

What an absolutely brilliant coverage of Postgres! Excellent video.

@nesgoof3412 2 ай бұрын

Very nice video! I love how you have long takes and not cut every half second like so many KZfaqrs do nowadays.

@TheArtOfTheTerminal 2 ай бұрын

Thank you for the feedback. I too am tired of the flashy mr.beast-style editing :)

@nesgoof3412 2 ай бұрын

@@TheArtOfTheTerminal Agreed. It's so much more easier to focus on the content when the pacing is relaxed and there's no context switching a billion times per video. Keep up the good work!

@kellymoses8566 2 ай бұрын

I HATE it when a KZfaqr constantly cuts between two cameras for no reason.

@Cranked1 2 ай бұрын

Surprisingly good video. Had expected much less to be honest but the short explanations with shell examples were great.

@TheArtOfTheTerminal 2 ай бұрын

Thank you for the feedback! Happy you liked it.

@tomthetitan101 2 ай бұрын

Incredible format for a video, love the sound effects lol

@someguyO2W 2 ай бұрын

As someone who built applications fully in the database (looking at you Oracle), it's not for the faint of heart.

@RevHardt 2 ай бұрын

Can you please tell us about some scary scenarios you've dealt with?

@savire.ergheiz 2 ай бұрын

Oracle are way over engineered on the language side. They have the sole intention of catering to enterprises. Their PLSQL documentation are humongous but tbh many of their features are useless and keep changing over the years which is probably intended since enterprises dev loves having to work on changing stuff without gaining nothing just to keep the money rolling in 😁

@someguyO2W 2 ай бұрын

@@savire.ergheiz that's true but besides the point. Building in the database is hard. Very hard.

@someguyO2W 2 ай бұрын

@@RevHardt I took over a web application from someone who decided that building the entire app in postgres was a good idea. And this was before the modern tooling that we have now. They had a php frontend that acted as a proxy. Would convert the request into a stored proc and return the response to the client. Holy lord that was a hard app to modify and debug.

@someguyO2W 2 ай бұрын

@@RevHardt most of my other experiences came from working in a banking application built on oracle. You don't know pain until you have to follow cascading triggers.

@MattHeslington 2 ай бұрын

Loved this, cheers. Recently just moved to using Postgres for the first time, and am so glad I did

@CalifornianViking Ай бұрын

I have used Postgres extensively. Consolidated document databases, key value stores, graph, and time series. It is truly an amazing database. Two things worth mentioning: PostGIS is a geographic information system in Postgres, it can compete with ESRI. AWS Aurora Postgres is fast.

@Marc42 2 ай бұрын

Postgres in 2024 looking great, thanks for sharing!

@TheArtOfTheTerminal 2 ай бұрын

Thank you for the feedback!

@andythedishwasher1117 Ай бұрын

I'm so happy right now. I just integrated Postgres as a module into my automation stack, treating it like a boring old table, column, and row relational rigamarole. That all works, but what you just revealed here tells me that I can adopt some way slicker strategies, and my stack now has a fully integrated solution for a whole range of problems I haven't even approached yet. I'm 100% on team BoB (Bet on Boring), but I would add that many boring things can combine to make very exciting things, as we are seeing in Postgresql's feature set.

@NeotenicApe 2 ай бұрын

Great video. God I love PSQL and the open source community. I would have loved for you to talk about scalability and partitioning (e.g., vs Scylladb)

@tehphoebus Ай бұрын

Great video. Thank you. Its been one of my favorite DBs for years. Its interesting how everyone that keeps chasing the new shiny, wnd all the things i learn back in the 90s and 00s keep coming back.

@Marque734 Ай бұрын

Cryptocurrency comes back every few years. People rediscover scams and bad ideas all the time. Retro is just a weird form of chasing the new shiny. When we stopped doing things, there is usually a reason.

@thelanavishnuorchestra Ай бұрын

Oh, man. I'm sold. I had no idea is was such a complete solution. I'm feeling a database powered app development system coming up in my near future.

@droydi 2 ай бұрын

Solid and well presented information, thank you for sharing this. Looking forward to the next one!

@loganbries3867 2 ай бұрын

Great video, hope your channel grows!

@TheArtOfTheTerminal 2 ай бұрын

Thank you so much!

@sinamobasheri Ай бұрын

The dude went completely crazy at the end 😆😆😆😆😆 Nicely done video, good job and thank you! You deserve a million subscribers 😎

@TheArtOfTheTerminal Ай бұрын

Thank you so much!

@evadeflow 2 ай бұрын

Thanks for this, it's really helpful to know how much I can lean on Postgres in my various side projects. I've been getting a bit bogged down trying to emulate the tech stacks the 'big boys' are using, but... it shatters my focus and prevents me from getting things done. You've inspired me to try a different approach: I'll just put _all_ the backend stuff in Postgres by default, and only move things if/when forced. Seems liberating, honestly, to ignore all these hyped-up technologies and just get 💩done!

@abdullahhejazi 2 ай бұрын

Great video, didn't know PosegreSQL is this awesome also please have the terminal full screen or at least bigger horizontally so it can be more readable.

@TheArtOfTheTerminal 2 ай бұрын

Thank you :) Will do.

@speedstyle. 2 ай бұрын

It was fine a lot of the time, but eg 6:16 when you used rustup the progress bars overflowed

@marioscheliga7962 Ай бұрын

Thank you 🙏- I like the perspective to leave out network within the backend services 🤘

@andydataguy 2 ай бұрын

Bro your content is great!! Thank you!! I'm a believer now 🙌🏾💜

@TheArtOfTheTerminal 2 ай бұрын

Thank you so much :)

@MichaelRainabbaRichardson Ай бұрын

🤯 Having written MS SQL CLR Assemblies, I REALLY appreciate this approach! Thanks for making me see the light 😝

@TheArtOfTheTerminal Ай бұрын

Happy you liked it!

@thiloho Ай бұрын

Fantastic video, very interesting and insightful. Keep up the good work!

@TheArtOfTheTerminal Ай бұрын

Thank you! Happy you liked it :)

@professortrog7742 2 ай бұрын

Outstanding content. At the moment you mentioned PostgREST you got my sub and 👍🏻

@dog4ik 2 ай бұрын

That is wild. I will try it out in my projects

@spacewolfjr 2 ай бұрын

Great video! I'd love to know more about running Postgres in a production-like environment.

@Siejec Ай бұрын

Very cool vid man! Keep it up!

@complexity5545 Ай бұрын

This is one of the best PostgreSQL videos that I have ever seen on the web.

@TheArtOfTheTerminal Ай бұрын

Thank you so much :)

@deado7282 2 ай бұрын

What a great video. Exciting topic, excellent presentation.

@TheArtOfTheTerminal 2 ай бұрын

Thank you for the kind words :)

@prometeoprime9893 2 ай бұрын

Quality content, subscribed!

@alexischicoine2072 2 ай бұрын

Super interesting thanks for sharing! Curious how well that can scale and at what point it becomes easier to scale application servers and keep the database lean.

@boo_1096 Ай бұрын

Haha wow! I've used postgres at my job for a via ORM, but I did not know it was this capable! I've always preferred pg due to its stability (IME) compared to mariadb when hosting stuff for my homelab. I'm kind of excited to look into some of this and build a project around it.

@BenjaminVestergaard Ай бұрын

During my apprenticeship I was dealing with Oracle and DB/2 servers. That taught me the advantages of procedual languages like PL/SQL. But those servers weren't exactly affordable to the common hobbyist at that time. MySQL was fast but didn't have any sort of PL at that time. So I ended up starting to use PostgreSQL for my own projects, to get the features I had gotten used to and more. It wasn't the fastest but it was more grown up than other free SQLs.

@dacam29 2 ай бұрын

I love the new Oracle Forms

@petrusboniatus 2 ай бұрын

I Love this felling when you accidentally step on new rabbit hole. I was thinking about serving hmlx directly from the database. Seems like someone already did it 😂.

@ivanily4 Ай бұрын

Great video. Thank you for your work.

@aurelienregat-barrel9217 Ай бұрын

Quite impressive how this DB has evolved

@sir_no_name1478 2 ай бұрын

Wtf this is your 5th Video? You have really great Quality of making Videos

@TheArtOfTheTerminal 2 ай бұрын

Thank you :)

@thelateweeb2799 2 ай бұрын

This is a cool video! Thanks for informing us!

@TheArtOfTheTerminal 2 ай бұрын

Thank you! Happy you liked it :)

@babatundeadeyemi4412 2 ай бұрын

You just earned a subscriber! 🙌

@jirisuster6165 2 ай бұрын

Incredibly great video

@TheArtOfTheTerminal 2 ай бұрын

Thank you very much!

@CrazyMan42DABOMB 2 ай бұрын

Thank you so much for this video. I've been a professional Postgres fanboy since 2018 and you've still taught me a ton. Gonna go uninstall couchbase and give postgrest a try now...

@TheArtOfTheTerminal 2 ай бұрын

Happy you liked it :) Thank you for the feedback!

@AnsisPlepis 2 ай бұрын

Amazing video and exactly what i wanted to know more about

@TheArtOfTheTerminal 2 ай бұрын

Glad you liked it :). Thank you for the feedback!

@Rein______ 2 ай бұрын

Yes! I love this so much!

@EzequielRegaldo Ай бұрын

All those features should be use to power up dump storage, we should save all potential to expensive tasks related to storage. Thank you for your content!

@RobertOSheaGameDev 2 ай бұрын

Came for PostgreSQL content, stayed for the Oblivion reference

@andyburnett4918 2 ай бұрын

Ok, you have totally convinced me to go and spin up a Postgres instance. I will be back in a couple of months! And thanks for a great video.

@TheArtOfTheTerminal 2 ай бұрын

Thank you! Extremely interesting to hear back from you on your experience afterwards.

@himanshupandey9303 2 ай бұрын

you have earned a sub, ser. Wowzie

@Fido1hn Ай бұрын

I really enjoyed this video. Gained a subscriber.

@fastatall1874 2 ай бұрын

Very informational video

@Andrii-zc4dp 2 ай бұрын

Yea, I use arch btw, you can use PostgreSQL if you like :)

@REDIDSoft 2 ай бұрын

Amazing video I Love PostgreSQL

@Requiem100500 Ай бұрын

Truly the EMACS of databases

@BryonLape 2 ай бұрын

I started using Postgres back in the early 90's with version 4.2. Back then, you downloaded the code and built it yourself. Used table inheritance back then as well.

@nicoladellino8124 2 ай бұрын

Very useful video, THX bro.

@adrianmisak07 2 ай бұрын

thank you for the video, subscribed immediately

@TheArtOfTheTerminal 2 ай бұрын

Cool, thank you so much!

@m12652 2 ай бұрын

Excellent video, cheers 👍

@TheArtOfTheTerminal 2 ай бұрын

Thank you!

@davidmc971 2 ай бұрын

Great video, learned some new stuff, thanks!

@TheArtOfTheTerminal 2 ай бұрын

Thanks for the feedback!

@VorpalForceField 2 ай бұрын

Impressive and Very Cool ... Thank You for sharing .. Cheers :)

@DuuhK 2 ай бұрын

you about to blow up on this one my boy

@RoryDavidWatts 2 ай бұрын

Great video! Really interesting.

@TheArtOfTheTerminal 2 ай бұрын

Thank you :)

@marcosoliveira8731 2 ай бұрын

What a platform!

@misterlinuxfriendly947 2 ай бұрын

Great video, thank you. Subscribed!

@TheArtOfTheTerminal 2 ай бұрын

Thank you so much

@pr0way Ай бұрын

It's insane what's possible to do with PostgreSQL. From this 20 minutes wideo I get whole stack of technology to learn for next 2y...

@MiklosGalicz 2 ай бұрын

PG has been my go to DB for the past couple years, so thanks for the examples, but I have to wonder about, source code versioning, scalability and general performance.

@calvinli4732 2 ай бұрын

great research and summaries on postgres! I

@TheArtOfTheTerminal 2 ай бұрын

Thank you :)

@mwguy 2 ай бұрын

Amazing!

@Diapolo10 2 ай бұрын

I'll be honest, I had no idea most of the stuff on this video was even possible. Neat!

@david2358 2 ай бұрын

Thanks, just subscribed 🎉

@hassaanalansary 2 ай бұрын

Wow very informative. It is mind blowing. Small suggestion: try not to paster large chunks of text at once. And if so leave them a bit longer on the screen

@TheArtOfTheTerminal 2 ай бұрын

Thank you for the feedback, really useful. Will definitely improve the demo part.

@guilhermecarvalhotrindade2625 2 ай бұрын

Excellent content, great presentation. Please make your terminal wider in future videos 😢.

@TheArtOfTheTerminal 2 ай бұрын

Thanks for the feedback. Yes, I hear you re: terminal size. Will be fixed.

@Bobcat30010 2 ай бұрын

Here because Pirate software sent me

@catalinmarianmursa7892 Ай бұрын

Thank you!

@ab2qik 2 ай бұрын

Nice demo.

@muhammadbadar6089 Ай бұрын

awesome video super informative

@UnhingedNW 2 ай бұрын

Great video!

@TheArtOfTheTerminal 2 ай бұрын

Thank you :)

@beloaded3736 2 ай бұрын

So underrated channel, instant sub.

@zabimaru404 Ай бұрын

THIS IS MADNESS...

@nexovec 2 ай бұрын

I had no idea you can do this much.

@marcthenarc868 2 ай бұрын

Doom never disappoints.

@Abc-sl1nf Ай бұрын

Great video

@PeachBug 2 ай бұрын

from ultima to oblivion, ahh a man of culture I see!

@ScottEdwards2000 2 ай бұрын

yes, so glad I wasn't the only old fart to get excited to see Lord British's handiwork! It's either U5 or U6 - not sure...

@caty863 2 ай бұрын

As a GIS analyst, I like PostgreSQL simply because of its PostGIS extension. Its usage is very simple yet powerful to handle any use case I could ever come up with. Its support by GIS tools such QGIS is excellent too. In my opinion, I don't think there is any genuine excuse any team would choose Oracle or SQLServer over PostgreSQL. Yet, these sh**t dbms are still popular in some companies...for some mysterious reason. Applying the Ockham razor theory, I think it's because devs in these companies are lazy and don't want to migrate or learn a new tool, albeit superior. Or, sales guys at these providers have lined the pockets of the tech decision makers at these companies.

@FaberFedor 2 ай бұрын

It's not mysterious. They have different priorities. Technical superiority is rarely a factor in most businesses.

@deividxyz Ай бұрын

That’s because commercial db like Oracle or MS come bundled with support. The only time you will see Postgres or MySQL in enterprise production massive environments is when some big cloud vendor like Amazon sells this as a service, and they probably won’t let you install many of the extensions shown

@jonviarorsteinsson3634 Ай бұрын

Thanks for great video, do you know if Postgresql has any alternatives to SQL Server analysis server?

@TheArtOfTheTerminal Ай бұрын

Thank you for the feedback. Regarding OLAP on Postgresql, quick search finds this project www.hydra.so/, but not sure how it matches against SSAS.

@gautamkrishnar Ай бұрын

Damn bro. Nice video

@HunterMayer Ай бұрын

I've heard of this piece of tech my entire coding career but never taken a moment to look at it or had anybody try to convince me it was the way to go or what I use it for... Getting all the accessibility you describe I not surprised there's a cult following... Quite cult, but cult nonetheless. I appreciate your video. I am very much vision impaired through half of my KZfaq viewing (The eyes ain't what they used to be) and the only thing I could take out of this video was that it could do things all of the concrete demonstration/typing ASMR left me completely in the dark... literally. That's my only complaint about this video and I realize I'm probably a minor edge case, so if the ethereal music and the tapping of the keyboard is what people love about your stuff don't even consider this feedback... This is my first video encounter with you btw, I didn't know if your. Explaining what you're doing audibly while you're typing into the terminal would make the non-visual component of your video more complete for me in these cases I didn't have my vision enhancing tools available. Even if you just describe what you're doing. I thought I could see some text and some of these moments. It was difficult to understand what was happening from audio alone in those moments. That's just a minor critique. The video is really good to at least put it on my radar but it's capable of. Thanks for that!

@TheArtOfTheTerminal Ай бұрын

Thank you so much for your feedback! I'm going to improve the demo part for sure.