TinyDB
TinyDB is a lightweight document oriented database optimized for your happiness :) (by msiemens)
pyodbc
Python ODBC bridge (by mkleehammer)
Our great sponsors
| TinyDB | pyodbc | |
|---|---|---|
| 8 | 23 | |
| 6,514 | 2,836 | |
| - | - | |
| 3.9 | 7.9 | |
| 2 months ago | 9 days ago | |
| Python | C++ | |
| MIT License | MIT No Attribution |
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.
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.
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 2023-02-16.
-
How to make a GUI translator app with Python Tkinter
Here, we save app settings with Python tinydb and you can also use another simple database options. It is included because Python is used here.
-
Should a beginner on python start a project
If you are interested in database, I would also recommand have fun with tinydb https://github.com/msiemens/tinydb and reading it's source code, even alter it and mess around (just keep Git in mind in your adventure).
-
ShyySH: a TUI connection manager for SSH
I have made yet another ssh connection manager with TUI, using asciimatics and tinyDB.
-
BetterJSONStorage - faster 'Storage Type' for TinyDB.
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
-
tinydb groovy equivalent
I was looking for a streamlined-really simple db solution for my application and tinydb got my attention.
-
Why not use PostgreSQL?
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 !
It has got its inspirations from tinyDB ( for its simplicity ) and Firestore( NOSQL database offered by firebase for its document style datamodelling ).
pyodbc
Posts with mentions or reviews of pyodbc.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-03-07.
-
Is there a way to monitor in real time all SQL commands Sent to SQL Server 2017 through Python
Python can script and view this via pyodbc... https://github.com/mkleehammer/pyodbc/wiki
-
Problems Changing a Password with Pyodbc
I am not 100% sure you call stored procedure correctly. in the examples they declare @out parameter for the procedures with output.
- Trying to deploy a windows based Python & Flask web app
-
Self-hosted Car Infotainment
pyodbc has the odb2 part figured out. This could be useful instead of reinventing the wheel. The rest I can't think of anything that has been done. Sounds like an interesting project.
-
How to use a value more than once in a Prepared Statement (pyodbc)
From its documentation it looks like pyodbc conforms to the DB API, so you can probably use named parameters by passing a dictionary to execute(), as described here.
-
Installing pyodbc in termux help
~ $ pip show pyodbc Name: pyodbc Version: 4.0.34 Summary: DB API Module for ODBC Home-page: https://github.com/mkleehammer/pyodbc Author: Author-email: License: MIT Location: /data/data/com.termux/files/usr/lib/python3.10/site-packages Requires: Required-by:
- Weird error with driver - Data source name not found and no default driver specified
- pyodbc, unixODBC Driver Manager Error
-
ODBC and OLE DB connections "going stale" after several hours
I am trying to migrate data from our Enterprise Data Warehouse to one of our own reporting databases via ODBC and Python scripts. The python scripts import pyodbc to handle the database connections and execute SQL queries. A system DSN is defined on our ETL server for each database involved in the process.
-
Python using MS Access?
See the docs.
What are some alternatives?
When comparing TinyDB and pyodbc you can also consider the following projects:
pickleDB - pickleDB is an open source key-value store using Python's json module.
PyHive - Python interface to Hive and Presto. 🐝
ZODB - Python object-oriented database
PyAthena - PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.
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.
SQLMap - Automatic SQL injection and database takeover tool
PipelineDB - High-performance time-series aggregation for PostgreSQL
django-pyodbc-azure - Django backend for Microsoft SQL Server and Azure SQL Database using pyodbc
MerkavaDB - A fast ordered NoSQL database.
shillelagh - Making it easy to query APIs via SQL
SSShelf - An ORM for S3
AIOHTTP - Asynchronous HTTP client/server framework for asyncio and Python