Open Source Python Software Development Software for Windows

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.

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.

Generate a backend and frontend stack using Python, including interactive API documentation. Production ready Python web server using Uvicorn and Gunicorn. Very high performance, on par with NodeJS and Go (thanks to Starlette and Pydantic). Great editor support. Completion everywhere. Less time debugging. Designed to be easy to use and learn. Less time reading docs. Minimize code duplication. Multiple features from each parameter declaration. Get production-ready code. With automatic interactive documentation. Many other features including automatic validation, serialization, interactive documentation, authentication with OAuth2 JWT tokens, etc. Celery worker that can import and use models and code from the rest of the backend selectively. REST backend tests based on Pytest, integrated with Docker, so you can test the full API interaction, independent on the database. As it runs in Docker, it can build a new data store from scratch each time.

SQLObject is an object-relational mapper for Python. It supports MySQL, PostgreSQL, SQLite, Firebird, MaxDB/SapDB, MS SQL and Sybase. It supports Python versions back to 2.7.

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

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.

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.

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.

A Python extension for the SQLite Embedded Relational Database.

Python module that makes it easy to use Microsoft ADO for connecting with databases and other data sources. For CPython users, this module is included as part of pywin32 (https://github.com/mhammond/pywin32), and continued support will take place there. This fork will be maintained for Iron Python users. * Documentation at http://adodbapi.sourceforge.net/quick_reference.pdf or quick_reference.odb in the .zip

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

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

Server bundle of : Apache2 , MySQL , PostgreSQL , OpenSSL , Xmail , SlimFTPd Software developing triad of : PHP , Perl and Python + Apache2TriadCP , PHPmyadmin , PHPPgAdmin , AWStats , UebiMiau , PHPXMail , PHPSFTPd. All latest stables , all manuals

It is a set of tools to help database applications developers to handle database communication, reporting and printing. It has a solid, stable and easy to use API. It is also GUI toolkit agnostic and portable.

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.

MyOODB is a Database, Web and Application Framework. A holistic approach to software development. Bringing the power of Object-Oriented-Design back to Software Development (Java, Jython, and JavaScript/AJAX).

Metakit is an efficient database library with a small footprint. It's a cross between flat-file, RDBMS, and OODBMS. Keywords: structured storage, transacted, load on-demand, portable, C++, Python, Tcl, instant schema versioning.

Entity-relation (ERW) database modeling tool for both windows and *nix/*nux. PyDBDesigner intends to be similar to Power Designer or Erwin. Both physical and logical models are supported. Main features are database modeling, SQL generation, documentation

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.

HyperSQL is like a doxygen plus javadoc for SQL, hypermapping SQL views, packages, procedures, and functions to HTML source code listings and showing all code locations where these are used.

Python DB API compliant module for accessing databases through the ODBC API

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

NoOra is a database deployment tool which can be used to automate the database deployment cycle and is designed for agile and or devops teams. The supported database platforms are Oracle and Mysql. The support for Postgresql is work in progress. Feedback is more then welcome.

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