3 ms·
Is loading extensions at runtime new? Coulda sworn I used to have to recompile for this
by eli 8y ago
Is loading extensions at runtime new? Coulda sworn I used to have to recompile for this
- WaltPurvis 8y agoPretty sure it's been around for at least 10 years or so. (But it's not a widely used feature, I think.)
- deleted 8y ago[deleted]
- blattimwind 8y agoJSON1 is compiled into every Linux distro's SQLite I tested and is also in Mac's SQLite, as well as the Windows binaries provided by sqlite.org. The only exception I found was the SQLite bundled with Python for Windows, which doesn't seem to have any extensions at all. Performance-wise this is fast enough that you can do faily complex un-indexed queries (so full table scans) against tables with a few ten-thousand to hundred-thousand rows and have them complete in a couple tens msecs.
- pstuart 8y agoIt seems valuable enough to have in the standard build. That and the CSV extension as well.
- deleted 8y ago[deleted]
- pjtr 8y agoEspecially for things like Python's embedded SQLite. Packaging and loading an extension module cross-platform with an otherwise pure Python script seems difficult.