Meet the MicroOLAP Database Designer for MySQL 2.1.5!

mydesigner-boxshot

MyMDD 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 improves logging facility, adds support for invocation views options, enhances control on views display preferences, fixes some rare bugs.

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

Full change log:
[!] Error logging improved a lot
[+] “Show object icons” option added to Display Preferences
[+] “With Check” view option support added
[+] Algorithm view option support added
[+] Attributes option added to the View tab of Display Preferences
[+] Comments option added to the View tab of Display Preferences
[+] SQL Security view option support added
[+] Targets option added to the View tab of Display Preferences
[*] “Add object” menu item is available for the Object Tree View
[*] Handling of incorrect file paths improved in Generate Database
[*] Multiple triggers are permitted for the same Time and Event combination as of MySQL 5.7.2
[*] Trigger name generation simplified in Table Editor
[-] “Apply button is sometimes available even if no changes made in the object editor” bug fixed
[-] “Cannot open model (.mdd) file in Explorer if application already launched” 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/

This slideshow requires JavaScript.

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

PostgresDAC 3.0.2 with PostgreSQL 9.4.2 support is available


The MicroOLAP team is proud to announce the release of PostgresDAC v3.0.2 with support for PostgreSQL 9.4.2.

Full change log:
[!] v9.4.2 client libraries added
[!] v9.4.2 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
[!] v9.3.7 dump & restore libraries (pg_dump-9.3.7.dll, pg_restore-9.3.7.dll) added
[!] v9.2.11 dump & restore libraries (pg_dump-9.2.11.dll, pg_restore-9.2.11.dll) added
[+] TPSQLCopy.SaveToStrings(Strings: TStrings; Encoding: TEncoding) method added
[*] Dumping of views that are just VALUES(…) but have column aliases improved
[*] Possible TPSQLDump failure when concurrent sessions are creating and dropping temporary functions avoided
[*] Risk of network deadlock when using non-blocking mode reduced
[*] Scroll bars added to SQL Editor if standard memo used
[*] TPSQLDump considers foreign key relationships between extension configuration tables while choosing dump order
[*] TPSQLDump now honors CompressLevel value together with dfDirectory output format
[-] TPSQLDump’s rule for deciding which casts are system-provided casts that should not be dumped fixed

You’re welcome to download the PostgresDAC v3.0.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

PostgresDAC meets RAD Studio XE8!

PostgresDAC v3.0.1 with support for Delphi XE8 and C++ Builder XE8 is available immediately!

Full change log:
[!] Support for Delphi XE8 and C++ Builder XE8 (Elbrus) introduced
[-] “TPSQLDatabase.Host is empty after form loading if proper IP specified as property value” bug fixed

You’re welcome to download the PostgresDAC v3.0.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

MicroOLAP Database Designer maintenance release v1.10.4 is available immediately

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 is maintenance release which fixes slow Reverse Engineering and Modify Database on some models, improves shell association. Some minor bugs were fixed.

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

Full changelog:
[!] Dramatically increased Reverse Engineering speed
[+] “Add object” menu item is available for Domains and Sequences in the Object Tree View
[*] Manager tool bar is enabled automatically after new model created
[-] “Cannot open model (.pdd) file in Explorer if application already launched” bug fixed
[-] Temporal types have no precision specifier in new domains by default from now

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

MERGE in PostgreSQL

Found cool trick how today implement Orable MERGE in PostgreSQL:

Oracle statement:

  1.  
  2. MERGE INTO acme_obj_value d
  3. USING ( SELECT object_id
  4.         FROM   acme_state_tmp
  5.       ) s
  6. ON (d.object_id = s.object_id)
  7.   WHEN matched THEN
  8.     UPDATE SET d.date_value = LEAST(l_dt, d.date_value)
  9.   WHEN NOT matched THEN
  10.     INSERT (d.id, d.object_id, d.date_value)
  11.     VALUES (acme_param_sequence.NEXTVAL, s.object_id, l_dt)
  12.  

PostgreSQL statement:

  1.  
  2. WITH s AS (
  3.      SELECT object_id
  4.      FROM   acme_state_tmp
  5. ),
  6. upd AS (
  7.      UPDATE acme_obj_value
  8.      SET    date_value = LEAST(l_dt, d.date_value)
  9.      FROM   s
  10.      WHERE  acme_obj_value.object_id = s.object_id
  11.      RETURNING acme_obj_value.object_id
  12. )
  13. INSERT INTO acme_obj_value(id, object_id,  date_value)
  14. SELECT NEXTVAL('acme_param_sequence'), s.object_id, l_dt
  15. FROM   s
  16. WHERE  s.object_id NOT IN (SELECT object_id FROM upd)
  17.  

Tagged with: , ,
Posted in Coding, PostgreSQL

Delphi: Warnigs → Errors

Delphi+Elevate+Warnings+to+Errors

Want to force your dev team to address Compiler Warnings rather than ignoring them?

Elevate Warnings to Errors:

1) Go to Project Options
2) Under Delphi Compiler, select Hints and Warnings
3) Expand the Output warnings item
4) For each important Warning you wish for your developers to address rather than ignore, select the drop-down list and select Error.

Enjoy!

Thanks Simon Stuart for hint!

Delphi+Elevate+Warnings+to+Errors

Tagged with: , ,
Posted in Coding, Delphi

MicroOLAP Database Designer meets PostgreSQL 9.4!

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 introduces support for the latest v9.4 SQL grammar. Among other important features JSONB type support were added. Modify Engine allows creating indexes CONCURRENTLY. Several non critical bugs fixed.

Download

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

Feedback

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

Full changelog:

  • [!] PostgreSQL 9.4 support added
  • [+] Allow creating indexes CONCURRENTLY using Modify script
  • [+] JSONB type support added
  • [*] Primary column removed from Column Manager
  • [*] Support for ENUM types improved in Column Manager
  • [*] uuid[] type added to editors
  • [-] “Quote Default Value option not saved in Column Manager” bug fixed
Tagged with: , , , ,
Posted in Announces
Archives
Map of wandering
Follow

Get every new post delivered to your Inbox.

Join 426 other followers