DreamCoder for PostgreSQL (FREE PostgreSQL Tool)
|
Overview
|
|
DreamCoder for PostgreSQL News | Requirements | View demo | Screenshots | FAQ | Testimonials
DreamCoder for PostgreSQL is a tool for developing in a PostgreSQL database. It can make daily tasks much easier for developers.
DreamCoder for PostgreSQL has features that allow you to 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.4.
DreamCoder for PostgreSQL is available in a freeware version.
Feature List
Supports all versions of database server (8.0,8.1,8.2,8.3,8.4)
- Supports the latest PostgreSQL 8.3 version
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
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
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
Advanced options for synchronizing the database
- Utility to synchronize two database schemas
- Utility to synchronize data of two databases
Database Monitoring
- System Monitor
- Built and executed queries History
IDE customization options
- Complete options for modifying IDE behavior
- Complete options for modifying SQL editor behavior
- Complete options for modifying data grid behavior
|