TurboBird IBX

[maurog]

Hello,

I have uploaded TurboBird v1.2.1.1270.

New in this version:

Transaction configuration added
(Right-click on the database name → DB Tools → Transaction Config)

Simple CSV Editor added
(Menu: Built-In Tools → CSV Editor)

SQL Editor (Design-Time) from IBX added
(In the Query Window on the toolbar)

In addition, several bugs have been fixed.

Best Regards,
Maurog.

[maurog]

I have uploaded TurboBird v1.2.1.1272.
https://github.com/mdadali/TurboBird/releases/tag/TurboBird_v1.2.1.1272

This release includes several improvements and fixes:

- DBReader integrated as a data recovery tool
  (https://github.com/serbod/DBReader)

- CSVEditor renamed to DataEditor, as it now supports multiple file formats for editing and export

- New menu entry "Built-in Tools" added to the main menu

- Support for Embedded Connections added
  (please refer to the file "known_limitations_bugs.txt")

- Known limitations/bugs are now included in the distribution

- Several bugs have been fixed

Best regards
Maurog.

[valdir.marcos]

It's working on Zorin OS/Ubuntu/Debian.

Thanks.

[maurog]

Hi,

I have uploaded TurboBird v1.2.1.1273. This version is significantly more powerful than v1.2.1.1272.
https://github.com/mdadali/TurboBird/releases/tag/TurboBird_v1.2.1.1273

Here is an excerpt from the changelog:

**+ Runtime Drag & Drop Form Designer & PascalScript (New)**
- Dedicated "Forms" node in the database tree
- Custom forms can now be created per database
- Forms are saved as .cfrm + .rops files
- "New Form" opens the visual designer
- "Edit Form" loads an existing form into the designer
- "Execute Form" runs a form directly
- Double-click on a form starts execution
- Storage location: data/PSStudio/Forms/<Server>/<Database>/

**! Table Management and Constraints (completely overhauled)**
- All constraint types now visible as subnodes of each table
- Primary Key with field list
- Foreign Keys with reference display
- Unique Constraints with field list
- Check Constraints with condition
- Not Null Constraints with affected fields
- Indices (only user-defined, without system indices)
- Multi-column keys are clearly grouped (PRIMARY KEY (Field1, Field2))
- Table management extended with new tabs:
  - Primary Key: select fields via checkbox, changes generate SQL
  - Foreign Keys: manage existing ones, create new ones with wizard
  - Unique Constraints: select fields, assign name
  - Check Constraints: edit expression directly
  - Not Null Constraints: check fields, changes as ALTER statements

**! Trigger Support (extended)**
- New trigger types in the tree:
  - Database triggers (ON CONNECT, ON DISCONNECT, ON TRANSACTION...)
  - DDL triggers (BEFORE/AFTER CREATE TABLE, DROP TABLE, etc.)
  - UDR triggers (EXTERNAL NAME ... ENGINE UDR)
- "Create new Trigger" with appropriate template for each type
- Trigger view shows correct type (Table/DB/DDL)
- Editing and deleting of all trigger types possible

**! Tree Structure (improved)**
- Table fields now clearly grouped under "Fields"
- Constraints and indices visible directly under the table
- Table triggers visible directly under the table
- "References" and "Permissions" under each table

And several bugs fixed.

I will also upload an animated GIF showing how to use PascalScript Studio.

Best Regards,
Maurog.

[maurog]

New version 1.2.1.1277 is online. Automatic update notification is now active.

Best regards,
Mustafa.

[maurog]

Hello everyone,

I have just uploaded TurboBird v1.2.1.1280. Here are the changes in this release:

TurboBird v1.2.1.1280
Build date & time: 26.07.2026

+ Clone Table (Universal Copy Tool)
Replaces three old dialogs: ImportTable, CloneToExternal, CopyTable
Copies tables in all directions: FB → FB (local & Cross-Database), FB → External Table (binary format, up to 220,000 rows/sec), External Table → FB
Automatic selection of the fastest copy method: INSERT...SELECT (local, up to 70,000 rows/sec),
EXECUTE   BLOCK (Cross-DB, up to 4,600 rows/sec), Row-by-Row (Cross-DB with all field types)
Data transformation support with $1 placeholder (e.g. $1 * 1.1, UPPER($1))
Optional data copy (table structure only or including data)
Batch processing with configurable size
Progress display with time measurement and speed
Automatic detection and deselection of problem fields (BLOBs, Arrays) for external target tables

+ Data Editor (significantly enhanced)
Universal interface between Firebird and text files
Direct access to FB tables via right-click: "View in Data Editor" (Read-Only), "Edit in Data Editor" (Read-Write, using TIBTable)
Loading FB tables with progress dialog and statistics
All export formats available (CSV, JSON, HTML, PDF, Spreadsheet, etc.)
Direct editing in the grid (Read-Write mode)


+ Create Table from DataSet (New)
Creates a Firebird table directly from CSV/JSON/Excel data
Accessible from Data Editor via "Create Table"
Selection of server, database and table name, fields selectable via checkbox
Optional data copy (structure only or including data)
Batch processing with progress dialog
Formula support (optional)

+ Bulk Export (New)
Exports FB tables as Text files
Server-side formatting for maximum speed
Batch processing with configurable size, buffered stream for optimal write speed
Progress display with time measurement and statistics
Formula support for transformed exports, configurable via INI file

- Removed old dialogs
ImportTable, CloneToExternal, CopyTable (replaced by CloneTable)

+ Session Password Cache – temporary passwords are stored for the duration of the session

- PascalScript Studio deactivated (currently unstable)

* Several bugs fixed

For reference, the performance numbers were achieved on a modest machine: an old AMD CPU, 3.5 GB RAM, a standard SSD, running Linux. With better hardware significantly higher speeds are possible.

Greetings,
Maurog.

[laguna]

Hi!

I saw your IBX-based TurboBird project and I have to say the porting is really great.

I've done some testing and wanted to share my feedback:

    Linux Version: Tested with the binaries and it works very well; I really liked it.

    Windows Version: Using the precompiled binaries, I encountered an error at startup while registering fbclient.dll.

        Note on Dependencies: Unlike the Linux version where GTK is standard, the Windows version currently depends on GTK. It would be much better if the Windows build could avoid this dependency to feel more native and avoid extra setup hurdles for Windows users.

Building from Source (Windows): To work around the startup problem, I downloaded the sources and recompiled it, but I encountered some difficulties:

    Add-ons conflicted during installation.

    The project was set to Linux instead of the default (this issue has been resolved).

    It would be helpful, if possible, to align the add-ons with the latest stable version of Lazarus.

I haven't had a chance to try the macOS version yet, but I hope to do so this week.

Thank you so much for your great work!

Laguna

[laguna]

Hi everyone,

First of all, I want to say that IBX for Lazarus is an excellent component. I use it regularly and it works flawlessly on both Windows and Linux.

However, I am currently facing a couple of issues when trying to use it on macOS 26:

1. Firebird 5 Installation Not Recognized
Currently, the component does not recognize the installation of Firebird SQL 5 on macOS. Since Firebird SQL 5 is architecturally different from Firebird SQL 3, the detection process seems to fail completely, preventing me from using the latest version of the database.

2. "Invalid type cast" Error with Firebird 3 and TurboBird
Because of the first issue, I fell back to using Firebird SQL 3. By making several compromises, I actually managed to get TurboBird IBX to compile and run on macOS 26. I can successfully register both the server and the database. However, whenever I click on a table to view it, I immediately get the following error:

    Exception: Invalid type cast

Has anyone successfully configured IBX with Firebird 5 on macOS, or does anyone know what might be causing the type cast exception when browsing tables with Firebird 3? Any guidance, patches, or workarounds would be highly appreciated.

Thanks in advance for your help!

[maurog]

@laguna

thank you for the appreciation!

Regarding Windows and GTK:
There are the configurations x86_64-win64-win-debug and x86_64-win64-win-release – these two do not require GTK. They use pure Windows libraries. Please use one of these.

Firebird 5 installation not recognized:
I think I read somewhere in the forum that the problem can be solved by copying the fbclient into the IBX directory.

"Invalid type cast" error with Firebird 3 and TurboBird:
Please try different fbclient versions. In TurboBird, you can select and test any fbclient in the server and database configuration (Register/Edit). I use the client library that comes with Firebird 6 – it works with Firebird versions from 2.5 to 6.0. The library is very backward compatible. Maybe that helps.

The form that causes the exception uses the TIBQuery component. You could create a small test project and test the component separately – that way you would see whether the error lies with the component or with TurboBird.

I am very pleased that TurboBird is now also available on macOS. Thank you very much for that!

Best regards,
Maurog.