libsql-experimental 0.0.2

No project description provided

libSQL API for Python

Getting Started

Connecting to a database

import libsql

con = libsql.connect("hello.db")
cur = con.cursor()

Creating a table

cur.execute("CREATE TABLE users (id INTEGER, email TEXT);")

Inserting rows into a table

cur.execute("INSERT INTO users VALUES (1, '[e-mail]')")

Querying rows from a table

print(cur.execute("SELECT * FROM users").fetchone())

Developing

Setup the development environment:

python3 -m venv .env
source .env/bin/activate
pip3 install maturin pyperf pytest

Build the development version and use it:

maturin develop && python3 example.py

Run the tests:

pytest

Run the libSQL benchmarks:

python3 perf-libsql.py

Run the SQLite benchmarks for comparison:

python3 perf-sqlite3.py