MWA Software’s Firebird Pascal Client API package (fbintf) release 1.0.2 is now available for download. The package has been updated to support Delphi Win32 (from Delphi 2010 onwards) in addition to the Free Pascal Compiler (3.0.0 onwards). The package is otherwise functionally identical to release 1.0.1.
The Firebird Pascal Client API package provides common Pascal language bindings to the Firebird API that are independent of the Firebird API version. Both legacy and Firebird 3 APIs are supported. The fbintf package provides the Firebird API in a format where all data types for SQL data, interface parameters and results are native Pascal types, including all parameter blocks and database information. The Pascal API is pitched at a similar level and purpose to the IBPP Firebird API provided to the C++ world. It is a required dependency for version 2 onwards of IBX for Lazarus, and is provided as both a standalone package and as part of IBX2.
The Firebird Pascal API is intended to be simple to use and to place the minimum burden on the API user when it comes to managing the Firebird client library and the various Pascal objects that are created to provide the API. It is implemented as reference counted COM interfaces which, for the API user, are as easy to use as other managed types such as AnsiStrings and dynamic arrays. The user only needs to worry about accessing and using the interface; disposing of interfaces is performed automatically whenever an interface goes out of scope. It is intended to be a full implementation of the Firebird API, including events, services, blobs and arrays.
It is distributed under the IDP Licence.
The package may be downloaded from https://www.mwasoftware.co.uk/fb-pascal-api
A comprehensive user manual fully describing the API is available from https://www.mwasoftware.co.uk/documentation
IBSurgeon has released the complete trial kit for Firebird encryption, which includes fully functional time-limited AES256 encryption plugin and demo application (in Delphi) to demonstrate how to connect to the encrypted database.
The trial kit is designed for the following:
1) Easy performance testing of the existing databases with the encryption: you can encrypt database on the server and test your existing applications without changing them.
2) Implement client-side security: there is a simple example of Delphi application (sources included) which demonstrates how to send the key from the client to the server.
Download Firebird encryption plugin and example of a client application.
LibreOffice 5.3 is coming soon – it’s due to be released in early February. What have the developers been working on?
Find out in new contributor interview, with Tamás Bunth:
Ransomware attacks became the serious problem for many companies: during the last week, we had 3 incidents from different customers which had their Firebird databases encrypted by ransomware viruses. Luckily we were able to help all of them, but the scale of the problem definitely increases.
SQL Security clause part of SQL Standard (2003, 2011) Feature is implemented in Firebird master git tree.