![Tom Delalande](/img/default-banner.jpg)
- 31
- 2 214 961
Tom Delalande
Australia
Приєднався 6 січ 2024
I'm a software engineer talking about whatever interests me most right now.
The Perfect Dependency - SQLite Case Study
SQLite is a side project that became the most deployed piece of software ever. Estimated to have more than 1 trillion deployments. It is a great example of how far simple software can go.
Timestamps:
0:00 - The scale of SQLite
0:54 - Origin Story
3:20 - Dependencies
6:59 - Features
8:47 - Backwards Compatibility
9:49 - Simplicity
10:28 - Testing
14:35 - Current Development
15:40 - Licensing & Monetisation
17:10 - Fossil
18:03 - Tinker
18:33 - Summary
Resources:
www.sqlite.org/about.html
Podcast: corecursive.com/066-sqlite-with-richard-hipp/#
Why SQLite succeeded as a database: ua-cam.com/video/IFhJb9Kjaio/v-deo.html
^ Part 2: ua-cam.com/video/KgcqPYahSQg/v-deo.html
Interview: ua-cam.com/video/2eaQzahCeh4/v-deo.html
SQLite How it Works: ua-cam.com/video/ZSKLA81tBis/v-deo.html
Personal Website: www.hwaci.com/drh/
Why 100% test coverage matters: news.ycombinator.com/item?id=18685748
news.ycombinator.com/threads?id=SQLite
fossil-scm.org/home/doc/tip/www/rebaseharm.md
fossil-scm.org/home/doc/tip/www/whyallinone.md
www.sqlite.org/mostdeployed.html
www.sqlite.org/formatchng.html
www.sqlite.org/selfcontained.html
www.sqlite.org/testing.html
www.sqlite.org/th3.html
www.sqlite.org/sqllogictest/doc/trunk/about.wiki
www.sqlite.org/testing.html#dbsqlfuzz
Timestamps:
0:00 - The scale of SQLite
0:54 - Origin Story
3:20 - Dependencies
6:59 - Features
8:47 - Backwards Compatibility
9:49 - Simplicity
10:28 - Testing
14:35 - Current Development
15:40 - Licensing & Monetisation
17:10 - Fossil
18:03 - Tinker
18:33 - Summary
Resources:
www.sqlite.org/about.html
Podcast: corecursive.com/066-sqlite-with-richard-hipp/#
Why SQLite succeeded as a database: ua-cam.com/video/IFhJb9Kjaio/v-deo.html
^ Part 2: ua-cam.com/video/KgcqPYahSQg/v-deo.html
Interview: ua-cam.com/video/2eaQzahCeh4/v-deo.html
SQLite How it Works: ua-cam.com/video/ZSKLA81tBis/v-deo.html
Personal Website: www.hwaci.com/drh/
Why 100% test coverage matters: news.ycombinator.com/item?id=18685748
news.ycombinator.com/threads?id=SQLite
fossil-scm.org/home/doc/tip/www/rebaseharm.md
fossil-scm.org/home/doc/tip/www/whyallinone.md
www.sqlite.org/mostdeployed.html
www.sqlite.org/formatchng.html
www.sqlite.org/selfcontained.html
www.sqlite.org/testing.html
www.sqlite.org/th3.html
www.sqlite.org/sqllogictest/doc/trunk/about.wiki
www.sqlite.org/testing.html#dbsqlfuzz
Переглядів: 126 566
Відео
Celeste was originally an 8-bit retro game
Переглядів 3 тис.2 місяці тому
github.com/tom-delalande/pico8-example www.lexaloffle.com/pico-8.php www.lexaloffle.com/bbs/?tid=2145 store.steampowered.com/app/504230/Celeste
The game of the year was written in Lua
Переглядів 327 тис.2 місяці тому
Balatro is an extremely successful game that was created using the Love2D framework in Lua. I found that pretty interesting so I decided to explore Love2D a little to try and re-create some of that Balatro magic. A journey which gave me a new appreciation for shaders. I have no talent please forgive my terrible code. Balatro - store.steampowered.com/app/2379780/Balatro/ LocalThunk - bsky.app/pr...
Why Melee Is Still The Best Fighting Game - Melee Modding Explained
Переглядів 8 тис.3 місяці тому
UnclePunch Patreon: www.patreon.com/UnclePunch Slippi Donations: slippi.gg Timestamps 0:00 - Intro 0:39 - Melee 3:16 - 20XX 4:35 - Dolphin 4:59 - Assembly 8:00 - Gecko Codes 9:30 - Smash 4 & Ultimate 10:16 - Uncle Punch's Training Mode 12:36 - Slippi 14:20 - Slippi Replay 17:09 - Rollback Netcode 18:47 - Input Lag 21:04 - Outro References Netplay Desync: ua-cam.com/video/h-fv1e6-XTc/v-deo.html ...
How 1 Software Engineer Outperforms 138 - Lichess Case Study
Переглядів 303 тис.4 місяці тому
This is a case study on the Lichess product. A free and open source chess platform with over 4 million monthly active users and 1 core developer. The stack he uses is Scala, MongoDB and Snabbdom hosted on bare metal. This is an incredibly interesting project that I enjoyed studying to understand productivity. This is a new format so I'm interest to hear your feedback. I had a lot of fun studyin...
The Best Terminal Shell Ever Created
Переглядів 64 тис.5 місяців тому
shell shells shell shells by the shell shore
How Garbage Collection Works
Переглядів 15 тис.5 місяців тому
This is a video about garbage collection, some information may be wrong or oversimplified. Leave your opinions and corrections below so that I can ignore them since reading comments stresses me out. Please subscribe, as a human I have been conditioned to care about base 10 numbers and my brain will release happy chemicals when I reach the next one. Some useful links: - maplant.com/2020-04-25-Wr...
Spring is the worst framework ever created
Переглядів 38 тис.6 місяців тому
... except maybe Ruby on Rails
Swift for Android, Kotlin for iOS
Переглядів 16 тис.7 місяців тому
I haven't taken a look at new mobile development tools for a while. So I decided to explore some cross platform native tool-chains. github.com/thebrowsercompany/windows-samples github.com/readdle/swift-android-buildtools skip.tools/ github.com/android/compose-samples developer.apple.com/tutorials/sample-apps
I re-created the game of life in Assembly
Переглядів 22 тис.7 місяців тому
github.com/tom-delalande/learning-language-abstraction This video is for entertainment purposes only, you probably shouldn't do as I say or as I do. I wanted to do something a little more significant than a 'Hello world' in Assembly so I decided to tackle the game of life. I took the opportunity to try and recreate some of my favourite programs in low level languages. Including a Vi clone in C ...
AI is more than just ChatGPT
Переглядів 5 тис.8 місяців тому
In my mental model of AI there are 5 levels: Level 1: Decision tree Level 2: State machine Level 3: Mathematical algorithms Level 4: Neural networks Level 5: General Neural networks I think we tend to focus too much on ChatGPT instead of implementing useful AI systems. AI can be refreshingly simple and to prove that I implemented a short demo for each of the mentioned levels using pure HTML, CS...
Why YouTube has blank boxes when loading
Переглядів 5 тис.8 місяців тому
I wanted to dig into why UA-cam has these blank boxes when loading. It's a simple answer, but optimization is a very interesting topic. Developers use techniques like minifying, compression and caching to make the websites you use every day load faster. They also try to improve cumulative layout shift so that the experience is more pleasant. This is a more beginner friendly video than usual, le...
JWTs are insecure session tokens
Переглядів 29 тис.9 місяців тому
I've often seen hate for JWTs online, but never really understood why they we're seen as badly designed and insecure. So I did some digging and came to my conclusion. Which is that JWTs are a good method of authentication, but bad session tokens. Basic opaque session tokens are usually the way to go. Using stateless tokens has many added costs, while not providing that many benefits in practice.
Authentication is a developer nightmare
Переглядів 68 тис.9 місяців тому
authn.tinyclub.io Music: ua-cam.com/video/jUkI7Ixiqgk/v-deo.html Let's talk about authentication. I would like to show how easy it is to implement authentication with 3 different methods. Password, Oauth2 (or social login) and passkeys. They all have their benefits and drawbacks but hopefully this video is a fun way to understand how the systems powering authentication actually work. I've also ...
The cloud is over-engineered and overpriced (no music)
Переглядів 743 тис.9 місяців тому
The cloud is over-engineered and overpriced (no music)
The cloud is over-engineered and overpriced
Переглядів 120 тис.9 місяців тому
The cloud is over-engineered and overpriced
My latest weekend project. Mixing the scalability of SQL and with the easy of use of spreadsheets
Переглядів 8 тис.9 місяців тому
My latest weekend project. Mixing the scalability of SQL and with the easy of use of spreadsheets
Comparing 10 programming languages. I built the same app in all of them.
Переглядів 195 тис.10 місяців тому
Comparing 10 programming languages. I built the same app in all of them.
How leveraging events can simplify your app
Переглядів 13 тис.11 місяців тому
How leveraging events can simplify your app
The better alternative to Markdown
Переглядів 35 тис.11 місяців тому
The better alternative to Markdown
HTMX examples for React developers
Переглядів 4,5 тис.11 місяців тому
HTMX examples for React developers
You can compile Kotlin to Javascript
Переглядів 6 тис.11 місяців тому
You can compile Kotlin to Javascript
My opinion on Pkl (Apple's new configuration format)
Переглядів 2,4 тис.11 місяців тому
My opinion on Pkl (Apple's new configuration format)
Making Poker with HTMX: Real time multiplayer using SSR with Kotlin, HTMX and Tailwind
Переглядів 3,4 тис.Рік тому
Making Poker with HTMX: Real time multiplayer using SSR with Kotlin, HTMX and Tailwind
Implementing Passkeys with no dependencies
Переглядів 3 тис.Рік тому
Implementing Passkeys with no dependencies
Why Kotlin is the best language to use with HTMX
Переглядів 10 тис.Рік тому
Why Kotlin is the best language to use with HTMX