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

Metadata

Release files for python-fundb 0.0.15

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for python-fundb 0.0.15
File	Size	Uploaded
python-fundb-0.0.15.tar.gz	16.8 kB	Jun 17, 2022	Details

Built distribution (wheel)

Table of built distributions (wheels) for python-fundb 0.0.15
File	Interpreter	ABI	Platform	Reset
python_fundb-0.0.15-py3-none-any.whl 17.8 kB Jun 17, 2022	Python 3	none	any	Details

Total release size: 34.7 kB

Release files / python-fundb-0.0.15.tar.gz

Download URL	python-fundb-0.0.15.tar.gz
Size	16.8 kB
Tags	Source
SHA-256 checksum How to use checksums	`517834d58cf843a94e3a4e931bc30390814654e20f28ee867dc677964113851e`
BLAKE2b-256 checksum How to use checksums	`6ffef8c4c2f546be8b59b6b9813b10ac5647fa300bf556cf2e740ef4f052ab9a`
Upload date	Jun 17, 2022
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/4.0.0 CPython/3.8.10`

Release files / python_fundb-0.0.15-py3-none-any.whl

Download URL	python_fundb-0.0.15-py3-none-any.whl
Size	17.8 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`1bb3d34dcf9a4d0507733a427161176ad98f2331ef968a5e59fec87c28ced176`
BLAKE2b-256 checksum How to use checksums	`97fd5488b49af4926ddea6c61872ae039f1aa7e8cf26daf83ffc174de01fa4ba`
Upload date	Jun 17, 2022
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/4.0.0 CPython/3.8.10`