smartFB v. 2.2.0.185 is available for download at the link: https://api.xtumble.com/downloadattachmentpub?cid=05830520960&fname=/applications/public/SetupSmartFB.exe What’s New: New form to test API connections, styled like Postman ( Tools –> Network Utility –> API Tester ) Direct display of stored procedure parameters on the main db tree Improved syntax highlighting and parenthesis management in the editor Introduced field-level dependency analysis…
Read more
Managing the “&” character with Firebird’s string manipulation functions sometimes may not yield the expected results. The documentation for Firebird’s official “REPLACE” function: https://firebirdsql.org/refdocs/langrefupd25-intfunc-replace.html For example, if we were to make the classic replacement “>” with “>” with an update, it would be normal to write:
|
1 2 |
UPDATE "YOUR_TB_NAME" SET "YOUR_TB_NAME"."TEXT_FIELD" = REPLACE("YOUR_TB_NAME"."TEXT_FIELD",'>','>') |
If this syntax does not produce the expected…
Read more
smartFB v. 2.2.0.185 is available at: https://api.xtumble.com/downloadattachmentpub?cid=05830520960&fname=/applications/public/SetupSmartFB.exe Whats new: Firebird 5.0 support “Internal Function” manager For any questions or feedback, please do not hesitate to contact us. Your opinion is crucial to us! Thank you for your support and trust in smartFB. Good luck with your Firebird databases!
Firebird 5.0 brings with it a remarkable series of improvements from many points of view, from performance to security to the management of parallel backups and restores. You can find these well described at the following link: https://ib-aid.com/en/articles/detailed-new-features-of-firebird-5-part-1-improvements-in-optimizer. So, let’s get down to business, let’s install Firebird 5.0 on a nice Ubuntu 22.04 machine in…
Read more
Test Ubuntu 22.04: Ubuntu 22.04 Server distro for Intel / AMD x64 on virtualization environments (all configured with 4core and 2virt, 8GB, 40GB SSD): VMWare Fusion for MacOSX –> passed no issue VMWare Workstation –> passed no issue KVM –> passed no issue Ubuntu 22.04 Server on this hardware conf: Dell T440 Intel Xeon…
Read more
A new version of smartFB, the rapid Firebird and Interbase database management tool. New features: Improved usability and minor graphic tweaks Improved management of embedded database creation Integration with Xtumble4Delphi library for JSON to Delphi Record management Started implementation of a tool that allows you to export / import datasets in MIDAS ClientDataset and FiredacMemTable…
Read more
