Open Source Python Software Development Software for Linux

The Orator ORM provides a simple yet beautiful ActiveRecord implementation. The Orator ORM is based on conventions to avoid the hassle of defining every single aspect of your models. It is inspired by the database part of the Laravel framework, but largely modified to be more pythonic. All you need to get you started is the configuration describing your database connections and passing it to a DatabaseManager instance. If you have multiple databases configured you can specify which one is the default. For MySQL and PostgreSQL, the connectors are configured to return unicode strings. If you want to use the previous behavior just set the use_unicode configuration option to False. Once you have configured your database connection, you can run queries. To run a set of operations within a database transaction, you can use the transaction method which is a context manager.

SQL Explorer aims to make the flow of data between people fast, simple, and confusion-free. It is a Django-based application that you can add to an existing Django site, or use as a standalone business intelligence tool. Quickly write and share SQL queries in a simple, usable SQL editor, preview the results in the browser, share links, download CSV, JSON, or Excel files (and even expose queries as API endpoints, if desired), and keep the information flowing! Comes with support for multiple connections, to many different SQL database types, a schema explorer, query history (e.g. lightweight version control), a basic security model, in-browser pivot tables, and more. SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. SQL Explorer is inspired by any number of great query and reporting tools out there.

PyBSDDB is an extension module for Python that wraps the BerkeleyDB from Sleepycat Software. This project will be used to help unify the various implementations and to continue enhancing the module as new features are released from Sleepycat.

Cinemagoer is a Python package useful to retrieve and manage the data of the IMDb movie database about movies, people, characters and companies. Platform-independent, it can retrieve data from both the IMDb's web server and a local copy of the whole db.

2023/04/04: MIGRATED TO https://gitlab.com/wef/gjots2 gjots2 is a fairly simple jotter (outline processor) application for your desktop. See http://bhepple.freeshell.org/gjots

Database mapping layer for MongoDB on Python. Includes schema enforcement and some facilities for schema migration.

dbweaver provides a set of tools to extract CREATE statements from a database server and dump them to a text file. These files can be used for editing, source revision control and database migration.

Pure Python library to read/write/modify Palm PDB and PRC format databases.

Reporting engine library written in C. Create one XML file and generate PDF, HTML, TXT, and CSV reports based on queries. Has support for MySQL, PostgreSQL, ODBC. Bindings for PHP, Java, Python.

LightProfiler – application for performance analysis of the Oracle databases. It generates detailed resource profile for extended SQL trace files (10046 event), containing information about consuming of response time (by events, by cursors, etc.), data files usage, error analysis (SQL, PL/SQL) and much more. Also it contain tools for additional processing of trace files (extract session data, splitting files) and for management of database's sessions (disconnecting, tracing, monitor parameters, blocking locks, events and etc.)

Convert a mysql database to a Sqlite database. Includes two projects : A) A php script B) A windows executable, based on a python script Converts data, indexes and foreign key constraints. About the php script : -don't need a lot of memory -good speed Was projected to use on VDS/VPS. Usage: wget https://sourceforge.net/projects/mysql2sqlite/files/mysql2sqlite/download chmod +x mysql2sqlite ./mysql2sqlite About the Windows executable and the Python script : Usage : edit the in i file to fit your system, and just run the exe or the python script.

FramerD is a distributed semi-structured object database originally developed at MIT. It provides an internationalized Scheme-based scripting language, built-in text analysis tools, and special support for web scripting.

PgWorksheet is a simple GUI frontend to PostgreSQL for executing SQL queries and psql commands without using the psql command line tool. Please see the project home page for bug reports, forums and installation instructions.

"Project EROS" is a collection of software which includes a web application framework for developing intranet and extranet applications (bbsengine), as well as example applications to demonstrate the available functionality.

Reves is tool for relational database reverse engineering. It maps the schema of existing databases into XML files.

SPWrapper generates java (and now python) classes able to invoke stored procedures and to execute sql statements for you: you just have to give it the stored procedure name or the sql statement.

This module provides access to MS SQL Servers from Python scripts. Tested on Linux, *BSD, Solaris, Mac OS X and Windows.

Tikal's open source Application Development & Deployment is comprised of fully integrated suites that cover the entire software life-cycle, include tools for development and deployment of applications, software configuration management and ASQA.

xbgtk - an xbase/Harbour/xHarbour object-oriented wrapper for using the GTK+ GUI. This project has been deprecated in favour of https://github.com/tuffnatty/hbgi, an approach that uses GObject Introspection for automatic bindings.

2tools is a set of online CMS maintenance tools: just one click to migrate to/from different CMS; safe configuration settings to upgrade your CMS; easy Data movement to/from DBMS, databases or tables; SQL, XML, XSLT, PHP technologies. All tools are main

ActiveGrid is an Enterprise Web 2.0 solution that allows the composition of code-free applications that comply with corporate IT standards. Technologies include Python, Java, XForm, Xpath, WSDL, CSS, XML Schema (XSD), XACML, and BPEL.

A configuration generator tool which is able to generate programs that insert, delete, or update database records for a number of different database programs. <a href="http://www.manelelena.com">Project Page</a>

An RDBMS backed object development framework in Python.

This is a testbed for projects of personal interests, especially academic projects.