Jaybird 4.0.0-beta-1 available for testing

The first beta for Jaybird 4 is available for testing.

We’d really appreciate it if you take the time to test this version of Jaybird with your applications. Bug reports about undocumented changes in behavior are appreciated. Feedback can be sent to the Firebird-java mailing list or reported on the issue tracker http://tracker.firebirdsql.org/browse/JDBC.

Jaybird 4 is – compared to Jaybird 3 – an incremental release that builds on the foundations of Jaybird 3. The focus of this release has been on further improving JDBC support and adding support for the new data types and features of Firebird 4.

The main new features are:

  • Wire encryption support (backported to Jaybird 3.0.4)
  • Database encryption support (backported to Jaybird 3.0.4)
  • Authentication plugin improvements
  • Firebird 4 DECFLOAT support
  • Firebird 4 extended numeric precision support
  • Firebird 4 time zone support
  • JDBC RowId support
  • JDBC DatabaseMetaData.getPseudoColumns implemented
  • JDBC DatabaseMetaData.getVersionColumns implemented
  • Improved JDBC function escape support
  • New JDBC protocol prefix jdbc:firebird:
  • Generated keys support improvements

Jaybird 4.0.0-beta-1 is for testing purposes only, and not intended for production use.

See also:

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

How to track deadlocks in firebird

As you probably know, Firebird Conference 2019 will include the practical workshops, and the article “How to track deadlocks in Firebird” is one of the sneaks peeks of the workshop “All About Transactions”, which will be done by Vlad Khorsun, Firebird core developer, and Alexey Kovyazin from IBSurgeon.

To help developers investigate the update conflicts (deadlocks), Firebird puts into error messages the reference to the concurrent transaction – i.e., the transaction where the concurrent update is not yet committed. Together with Trace API, it gives us the ability to track both conflicting operations.

Let’s consider the practical steps on how to do it: read the article “How to track deadlocks in Firebird“.

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

IBProvider News. Support For Visual Studio 2019

Hello All!

In latest update of our components, we offer support for Visual Studio 2019, which was released a week ago:

  1. New DDEX providers (v1.12) for our ADO.NET provider (FW4.5, FW4.6.2, FW4.7.2) and VS2019. The installation instruction is the same as for Visual Studio 2017.
  2. IBProvider v5.3.1 compiled by VS2019 (signature of binaries – vc16)

IBProvider vc16 builds (32/64bit) have gone through load testing, so you can start using them in your solutions without any problems.

This news at our web site: https://www.ibprovider.com/eng/news/n_190411-vs2019.html

Thanks&Regards. IBProvider Team.

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

New article: Fast conversion from Firebird 2.5 to 3.0 with streamed backup-restore

If you need to convert a very big Firebird 2.5 database to 3.0, or many databases during the short period of time (for example, overnight or during the weekend), you will definitely find useful this article: it describes how to speed up the backup-restore process by 25-30% with stream backup-restore process. 
Please read  Fast conversion of Firebird 2.5 databases to Firebird 3.0

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

Daily Export Firebird data to AWS Aurora

Bipost Sync new release! A tool design to daily export FirebirdSQL data to AWS S3 and Aurora-MySQL. New features include:

  • Tenant: an option to send data from multiple Firebird databases and consolidate on a single AWS Aurora-MySQL database.
  • Firebird 3.x support.
  • Send data from new engines (Sybase SQL Anywhere).

Contact information: info@factorbi.com MX: +521 (55) 7656-4690 US: +1 (646) 504-7812

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

Jason Wharton is the new elected President of the Firebird Foundation

News via LinkedIn :

I’m grateful to announce that I was recently elected to be the President of the Firebird Foundation!

For me this is a great honor and privilege as I have been heavily involved with Firebird SQL ever since its very beginnings. I even played a significant role in the events leading up to the open sourcing of InterBase.

This database is on a solid foundation! If we really get the attention we deserve, and attract some additional talent to add to our dedicated team of developers, it will be amazing to see what we continue to accomplish over the years.

I would especially like to begin reaching out to companies who would be open to becoming sponsors of our ongoing development.

I welcome contact from large corporations looking to improve their bottom-line by adopting Firebird in their embedded devices and everything in between, all the way up to mid-ranged muti-terrabyte datastores.

Firebird’s versatility and light footprint and low maintenance make it a must-have database tool for the industry today.

Jason Wharton

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

DB Explorer For Firebird Databases

Explore and run queries against your Firebird® databases without leaving VS Code. This extension allows you to connect directly to your Firebird databases, list tables and fields, run queries, display/export results and more.

Features

NEW! SQL Mock Data Generator
Manage multiple database connections
List hosts, databases, tables and fields inside Explorer View
Firebird Reserved Words Code Completion
Table and field names Code Completion
Run Firebird SQL queries
Run predefined custom queries
View results in a table
Realtime results filtering and sorting
Export results to JSON, CSV, XSLX or PDF file

Find more here.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
1 2 3 4 439