MicrOLAP Database Designer for PostgreSQL v1.9.0 is out!

Posted on May 22, 2013 by pashagolub — Leave a comment ↓

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:
http://microolap.com/products/database/postgresql-designer/download/

Full changelog:
[!] 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
http://www.microolap.com/support/

Tagged with: designer, ER, pgmdd, PostgreSQL, release
Posted in Announces

PostgresDAC 2.9.6 with RAD Studio XE4 support is out!

Posted on May 14, 2013 by pashagolub — Leave a comment ↓

This release introduces support for RAD Studio XE4!

You’re welcome to download the PostgresDAC v2.9.6 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/

Tagged with: PostgreSQL, release, PostgresDAC, Delphi, component
Posted in Announces

Development using Lazarus and PostgresDAC. Installation

Posted on April 19, 2013 by pashagolub — Leave a comment ↓

Preface

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;

Installing Lazarus

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.

Getting PostgresDAC

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.

Tagged with: development, FreePascal, lazarus, PostgresDAC, PostgreSQL
Posted in PostgresDAC

MicroOLAP Database Designer for PostgreSQL v1.9.0 Beta is out!

Posted on April 10, 2013 by pashagolub — Leave a comment ↓

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
http://microolap.com/products/database/postgresql-designer/download/.

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.

Tagged with: PostgreSQL, designer, ER, release, pgmdd
Posted in Announces

PostgresDAC v2.9.3 is immediately available

Posted on February 20, 2013 by pashagolub — Leave a comment ↓

This maintenance release contains the latest client librariy, several bug fixes and improvements.

Full changelog:
[+] 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:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/

Tagged with: component, Delphi, PostgresDAC, PostgreSQL, release
Posted in Announces

2012 in review

Posted on December 31, 2012 by pashagolub — 2 Comments ↓

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

Do we need LIMIT clause in UPDATE and DELETE statements for PostgreSQL?

Posted on November 23, 2012 by pashagolub — 9 Comments ↓

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;

Posted in Polls, PostgreSQL