libsql-experimental-python
libsql-experimental-python copied to clipboard
tursodatabase
libSQL API for Python (experimental)
In sqlite3, these work the way you would expect with each variety of named parameter using a dictionary to specify values: ```python cur.execute("INSERT INTO users VALUES (:id, :email)", {"id": 2,...
In sqlite3, this is the idiomatic way to iterate rows from a query: ```python con = sqlite3.connect(":memory:") cur = con.cursor() for row in cur.execute("SELECT * FROM users"): print(row) ``` `execute`...
In sqlite3, this works as you would expect (list of values in square brackets vs. tuple in parens): ```python cur.execute("INSERT INTO users VALUES (?, ?)", [1, '[email protected]']) ``` In libsql,...
Let's add support for the different Python sqlite3 module isolation levels, including auto-commit mode.
` error: failed to run custom build command for `libsql-ffi v0.2.1 (https://github.com/penberg/libsql/?rev=5a806fe53cc84a5a49853d4ae30bad64b7210c67#5a806fe5)` Caused by: process didn't exit successfully: `C:\Users\\AppData\Local\Temp\pip-install-kwpyryow\libsql-experimental_12cb8194173940f88b6ecbc5b9c5d2ec\target\release\build\libsql-ffi-8105b99e0fa61d6e\build-script-build` (exit code: 101) --- stdout cargo:rerun-if-changed=bundled/src/sqlite3.c cargo:rerun-if-changed=bundled/SQLite3MultipleCiphers/build/libsqlite3mc_static.a cargo:lib_dir=C:\Users\\AppData\Local\Temp\pip-install-kwpyryow\libsql-experimental_12cb8194173940f88b6ecbc5b9c5d2ec\target\release\build\libsql-ffi-627ab9f5a78bbde9\out Running `cmake` with...
Both APIs are now implemented using interactive transactions. Batches will be more efficient.
I think this is pretty self explanatory. :) ```bash thread '' panicked at src/lib.rs:453:40: not yet implemented: blobs not supported note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace...
from sqlalchemy import create_engine import os url = os.getenv("TURSO_DATABASE_URL") auth_token = os.getenv("TURSO_AUTH_TOKEN") engine = create_engine("sqlite+libsql://", echo=True) Base.metadata.create_all(engine) then if i set this to local db, after process how to sync...
Works as expected when values are present. Python 3.12.4 on MacOS 14.5 with libsql-experimental==0.0.34 ``` thread '' panicked at src/lib.rs:411:39: not yet implemented stack backtrace: 0: _rust_begin_unwind 1: core::panicking::panic_fmt 2:...
[https://github.com/tursodatabase/libsql-experimental-python/issues/47](url) Referencing the old Issue above. I am seeing this again on an M2 Mac Mini after installing libsql-experimental-0.0.34 dlopen(/Users/~/venv/lib/python3.9/site-packages/libsql_experimental/libsql_experimental.cpython-39-darwin.so, 0x0002): symbol not found in flat namespace '_sqlite3_wal_manager'
