4 ms·
It seems like there are a lot of extensions that are being built for sqlite. I would like to use these extensions, but I am skeptical about their support over t
by breadchris 3y ago
It seems like there are a lot of extensions that are being built for sqlite. I would like to use these extensions, but I am skeptical about their support over time. I like sqlite for how freakin stable it is. How do people feel about sqlite extensions?
- yellowapple 3y agoSQLite being as stable as it is means that even an unmaintained extension will probably continue to work for a very long time.
- breadchris 3y agothat is what i was thinking about, which is encouraging.
- mikepurvis 3y agoMy limitation with it is that it means I have to recompile sqlite for my use case. That's sometimes easy and obvious to do, but it's a lot more of a pain if it's, say, the sqlite embedded in my language interpreter and I just signed myself up for compiling a custom Python to support my project. That said, I just googled it and it turns out I'm being a bit dramatic— it's actually not super hard to dynamically link Python to a custom-built sqlite: https://charlesleifer.com/blog/compiling-sqlite-for-use-with-python-applications/ https://charlesleifer.com/blog/compiling-sqlite-for-use-with...
- justinclift 3y agoI guess it depends on what kind of support time scale you're wanting? Popular curated extension collections like sqlean (https://github.com/nalgeon/sqlean https://github.com/nalgeon/sqlean) seem like they'll have a shelf life of many years.