Editor's review
This is a development tool for developments based on the PostgreSQL database.
DreamCoder for PostgreSQL is a tool for development activities in a PostgreSQL database. Activities 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, manage BLOB are a few of the many features you could use. All versions of the PostgreSQL database server, from version 8.0 to version 8.3 are supported with the tool. Some of the basic functions that can be handled include add, view, edit, search, group, sort and filter data items. You are able to delete selected record. Import data from Excel by simple copy-paste and export data to SQL inserts. The developer can create filter data constructor and master detail relationship between unlimited number of tables. Advanced query building features include an editor with auto complete, syntax highlighting, code folding, objects description, code proposal and parameters management. SQL code formatter, ability to run scripts and auto replacement of parameters are useful in creating these queries. Even novice developers will be able to use the query builder easily.
Database synchronization and monitoring is aided by the availability of utilities that can synchronize two databases including schemas. Monitoring tool are available that includes a system monitor and a history recorder that records queries built and executed. A large number of data formats are supported for data import and exports. These include MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF for exports and MS Excel, MS Access, DBF, XML, ODF, TXT and CSV for imports. These features make for a fairly flexible development tool and if you do development and maintenance in the PostgreSQL environment, this is one tool worth trying out and then keeping in your tool bag.
User comments