Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

switch from Python sqlite3 module to apsw #92

Closed
riastradh-probcomp opened this issue Jul 29, 2015 · 4 comments
Closed

switch from Python sqlite3 module to apsw #92

riastradh-probcomp opened this issue Jul 29, 2015 · 4 comments

Comments

@riastradh-probcomp
Copy link
Contributor

http://rogerbinns.github.io/apsw/

apsw supports:

  • sqlite3_backup API, so we can save in-memory databases to disk and take reliable snapshots of databases on disk
  • virtual tables, so we can obviate the need to create a large intermediate table up-front for SIMULATE
  • less obnoxious automagic DB-API transaction nonsense to work around
  • anything else in the sqlite3 API we care about

But it also means a nontrivial external dependency.

@axch
Copy link
Contributor

axch commented Oct 8, 2015

Would ease #238 by providing corresponding modes for the underlying sqlite database, which sqlite3 apparently does not.

@riastradh-probcomp
Copy link
Contributor Author

Someone^TM should just do this. I started on the 20150210-riastradh-apsw branch https://github.com/probcomp/bayeslite/tree/20150210-riastradh-apsw, but at this point it would probably be better to start afresh using that branch as inspiration than to whittle that branch into shape.

@riastradh-probcomp
Copy link
Contributor Author

20151119-riastradh-apsw #320

@riastradh-probcomp
Copy link
Contributor Author

Done in c492cf3. Depend on >=0.1.4a20151203 to get this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants