sqlite-sqlean icon indicating copy to clipboard operation
sqlite-sqlean copied to clipboard

Should official sqlean binaries be used instead?

Open karlb opened this issue 2 years ago • 1 comments

Some sqlite extension packages like sqlite_regex use the official binaries instead of compiling their own. Both approaches have their advantages (originally discussed in https://github.com/nalgeon/sqlean/issues/66).

Source based (master branch):

  • Can be installed on systems without pre-built binaries (e.g. linux-arm). Note: This does not mean that most users will need a C compiler, since we can still upload binary wheels to PyPI
  • More similar to typical python extensions (not sure if that has any practical advantages, though)
  • Can use common infrastructure such as https://cibuildwheel.readthedocs.io to build and test for many platforms (probably only a real advantages for those platforms without official sqlean binary releases)

Binary based (binary branch):

  • Exactly the same extension binaries and thus better tested builds
  • Less duplication of build system (and thus probaby less maintenance burden)

If you have a clear preference of additional arguments in either directions, please comment here.

karlb avatar Feb 11 '23 18:02 karlb

Until https://github.com/karlb/sqlite-sqlean/issues/4 is resolved, I am hesitant to rely on the source based version. So I released v0.1 based on the binary branch.

karlb avatar Feb 15 '23 07:02 karlb