Simon Willison’s Weblog

Subscribe

27th September 2020

None
TIL Figuring out if a text value in SQLite is a valid integer or float — Given a table with a `TEXT` column in SQLite I want to figure out if every value in that table is actually the text representation of an integer or floating point value, so I can decide if it's a good idea to change the type of the column (using [sqlite-utils transform](https://sqlite-utils.datasette.io/en/stable/python-api.html#transforming-a-table)).
Posted 27th September 2020 at 8:40 pm

Recent articles

This is a beat by Simon Willison, posted on 27th September 2020.

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe