The Art Of The Terminal

Пікірлер

@BravePro 11 күн бұрын

Fuck me. While researching on wtf object relational db is a few months ago I had to go through multiple articles and vids. Still didn't understand shit. ;( You just explained it in 2 mins. Thank you!

@TheArtOfTheTerminal 10 күн бұрын

Thanks for the feedback!

@sharkmanw 15 күн бұрын

PostgreSQL is an OS.

@TheArtOfTheTerminal 15 күн бұрын

Very much so!

@boo_1096 18 күн бұрын

I think it's fascinating how good the original Unix developers were at reusing concepts. The fact that sed and grep come from ed is really cool, as well as how the interface terminal emulators use is identical to teletypewriters, just a bit smarter in how they buffer and interpret the bytes :)

@TheArtOfTheTerminal 18 күн бұрын

Indeed!

@languagemodeler 29 күн бұрын

t-shirt link?

@TheArtOfTheTerminal 27 күн бұрын

Hi! Which t-shirt you mean?

@languagemodeler 26 күн бұрын

The one you're wearing. Looks great on you lol.

@TheArtOfTheTerminal 26 күн бұрын

@@languagemodeler Thank you so much. That's uniqlo.

@Ian-xo4vy Ай бұрын

Not sure it's even possible, but it would be cool if you forced yourself to never use a mouse in any of the tasks

@TheArtOfTheTerminal Ай бұрын

You mean for terminal demonstrations?

@Ian-xo4vy Ай бұрын

Yes, when you're in the terminal you sometimes highlight text with your mouse and then right-click and choose "copy". I've always wondered how difficult it would be to have no mouse at all when using different terminal apps and whether something like tmux can give a universal solution to select and copy text. Mainly I wonder whether it's realistically possible. I have an odd dream of having a DEC VT-420 terminal on my desk and doing as much as possible from the keyboard-only terminal...

@TheArtOfTheTerminal Ай бұрын

@@Ian-xo4vy Yeah, it's totally doable with tmux or screen. I'm probably just too lazy :)

@Levi_OP Ай бұрын

Using cursor keys in vim is the stupidest shit I've heard all year. Learn how to use the damn editor! You'll get used to it in a few days max

@omojjegomosc8211 Ай бұрын

What keyboard and switches do you use?

@TheArtOfTheTerminal Ай бұрын

HHKB Professional 2. Highly recommend btw :)

@omojjegomosc8211 Ай бұрын

@@TheArtOfTheTerminal thx for answer :)

@arturobgz Ай бұрын

This remembers me to Emacs 😅

@arturobgz Ай бұрын

This remembers me to Emacs 😅

@user-ow7nl4vs9c 2 ай бұрын

let's build juicy monoliths on Postgres exclusively so future generations will have to migrate these to microservices

@boo_1096 2 ай бұрын

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.

@ricardoduarte9062 2 ай бұрын

Thing is most extensions need a hosted instance, some providers have no logs access, and debugging things is hell, after using triggers on a project and having to traverse pg logs put many doubts using pg for any other use than db. Interesting video on these extensions though.

@Requiem100500 2 ай бұрын

Truly the EMACS of databases

@natking1u1z99 2 ай бұрын

Should I learn postgresql instead of MySQL?

@originalTriniOne 2 ай бұрын

I 'm not going to Subscr... Darn! Just did.

@arberstudio 2 ай бұрын

I’m early with it but I like Postgres…I extended a wordpresss site that uses mysql to basically “proxy” all the incoming data to the postgres db so I could take advantage of features to turn the site to an AI app.

@8eck 2 ай бұрын

PostgreSQL is like an old grandpa, who outlives all of us. It is still not scalable as others databases thou.

@gazorbpazorbian 2 ай бұрын

I almost died with the game of ultima at @3:51 so many great memories!

@Ian-xo4vy 2 ай бұрын

Great channel. I've been managing different contexts by switching in tmux but I like the look of direnv

@Siejec 2 ай бұрын

Very cool vid man! Keep it up!

@TzOk 2 ай бұрын

It is a little unfair to count MySQL and MariaDB separately...

@llucianf 2 ай бұрын

i think their approach of making it feature rich is a wrong path. they should rather focus on making it lighting fast and able to manage huge dbs. leave the data logic where it belongs aka app's backend layer. it is crucially stupid to spread logic within db engine. howdafuckdoyou debug a sp? does the PLSQL level of control compare with the one offered by app backend using an OOP language?

@birarakisarap 2 ай бұрын

One day, We went using PostgreSQL and never needed to return back.

@zeeshanm6 2 ай бұрын

Hey ! Here’s a crazy new idea.. what if we let the database do what a database is supposed to do and move the business logic to a separate “backend” ? I think it’s called separation of concerns or something like that

@DigitalAlligator 2 ай бұрын

PostgreSQL can do ALL orther databases like MongoDB neo4j, period

@bordeux 2 ай бұрын

Good luck with scaling it up or in future - upgrade it :) I know, if all you have is a hammer, everything looks like a nail

@NeilHaskins 2 ай бұрын

So, Emacs in Postgres or Postgres in Emacs?

@serus164 2 ай бұрын

The only issue with this approach is that it doesn't scale horizontally

@kebman 2 ай бұрын

Wow PostgreSQL is almost as good as Emacs!

@okie9025 2 ай бұрын

Not gonna lie, this video made me hate postgres even more lol. I feel like this is a quick way to triple your tech debt once a "new postgres" eventually comes along, and everyone starts calling the old (now current) postgres slow and bloated. It's the same situation with SPA+REST API vs traditional web apps. The former worked great, and it still does, but nudev philosophers thought SSR/SSG/ISR/whatever was a "simpler" approach and called for a "return to tradition" and now you have codebases completely tied to one specific framework and/or with 3x the amount of LoC and complexity. Every tool should do one thing, and do it well. More complex software calls for more components, not deeper components. I thought this was common knowledge, but I guess not.

@TheArtOfTheTerminal 2 ай бұрын

I think I didn't explain my point well enough. I also believe that one tool should do one task. The point is to look at your projects and decide: do I *really* need that one specialized NoSQL database or a SaaS solution when my problem can be solved with just SQL?

@okie9025 2 ай бұрын

"Radical Simplicity" sounds a lot like "just fucken put everything in one place and call it a day because if it barely works, it still works". Each tool should do exactly one job. Can't get any more "radically simple" than that. If you require 20 microservices, but all of them are lean and serve a single purpose, then go for it. But if your web server does everything from REST API, streaming HTML, funky no-js clientside tech, GraphQL, caching, queues, etc. in like 3 files in total, then that is a PROBLEM.

@TheArtOfTheTerminal 2 ай бұрын

You are right, some projects are better off with 20 (or 2000) single purpose microservices. What the radical simplicity means (not my term btw) is asking yourself a question: do *I* *really* need X microservices like these other guys? Or maybe my business problem can be solved with an SQL database and a pgmq task queue, just two components that, yes, each do exactly one job. Sometimes Postgrest (the REST API thing) is also the solution -- as some people commented here. There is a reason why people migrate back to on-prem from public clouds, why htmx/alpine micro-frameworks are getting traction. Imo professionals are getting tired of *unnecessary* complexity.

@0xffffffffffff 2 ай бұрын

Doom is not controlled via SQL... what a disappointment!

@TheShorterboy 2 ай бұрын

I started using postgres because it had views and mysql didn't

@andreygubarev7042 2 ай бұрын

In 2016, I worked on a project where almost all the business logic was in a database (Hi Oracle with PL/SQL) and it was a nightmare. There is only one upside to this approach: if you move all business logic (especially if you move cache, elastic search, etc. like in the video) into a database, you are probably safe from having to let go forever because no one would be able to understand how things work. And the phrase "Hey, join us, we have everything in the database" doesn't seem so attractive to developers. I believe it may be attractive for DBAs but moving all the stuff into the database you limit yourself in hiring.

@TheArtOfTheTerminal 2 ай бұрын

I agree that *business* logic probably shouldn't be in the DB, I was talking about *data* logic with an example of application users management. I know that many developers won't like the idea of having just a handful of components in a tech stack, because we are all resume-driven to a certain extent. But at some point many developers are also getting tired of a constant framework/stack/whatnot churn and yes, they will vote for simplicity. Because they want to do creative work and solve business problems instead of editing yaml files 80% of the time. Just python (php, perl, ruby, elixir etc) and an SQL database -- both running on bare metal servers -- is really enough for most IT projects out there. A stored procedure that hashes passwords or generates tokens, written in pl/python and covered by unit tests like all the rest of the code is nothing scary.

@PhilFlipper 2 ай бұрын

Good video! But you have a green screen ^^ Use it, move yourself to the side, point at things. Might be hard in the beginning, but if you already go the length of adding a black background. Might as well have fun. :D

@TheArtOfTheTerminal 2 ай бұрын

Oh cool! Thank you for the suggestion!

@OneEyedMonkey9000 2 ай бұрын

Where was the "Scrum..., Scrum....Scrum" clip from?

@TheArtOfTheTerminal 2 ай бұрын

From "Silicon Valley" series

@marioscheliga7962 2 ай бұрын

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

@ionrael 2 ай бұрын

yes, but, what are the cons? too much CPU usage? too much Disk usage? hard to maintain and debug? or the cons are that now one person can do the job of an entire team?

@TheArtOfTheTerminal 2 ай бұрын

Well, as with any architecture, you need to know the context of the particular project to understand the cons. Whether things will become harder to maintain and debug depends on execution. As some people commented here, there were/are examples of bad executions that turned entire projects into a maintenance nightmare. Inexperienced and unmotivated developer can take a beautiful python web framework and come up with a messy and unreadable code that is easier to rewrite from scratch than to fix. So it is with Postgresql and its extensions of course.

@complexity5545 2 ай бұрын

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

@TheArtOfTheTerminal 2 ай бұрын

Thank you so much :)

@nightwintertooth9502 2 ай бұрын

I discovered pgvector and then dove down the rabbit hole of postgres SQL.extensions during all that. Honestly my top choice. Robust, stable, reliable, lightweight, and extremely versatile. Its cursor is also very very fast. Every use case you can think of.

@ShinSpiegel 2 ай бұрын

I liked the video, hated the features on the database. This feels wrong, it's like killing a mother with a baseball bat.

@BenjaminVestergaard 2 ай бұрын

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.

@thiloho 2 ай бұрын

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

@TheArtOfTheTerminal 2 ай бұрын

Thank you! Happy you liked it :)

@rautamiekka 2 ай бұрын

Linux-only, you need to mention that.

@TheArtOfTheTerminal 2 ай бұрын

Good point, thanks!

@Fido1hn 2 ай бұрын

I really enjoyed this video. Gained a subscriber.

@web3dev435 2 ай бұрын

just a matter of time before someone writes the linux kernel in SQL

@LokiScarletWasHere 2 ай бұрын

PostgreSQL giving Emacs a run for its money.

@sinamobasheri 2 ай бұрын

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

@TheArtOfTheTerminal 2 ай бұрын

Thank you so much!

@user-fed-yum 2 ай бұрын

5:02 Maybe don't insert highly questionable misogynist content if you'd like non incel boys to stay engaged. Your typing examples in non accessible portrait mode were close to the worst I've ever seen, no comprehensible explanation at all what you were doing, unintelligible nomenclature that has nothing to do with Postgres. Give it up, this isn't your thing.

@friedrichdergroe9664 2 ай бұрын

Wow. Nothing more needs sayin'.

Ең жақсы KZfaq

Пікірлер