DHH discusses SQLite (and Stoicism)
Вставка
- Опубліковано 26 тра 2024
- Join the waitlist for my SQLite course launching in June: highperformancesqlite.com/
DHH and Aaron discuss modern SQLite, the one-person framework, conceptual compression, stoicism, and ONCE.com's newest product: Workbook.
Get production ready SQLite with Turso: turso.tech/tryhard - Фільми й анімація
Woah, it's shocking how much Twitter can skew reality. People love to hate on DHH there, but I found this entire conversation so damn inspirational! Thank you both for sharing your insights. I'm super grateful and gained a new perspective on what it means to be a developer.
Lame idiots hate on DHH
Twitter sheep
It's shocking that people are shocked to find social media of most any kind can skew their reality.
No offense intended, I'm happy for you.
DHH is one of those people who starts with these takes that seem super out there and then society just converges on them over time. I bet he bough nvidia stock a decade ago
🤡
🤡
"We cannot give up on the internet being something that individual developers can build for and be competitive on." - DHH
Such a powerful point and one that resonates so much having watched 'www' go from a curiosity on my NeXT box to what we all use today.
I love the idea that one person should be able to build, deploy, and support a complete web site.
DHH is slowly becoming my virtual mentor. That bit about stoicism was great. Amazing interview, thank you Aaron!
Great interview Aaron, thank you! You are a great communicator, seriously. Interesting questions, you never intererrupt and you are legit interested. Keep up the great work and I am looking forwards to that SQLite course!
Thank you so much! I really appreciate that. I had a lot of fun talking to him
Aaron, you have the perfect attitude towards things to make new people be interested in an older language like PHP, Laravel and all the stuff around that.
Your combination of general lightness and genuine interest in these things works really well. You are probably making a significant difference in changing some of the negative reputation of the language, keep it up!
I think the language should be rebranded in laravel, maybe merge the companies. Would be a smart move to take the name of the most popular php framework for the language itself
Geeze this made my day. Thank you
@ivan.jeremic Merging a framework and language branding is a bad idea from a historical standpoint. Once upon a time, Zend was heavily featured all over the place. The PHP core is still referred to as the Zend Engine, there's the zend_extension ini directive, and the Zend Framework... existed until recently... it's now renamed to Laminas. It started to become less popular over time as other frameworks like Symfony and Laravel started to become more popular.
Hearing DHH's takes and views on thing is always a delight.
Joe: "Oh so you run a blog, whats with the 20 guys behind you?"
Bob: "DevOps team"
I don't get it
@@aarondfrancispretty much agree with DHHs stance on needless complexity ... PPL sometimes don't even know what kind of product/application they wanna build, but set up a k8s cluster from the get go 😂
devops IS complexity for the sake of complexity (and keeping people in jobs)
Don't forget to setup AWS Cognito for 7-Factor authentication for all of your 4 users
@@aarondfrancishow did you not get that 😂
Love how exited DHH gets whenever he talks about tech!
What a wonderful interview Aaron! Thanks a lot 🎉
Love when a conversation like this gives me dozens of new ideas & things to try out. This interview is such a breath of fresh air when compared to the engagement-oriented needless drama that goes on in Twitter. Thank you both!
Hell yeah! What a fantastic get Aaron. What a great confirmation that you’re doing great stuff.
Wonderful interview! I absolutely love how DHH is passionate about stuff, such a unique character. Thanks
DHH's transition into Gilbert Gottfried is almost complete
Great content Aaron and David, thanks! I really agree with David on complexity. I've been a one man team since my teens, and I've learnt quite a few times that complexity(and dependencies) are both a huge risk. Less complexity and dependencies makes it so much easier to come back to something you wrote 10 years ago that is now in need of a small update.
Amazing discussion and so many great insights !
sqlite can also be used a in-memory open-source replacement for redis using the following command:
sqlite3 /dev/shm/database.db
😄
This is cool, but I think my surprising takeaway was that ssd and local without network can compete with redis on another server. Only shared cached data would need an external cache
Love this interview and DHH has the exact right mind set. Fighting complexity ❤ Looking forward to the SQLite course!
What a great conversation! Such good vibes and so much positivity. It's amazing what you can do with tools nowadays that 10 or 20 years ago would have been considered crazy. His comments around reducing complexity resonated with me so much.
After 2 years of JS/Typescript/Feathers/React dev and getting back to PHP now, I'm having so much fun again! I've taken an ultra minimalist approach with my current PHP project and I'm getting so much done! SQLite is such an interesting option because there's so few moving parts. In the interest of simplicity and getting things done, it's looking like a really good option.
I also love what he said about customers not caring about the underlying tech. As long you're adding value and customers are having a great experience, it's going to make zero difference to them what you use underneath.
Anyway, thanks so much for sharing another great video!
Great conversation, loved to hear it
First? 🎉
On a serious note ... markdown for blog/article type projects and sqlite for more complex use-cases where u need relational data ... love the simplicity 😊
What a wonderful interview, really. Hard to beat this genuine content.
Love this! Great conversation.
Loved this interview
DHH is a great guy
Thanks for the interview!
I've kinda known of DHH since a long time but now for the first time watching him speak. he has a very passionate and charming personality. Aaron is great host ofc.
I am a regulare DHH blog reader, seing you two in the same place just made a lot of sense. A lot of practical value here, great talk DHH!
Fantastic interview. Can feel the passion. Wish everyone could have the opportunity to do a work stint with persons like this.
That was a great interview!
What a awesome talk!
SQLite is amazing. We use it within our container for holding a couple of large mostly static datasets… when running at full speed it’s handling millions of read and writes per minute.
Main takeaway from this video
"Linux, it just works" - DHH
Very good interview, thanks from Ethiopia.
although I'm a Typescript fanboy, I cannot deny that this podcast was very nice to watch. This guys is so interesting.
Love SQLite. Great talk
Thanks for the video!
Great interview
Great interview, Aron
Aaron is the best. He needs more exposure and subscribers
What an inspiration. I was not aware that this approach has a name Negative Visualization, but that's what I am doing all the time.
Great talk!
Hey Aaron, awsome interview. I really enjoyed it and i personally like DHH a lot. The dude's got what a lot of devs are missing IMO: a bit of common sense, heh.
Keep up the good work, you are an inspiration!!
Cheers!!
Great video
always bet on simplicity 🔥
Watched it on your site and dhh was on the right side of the screen! Technology!
What will they think of next??
LibSQL is for another case, and now they have native extension for PHP and also for Driver for Laravel!
Wow! That's cool!🤘
Which awesome Sony camera is DHH using? 📸
Wait what are the better sqlite defaults? Need these settings. Anyone read through the rails docs/source to get these better ones?
31:02 "PHP" 😁 Bring it back! Ah, the nostalgia...
Hi Aaron, if you run Sqlite in prod, how do you inspect the db?
Copy the file local kek
i need this on apple podcasts
That Sony Camera with Linux support is this? Asking for a friend
wow, can't believe this interview is happening.
This was a great interview!! Thanks!! Love DHH but still disagree with him on typescript LOL
Weird timing. Working on a little side project for myself and was going to use SQLite to keep track of sessions in my app.
35:00
This should be the mindset of anyone not only programmers.
You shoud be capable of doing anything alone.
Gain enough knowledge.
You would have explained all of that in 50 secs and make it fun. Thank you for your great content, is really inspiring.
Nice interview with Cbum 😂❤
Pocketbase been awesome for me, which is SQLite
I don't see how postgres would be worse deployed locally but I could see how the massively vaster features would be better.
Key moment - 17:48
DHH makes a powerful point: big tech companies and their architecture cannot become a dependency of individual Web developers.
Really nice podcast. I love sqlite really want to see laravel use sqlite as queue driver. I have used sqlite as queue driver as separate database just queue jobs with laravel 7 but the issue i faced it lock sqlite file if number of jobs are high same thing happen with when used mysql as queue driver jobs table was locked and don't know how to unlock that table. Loved to see sqlite as cache
Everything he says is common sense. I have no idea why he gets hate. So glad I found out about the Rails community and this amazing methodology towards development and business
Twitter bubble world. Don't trust Twitter
DHH MENTIONED
I'm a bit confused, which part was about stoicism?
33:13
There's an incorrect assumption that SQLite can't horizontally scale. Go see Turso or RQLite!
RQlite doesn't scale writes, in fact writes are actually slower compared to a single SQLite instance (with the same settings). Reads only scale if you can tollerate weaker consistency levels.
Turso is a managed service. They are almost certainly sharding and replicating data with their own proprietary layer on top of SQLite. There's nothing inherently wrong with that, but you're now talking about a separate paid service that happens to use SQLite.
Side note: SQLite was the backend for FoundationDB for a very long time.
Theo demonstrated the performance issues with Hey, including substantial lags (using gigabit fiber) and a lack of debounce. It would be interesting to see him defend or at least reflect on the engineering choices that led to that flawed UX. DHH has seemed pretty dogmatic about not using reactive clients on Xitter (formerly known as Tw), so I wonder if he would even acknowledge the UX issues with Hey.
They already fixed it. None of their customers noticed so it wasn't a priority
@@aarondfrancis I see.
Timestamp for Stoicism?
Someone please add timestamps
One piece of feedback: I would've loved an introduction of the guest and what they are known for. I don't know who he is or what he has done. He frequently refers to projects/companies that haven't been introduced to the listener, which was honestly a little frustrating. Practically this means that I don't know what perspective to put those statements in.
He's the guy who invented Ruby on Rails and basecamp
@@EightNineOne oh nice! See, I would’ve loved to have known that up front!
He can save us
There's a fair bit of assumed knowledge here in knowing who "DHH" is. I have no idea. Never seen him or heard of him. Maybe link to his social media or something?
He's the creator of Ruby on Rails. He's also known as being very opinionated on software beyond Rails or Ruby.
the amount of a fan i am of dhh almost makes me feel ashamed. but, eh, i'm ok with that. i'm currently rewriting a huge lab test and order entry system that's half rails half php. with one other guy. and it's going well. and it's actually fun :)
Sneaks off to get Campfire...
DHH gives me Keanu Reeves vibes of tech😂
Haha true, for me it was Russell Brand vibes 😂
next with the Laravel Creator
This DHH guy is cool
I agree!
Browsers
😅
16:56
Fix the damn data types. It's such an artful experience 🤭
All these people realizing that what they have been told about DHH is not the reality and he actually just cares about simplicity. I wonder how many of them still believe what they heard about Ruby.
If only SQLite had encryption
Aaron are you running a sort of AI camera?
Nope! Why?
Your camera output is super sharp and your skin very smooth, it seems one of these generated avatar.
Just lots of moisturizer I guess!
Damn, I have to step up my moisturizing game 😅
I measure your competency by the frequency of "like" in your verbal expression. DHH expresses himself eloquently and elegantly. His "like" count is 0.
That's an odd way to measure competency tbh.
Yeah this feels like maybe a way to target and perceive certain groups of people as incompetent. Typically heterosexual men say like the least, then gay men more, and then women maybe more. If we follow your rules it leads you to unsavory conclusions, at which point you should analyze your metrics. I could go on a rant on how "data analysis" is BS meant to justify our biases 99% of the time but I won't keep you.
This guy is like if George Hotz and Jonathan Blow had a baby
Second
Sorry but you're handsome dude
Do not be sorry. Thank you!
Vids on php and now DHH? Man, Aaron really making controversial content these days
Look out, I may do one about how reading the documentation can be helpful. I'm truly a menace!
@@aarondfrancis documentation? What’s that?
@@aarondfranciscome on, now you're being ridiculous 😂
@@nimmneun ikr? you cannot contain me
Ah! The christian software. It's real good.
He sounds so much like Jordan Peterson. Both in his voice actually sounding like him, but because they're both so Stoic.
Who is Jordan Peterson?
If DHH took steroids, he'd look like Schwarzenegger
21:27
> Opensource rests on three dudes and that is somehow terrible - no, it's amazing, we are so lucky!
Except when one to three core contributors die or burn out, and there is no one with a history of contributions to this project to take the flag - only some shady dude working for three letter agency of some unnamed country.
Cornerstones of the modern internet and businesses worldwide should not depend on luck. They should have redundancies and support from other projects to take a burden if needed.
Three is thrice as redundant as one. That's pretty good!
Skype used SQLite. WTF is DHH on about. Machines had a lot less cores and some were used for relatively new video streaming with Skype.
Great interview, Aron