Community Guide to PostgreSQL Tools Abandoned

From PostgreSQL wiki

Jump to: navigation, search

This is a list of Postgres Tools (of any type and flavor, and OS) that appear to not be maintained (i.e. had a release in the last 5 years).

Contents

Obsolete or End-of-Life

Alternate Guides

Another detailed summary from 2009 is available at Database Administration, Reporting, and Light application development

pgdesigner

http://pgdesigner.sourceforge.net/en/index.html

Druid III

http://druid.sourceforge.net/

Java (multi-platform)

The druid is a tools that allows users to create databases in a graphical way. The user can add tables, fields, folders to group tables and can modify most of the database options that follow the SQL-92 standard. In addition to sql options, the user can document each table and each field with HTML information. Once the database is created, the druid can generate:

  • HTML documentation: for all tables, with browsing facilities
  • PDF documentation: for all tables
  • Java classes: (one class for each table) that contain tables' constants (such as fields size) plus java code added by the user
  • A data dictionarythat contains all tables and fields present in the database
  • SQL script which contains all table definitions that can be piped to the DBMS
  • And much more info...

Last update: 2006

Open Source CMS

http://www.risetobloome.com/Page_1_S.aspx?ITEM=2017

Windows

The CMS is a free Visual Studio 2010 solution template with a set of projects providing a complete Content Management System (CMS) based on RISE Visual Modeling with model, full source, sample site and DB-scripts for PostgreSQL, MySQL and SQL Server.

It’s a complete ready-to-run Visual Studio solution with model, source code and web clients. It illustrates how to use RISE, how to implement a SOA backend and how to build RIA frontends.

Last update: 2014

Power*Architect

http://www.sqlpower.ca/page/architect

Java (multi-platform)

Power*Architect is an ERD modelling tool that is based on Java and JDBC. Support for forward and reverse engineering PostgreSQL databases is supported. It's OpenSource with a GPL license.

Last update: 2014

RISE PostgreSQL code generator

http://www.risetobloome.com/Page_1_S.aspx?ITEM=1889

Windows only

The RISE PostgreSQL code generator generates native PL/pgSQL scripts. Model your information in the free RISE Editor and generate your database script from your models. The script incrementally updates the tables, columns, indexes and constraints in the database to match the RISE model. Once the database model is updated, the views defined in the RISE model are created in the database and possible default data, entered in the model, is inserted.

Last update: 2014


Marshal SQL Utility

http://www.risetobloome.com/Page_1_S.aspx?ITEM=1756

Windows

The Marshal SQL Utility is a generic cross database utility with batch execution capabilities. It allows you to test ODBC connections, browse database schemas, discover tables, views and columns.

Key features of Marshal SQL Utility:

  • Execute any query supported by your database server
  • Execute batches of queries
  • Discover tables and views in your database
  • Discover columns for a selected table or view
  • Supports BLOBS and CLOBS
  • Save your results to file
  • Use any ODBC compliant database such as PostgreSQL.

RISE PHP for PostgreSQL code generator

http://www.risetobloome.com/Page_1_S.aspx?ITEM=1888

Windows

The RISE PHP for PostgreSQL code generator renders PHP source code for database access. Model your information and programming interfaces in the free RISE Editor and generate your code. The generated code implements the classes and methods corresponding to the information interfaces specified in the RISE model. This includes classes for database access and, optionally, classes implementing SOAP/JSON web services and proxy classes assisting the implementation of a PHP SOAP client.

RISE - Model Driven Development using ERD / UML

http://www.risetobloome.com

Windows

RISE is a free software suite for model driven information system development. Use a single source RISE model to generate your entire information solution including database, web services and documentation. Boost development throughput and improve quality and maintainability!

The RISE user experience is based on a project concept, similar to that of most integrated development environments. The user works with resources and drawings that are part of a single development project.

RISE supports a fully graphical approach to information modeling and system engineering, using ERD (Entity Relationship Diagram) as well as UML (Unified Modeling Language). This includes drag-and-drop of entities, their attributes and relations, as well as of views and entire web services.

RISE supports graphic editing of complex objects such as views and orchestrated methods. RISE automatically safeguards the combination process, thus, assuring a technically correct result.

RISE provides several ways to generate code from the model; directly to file, via the RISE Server or as an Internet service. RISE provides code generators for the database layer (SQL/DDL) as well as for the server side application layer (web services and persistent classes). All database scripts are incremental allowing you to install and maintain any number of databases from a single model.

Feature list http://www.risetobloome.com/Page_1_S.aspx?ITEM=1355

openOffice

RedHat


phpPgAdmin

http://phppgadmin.sourceforge.net/doku.php

PHP

Similar to phpMyAdmin, enhanced for PostgreSQL, supports browsing and modification of most types of PostgreSQL database objects, plus execution of ad-hoc queries.

(last updated 2013, 9.2.x)


pgEdit

http://pgedit.com

Not a standalone client, rather a plugin for Textmate for using psql.


DBTools Manager

http://www.dbtools.com.br

Freeware, available for PostgreSQL and MySQL, allows managing all aspects of the database: db, table, triggers, functions, etc. Includes import/export wizards to migrate data and structure to/from other database engines.


Marshal SQL Utility

http://www.risetobloome.com/Page_1_S.aspx?ITEM=1756

The Marshal SQL Utility is a generic cross database utility with batch execution capabilities. It allows you to test ODBC connections, browse database schemas, discover tables, views and columns.


VSQL++ for PostgreSQL

http://www.sqlpp.com/products/postgresql-management/

A powerful Postgresql database management tool to help DBA sto manage the database objects easy and quickly.


PGExplorer

http://www.PGExplorer.com

Hasn't been significantly updated in many years, but latest downloads suggest it may support Postgresql 9.* to some extent.


Gnome DB

http://www.gnome-db.org

Database administration/user tool for GNOME, based on libgda/libgnomedb, which are a complete database-independent access layer for UNIX systems, with support for PostgreSQL, MySQL, Sybase, MS SQL Server, Oracle, Interbase/Firebird, MS Access files, xBase.

Has an experimental Windows build available too.


Druid III

http://druid.sourceforge.net/

Java

The druid is a tools that allows users to create databases in a graphical way. The user can add tables, fields, folders to group tables and can modify most of the database options that follow the SQL-92 standard. In addition to sql options, the user can document each table and each field with HTML information.

SQLTool Pro Database Editor

http://www.sqltoolpro.com

Android

SQLTool Pro is a professional Android SQL editor for MySQL, SQL Server, PostgreSQL, Sybase, and Oracle Databases.

phpPgAdmin

http://sourceforge.net/projects/phppgadmin

browser-based, requires webserver

Admin

Similar to the ever-popular phpMyAdmin, enhanced for PostgreSQL, supports browsing and modification of most types of PostgreSQL database objects, plus execution of ad-hoc queries. Maintained by (who else?) the phpPgAdmin team. (JMB 11.2002).

phpPgAdmin (and the required Apache and PHP packages) may be easily installed using Stack Builder if you are running a one-click-installer PostgreSQL distribution.


pgEdit

http://pgedit.com

Macintosh pgEdit is a high-performance SQL editor and development environment designed specifically for PostgreSQL relational databases. pgEdit features include SQL syntax coloring, direct source code execution, PHP support, integrated documentation, and extensive customizable editing facilities.

pgEdit uses psql, the interactive terminal application included with every PostgreSQL installation. This makes it easy to develop with pgEdit and then transfer your work to any PostgreSQL installation for maintenance and production tasks.

pgEdit is a native application for both Macintosh and Windows. It does not use Java or require installation of external libraries. You have the option of using the version of psql included with pgEdit or a different version installed anywhere on your hard drive.

DB Designer Fork

https://sourceforge.net/projects/dbdesigner-fork/

DB Designer Fork is a fork of the fabFORCE DBDesigner 4. It integrates entity relationship design,front-end (you can run queries) and SQL exporting.DB Designer Fork generates SQL scripts for Oracle, SQL Server, MySQL, FireBird, SQLite and PostgreSQL.

ModelRight

http://www.modelright.com

ModelRight allows you to graphically view your database, enforce complex constraints, manage database views, validate design decisions, and generate complete CREATE and ALTER scripts.

Docs mention support for Windows 7 and PostgreSQL 9.0.


dbmstools

https://github.com/charlesnagy/xml2ddl

Python, uses XML as the one true format and generates migration scripts from that.



SchemaSpy

http://schemaspy.sourceforge.net

Java, LGPL

SchemaSpy analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams.

Personal tools