Open Source Python Database Software - Page 21

Levin is an event-based key/value server based on radix-tree (space optimized trie). Key search can be performed with an approximate key matching algorithm based on Levenshtein edit distance.

libbatch implements typical batch process functions. These functions include common SQL operations, functions for working with temp files, logging functions (with severity, priority, colors, and verbosity), functions that work with files and directories,

littletable is a lightweight in-memory data manager of collections of Python objects, providing ORM-like access for querying and joining data using object attributes as pseudo-columns.

madman administrates digitial music archives nicely: madman is a powerful digital music cataloging tool that is capable of flexible querying, tagging and organizing huge amounts of digital music.

TODO

meBiblio was specially developed as a small and accessible Python-based bibliography tool. meBiblio can organize your reference library, allows easy search in your references and permits immediate retrieval and examination of digitally stored literature items. It connects to online catalogs as PUBMED to retrieve data.

https://codeberg.org/andybalaam/migratedata

mongoaudit is a CLI tool for auditing MongoDB servers, detecting poor security settings and performing automated penetration testing. It is widely known that there are quite a few holes in MongoDB's default configuration settings. This fact, combined with abundant lazy system administrators and developers, has led to what the press has called the MongoDB apocalypse. mongoaudit not only detects misconfigurations, known vulnerabilities and bugs but also gives you advice on how to fix them, recommends best practices and teaches you how to DevOp like a pro! MongoDB listens on a port different to default one. Server only accepts connections from whitelisted hosts / networks. MongoDB HTTP status interface is not accessible on port 28017. MongoDB is not exposing its version number. MongoDB version is newer than 2.4. TLS/SSL encryption is enabled. Authentication is enabled. SCRAM-SHA-1 authentication method is enabled.

Imgration database structure and data from sql server express to postgresql database

mssql-cli is an interactive command line query tool for SQL Server. This open-source tool works cross-platform and is proud to be a part of the dbcli community. mssql-cli supports a rich interactive command line experience, with features such as auto-completion, fewer keystrokes needed to complete complicated queries. Syntax highlighting, highlights T-SQL keywords. Query history, easily complete an auto-suggested query that was previously executed. Configuration file support, customize the mssql-cli experience for your needs. Multi-line queries, execute multiple queries at once using the multi-line edit mode. Non-interactive support, execute a query without jumping into the interactive experience.

mssql2mysql is a python script used to create a SQL dump from a Microsoft SQL server that is ready to use with MySQL. Supports Schema and data dumping, including Primary Keys for each table, allows to dump all data or just a small portion of it

The goal of this project is to create a technical infrastructure for a distributed, multiuser movie database. It is supposed to help you organize your own movies and see what movies your friends own.

mycli is an enhanced command-line client for MySQL and MariaDB that features syntax highlighting and intelligent auto-completion for database queries. Built for developers and DBAs, it improves productivity with features like query history, table suggestions, and colored output. The tool is designed to be both powerful and user-friendly, making interactive database work more efficient and visually intuitive.

Generate a standard JSON starting from a query to a MySQL server.

Summary: mysqlclient is a MySQL/MariaDB connector for Python, providing a convenient interface for database interactions.

This tool will analyze your MySQL binary log (binlog) files. (Requires mysqlbinlog). Query speed, distribution, and size are reported.

Python script for migration from mysql to postgresql. Don't need dump because it use the dbapi 2.0 during the migration.

10gen Education / MongoDB University courses of 2013: "M101P: MongoDB for Developers", "M102: MongoDB for DBAs" and "M101J: MongoDB for Java Developers" - My code.

ophtalmologic EMR written in python, wxpython for the GUI psycopg2 for the DB API and postgresql for the database/

Goal of oraschemadoc is to provide detailed documentation for all objects in schema covering Oracle specific features. Result of execution of oraschemadoc is set of static xhtml files. There are more features under development...

pg_probackup is an advanced backup and recovery tool for PostgreSQL developed by PostgresPro. It supports full, incremental, and differential backups with compression and encryption, and provides fine-grained control over backup and restore processes. It’s designed for enterprise-grade backup strategies in PostgreSQL environments.

pgai is a suite of PostgreSQL extensions developed by Timescale to empower developers in building AI applications directly within their databases. It integrates tools for vector storage, advanced indexing, and AI model interactions, facilitating the development of applications like semantic search and Retrieval-Augmented Generation (RAG) without leaving the SQL environment.

pglib is an implementation of the frontend side of the PostgreSQL protocol, version 3.0. It is written in Python and Twisted (a framework for writing asynchronous applications). It offer a low level, asynchronous, acces to a PostgreSQL database, wit

pglog is set of function written in the PL/Python language for PostgreSQL that enables users to log changes to selected table. pglog also enables users to revert specified changes.

An intuitive GUI (GTK-based) for PostgreSQL management in under 100K (zipped).