Code Quality Comparison of Firebird, MySQL, and PostgreSQL

I have read very interesting post “Code Quality Comparison of Firebird, MySQL, and PostgreSQL” today about static analysis of three open-source RDBMS. And I wonder, should we use static code analyzers on an ongoing basis, e.g. PVS Studio?

tl;dr:

So, the code-quality rankings are as follows:

    • 1 place – Firebird and PostgreSQL.
    • 2 place – MySQL.

 

 

Please remember that any review or comparison, including this one, is subjective. Different approaches may produce different results (though it is mostly true for Firebird and PostgreSQL, but not for MySQL).

image7

Advertisements

Meet the MicroOLAP Database Designer for MySQL 2.1.5!

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.

Meet the MicroOLAP Database Designer for MySQL v2.1.3!

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.