Open Source Python Software Development Software for Mac

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.

Apple has a utility in /usr/bin named tccutil, but it only supports one command, which is to reset the entire database. It has been like this for many versions of macOS. I wanted a command-line utility that would be able to add, remove, list, and take other actions. This tool needs SIP disabled in order to function. The risk of doing so is up to you. tccutil.py can be installed without any additional software. Depending how you have your $PATH variable setup, you can simply type tccutil (instead of the full path) and it will run this utility instead of Apple's. This utility needs super-user priveleges for most operations. It is important that you either run this as root or use sudo, otherwise it won't work and you will end up with “permission denied” errors.

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.

A Python extension for the SQLite Embedded Relational Database.

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.

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

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.

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

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>

Hornet is a tool to browse and build MySQL databases, with the ability to connect to remote servers. It intends in the future to provide the capability to generate PHP-based interfaces to MySQL databases.

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

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

BDOZ (Bulldozer) is a Python package that extends the use of ZODB outside of Zope. BDOZ includes wrapper classes that make ZODB database applications easier to create and manage.

The csvdatamix project aims to randomize CSV input data files in order to conceal the original state of the data. Similar to data masking or data transformation. Also has mapping abilities to translate back to the original state of the data.

Db Api client is a simple Python DB Api v2.0 client. It shows some information about database, tables, table\'s description. Db Api Client provides sql queries executing, shows results, and exports to some formats (html, csv).

Datawarehouse process workflow server and generator of datawarehouse mappings. It allows to define dependencies between tables or files and processes and according to these metadata it runs processes in parallel.

The goal of this project is to make possible to access Progress database from any external program that can use sockets. The server (broker and agents) are written in Progress 4GL and made use of sockets capabilities of Progress V9.

This framework allows the definition of attributes, entities and relations as used in entity-relationship (ER) models. It will then handle input and representation of data appropriately.

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.

Language-independent interfaces like DOM, SAX and XSLT are not particularly "Pythonic". Several tools are contained in this "XML2Python Interfaces" project that provide more natural ways of translating between XML and Python objects.

A high level Python Web framework. The project is under active development and is not ready for production use.

KML is a knowledge base with support of logical modeling. Advanced model is used to represent knowledge as a set of statements similar to natural language sentences. This project hosts a set of model storage library and server (vrb-ols) and clients.

A small web-based application intended to assist project developers in managing and creating translations. Django based.