Shelf DB is a tiny document database for Python to stores documents or JSON-like data

Um Nontasuwan

Last update: Nov 3, 2022

Related tags

Overview

Shelf DB

Introduction

Shelf DB is a tiny document database for Python to stores documents or JSON-like data.

Get it

$ pip install shelfdb shelfquery

Start asyncio server

$ shelfdb
Serving on ('127.0.0.1', 17000)
Database : db
pid : 12359

uvloop built-in already to make it faster. See uvloop.

Sync/Async query client through network.

import shelfquery

# Sync client point to 127.0.0.1:17000
db = shelfquery.db()

# Make it async client
db.asyncio()

# Make it sync client again
db.sync()

Store data

db.shelf('note').insert({
    'title': 'Shelf DB',
    'content': 'Simple note',
    'datetime': datetime.utcnow()})

Flexible query API with similar syntax

db.shelf('note')\
    .filter(lambda note:
        note['title'] == 'Shelf DB')\
    .sort(key=lambda note: note['datetime'])
    .run()

No need to learn more syntax. Let's just query using filter, slice, sort, map, reduce which almost the same to Python built-in functions.

Regular expression

Python reqular expression re can be use inside query function

import re
db.shelf('note')\
    .filter(lambda note:
        re.match(r'.*DB$', note['title']))\
    .run()

Tiny

shelfdb ~ 12kB shelfquery ~ 4kB

Runtime code is small, easy to install. Shelf DB also works on Raspberry Pi.

securedb is a fast and lightweight Python framework to easily interact with JSON-based encrypted databases.

securedb securedb is a Python framework that lets you work with encrypted JSON databases. Features: newkey() to generate an encryption key write(key,

2 Nov 23, 2022

Oh-My-PickleDB is an open source key-value store using Python's json module.

OH-MY-PICKLEDB oh-my-pickleDB is a lightweight, fast, and intuitive data manager written in python 📝 Table of Contents About Getting Started Deployme

6 Feb 20, 2022

Python object-oriented database

ZODB, a Python object-oriented database ZODB provides an object-oriented database for Python that provides a high-degree of transparency. ZODB runs on

574 Dec 31, 2022

Python function to extract all the rows from a SQLite database file while iterating over its bytes, such as while downloading it

16 Nov 9, 2022

A Persistent Embedded Graph Database for Python

Comments

Implement 'uvloop' for better performance

uvloop is a fast, drop-in replacement of the built-in asyncio event loop. uvloop is implemented in Cython and uses libuv under the hood. https://github.com/MagicStack/uvloop

opened by nitipit 2
Use XML-RPC instead of python pickle/dill
Starting point : https://docs.python.org/3/library/xmlrpc.html

Reasons

Standard for many programming languages

dill/pickle has limitation when import call function from modules, it dumps functions call as reference which can't be called on server.
opened by nitipit 1
shelfdb 'start' cmd to start server
In order to start shelfdb server

$ shelfdb start

for $ shelfdb, change behavior to show cmd help. https://github.com/nitipit/shelfdb/blob/master/shelfdb/server.py#L114
opened by nitipit 0