Upscene releases Database Workbench 5.4.2

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:

” Database Workbench 5.4.2″

This release support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a custom report writer, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and several other features.

Firebird Synchronization to AWS Cloud.

Happy to announce a new release and general availability of Bipost Sync, a tool designed for synchronizing Firebird SQL (Windows) to AWS cloud.

Built for developers in mind.

Bipost Sync is ideal to extend your on-premises Firebird DB’s to the cloud, and build web applications, web services and API’s on top of AWS cloud platform.

It is also a great way to consolidate information from separate databases and locations, e.g. manufacturing companies may want to read sales and inventory information from 2nd or 3rd tier small retailers.

Tech Stuff:
(*) Synchronize specific data sets from Firebird SQL on Windows to AWS Aurora-MySQL.
(*) Two-way synchronization available, from AWS Aurora-MySQL back to your Firebird SQL.
(*) No need to create/alter schemas, this is done by our sync tool.
(*) Prepare your data before you load with stored procedures you define.
(*) Transform your data after load is done, also with stored procedures you define.

More info:
https://factorbi.github.io/

Firebird Members Offer available:
https://www.firebirdsql.org/en/member-to-member-offers/

MWA Software is pleased to announce that release 2.2.0 of IBX for Lazarus is now available for download from mwasoftware.co.uk/ibx. This is an important update to IBX and all users are recommended to upgrade to the new release. Please read the changelog before upgrade.

The main intent behind the release is to add support for the remaining Firebird 3 features (and some from earlier Firebird releases) that were not supported in release 2.1. This includes:

  1. Support for SQL Statements INSERT/UPDATE/DELETE…RETURNING. The first two cases are now able to update the current row for all TIBCustomDataset descendents including TIBTable, using data returned following a row insert or update.
  2. INSERT…RETURNING is used to provide support for Firebird “Identity” columns. For example, when used to provide auto-increment primary keys.
  3. Firebird “Packages” are now supported by TIBStoredProc and by the SQL Component Editors.
  4. Additional Firebird 3 properties are now supported by TIBDatabaseInfo and by the Services API components (e.g. TIBConfigService).
  5. Alternative Security Databases are now supported by the Services API Components.
  6. TIBExtract now supports DDL Grants and triggers on database objects.
  7. A new IBServices component to support online validation of a database (TIBOnlineValidationService).
  8. A major new example application (DBAdmin) is now included. This illustrates the use of IBX for Day-to-Day Database Administration tasks including User Management, Backup/Restore and Database Validation and Repair. It is also intended to provided a useable application that users may use directly or incorporate into their own toolsets. It also demonstrates User Management using Firebird 3 virtual tables and SQL statements. Note: this application also requires the standard Lazarus package MemDSLaz.

This release also incorporates recent bug fixes and includes a 33 page guide to the use of IBX for Firebird DBA activities.

IBX for Lazarus may be downloaded from: www.mwasoftware.co.uk/ibx

or by subversion from:

svn.mwasoftware.co.uk/public/ibx/tags/R2-2-0

Migration Guide to Firebird 3 gets updated!

I’m proud to announce a new update to my Migration Guide to Firebird 3 eBook! The changes in revision 1.20 are mostly concentrated in the chapters about Connecting to Firebird 3 using an old client library, Testing application’s queries, Jaybird, .NET Provider and the two new sections about permissions for creating databases and for generators and exceptions.

In the next days, all those who already bought the eBook will receive an email with instructions about how to download the new revision.

The printed version will also get updated asap is already updated to 1.20. Those who already bought the printed book (rev 1.02) can email me to receive a PDF with the changes.

Click here for more information and to buy the eBook.

IBSurgeon is offering 10% discount on the HQBird Standard to all buyers of the eBook. More information here.

dbMigration .NET 7.5 released!

dbMigration .NET 7.5 is a simple, easy and intuitive multiple database migration and data synchronization tool, With it you can easily migrate schema and data to Firebird and vice versa. (Full support for Firebird 1.5~4.0+)

http://fishcodelib.com/DBMigration.htm

Upscene releases Database Workbench 5.4.0

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:

” Database Workbench 5.4.0″

This release support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a custom report writer, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and several other features.

Database .NET v24 released

Database .NET v24 is an innovative, powerful and intuitive multiple database management tool.
(Full support for Firebird 1.5~4.0+)

http://fishcodelib.com/Database.htm

Firebird Perl extension DBD-Firebird version 1.31 is released

Perl extension DBD::Firebird version 1.31 is released with quite a few changes if you compare with provious announcement , here are a few from the ChangeLog:

* remove artificial hard-coded limit of 1_000_000 bytes when fetching BLOB data
* add /usr/local to the list of possible firebird homes [RT#123723]
* blob_type needs to be signed to be assigned/compared to -1
* bpb parameter to isc_open_blob2 is a pointer
* drop unused column character set definition
* correctly check for Test::CheckDeps presense
* finish: do not check uninitialised status vector If statement type is isc_info_sql_stmt_exec_procedure,isc_dsql_free_statement is not called and there is no point checking the status vector for errors. An error there may be from a previous call, or just plain garbage.
Fixes Debian bug : 883183 — test failure on i386, and RT#110979
* add support for a ‘timeout=$secs’ parameter [RT#119764]
* put fb_api_ver in XS and make it available to both embedded and regular driver
* more constants for client version (major/minor/full version string)

1 17 18 19 20 21 147