1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Free Database Workbench Lite edition available!

Upscene Productions is proud to announce the availability of a free feature limited version of Database Workbench, the Lite Edition, for personal non-commercial use. Download it here. There’s a version for Firebird and a version for MySQL.

For details on the feature differences between editions, see this feature matrix.

“Database Workbench is used by thousands of developers around the world, we’re making it available to hobbyists too”, says Martijn Tonies, founder of Upscene Productions. “Everyone can now use the free Lite Edition for personal non-commercial use.”

Database Workbench Basic and up support MySQL, MariaDB, Firebird, Oracle, SQL Server, PostgreSQL, NexusDB, SQLite and InterBase, comes in multiple editions and is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools.

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...

IBX for Lazarus has moved to GitHub

MWA Software is pleased to announce that the ibx4lazarus package has been successfully rehosted on GitHub. The svn repository has been decommissioned and is no longer available for use. Please go to https://github.com/MWASoftware for all of our software packages.

The move to GitHub has also allowed the package split of ibx4lazarus into three separate packages.

  1. The Firebird Pascal API (fbintf)
  2. The ibcontrols package.
  3. The ibx4lazarus package

fbintf and ibcontrols are dependencies for ibx4lazarus itself and must be installed before ibx4lazarus itself.

In future, please report all issues that apply to any of these packages using the GitHub issues feature.

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 5.00 out of 5)
Loading...

RED EXPERT 2025.01 HAS BEEN RELEASED

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.01 is available.

What’s new?

  • Updated the list of available application themes based on the survey results.
  • Stopped support of 32-bit Windows (x86) operating systems.

Improved:

  1. Display application fonts in new themes
  2. Copying field names with data types from a Result Set
  3. Data view panel interface for BLOBs that not available for editing

Fixed:

  1. Trace parsing
  2. Interacting with Red Database 2.6 and Firebird 2 connections
  3. Processing of connection parameters when changing the interface language
  4. Readability of selected lines on the “Analyze” tab in the Trace Manager
  5. Applying old settings, which require restarting the application, during upgrade
  6. Customizing date and time patterns
  7. Adding a comment to JOB
  8. Behavior of the “Wrap lines” checkbox on the BLOB data view panel
  9. Confirmation dialog disappearing when altering the database object
  10. Dialog closing after creating database objects
  11. Applying and restoring settings
  12. Various exceptions occurred by the data export
  13. Displayed data type size in the results of the SELECT query

In previous versions, Portuguese language support was added. We want to make the app better, so we welcome comments from native speakers.

Download and install the new version.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

FBPC 1.0.3 is released

A new version of Performance Comparer for Firebird (FBPC) is now available. Version 1.0.3 has the following changes:

  1. Fixed some parameters data type identifying logic (the traceapi writes the params data types based on their internal field type, not the declared type)
  2. The statement’s grid wasn’t showing a value when the statement execution time was below 1ms
  3. Added some error handling during the statements execution
  4. Now any errors during the execution of an statement will be logged in the errors.log file (in the application directory)

FBPC is a free tool that can help people to compare the performance of real life SQL statements between two Firebird versions, or even between the same Firebird version but with different configurations in firebird.conf.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

RED EXPERT 2024.12 HAS BEEN RELEASED

You can join to the Telegram chat for discussion.

New version of Red Expert 2024.12 is available.

What’s new?

Added:

  1. Formatting numbers for table statistics
  2. Copying formatted column names

Improved:

  1. The amount of memory required for audit analysis has been reduced
  2. Exporting data with BLOB SUB_TYPE TEXT type now does not require mandatory file specification for exported blobs

Fixed:

  1. Recalculation of index selectivity
  2. Parsing of the nested procedures
  3. Parsing of the procedure cursors
  4. Parsing of the procedure variables with NCHAR, REAL, INT, LONG FLOAT and other types
  5. Generating SQL statements for variables with COLLATE
  6. Display SQL queries containing special characters on the “Analyze” tab in the Trace Manager
  7. Increased CPU load after repeated opening of the search window in the Query Editor
  8. Mismatch between the versions of the client library and driver used for native connection

Download and install the new version.

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Blob transfer speed optimizations

It is well known that transferring blobs in Firebird over high latency networks (i.e. internet) is very slow. The main reason is that transferring blobs always required lots of roundtrips. The good news is that the donations collected in the 21st Firebird Developers Day (FDD) Brazilian conference are being used to sponsor the improvement of blobs transfer speed. The changes are being developed by Vlad Khorsun and the currently results looks very good (see below)!

Note that the improvements are being developed in two phases. The first phase is ready and didn’t require any changes in the Firebird Wire Protocol, so it will be available in the upcoming Firebird 5.02 release. Transfer times were reduced by 33%-49%.

The second phase is still under development and requires changes in the Firebird Wire Protocol, so it will be available only in Firebird 6, but it already shows great results from 94%-97% improvement! In the best case, the time dropped from 12s to 477msecs!

1 Star2 Stars3 Stars4 Stars5 Stars (6 votes, average: 5.00 out of 5)
Loading...

1 2 3 485