Open Source Python Database Software - Page 16

Records is a Python library designed to make direct SQL querying convenient without introducing a full object-relational mapper. It supports relational databases including PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server, and Amazon Redshift through SQLAlchemy. Query results are exposed as friendly Record objects whose fields can be accessed by attribute, key, or numeric index. Queries support safe parameterization, SQL files, transactions, and bulk operations. Result collections can be converted into dictionaries or exported through Tablib to formats such as CSV, JSON, Excel, HTML, YAML, and Pandas DataFrames. A command-line utility allows SQL queries and exports to be performed outside Python code. The library focuses on keeping raw SQL workflows concise and readable.

Redfoot is an extensible RDF server written in Python for building a Semantic Web of P2P nodes.

Relationale is a domain-specific language implementing relational algebra atop a general-purpose host language. It features a static type system, type inference, lexical scope, and delayed evaluation. A proof-of-concept is being developed in Python.

The Restaurant Table Reservation System is a Django-powered web server framework that allows programmers (or me) to build websites for restaurant owners where customers can reserve tables (over the web) based upon owner-provided table availability data.

A tool that parses SQL Select statements and generates a diagram. The diagram shows parts of the underlying SQL directly in the diagram. For example x=30 , GROUP BY (year), HAVING MIN(age) > 18. It is easy to see cartesian joins and/or loops.

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

STAFFI uses a graphical user interface to store and manipulate data regarding volunteers, fundraising events and donations. STAFFI is able to pass information on in real time to web pages and provides robust tools for contacting supporters in bulk via email and post.

The SBS1 Explorer application features a nice GUI allowing a variety of queries to any SBS-1 flights database without having to install the BaseStation software. Simply get a database file (usually BaseStation.sqb) and open it in SBS1 Explorer.

Why use it? You can create your own Python script using model builder, but you have to modify the script everytime you want to dump different tables. Using this script you only need to have a CSV with all the table names, that’s it. Purpose: It can be used as an archival and historical database It will make you ArcSDE database portable and shareable

SDict Viewer is a viewer for dictionaries in open format developed by AXMASoft (free dictionaries are available for download at http://sdict.com). Primary goal of the project is to provide usable dictionary app for Nokia Internet Tablets running Maemo.

This project is an customised, highly evolved open source L2J server emulation software. Main source bases mostly on L2JOfficial project files. Project is written in Java, Python, XML, HTML, SQL and so on. //// and is not available to all anymore. ho

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.

DB Semantic Browser (DBSB) is designed for the software developers. Applications access data located in multiple tables and it takes some effort to get all information relevant to the particular object. Developers have more interesting things to do than navigating through multiple tables, determining keys and selecting rows. DBSB uses DB meta-data, discovers relationships between tables and shows rows related to the selected one. See Wiki for documentation.

SQL Drivers is a simple-to-use wrapper around SQL connectivity for many languages, including PHP, Python, and Perl.

Sqltoolbox is a collection of database manipulation tools allowing viewing, editing, and querying of data across different database platforms and operating systems.

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. SQLAlchemy provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language. An industrial strength ORM, built from the core on the identity map, unit of work, and data mapper patterns. These patterns allow the transparent persistence of objects using a declarative configuration system. Domain models can be constructed and manipulated naturally, and changes are synchronized with the current transaction automatically. A relationally-oriented query system, exposing the full range of SQL's capabilities explicitly, including joins, subqueries, correlation, and most everything else, in terms of the object model. Writing queries with the ORM uses the same techniques of relational composition you use when writing SQL.

SQuaLe is a glib based SQL query load balancer over persitent database connections.

Student database and management system originally designed for a Christian school. Written by a teacher, it focuses on simplicity and user-friendliness. Key components include student records, grades, discipline, curriculum, attendance, and reports.

A fork of the SAP DB version 7.3, 7.4 and client libraries. Client libraries is being maintained in LPGL license model.

SchemaDoc is a XML-based markup language for documenting XML schemas. The work products include both the vocabulary and a set of tools for combining it with the schema source (e.g. a DTD) to produce documentation in HTML, XML DocBook, LaTeX, etc.

Schemamajig is a tool for designing and comparing schemas across multiple databases. It provides a graphical environment for designing and comparing schemas and a command line interface for comparing schemas.

Crossplatform viewer (Qtopia/Qt/Tk) for SDictionary bases (http://sdict.com).

SeSIL is a framework for providing semantic relationships between objects in a database.

A Python DBAPI 2.0 - like adapter for the Sedna XML database

This repository serves as our entire project space which contains all of the open-source projects we've worked on. - C/C++ - C#/.NET - PHP - HTML5/CSS3