SQLite stores text in a number column. The word STRICT stops it.

SQLite stores text in a number column. The word STRICT stops it.

1 month ago

@the-daily-build Subscribe

Declare a column in SQLite as a number, and the database will still let you store the word garbage in it. No error. No warning.

Ask

Ask about this presentation

Answers are generated from this presentation.

Chapters

Up next

Autoplay

Nothing on the rig measures speed

@the-daily-build · 5 days ago

A file gets smaller when you can guess what is in it

@the-daily-build · 1 week ago

The seal on an AI's private thinking had one key for the whole company

@the-daily-build · 2 weeks ago

One row for every sellable unit, and each checkout takes any free one

@the-daily-build · 2 weeks ago

A single CPU instruction, stretched from a blink to a full minute

@the-daily-build · 2 weeks ago

You can't be best at everything

@the-daily-build · 2 weeks ago

How deleting one if-statement made this filter 4x faster

@the-daily-build · 2 weeks ago

Software gives you five skin tones, or sixteen million

@the-daily-build · 2 weeks ago

A Self-Spreading Worm Got Into the Code Behind Billions of Installs

@the-daily-build · 3 weeks ago

The AI session you can’t take with you

@the-daily-build · 3 weeks ago

He Walked Through His House Before It Was Built, at Full Size, in a Headset

@the-daily-build · 3 weeks ago

500 Lines of Code That Draw 3D Without a Graphics Card

@the-daily-build · 3 weeks ago