SQLite is not weakly typed!

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.

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

[alvechy]

My coding skills are not weak, they are flexible

[vikingthedude]

Aaron please never stop making videos im begging you

[LogicEu]

Man, I love your enthusiasm and openness! Very nice tips going on here!

[blessdarah]

The passion is the only thing that keeps me glued. The knowledge simply follows from the later.

[ahmad-murery]

SQLite is very similar to Excel/Spreadsheet like apps, a cell can hold any value unless you strictly specified a type, although nobody hates Excel for that as far as I know.
The best thing about SQLite is that it doesn't require any installation other than your app.

Thanks Aaron

[thomas]

the pacing on this video is perfect. go quickly in the beginning to get everyone caught up to speed, then explain what's going on

[NaourassDerouichi]

This is the type of content I'm looking for.

[Levy]

Love your series on MySQL, keep up the good work!

[DanelonNicolas]

Turso works like a charm. nice video 💪🏻

[panggilmeiam]

Yes! I need to learn Rust with some motivation that come from Aaron Francis podcast and YouTube Video PHP doesn't suck (anymore)
Why not!
Learning Rust is the same as I will become rust that can stick to sturdy scrap metal.

That's quote in my DEV blog: You're re-motivated me Aaron! Now Turso/libSQL is near PHP Ecosystem. Thank you!

[DavidYoo-mz]

Love that you struck out on your own but u deserve/need a full-time sponsor so u don't get spread thin doing 1/2 business management and 1/2 content creation, otherwise the stress will bleed into your videos. The world needs a relaxed AF with a dewy glow getting paid $600k/yr to drop deep cuts on us. You changed the game on SQL content, and you're a magnet for whatever tech you demonstrate so long as it's the same tech across across months/years. I hope some bluechip exec is smart enough to realize this.

[joshr]

Curious what the history is for the reason they chose dynamic types by default. Seems like a bit of a gun if you don't know this behavior and expecting the strict mode by default. Might have the dig up the docs to see why

[antonpetrov]

Awesome videos and very enjoyable. What color schemes do you use in the editor and terminal?

[fran]

Great video! Is there a way to have strict behavior but allow a specific combination of types for example, integer OR string, but not anything else?

[stephenshead]

Very helpful distinction - thanks.

I've been mulling on a different question (I know, not what this video is about!): possible ramifications of the fact that SQLite is ... dunno if this is the right word ... "limitedly typed": null, integer, real, text, or blob, and (as I understand it) that list will never grow. I'm wrestling with the whole UUID/GUID question, and whether they can be done well and efficiently in SQLite (e.g. using a UUID as the PK, and with/without the "rowed"). Got a bunch of sub-questions / thoughts, including when and how that's a good idea anyway, but interested to know if you'd have something helpful to point me towards.

[IndraPrastha]

Would creating a table from Laravel migration set it as flexible as default? or are there anyway to set it as strict from Laravel blueprint migration side?

[MegaCystic]

where do you get your black t's at?