3 ms·

I like improvements, but I like speed and light demands for RAM or computation even more.

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 ago
    Excel/ODS support ? I only see csv support in provided links?
    - justinclift 4y ago
      https://github.com/x2bool/xlite https://github.com/x2bool/xlite
      - ilyt 4y ago
        Thanks. Shame it's read only, althought I guess using odbc driver in excel to read sqlite is the way to go
        justinclift 4y ago
        There'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. :)
bearjaws 4y ago
I briefly looked to see how its footprint has increased, but couldn't find anything compelling. The binary has remained tiny, with most OS's under 2MiB, but that won't really indicate memory usage. Do you have any articles to show its resource usage over time?

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 ago
  Excel/ODS support ? I only see csv support in provided links?
  - justinclift 4y ago
    https://github.com/x2bool/xlite https://github.com/x2bool/xlite
    - ilyt 4y ago
      Thanks. Shame it's read only, althought I guess using odbc driver in excel to read sqlite is the way to go
      - justinclift 4y ago
        There'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. :)

bearjaws 4y ago

I briefly looked to see how its footprint has increased, but couldn't find anything compelling. The binary has remained tiny, with most OS's under 2MiB, but that won't really indicate memory usage. Do you have any articles to show its resource usage over time?