General news Archives - Page 62 of 200

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

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

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>

Database .NET v19 and dbMigration .NET 3.5 released!

August 2, 2016 fishcodelib Leave a comment

Database .NET 19.0 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 18.9 to 19.0 (2016/08/03)

Added Grant Manager for Firebird (FB/Pro)
Added support for single-dimensional array and multi-dimensional arrays (FB)
Fixed the remote connection with a different account (FB)
Fixed issues with a monitor >=4K and >= 250%
Improved AutoComplete and IntelliSense
Improved Search Objects
Improved SQL Editor
Improved Data Editor and Browser
…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.5 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 from 3.2 to 3.5 (2016/08/03)

Added Global connection properties for Firebird (FB)
Added support for Firebird (Run as an Application) (FB)
Ability to add a remote connection for Firebird (FB)
Ability to automatically set charset (FB)
Ability to automatically fix client library for Firebird v3 Embedded Server (FB3)
…and more

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

Yii2-firebird 0.8.2 is released

August 2, 2016 mariuz Leave a comment

Yii2-firebird 0.8.2 is released with

Support to Yii2 2.0.9
Fixed batch insert with empty rows

Django-firebird with support for Django 1.8.x released

July 13, 2016 mariuz Leave a comment

Maximiliano Robaina wrote:

After a long time, I like to announce a new django-firebird release.
This version is compatible with django 1.8.x LTS.

Also there are a new version to django-firebird 1.7.1 with a minor bug fix (backported from 1.8 version)

v1.8.0
———–
+ First version with django 1.8.x support
+ Implement new UUIDField #54
+ Implement new DurationField #55
+ DatabaseOperations: repleace convert_values by get_db_converters #56
+ DatabaseIntrospection: get_relations implementation change in 1.8 #57
+ Introspection of boolean field type fail #58
+ Create new object with a time field fails if microseconds greater than 6 digit #60
+ django-firebird not working with non-default firebird port #62
+ Client db shell doesn’t work on non-default firebird port #63

Database .NET 18.8 released

July 4, 2016 fishcodelib Leave a comment

Database .NET 18.8 is an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data, Run queries and Migrate data with a consistent interface. (Full support for Firebird 1.5~3.0)

New features and improvements from 18.6 to 18.8 (2016/07/04)

Added Support for package’s procedures and functions (FB3)
Added Support for Firebird (Run as an Application) (FB)
Ability to automatically set charset (FB)
Ability to automatically fix client library for Firebird v3 Embedded Server (FB3)
Ability to specify Client Library path (FB)
Improved SQL History (FB)
Improved Query Builder (FB)
Improved Binding Procedure and Function parameters (FB)
Improved Transaction Mode (FB)
Improved Find In Grid (FB)
Improved AutoComplete and IntelliSense (FB)
…and more

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

Firebird SQL Stored procedures in .NET

June 28, 2016 mariuz Leave a comment

Jiří Činčura wrote on Firebird-devel : There’s something I’ve been working on for a few evenings and weekends.
As you might know, from Firebird 3 there’s and interface to write a
plugin that allows to execute any code as stored procedure, function or
trigger.

So why not to have these in .NET, right? I have a working plugin right
now. Currently only stored procedures are supported. No blobs at the
moment as well

« 1 … 60 61 62 63 64 … 200 »

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.