Open Source Python Database Software - Page 21

An easy to use sql client gui.

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,

Libdejector is a database tool which defeats SQL injection attacks by performing context-free validation of queries. While written in C, SWIG wrappers exist for Python and other languages will be following soon.

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.

TODO

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.

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

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