DreamCoder for PostgreSQL is a free powerful Integrated Development Environment (IDE) for PostgreSQL Databases.
Features: Freeware DreamCoder for PostgreSQL is a good tool to develop and manage a PostgreSQL database server. This is meant for people who are learning about the database and who need basic server functionality to try things out. DreamCoder for PostgreSQL is also an Integrated Development Environment (IDE) for PostgreSQL Databases. With the intuitive DreamCoder`s GUI code quality can be improved and development time reduced. This application lets you build and run queries scripts etc. You would be able to create and modify databases. Compiling PL and pgSQL code becomes easy. Import and export of data to these databases, user session monitoring and the database monitoring are available features.Several visual tools help with your productivity. These tools include SQL editor, a PL/pgSQL editor,database structure synchronization, master detail table browser etc.Tools also include parameter manager, SQL formatter, query builder, SQL history, session monitor etc.
The application supports all versions of database server (8.0,8.1,8.2,8.3,8.4) and supports the latest PostgreSQL 8.3. Data handling features available include add, view, edit, serch, sort and filter data, copy and paste data from Excel directly, deletion of selected records, export data in SQL inserts, master detail relationship creation between unlimited number of tables and advance filter data constructor. The visual query builder supports auto-complete, syntax highlighting, code folding, objects description, code proposal and parameter management etc. Database monitoring features include system monitor and history of built and executed queries history. The IDE is customizable and the options include IDE behavior customization options, SQL editor customizations and modifying data grid behavior options.
Overall: Nice learning and development tool.