4 ms·
Of of curiosity, how configurable are sqlite builds? Can one disable json support, for example? I'm not sure what other "categories" of features three might be
by rektide 4y ago
Of of curiosity, how configurable are sqlite builds?
Can one disable json support, for example? I'm not sure what other "categories" of features three might be. Certainly there's a lot of builtin functions; how configurable is sqlite in picking buultins to omit?
- justinclift 4y ago> Can one disable json support ... Yeah, it's pretty configurable, including the JSON support. Being able to include/exclude things can be done at compile time: https://www.sqlite.org/compile.html https://www.sqlite.org/compile.html ← lists the options for including/excluding stuff And there's a function for loading 3rd party extensions at run-time too, which itself can be turned off. :) There's a fair amount of 3rd party extensions too. eg: https://github.com/nalgeon/sqlean https://github.com/nalgeon/sqlean GIS stuff, encryption support (several varieties), Excel/ODS support, and tonnes of other things
- ilyt 4y agoExcel/ODS support ? I only see csv support in provided links?
- justinclift 4y agohttps://github.com/x2bool/xlite https://github.com/x2bool/xlite
- ilyt 4y agoThanks. Shame it's read only, althought I guess using odbc driver in excel to read sqlite is the way to go
- justinclift 4y agoThere's also a fairly popular JDBC driver for SQLite as well: https://github.com/xerial/sqlite-jdbc https://github.com/xerial/sqlite-jdbc Mentioning that because from (very) rough memory, Excel can work with JDBC too. So if the ODBC approach doesn't work for someone, there's potentially another thing they can try. :)