Hacker News Reader

Comment by tony | Hacker News Reader

Any features in this library you'd like to see standard library's sqlite3 [1]? Maybe a PEP [2, python enhancement proposal] could do it.

[1] https://docs.python.org/3/library/sqlite3.html

[2] https://www.python.org/dev/peps/pep-0001/

View on HN

> Any features in this library you'd like to see standard library's sqlite3 [1]? Maybe a PEP [2, python enhancement proposal] could do it.

Not sure if it's in this library, but I'd want the ability to open a database that's already loaded in memory as a byte array.

In the standard library? Probably nothing.

But if someone published an alternative APSW wheel with JSON1, ICU, and FTS5 enabled, I'd be happy.

I'm the APSW author. The binary builds for Windows are distributed with those extensions all compiled in, although my doc needs some updating. It is also only a single flag for other platforms to include all extensions during compilation. What can I do?

Whats the hold back to getting it via pip install via a wheel? I'm curious (happy APSW user here). Its not well elaborated from what I could find. This is something I would love to help with but not sure where to start, as I'm not sure where in the process of doing the builds it falls down.

Would Cython help, perhaps?

Cython wouldn't help. The reason[1] is in the docs.

I already do Windows builds[2] - 21, becoming 23 in next release so that isn't a difficulty.

The problem is tying all this together in a way that is useful, with sensible defaults and appropriate tools. APSW supports python versions going back 16 years! I welcome discussion at python-sqlite[3]

[1] https://rogerbinns.github.io/apsw/download.html#easy-install...

[2] https://rogerbinns.github.io/apsw/download.html#source-and-b...

[3] https://groups.google.com/forum/#!forum/python-sqlite

First of all thanks for producing APSW and providing good documentation.

The problem for my case is that if I want to distribute anything with a Sqlite+JSON1 workflow I also have to host and distribute a version of sqlite3 or apsw with those flags enabled. If that's already done on Windows then great, but many people I'm sure (myself included) would like a cross-platform solution.

It would be great if we could use the Setuptools "extras" feature to select which flags we want enabled. Not sure what the technical requirements for that are.

Alternatively just having an "everything enabled" version of the package would i think be good for most people who dont need such fine control over their project dependencies. If anything, someone who cares so much about keeping the library minimal is probably in the minority and should be free to disable extensions as needed.

I'm very happy to take this general approach, but someone else needs to figure out exactly what needs to be done to get a package that way. Discussion is welcomed on python-sqlite mailing list.

May be just create a new PEP to replace sqlite3 with it.

Reply on news.ycombinator.com