Meet the MicroOLAP Database Designer for MySQL v2.1.3!

New Reverse Engineering dialog

PgMDD boxDatabase Designer for MySQL is a handy tool with intuitive interface that allows 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 within your database. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram. The product is specially developed for MySQL database and takes into account its features.

This release introduces enhanced Reverse Engineering dialog, options to prevent annoying warning messages, full support for modern table row formats, support for BLACKHOLE storage engine.

You’re welcome to download the Database Designer for MySQL 2.1.3 right now at:
http://microolap.com/products/database/mysql-designer/download/

Full change log:
[+] REDUNDANT and COMPACT row formats support is added
[+] BLACKHOLE storage engine support is added
[+] “Show warning before object deletion” option added to Environment Options
[+] “Show warning before editor closing” option added to Environment Options
[*] Reverse Engineering dialog vastly improved
[*] “Tables in a diagram row” option removed from Reverse Engineering dialog as deprecated

Please don’t hesitate to ask any questions or report bugs with our Support Ticketing system available at
http://www.microolap.com/support/

This slideshow requires JavaScript.

Tagged with: , , , ,
Posted in Announces, MySQL

MicroOLAP Database Designer for PostgreSQL v1.10.2 released

PgMDD boxDatabase 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.

This release fixes two exasperating bugs with user interface as well as improves Check Diagram functionality. One should consider to upgrade to this release as soon as possible.

You’re welcome to download the Database Designer for PostgreSQL 1.10.2 right now at:
http://microolap.com/products/database/postgresql-designer/download/

Full changelog:
[-] “Access Violation error occurs if Run New Database Wizard option is checked in the Generate Database” bug fixed
[-] “Index fields popup editor deselects all previously checked columns” bug fixed
[*] Check Diagram makes Output and Result List visible
[*] Check Diagram doesn’t show index warnings for tables with PK’s or Unique constraints anymore

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: , , , ,
Posted in Announces

PostgresDAC meets RAD Studio XE7!

PostgresDAC v2.12.2 with support for Delphi XE7 and C++ Builder XE7 is available immediately!

You’re welcome to download the PostgresDAC v2.12.2 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: , , , , ,
Posted in Announces

MicrOLAP Database Designer for PostgreSQL v1.10.0 is out!

PgMDD boxDatabase 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 support for the latest v9.4 SQL grammar as well as improved support for inheritance functionality. Modify Engine allows mark constraints as NOT VALID. Several non critical bugs fixed.

You’re welcome to download the Database Designer for PostgreSQL 1.10.0 right now at:
http://microolap.com/products/database/postgresql-designer/download/

Full changelog:
[!] SQL Executor and Validator support v9.4 grammar now
[!] Support for table inheritance improved dramatically
[+] “Always make PK columns first” option introduced in Diagram Options
[+] Allow CHECK constraints to be declared NOT VALID in Modify script
[+] Allow FOREIGN KEY constraints to be declared NOT VALID in Modify script
[+] Shortcut for “Save As..” and “Export” menu items added
[+] SQL keywords are properly highlighted according to 9.4 version
[*] Comments now shown at Preview tab of Table Editor by default
[*] Handling of incorrect file paths improved in Generate and Modify Database
[*] Merging of reversed user types with existing in model improved during Reverse Engineering
[-] “Changing domain schema doesn’t affect table representation where domain used” bug fixed
[-] “Changing some options in the Model Options doesn’t activate OK & Apply buttons” bug fixed
[-] “Column default values containing backslashes are corrupted after reloading model” bug fixed
[-] “Leak proof option doesn’t shown in the Function editor after reopen” bug fixed
[-] “LEAKPROOF attribute causes syntax error in the SQL Executor” 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: , , , ,
Posted in Announces

Get PostgreSQL sources using SVN

As you probably know PostgreSQL sources are managed by Git version control system. Which is great, but for me as SVN user it would be much better to get access to the sources using familiar tools, e.g. TortoiseSVN. Mainly because I don’t need write access, read mode only. There is a workaround for such guys.

First of all, there is a mirror of PostgreSQL sources on the GitHub. And the second, GitHub supports SVN protocol using the bridge to communicate svn commands to GitHub.

So in my case I need only trunk with the latest commits. I’ve created an empty folder and made Checkout to the https://github.com/postgres/postgres/trunk URL.Image

Tagged with: , , , ,
Posted in Coding, PostgreSQL

PostgresDAC 2.12.0 meets RAD Studio XE6!

PostgresDAC v2.12.0 with support for Delphi XE6 and C++ Builder XE6 is available immediately!

Full change log:
[!] Support for Delphi XE6 and C++ Builder XE6 introduced
[!] TPSQLDump allows non-Latin characters in output file names
[*] “W1000 Symbol ‘DefaultFields’ is deprecated’” warning eliminated
[*] “W1030 Invalid compiler directive: ‘True’” warning eliminated

You’re welcome to download the PostgresDAC v2.12.0 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: , , , , ,
Posted in Announces

PostgresDAC 2.11.1 is immediately available


The MicroOLAP team is proud to announce the release of PostgresDAC v2.11.1 which resolves significant bugs and introduces new TPSQLCopy functionality.

If you are currently using PostgresDAC v2.11.0 in production, we recommend that you apply this update immediately. For other versions of the 2.x branches, applying the update is recommended at the next convenient opportunity.

PostgresDAC v2.11.1 is mostly maintenance release. Most notably this release fixes errors with TPSQLDump and TPSQLRestore components.

Full change log:
[+] TPSQLCopy.LoadFromProgram method added
[+] TPSQLCopy.SaveToProgram method added
[-] “ftMemo values with one byte client_encoding (not UTF8) are broken” bug fixed
[-] Bug with dump causing by environment settings is fixed

You’re welcome to download the PostgresDAC v2.11.1 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: , , , ,
Posted in Announces
Archives
Map of wandering
Follow

Get every new post delivered to your Inbox.

Join 83 other followers