Comparison of data filling of FB 5 and PostgreSQL 17

Leave a comment

A study comparing Firebird 5 and PostgreSQL 17 reveals that the best choice for database storage efficiency depends on the specific data types and usage patterns.

Key Findings:

  • Character Data: Firebird demonstrates superior efficiency in storing character data types, particularly for larger field sizes.
  • Integer Data: PostgreSQL is more efficient when it comes to storing integer data.
  • Updates: When 25% of the rows were updated, Firebird’s database size increased by only 8%, while PostgreSQL’s grew by 25%. After updating 50% of the data, Firebird saw an additional 12% increase, while PostgreSQL’s size increased by another 26%.
  • Temporal Data: Both databases are comparable in storing simple temporal data. However, for data types that include time zones, PostgreSQL uses more space for time with time zones, but less for timestamps with time zones.

In conclusion, the study suggests that Firebird may be a more space-economical choice for databases with frequent updates to character-heaving data. PostgreSQL, on the other hand, offers better storage efficiency for integer-based data and certain temporal data types. The choice between the two will ultimately depend on the specific needs and data characteristics of the application.

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

Database Workbench 6.8.0 released

Leave a comment

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

“Database Workbench 6.8.0”

This release introduces support for Oracle 23 Domains, Vector and Boolean datatypes, JavaScript stored routines and more.

Other changes include support for PostgreSQL 17, MariaDB 11.7 and MySQL 9.2, bugfixes and small new features.

Database Workbench supports Firebird, MySQL, MariaDB, PostgreSQL, SQLite, Oracle, MS SQL Server, SQL Azure, NexusDB and InterBase.

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

Database Workbench 6 comes in 3 different editions with different pricing models, there’s always a version that suits you!

There’s also free Lite Editions available for Firebird and MySQL.

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

RED EXPERT 2025.07 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.07 is available.

What’s new?

Improved:

  1. Metadata Export / Compare tool

Fixed:

  1. High CPU and RAM load when CTRL is held down in the Query Editor
  2. Infinite reconnecting to DB using certificate
  3. Editing table columns with encoding and dimensions
  4. Editing database users
  5. Loading table triggers in Firebird 2.5
  6. Loading procedure parameters
  7. Loading table constraints
  8. Creating a database backup by overwriting an existing file
  9. Restoring Query Editor tabs after restarting the application
  10. Loading drivers for connections containing spaces in the path
  11. Application hangs when working with unsupported DBMS
  12. Displaying hints for password input field
  13. Displaying the database statistics

Download and install the new version.

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

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

Free Database Workbench Lite 6.7.0 now available

Leave a comment

Upscene Productions is proud to announce the availability of a free feature limited version of Database Workbench 6.7.0 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.

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

RED EXPERT 2025.06 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.06 is available.

What’s new?

Required Java version has been updated to 21 LTS.
Java is supplied with the application now.

Added:

  1. Support for partial indexes
  2. Specifying JVM parameters in the configuration file
  3. Script for creating triggers and indexes for table metadata
  4. Connection tree visibility button

Fixed:

  1. Display settings after updating from the old versions (2024.07 and older)
  2. Generate SQL script for computed indices
  3. Generate SQL script based on ER diagram
  4. Displaying a query plan containing tables with “PLAN” in the name
  5. Working with the user context (AUTHID and SQL SECURITY)
  6. Handling errors that occur when connecting to a database
  7. Saving and loading ER diagram files
  8. Inserting and deleting table data using a dialog box
  9. Applying settings using the “OK” button
  10. Changing the colour properties for the table “Data” tab
  11. Displaying GUI components on some panels
  12. Displaying the date editor in a dark theme
  13. Displaying the application shortcut on Windows OS

Download and install the new version.

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

MCP Firebird 2.2.0 – Complete SSE Transport Implementation

Leave a comment

This release 2.2.0 brings complete SSE (Server-Sent Events) transport support to MCP Firebird, making it fully compatible with the MCP Inspector and modern MCP clients while maintaining 100% backwards compatibility with existing STDIO implementations.

✨ New Features

🌐 SSE Transport Support

  • Full SSE Implementation: Complete Server-Sent Events transport using official MCP SDK v1.13.2
  • MCP Inspector Compatible: Works seamlessly with npx @modelcontextprotocol/inspector
  • Backwards Compatible Server: Supports both modern and legacy MCP clients
  • Multi-Protocol Support: Single server instance handles STDIO, SSE, and HTTP simultaneously
Read more
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...

RED EXPERT 2025.05 HAS BEEN RELEASED

Leave a comment

You can join to the Telegram chat for discussion.

New version of Red Expert 2025.05 is available.

What’s new?

Added:

  1. OCTETS character set support
  2. Display UUID in hexadecimal
  3. Warning about incompatible ODS server and DB versions
  4. JetBrains Mono font for query editor

Fixed:

  1. Editing the scale of columns with NUMERIC and DECIMAL types
  2. Working with different file encodings in the query editor
  3. Saving the size and location on the screen
  4. Changing editor fonts in settings
  5. TABs to spaces converting
  6. Restarting application if there is unsaved data
  7. Editing tablespaces with comments
  8. Creating table with domain columns
  9. English documentation opening
  10. Copying a result set with NULL values to the clipboard
  11. Password field displaying in classic theme
  12. Displaying angle brackets in the SQL script difference pane
  13. Query editor tabs behavior on establishing/releasing DB connection
  14. SQL header generation when retrieving database metadata
  15. Deleting table records with the using of dialog window

Download and install the new version.

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

Jaybird 6.0.2 and Jaybird 5.0.8 released

Leave a comment

We are happy to announce the release of Jaybird 6.0.2 and Jaybird 5.0.8. Both releases provide support for upcoming Firebird 5.0.3 inline blobs, and some other improvements.

For more information on inline blobs, for Firebird 5.0.3 and higher, see also New Article: Data access methods used in Firebird.

Changes

The following was fixed or changed since Jaybird 6.0.1 / Jaybird 5.0.7:

  • Improvement: added authPlugins property on FBManager (#866 / #865)
  • Improvement: increased default and maximum SQL info sizes used for retrieving statement information like columns, parameters and plan information (#869 / #868)
  • Improvement: backported inline blob support (Firebird 5.0.3 and higher) from Jaybird 7 (#870 / #871)
  • Improvement: The time zone mapping was updated (#874 / #875)

Bug reports about undocumented changes in behavior are appreciated. Feedback can be sent to Firebird-java or reported on the issue tracker https://github.com/FirebirdSQL/jaybird/issues.

Jaybird 6.0.2

Jaybird 6 supports Firebird 3.0 and higher, on Java 17, Java 21, and Java 24.

See also:

Jaybird 5.0.8

Jaybird 5 supports Firebird 2.5 and higher, on Java 8, Java 11, Java 17, Java 21, and Java 24 (support for Java 11 and higher using the Java 11 version of the driver). 

See also:

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

1 … 3 4 5 6 7 … 492