gensql 0.3.0

Python Bindings for GenSQL

GenSQL for Python

This package provides bindings for GenSQL.

This package requires Java (>= 17) to be installed, either in $JAVA_HOME, or in your $PATH.

Usage:

First, you'll need a database file. You can find an example one here or create one using your own data set with this pipeline

Then, in your python file, you can load and query your database like so:

import gensql

db = gensql.DB("db.edn")
db.query("SELECT * FROM data LIMIT 5")

Optionally you can pick between the strict and permissive variants of gensql with the mode flag (defaults to permissive):

db.query("SELECT * FROM data LIMIT 5", mode="permissive")

You can also pass the results directly into DataFrame from pandas:

import gensql
import pandas as pd

db = gensql.DB("db.edn")
df = pd.DataFrame(db.query("SELECT * FROM data LIMIT 5"))

Known Limitations

For the moment, only one Python process can use GenSQL at a time. Starting up a second one will hang until the first one finishes.