I replied to the following: ↷

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. …
↑ bysimonwillison.net • archived copy • current

Excellent find! I use virtual tables to construct my homepage and feeds, wonder if this'll knock down load times.

Posted with Quill at in Everything

Shared to Twitter, @jalcine@todon.eu

Engagement is powered by Webmentions — a premier standard of the Web to let other sites know you've mentioned them. Learn how to reply from your own site. or from a supported silo Aaron has an interactive post about this. If you've mentioned this URL via another one, use the form below to submit it.

If you don't currently own your replies, then you can click below to do so.

I currently aim to own my comments and plan to eventually show those I've received once I finish Lighthouse.