FunDB: Hybrid Row-and-Document Oriented datastore leveraging SQL/RDBMS database: SQLite, MySQL, MariaDB, Postgresql
Project description
FunDB
FunDB is Hybrid Row-and-Document Oriented datastore leveraging SQL/RDBMS database: SQLite, MySQL, MariaDB, Postgresql
FunDB is both RDMBS + Document Oriented together.
It supports, regular SQL query along with Document Oriented and Key Value store.
Engine:
- JSON
- SQLite
- Mariadb
- PostgreSQL
- MySQL
Install
pip install python-fundb
Usage
from fundb import fundb
# Open the db
# or in memory > fun = fundb()
fun = fundb("./my.db")
# Select a collection.
# Collection will be created automatically
# or explicitely > test = fun.select('test')
test = fun.test
# Get total entries
print(test.size)
# Insert an entry. It returns fundb#Document
entry = test.insert({
"name": "Fun",
"type": "DB",
"version": "1.0.0"
})
# Retrieve document by _id
_id = "9c5e5fbd05544700995c5fa3ca3ef214"
entry = test.get(_id)
# Access properties
entry.name # -> fun
entry.type # -> DB
entry.version # -> 1.0.0
# Update a field
entry.update(version="1.0.1")
# ...or
entry.update({"version": "1.0.1"})
#
entry.version # -> 1.0.1
# Delete entry
entry.delete()
# Search
results = test.find({"version:$gt": "1.0.0"})
for entry in results:
print(entry.name)
~ API ~
Database
fundb
#select
To select a collection in the database
fun = fundb()
users = fun.select("users")
## or
users = fun.users
#collections
List all the collections in the database
fun = fundb()
users = fun.select("users")
## or
users = fun.users
##D
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
python-fundb-0.0.14.tar.gz
(16.8 kB
view hashes)
Built Distribution
Close
Hashes for python_fundb-0.0.14-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4b8b0f77c46a15d6357e5c66eb8ab056e8914951229f7a2a9a36f21a603b0d8a |
|
MD5 | b8a2bb42724a79ece35ff817eae58ec8 |
|
BLAKE2b-256 | 52965733c605d79821216b3548e5d9ead34bb2fac8f4f107f81d7c13a30c6078 |