Open Source Python Database Software - Page 21

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.

Moodss is a modular monitoring application, composed of a GUI and a daemon, which supports any device or process for which a module can be developed. Complete dashboards with graphical viewers, thresholds, SQL database archiving, ... can be managed.

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.

This is a Python 3 module for MySQL database connection. For now it is only developed for Linux, but it may possibly compile for other POSIX OSes.

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

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...

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).

pgsync is a lightweight tool for syncing Postgres databases across environments, such as from production to staging. It allows selective table syncing, data masking, and parallel copying for fast and safe data migration. pgsync is ideal for developers who need realistic test data without exposing sensitive information.

A set of PHP functions giving web developers a simple, yet immensely powerful "drop in" permission system for their current web based applications.