Can’t change system default SQLite binary

by

The simplest option if you just need a recent version of SQLite from python is now to install the pysqlite3 package (LINUX ONLY at the time of writing, per the project’s README file):

pip install pysqlite3-binary

This comes with a recent version of SQLite statically-linked. You can use it in a venv without affecting any other package.

You can use it like this:

from pysqlite3 import dbapi2 as sqlite3
print(sqlite3.sqlite_version)

If you happen to be using peewee, it will pick it up automatically.

If you need a specific version of SQLite, you can build this package, as suggested in Aaron Digulla’s answer.

More Related Contents:

  1. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  2. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  3. How to discover table properties from SQLAlchemy mapped object
  4. creating a database outside the application context
  5. How to delete a table in SQLAlchemy?
  6. SQLAlchemy create_all() does not create tables
  7. SQL Alchemy ORM returning a single column, how to avoid common post processing
  8. Python CSV to SQLite
  9. How do I execute inserts and updates in an Alembic upgrade script?
  10. SQLAlchemy, get object not bound to a Session
  11. Bulk insert with SQLAlchemy ORM
  12. Flask sqlalchemy many-to-many insert data
  13. HDF5 – concurrency, compression & I/O performance [closed]
  14. How to delete a record by id in Flask-SQLAlchemy
  15. How to do an upsert with SqlAlchemy?
  16. SQLAlchemy printing raw SQL from create()
  17. pysqlite: Placeholder substitution for column or table names?
  18. SQLite not saving data between uses
  19. SQLAlchemy: how to filter date field?
  20. method of iterating over sqlalchemy model’s defined columns?
  21. flake8 complains on boolean comparison “==” in filter clause
  22. How to execute “left outer join” in SqlAlchemy
  23. SQLAlchemy – Mapping self-referential relationship as one to many (declarative form)
  24. Problem with regexp python and sqlite
  25. How to close a SQLAlchemy session?
  26. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  27. How to get number of affected rows in sqlalchemy?
  28. Using SQLAlchemy models in and out of Flask
  29. Is possible to mapping view with class using mapper in SqlAlchemy?
  30. SQLAlchemy ordering by count on a many to many relationship

Leave a Comment