SQLite is not weakly typed! @aarondfrancis

Uploaded June 2024 | Updated September 2026, 1 hour ago

Want to learn more SQLite? Check out the full course: https://highperformancesqlite.com.

Get your free SQLite reference guide: highperformancesqlite.com/products/sqlite-reference-guide

SQLite is "flexibly typed," which is somehow different than weakly typed. Or it can be strictly typed! Or it can be strictly and flexibly typed! The choice is yours.

Check out aaronfrancis.com for more articles, podcasts, and courses. You can find the article version of this video there too: aaronfrancis.com/2024/sqlite-is-not-weakly-typed-bfc98b9c.

Chapters
00:00 SQLite is Flexibly Typed
00:26 Storing Multiple Types in Column
02:51 Use Cases for Multiple Types in Column
03:36 Strict Tables
04:30 Strict Table with Strict and Flexible Columns

Laravel tip: Higher order collection proxies (and Zevia)

The Music Makers Podcast - 002 - What Have You Tried?

Using a browser agent on the worst government website

The Music Makers Podcast - 032 - No Time For Something Important? Try Waking Up Earlier.

The Music Makers Podcast - 025 - A Little Bit of Slope Makes Up For a Lot of Y-Intercept

Code tip: Dont undo what you havent done

Building a Fly.io driver for Laravel Sidecar