DreamCoder for PostgreSQL Enterprise 2.0

DreamCoder for PostgreSQL Enterprise 2.0 is an application used for creating in a PostgreSQL database, which enables developers to perform their daily tasks easily.

With DreamCoder for PostgreSQL, you can quickly and easily perform all database development tasks, such as creating and compiling stored procedures, export and import data, generate reports, monitor database activity, synchronize database, build and run queries, format SQL code, and manage blob, among many other features. Supports all versions of the PostgreSQL database server, from version 8.0 to version 8.3.

Major Features:

1. Supports all versions of database server (8.0,8.1,8.2,8.3)
   • Supports the latest PostgreSQL 8.3 version
2. Data Handling
   • Add, view, edit, search, group, sort and filter data
   • Ability to copy and paste data directly from Excel
   • Ability to delete selected records
   • Able to export data into SQL inserts
   • Able to create master detail relationships between an unlimited number of tables
   • Utility to manipulate LOV
   • Advanced filter data constructor
3. Advanced visaul query builder and text
   • Advanced SQL editor with autocomplete, syntax highlighting, code folding, objetcs description, code proposal and parameters management
   • Advanced query builder to build SQL's - no previous knowledge required
   • SQL Code Formatter
   • Run scripts
   • Auto replacement of parameters
4. Options for exporting and importing data
   • Utility to export data from database
   • Utility to transfer data from database
   • Utility to export in multiple formats (MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF)
   • Utility to import multiple data formats (MS Excel, MS Access, DBF, XML, ODF, TXT and CSV)
   • Advanced options for export and import at data grid level
   • Utility to import data from excel
   • Simple data export data to a table
5. Advanced options for synchronizing the database
   • Utility to synchronize two database schemas
   • Utility to synchronize data of two databases
6. Database Monitoring
   • System Monitor
   • Built and executed queries History
7. IDE customization options
   • Complete options for modifying IDE behavior
   • Complete options for modifying SQL editor behavior
   • Complete options for modifying data grid behavior

Enhancements:

• SSH tunneling
• SSH tunneling allows to set key
• New SSL options
• New database data sinchronization
• Enhanced Database structure sinchronization
• Export manager redesign
• New clone table option
• New transfer data option
• Stored procedure test option
• Enhanced script execution
• New error manager window
• Autocomplete for stored procedures
• New database statistics option
• Enhanced session monitor
• New optimize tables optiion
• New reinex option
• New configuration options.
• New popup data grid menu.
• Data export manager support Excel and Word 2007
• Data import manager support Excel and Word 2007
• Code folding for complex queries is improved
• Editor now works considerably faster
• Enhanced syntax highlight
• Full support PostgreSQL server from 8.0 to 8.3.6
• Sometimes Ctrl+C and Ctrl+V shortcuts stopped working fixed
• New Query builder options.
• Minor improvements and bugfixes

Requirements:

• 300-megahertz (MHz) Pentium II-compatible processor or higher, 600 - megahertz (MHz) or faster.
• Microsoft Windows NT4, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista.
• 256 MB RAM or higher, 1024 MB recommended.
• 48 MB of disk available to complete installation.
• Super VGA (800x600) or higher, VGA (1024x768) recommended.
• Possibility to connect to a local or remote PostgreSQL server.

 WareSeeker Editor