Database Designer for PostgreSQL is an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ allowing you to
- build a clear and effective database structure visually,
- see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects,
- easily generate a physical database on a server,
- modify it according to any changes you made to the diagram using fast ALTER statements,
- import already existing diagram from the server,
- export diagram to the common graphic formats or as SQL script,
- create detailed printings and reports.
Improved and enhanced long awaited release is available. It introduces internal and architectural improvements. New compiler used as well as new exception tracer implemented. Some little changes and bug fixes are present too.
You’re welcome to download the Database Designer for PostgreSQL 1.9.0 right now at:
[!] New compiler used in development
[!] New exception tracer tool used
[-] “Designer doesn’t restore itself to maximized state after restart” bug fixed
[-] “Modify Database ignores output script character case option” bug fixed
[-] “Reverse Engineer warns that diagram is not empty even though it clearly is” bug fixed
Please don’t hesitate to ask any questions or report bugs with our Support Ticketing system available at
This release introduces support for RAD Studio XE4!
You’re welcome to download the PostgresDAC v2.9.6 right now at:
or login to your private area on our site at
There are a lot of tools for PostgreSQL development. I want to propose you one more. Why Lazarus:
- Lazarus is shipped with open-source Pascal compiler;
- it has a high degree of Delphi compatibility;
- availability on a variety of platforms, including Windows, Mac OS X, and Linux;
- complete source code is available;
Go to Lazarus at SourceForge.
Then at the Downloads Section get proper installer. I used lazarus-1.0.8-fpc-2.6.2-win32.exe and lazarus-1.0.8-fpc-2.6.2-win64.exe in my tests. These are the latest releases at the moment.
Here are the screen shots of the installation process where you can see what I had chosen:
I have Lazarus installed into C:\lazarus\ and hereafter I will use this path.
Now it’s time for PostgresDAC. At the moment many Laarus IDE functions require the source and warns if the source of a unit is missing. Thus we need PostgresDAC with sources version. Sources are available for licensed users in their profile.
I have extracted PostgresDAC sources to C:\PostgresDAC\.
Install PostgresDAC into the IDE
In the Lazarus IDE choose open package and select dclPostgresDACL.lpk. This is the design time package. Then in the Package window choose Use → Install.
Confirmation about rebuild will appear.
Choose “Yes”. Wait for some time. After successful rebuild Lazarus will reopen itself. Tada! We got it!
Now we may open some demo projects and play some time.
Database Designer for PostgreSQL is an easy CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ.
This release does not introduce any new functionality. A huge amount of internal and architecture tasks were done instead. New compiler version used as well as new exception tracer implemented. Some little changes, not worthy of mention, are also present, e.g. standard Color Dialog etc.
There are two new major features in this release as compared to previous:
- [!] New compiler used in development
- [!] New exception tracer tool used
Please test v1.9.0-Beta thoroughly. We depend on your bug reports and feedback in order to proceed to final release.
The more testing you do, the sooner 1.9.0 will be available.
If you have some spare time to help us with testing, please visit MicroOLAP Database Designer for PostgreSQL Download page at
Please don’t hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/
P.S. Beta releases should never be used in production; they are for testing purposes only.
This maintenance release contains the latest client librariy, several bug fixes and improvements.
[+] v9.2.3 client libraries added
[-] “FieldDef.Required always false” bug fixed
[-] “Incorrect work Locate and Lookup functions with filtered records” bug fixed
[-] “Reading TPSQLDatabase.Host IP-address from .dfm may fail if host name was assigned earlier” bug fixed
[-] “TPSQLNotify may produce rare memory corruption if USE_THREAD_POLLING firective used” bug fixed
[-] Ambiguity between System::Sysutils::UIntToStr and Psqltypes::UIntToStr resolved
You’re welcome to download the PostgresDAC v2.9.3 right now at:
or login to your private area on our site at
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
4,329 films were submitted to the 2012 Cannes Film Festival. This blog had 23,000 views in 2012. If each view were a film, this blog would power 5 Film Festivals
Click here to see the complete report.
Tagged with: helper monkeys
Posted in General
Was working with MySQL recently. Noticed that UPDATE command of it has special LIMIT clause which is really useful as for me, e.g.
UPDATE `Product_download` SET `version`='9.2.1' WHERE `product_download_id`=367 LIMIT 1;