Metadata-Version: 2.4
Name: sqlite-store
Version: 0.1.0
Summary: Sqlite Store
Home-page: https://github.com/kfkelvinng/sqlite-store
Author: Kelvin Ng
Requires-Python: >=3.0
Description-Content-Type: text/markdown
License-File: LICENSE
Dynamic: author
Dynamic: description
Dynamic: description-content-type
Dynamic: home-page
Dynamic: license-file
Dynamic: requires-python
Dynamic: summary

# A Shelve and Document Store backed by Sqlite3

Minimum extenral dependencies
Install simply drop into your project by downloading as zip or add a git submodule
```

```

https://www.sqlite.org/json1.html


import sqlite3
c=sqlite3.Connection(":memory:")
c.execute("CREATE TABLE J(D)")
r=c.execute("INSERT INTO J VALUES(JSON_OBJECT('someKey', 'someValue'));")
r=c.execute("SELECT * FROM J WHERE JSON_EXTRACT(D, '$.someKey')='someValue'")
r.fetchall()


c.execute("EXPLAIN query plan SELECT * FROM J WHERE JSON_EXTRACT(D, '$.someKey')='someValue'").fetchall()

r=c.execute("CREATE INDEX test_idx ON J(JSON_EXTRACT(D, '$.someKey'));")
c.execute("PRAGMA compile_options;")
c.execute("PRAGMA compile_options;").fetchall()
('ENABLE_FTS3',),
 ('ENABLE_FTS3_PARENTHESIS',),
 ('ENABLE_FTS3_TOKENIZER',),
 ('ENABLE_FTS4',),
 ('ENABLE_FTS5',),
 ('ENABLE_JSON1',),


are built into SQLite by default, as of SQLite version 3.38.0 (2022-02-22)


are built into SQLite by default, as of SQLite version 3.38.0 (2022-02-22)
>>> con.enable_load_extension(True)
>>> con.load_extension("./json1.so")
