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
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file python-fundb-0.0.15.tar.gz.
File metadata
- Download URL: python-fundb-0.0.15.tar.gz
- Upload date:
- Size: 16.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/4.0.0 CPython/3.8.10
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
517834d58cf843a94e3a4e931bc30390814654e20f28ee867dc677964113851e
|
|
| MD5 |
9bf2e5f2a48b770aca77b8de1ab6c291
|
|
| BLAKE2b-256 |
6ffef8c4c2f546be8b59b6b9813b10ac5647fa300bf556cf2e740ef4f052ab9a
|
File details
Details for the file python_fundb-0.0.15-py3-none-any.whl.
File metadata
- Download URL: python_fundb-0.0.15-py3-none-any.whl
- Upload date:
- Size: 17.8 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/4.0.0 CPython/3.8.10
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
1bb3d34dcf9a4d0507733a427161176ad98f2331ef968a5e59fec87c28ced176
|
|
| MD5 |
e068b7ac05c252f060da3a12ec6d88fa
|
|
| BLAKE2b-256 |
97fd5488b49af4926ddea6c61872ae039f1aa7e8cf26daf83ffc174de01fa4ba
|
