Flask-Migrate Flask-Migrate is an extension that handles SQLAlchemy database migrations for Flask applications using Alembic. The database operations are provided as command-line arguments under the flask db command. Installation Install Flask-Migrate with pip: pip install Flask-Migrate Example This is an example application that handles database migrations through Flask-Migrate: from flask import Flask from flask_sqlalchemy import SQLAlchemy from flask_migrate import Migrate app = Flask(__name__) app.config[‘SQLALCHEMY_DATABASE_URI’] = ‘sqlite:///app.db’ db = SQLAlchemy(app) migrate = Migrate(app, db) class User(db.Model): id = db.Column(db.Integer, primary_key=True) name […]

TileDB-Py TileDB-Py is a Python interface to the TileDB Storage Engine. Quick Installation TileDB-Py is available from either PyPI with pip: pip install tiledb or from conda-forge with conda or mamba: conda install -c conda-forge tiledb-py Dataframes functionality (tiledb.from_pandas, Array.df[]) requires Pandas 1.0 or higher, and PyArrow 1.0 or higher. GitHub https://github.com/TileDB-Inc/TileDB-Py    

pysonDB A Simple, Lightweight, Efficent JSON based DataBase for Python. The current stable version is v0.6.0 pip install pysondb==0.6.0 Features Lightweight JSON based database. Supports CRUD commands. No Database drivers required. Unique ID assigned for each JSON document added. Strict about Schema of data added. Inbuilt CLI to delete,display,create JSON database. from pysondb import dba=db.getDb(“path/to/json.json”)a.addMany([{“name”:”pysondb”,”type”:”DB”},{“name”:”pysondb-cli”,”type”:”CLI”}])a.getAll()[{“name”:”pysondb”,”type”:”DB”},{“name”:”pysondb-cli”,”type”:”CLI”}] See its simple.. Install pip install pysondb Create a database You can create a database using CLI. pysondb create database_name Or in the python file. […]

Estoult Estoult is a Python toolkit for data mapping with an integrated query builder for SQL databases. It currently supports MySQL, PostgreSQL, and SQLite. Features: Not an ORM. Estoult doesn’t attempt to apply relational algebra to objects. Concise and composable (sub)queries. Easy debugging by displaying any generated SQL in a readable format. Fast. Estoult is NOT an ORM. Estoult only works with Python 3.6+ and is primarily tested on Python 3.9+. Installation Install Estoult through pip: pip install estoult Contributing […]

Prom An opinionated lightweight orm for PostgreSQL or SQLite. Prom has been used in both single threaded and multi-threaded environments, including environments using Greenthreads. 1 Minute Getting Started with SQLite First, install prom: $ pip install prom Set an environment variable: $ export PROM_DSN=sqlite://:memory: Start python: $ python Create a prom Orm: >>> import prom >>> >>> class Foo(prom.Orm): … table_name = “foo_table_name” … bar = prom.Field(int) … >>> Now go wild and create some Foo objects: >>> for x […]