Firebird News

Database .NET 19.4 and dbMigration .NET 3.6 released!

September 11, 2016 fishcodelib Leave a comment

Database .NET 19.4 is an innovative, powerful and intuitive multiple database management tool. You can browse/grant objects, design tables, edit rows, run queries, generate scripts, analyze/monitor SQL and import/export/migrate/sync data with a consistent interface. (Full support for Firebird 1.5~3.0+)

New features and improvements from 19.1 to 19.4 (2016/09/12)

Updated to FirebirdSql.Data.FirebirdClient.dll 5.1.0.0
Added Managing User Permissions for Firebird (FB3)
Added Binding Function parameters for Firebird (FB)
Added Batch replacing cell values
Added Specifying the location of SQL files
Improved Grant Manager for Firebird (FB/Pro)
Improved Generating DDL and DML (FB)
Improved SQL History (FB)
…and more

For more information please visit http://fishcodelib.com/Database.htm
Free, All-In-One, Portable, Single executable file and Multi-language.

dbMigration .NET 3.6 is a simple, easy and intuitive multiple database migration and data synchronization tool, With it you can easily migrate schema and data between different databases without complicated procedures.

Supported databases: Firebird 1.5~3.0+, PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, HP Vertica, NuoDB, Teradata, Sybase ASE, SQLite, SQLCe, Access, dBase, FoxPro, Excel, ODBC, OLEDB, Text…etc.

New features and improvements (2016/09/12)

Updated to FirebirdSql.Data.FirebirdClient.dll 5.1.0.0
Massive performance improvements
Added Migrating VIEWS/PROCEDURES/FUNCTIONS/SEQUENCES/DOMAINS definitions) (FB)
Improved Command-Line
…and more

For more information please visit http://fishcodelib.com/DBMigration.htm
Free, All-In-One, Portable, and Single executable file.

(No Ratings Yet)

Are you prepared for Firebird 3?

September 9, 2016 Cantu Leave a comment

So, Firebird 3.0.1 is out, and you are planning to move to it. But are you prepared for this task? Migrating to previous versions was usually an easy task, but is this still true for Firebird 3.x? Answer the following questions to know if you are really prepared to move to Firebird 3!

1) Can I connect to a database created in Firebird 2.5, using Firebird 3?

[See remaining text...]

Yes, as it always happened in the previous versions!
Firebird 3 cannot access databases created in older versions of Firebird, so it is necessary to PUMP the data to an empty database created in Firebird 3.
Firebird 3 only access databases created with ODS = 12, so it is necessary to do a backup (gbak) before migrating to Firebird, and restore it in Firebird 3, to updated the ODS.
Yes, but first you need to run gfix with the new parameter -ods=12 to updated the ODS of the database.

2) Is it correctly to say that Firebird 3 finally solved the problem of someone stoling the database file and access all its data?

Of course, since now Firebird 3 comes with native database encryption!
Yes, if you enable encryption in the database file, the security is guaranteed!
Yes, if you create a good/safe encryption plugin, and take all precautions regarding dealing with the encryption key.
Unfortunately, there is no way to avoid the stolen database file to have its data accessed.

3) Regarding SYSDBA, we can say...

Firebird 3 doesn't even requires the existence of an user named SYSDBA.
SYSDBA needs to exists, since he is the Firebird's administrator.
The SYSDBA user is now called ADMIN.

4) What is the name of the Firebird executable on Windows?

It depends on the selected architecture.
Firebird.exe
For SuperServer, it is fbserver.exe. For Classic, it is named fb_inet_server.exe. For SuperClassic, it is fb_smp_server.exe
Firebird 3 doesn't has an executable anymore, only a DLL which is plugged directly to the Operating System as a service.

5) Regarding the enhancements in the Firebird's communication protocol, to make it more efficient in high latency networks, we can say:

In general, the data retrieved by selects will be transferred faster to the client.
In general, the data retrieved by selects will be transferred much faster to the client, unless you are transfering blobs.
Not only the selects, but insert, delete and update operations also became faster with the enhancements.
Better user text files for storage! Databases are devil stuff.

6) It is impossible to connect to a Firebird 3 server using and older client library (fbclient). This statement is:

Correct. Firebird 3 enhanced security forbids insecure connections from older client libraries.
Incorrect. Disabling the wire encryption and enabling the legacy authentication plugins, older fbclient will be able to connect to Firebird 3.
Incorrect. By default, older clients can connect to Firebird 3.
Correct, but Firebird 3 will accept the connection only if the user is member of the Firebird Foundation.

7) What about centralized users?

Firebird users are still centralized in the security database.
The Developer/DBA defines for each database file, if its users will be stored locally or not.
Firebird chooses automatically if the user being created will be stored locally or in the security database.
Nothing changed compared to the previous versions.

Wanna save some precious time when moving to Firebird 3?
Buy the Migration Guide to Firebird 3 book right now!
Available in digital and printed formats.

« Hide it

(6 votes, average: 4.33 out of 5)

Firebird 3.0.1 is coming

September 9, 2016 Cantu Leave a comment

The first maintenance release of the Firebird 3 series is planned to be released in this month (September/2016). Firebird 3.0.1 will bring several bug fixes and performance improvements.

(6 votes, average: 5.00 out of 5)

Database Workbench 5.2 released, includes PostgreSQL support

September 8, 2016 Martijn Tonies Leave a comment

Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:

” Database Workbench 5.2.0 “

This release includes new features and useful enhancements, including PostgreSQL support.

[See remaining text…]

The change logs for version 5.2.0 is available.

“There is so much new in Database Workbench 5, and the latest version includes the long awaited PostgreSQL support”, says Martijn Tonies, founder of Upscene Productions. “There’s new code editor features, diagramming improvements, multiple editions, fully HiDPI awareness, data compare tool, more complete visual query builder and much more.”

New features in version 5 include:

Support for PostgreSQL
Support for the latest versions of database engines including Firebird 3, SQL Anywhere 17, SQL Azure and MariaDB support
New and improved user interface
Code editor features like block staples, code folding, object linking and dynamic highlighting
“Diagram Navigator” for easier diagramming navigation
MySQL/MariaDB tunneling support
New tools, including a Data Compare tool
Basic and Pro Edition to suit your needs
and much more…

For more information, see What’s new in Database Workbench 5?

Database Workbench supports MySQL, MariaDB, PostgreSQL, Firebird, Oracle, MS SQL Server, SQL Azure, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools.

About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely on it
every day. From database design, implementation, to testing and debugging, it will aid you
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been providing
database developers with useful tools for over 14 years. Slowly expanding the product portfolio
and gaining recognition amongst InterBase and Firebird database developers, they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL Server.

« Hide it

(1 votes, average: 5.00 out of 5)

Summary for testing IBProvider with Firebird 2.5

September 8, 2016 Andrew Merkulov Leave a comment

Hello!

Since you already have made a pause in your work and came here, we are offering to you look at the short review of testing Firebird through IBProvider.

http://www.ibprovider.com/eng/news/n_160908.html

With Best Regards,
IBProvider Team

(No Ratings Yet)

Databases challenges

September 1, 2016 Cantu Leave a comment

ODBMS Industry Watch recently interviewed Jim Starkey about “Database Challenges and Innovations”. The complete interview can be seen here. Jim invented the MVCC (Multi Version Concurrency Control) model, which is used in Firebird, InterBase and Postgres RDBMS.

(No Ratings Yet)

Jaybird 3.0.0-alpha-1 release for testing

August 20, 2016 Mark Rotteveel Leave a comment

Jaybird 3.0.0-alpha-1 has been published for testing. We would really appreciate if you could start testing your applications with this version and provide feedback on stability and behavior, but also on the release notes.

Feedback can be sent to the Firebird-java mailinglist or on the issue tracker http://tracker.firebirdsql.org/browse/JDBC.

Jaybird 3.0 is a big change from Jaybird 2.2 and earlier. We have rewritten the entire low-level implementation to be able to support protocol improvements in newer Firebird versions, made changes with a stricter interpretation of the JDBC requirements, and removed some parts that were either obsolete or not functioning correctly.

We recommend that you do not consider Jaybird 3.0 a drop-in replacement for Jaybird 2.2, and study the release notes carefully.

See:

Release notes
Release files: Jaybird 3.0.0-alpha-1

Jaybird 3.0 Alpha 1 is available from Maven central:

Groupid: org.firebirdsql.jdbc,
Artifactid: jaybird-jdkXX (where XX is 17 or 18).
Version: 3.0.0-alpha-1

For example:

<dependency>
     <groupId>org.firebirdsql.jdbc</groupId>
     <artifactId>jaybird-jdk18</artifactId>
     <version>3.0.0-alpha-1</version>
</dependency>

If your application is deployed to a Java EE application server, you will need to exclude the javax.resource:connector-api dependency, and add it as a provided dependency:

<dependency>
     <groupId>org.firebirdsql.jdbc</groupId>
     <artifactId>jaybird-jdk18</artifactId>
     <version>3.0.0-alpha-1</version>
     <exclusions>
         <exclusion>
             <groupId>javax.resource</groupId>
             <artifactId>connector-api</artifactId>
         </exclusion>
     </exclusions>
</dependency>
<dependency>
     <groupId>javax.resource</groupId>
     <artifactId>connector-api</artifactId>
     <version>1.5</version>
     <scope>provided</scope>
</dependency>

If you want to use Type 2 support (native, local or embedded), you need to explicitly include JNA 4.2.2 as a dependency:

<dependency>
     <groupId>net.java.dev.jna</groupId>
     <artifactId>jna</artifactId>
     <version>4.2.2</version>
</dependency>

(2 votes, average: 5.00 out of 5)

Release of IBProvider v3.31

August 18, 2016 Andrew Merkulov Leave a comment

Hello All!

Six years after the release of IBProvider v3.0 in August 2010, we are proud to introduce version v3.31. This is the 72th update of the third version!

http://www.ibprovider.com/eng/news/n_160818.html

A brief description of the new release v3.31

Interaction with server has been optimized.
The problem with savepoints and InterBase has been solved.

The list of previous updates of the provider

http://www.ibprovider.com/eng/news.html

(No Ratings Yet)

13th Firebird Developers Days video

August 8, 2016 Cantu Leave a comment

Victory Fernandes published a video recorded at the 13th FDD, where he interviewed two conference speakers (Kelver Merlotti and me).

Audio is in portuguese.

(1 votes, average: 5.00 out of 5)

« 1 … 80 81 82 83 84 … 483 »

Wanna save some precious time when moving to Firebird 3?Buy the Migration Guide to Firebird 3 book right now!Available in digital and printed formats.

Wanna save some precious time when moving to Firebird 3?
Buy the Migration Guide to Firebird 3 book right now!
Available in digital and printed formats.