Simon Willison’s Weblog

CROSS JOIN and virtual tables in SQLite. Learned today on the SQLite forums that the SQLite CROSS JOIN in SQLite is a special case of join where the provided table order is preserved when executing the join. This is useful for advanced cases where you might want to use a SQLite virtual table to perform some kind of custom operation—searching against an external search engine for example—and then join the results back against other tables in a predictable way.

# 12:15 am / sqlite

How the SQLite Virtual Machine Works. The latest entry in Ben Johnson’s series about SQLite internals.

# 8:49 pm / ben-johnson, sqlite, databases

TIL: You Can Build Portable Binaries of Python Applications (via) Hynek Schlawack on the brilliant PyOxidizer by Gregory Szorc.

# 9:41 pm / python, hynek-schlawack