PipelineDB vs TinyDB

PipelineDB

High-performance time-series aggregation for PostgreSQL (by pipelinedb)

#Database #Realtime #Stream Processing #Analytics #SQL #Push #Postgresql #pipelinedb #time-series #Aggregation

Source Code

pipelinedb.com

TinyDB

TinyDB is a lightweight document oriented database optimized for your happiness :) (by msiemens)

#Database #Python #NoSQL #Documentdb #JSON

Source Code

tinydb.readthedocs.org

Our great sponsors

Scout APM - Less time debugging, more time building

SonarLint - Deliver Cleaner and Safer Code - Right in Your IDE of Choice!

SaaSHub - Software Alternatives and Reviews

Our great sponsors

PipelineDB		TinyDB
	Project
1	Mentions	5
2,474	Stars	5,061
0.1%	Growth	-
0.0	Activity	7.4
3 months ago	Latest Commit	3 months ago
C	Language	Python
Apache License 2.0	License	MIT License

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

PipelineDB

Posts with mentions or reviews of PipelineDB. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-04-22.

Ask HN: Is there a way to subscribe to an SQL query for changes?
17 projects | news.ycombinator.com | 22 Apr 2021

PipelineDB might be of interest. https://github.com/pipelinedb/pipelinedb

TinyDB

Posts with mentions or reviews of TinyDB. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-03-07.

BetterJSONStorage - faster 'Storage Type' for TinyDB.
4 projects | reddit.com/r/Python | 7 Mar 2022

BetterJSONStorage is a faster 'Storage Type' for TinyDB. It uses treading, the faster Orjson library for parsing the JSON and BLOSC2 for compression.
Uh oh, I'm in this meme
1 project | reddit.com/r/ProgrammerHumor | 9 Jun 2021
tinydb groovy equivalent
2 projects | reddit.com/r/groovy | 4 Jun 2021

I was looking for a streamlined-really simple db solution for my application and tinydb got my attention.
Why not use PostgreSQL?
1 project | reddit.com/r/PHP | 9 Apr 2021

Things like https://sleekdb.github.io/ and https://github.com/msiemens/tinydb come to mind in terms of document storage, for instance.
Introducing DBJson - Literally !
2 projects | dev.to | 9 Feb 2021

It has got its inspirations from tinyDB ( for its simplicity ) and Firestore( NOSQL database offered by firebase for its document style datamodelling ).

What are some alternatives?

When comparing PipelineDB and TinyDB you can also consider the following projects:

pickleDB - pickleDB is an open source key-value store using Python's json module.

ZODB - Python object-oriented database

PyPika - PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.

MerkavaDB - A fast ordered NoSQL database.

SSShelf - An ORM for S3

jsondbb - This is a simple flat file database which stores its data in a JSON file.

elara - Elara DB is an easy to use, lightweight key-value database that can also be used as a fast in-memory cache. Manipulate data structures in-memory, encrypt database files and export data. :dart:

pyodbc - Python ODBC bridge

dbj - Simple embedded in memory json database

PipelineDB vs pickleDB