Real-time Firebird – Monitor for Firebird – Server 2.5 / 3.0 / 4.0
A new version is available V1.5.6.161
Visit our Homepage and download the Trialversion:
(1 votes, average: 5.00 out of 5)
Loading...Firebird External Table Generator (ext-table-gen) 1.0 released
I am happy to announce the release of “Firebird External Table Generator” (ext-table-gen for short).
“Firebird External Table Generator” is a commandline tool to transform RFC 4180 CSV files to Firebird external table files (a binary format for external table data).
External tables are a good way for bulk-loading data into Firebird. Unfortunately, external tables use a fixed-width binary format, and not (more) standard formats like CSV. It is not always easy to create an appropriate external table file, and this is where ext-table-gen can be used.
At a high level, ext-table-gen provides the following features:
- Derive a CHAR-based external table definition (i.e. a CREATE TABLE statement and a configuration for ext-table-gen) from a CSV file
- Transform a CSV file to an external table file (either based on the CSV file itself, or based on a configuration file)
The current version only supports CHAR columns, which makes the generated file essentially a fixed-width text format. Future versions may introduce support for additional column types.
You can find the 1.0 release at ext-table-gen v1.0.
Documentation and release notes can be found on https://mrotteveel.github.io/ext-table-gen/.
The project itself is hosted on https://github.com/mrotteveel/ext-table-gen.
(2 votes, average: 5.00 out of 5)Loading...IBProvider v5.30. DECFLOAT and improved connection pool [FB4]
Hello Everyone.
In the current release, we have continued expanding the support of Firebird v4.
https://www.ibprovider.com/eng/news/n_230620__fb4_step2.html
New features
- The full support of DECFLOAT(16) and DECFLOAT(34) has been implemented
- The new version of IBProvider supports the ICU v63 from FB4 kit
- Using «ALTER SESSION RESET» for resetting a connection before reusing (see this new example)
Kind Regards and Good Luck! IBProvider Team.
(No Ratings Yet)Loading...Firebird Dialect for SQLAlchemy 2.0 is Released
https://pypi.org/project/sqlalchemy-firebird/
Now using firebird-driver. Recommended for Firebird 3.0+.
The legacy fdb driver could still be used for Firebird 2.5.
Both SQLAlchemy 2.0 and 1.4 are supported.
(2 votes, average: 5.00 out of 5)Loading...Jaybird 5.0.2 released
We are happy to announce the release of Jaybird 5.0.2.
The following has been fixed since Jaybird 5.0.1:
- Fixed: Reconnect transaction with a transaction id exceeding 0x7FFF_FFFF did not work (jaybird#734)
- New feature: add connection property parallelWorkers to set Firebird 5.0 isc_dpb_parallel_workers (jaybird#737)
- New feature: add MaintenanceManager.upgradeOds() for the Firebird 5.0 gfix/service repair action to perform a minor ODS upgrade of a database (jaybird#738)
- New feature: add parallel workers support for BackupManager (jaybird#739)
- New feature: add parallel workers support for sweep in MaintenanceManager (jaybird#740)
- Fixed: DatabaseConnectionProperties.setServerBatchBufferSize(int) ignored provided value and always set default (0, or “use server-side maximum”) (jaybird#741)
- New feature: add MaintenanceManager.fixIcu() for the Firebird 3.0 gfix/service repair action “ICU” to update or rebuild collations and indexes when the ICU version changed (jaybird#744)
- Fixed: The first call to getTableStatistics() of a FBTableStatisticsManager instance returned only a few or even no tables; if no tables were returned, subsequent calls would also return no tables (jaybird#747)
Jaybird 5 supports Firebird 2.5 and higher, on Java 8, 11, 17 and 20 (support for Java 11 and higher using the Java 11 version of the driver).
See also:
(2 votes, average: 5.00 out of 5)Loading...IBProvider v5.29. The initial support of FB4
Hello All 🙂
The implementation of FB4 support requires time. That is why we decided to split this process into parts and make intermediate releases. It will allow you to begin using IBProvider with FB4 right now.
https://www.ibprovider.com/eng/news/n_230522__fb4_step1.html
The current support of FB4
- You can work with FB4 through fbclient.dll
- You can work with FB4 through a built-in client (dbclient_type=fb.direct). The 13th protocol will be used
- The long name of database objects are supported
- All the FB4 datatypes (including new datatypes: INT128, DECFLOAT, time/date with a time zone) are supported at the metadata layer
- The full support of INT128 and NUMERIC on base INT128 was implemented
- New initialization properties were added — int128_rules, numeric_i16_rules
Lots of functional and load tests were made with using FB v4.0.3.2937.
For mission-critical, multi-threaded and 24/7 applications, we highly recommend using the built-in client.
IBProvider Free does not support FB4.
Additional changes
- The support of DBTYPE_TIMESTAMPOFFSET was added
- The transformation between {DBTIME, DBTIME2} and {DATE, DBDATE, DBTIMESTAMP, FILETIME} was deleted
- The transformation of NUMERIC into VARIANT was improved
- The procession of charset names was corrected
With best regards, IBProvider Team.
(No Ratings Yet)Loading...Flamerobin 0.9.7 Snapshot released with a few Firebird 4 fixes
Flamerobin 0.9.7 Snapshot released with a few Firebird 4 fixes
- Int128 does not respect scale (Issue #166)
- Make Domain::dataTypeToString able to process fb4 types.
- fix some bugs converting int128/dec34/dec16 to string
- replace CMAKE_SOURCE_DIR to CMAKE_CURRENT_SOURCE_DIR when copy templates in CMakeList.txt by @Khalyutin in PR #310
(2 votes, average: 5.00 out of 5)Loading...Database Workbench 6.2.0 released
Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:
” Database Workbench 6.2.0″
This release brings support for the latest PostgreSQL versions, recognizes Firebird 5 beta, and brings new features in general.
One of the major changes is the new object selection box in the Object Editors: much faster on a large number of objects and it now includes a filter for easier usage.
Database Workbench 6 comes in 3 different editions with different pricing models, there’s always a version that suits you!
(2 votes, average: 5.00 out of 5)Loading...The release of IBProvider v5.28
Hello Everyone!
We are pleased to present this new release of our flagship product. During its development, a number of old problems were identified and solved. Also the internal structure was improved for the next stage of development.
https://www.ibprovider.com/eng/news/n_230424.html
List of changes
- The keyword list of FB v2.5.9 was corrected.
- The keyword list of FB v3.0.4+ was corrected.
- The definition of TIMESTAMP, TIME and DATE in PROVIDER_TYPES was corrected.
- [DirectFB] The support of protocols v10-v12 was corrected. It solves problems with FB3.
- [DirectFB] The support of protocol v13 was improved.
- [ISC API] The protection from negative length of CHAR/VARCHAR datatypes was added.
- The new initialization property «force_nulls» was added for conducting low-level tests.
- Lots of internal changes and improvements were made.
Testing
- Our primary test server for load tests is FB v3.11.
The current plans
- The primary direction of our work is the implementation of FB4 support.
With best regards, IBProvider Team.
(1 votes, average: 5.00 out of 5)Loading...Saturnin (a Firebird Butler Platform for Python) version 0.8.0 has been released, along with packages with core services and SDK.
Saturnin (a Firebird Butler Platform for Python) version 0.8.0 has been released, along with packages with core services and SDK.
Saturnin can now be considered as early beta. There will be more additions, extensions and improvements before the 1.0 release, but the platform is almost feature-complete, and the functionality provided is considered stable and ready for testing. However, some backwards incompatible changes in future releases are still possible.
(2 votes, average: 5.00 out of 5)Loading...