Firebird News

Firebird 3 Beta 1 tagged

October 14, 2014 Cantu 2 comments

The source code of Firebird 3.0 Beta 1 is now tagged, meaning that we can expect the beta 1 release to be available very soon.

(7 votes, average: 5.00 out of 5)

Compiling IBASE sql driver for Qt 5.3 on openSUSE 13.1

October 13, 2014 mariuz Leave a comment

For this howto you will need to have firebird development package already installed on the system and also Qt 5.3.

(2 votes, average: 4.00 out of 5)

ANN: CopyCat Developer 3.07.0

October 9, 2014 jonneve Leave a comment

Microtec is pleased to announce a new release of our database replication engine, CopyCat Developer !

CopyCat Developer is a set of Delphi / C++Builder components providing customizable replication for Firebird, Interbase, Microsoft SQL Server, MySQL, NexusDB, SQLite, PostgreSQL and Oracle, including heteogenous replication between different database types.

Have a look at our site for more information : http://www.copycat.fr

This new release includes the following improvements:

[See remaining text…]

* PostgreSQL support

* Oracle support

* TCcConfig
– Raise error if ConfigName property is set while connection is open.
– Fixed bug that caused incorrect priority numbers to be inserted into RPL$TABLES
– Automatically grant full rights to system tables created by CopyCat for all users
– New ConnectAndRemoveConfig method allows to totally remove all CopyCat triggers and system tables from the database. This can be particularly useful when upgrading from an old version of CopyCat, so as to ensure that the tables are created correctly and up-to-date.

* TCcConnection : On databases that support quoted meta-data, we now always quote all meta-data identifiers (table names, field names, etc), which means that if any reserverd words or spaces are used in the names, it causes no trouble during replication.

* TCcReplicator
– Replication log counters (line number and total number of rows to replicate) are now cleared correctly after a call to AbortReplication or a connection loss (previously, they would be reset only on new connection).
– Fixed bug causing null values in ftWideString and ftWideMemo fields to get changed to ” (empty string) during replication.
– Fixed a bug causing the AutoReplicate property to be disabled after a lost connection
– For Firebird / Interbase dialect 1 databases (which do not support quoted meta-data), fields using reserved keywords as names are excluded from replication.

* SQLite : Fixed bug in SQLite adaptor causing dates to be parsed wrong when using FireDAC connector in recent Delphi versions

* Transport layer :
– Improved error reporting with clearer error message when connection gets dropped.
– Improved parameter type detection of null parameters, particularly useful when dealing with SQLite.

* XMLRPC Transport : Fixed bug that caused an access violation when using Delphi XE.

* FireDAC connector : Improved parameter datatype detection when replicating with FireDAC connector, solving issues with “Data type unknown” errors, particularly when replicating to or from SQLite.

* DataSnap Transport :
– Support for blob fields
– Various bugfixes

« Hide it

(1 votes, average: 5.00 out of 5)

New Firebird interface (cloop) – Cross Language Object Oriented Programming

October 7, 2014 mariuz Leave a comment

Adriano wrote on Firebird-devel and twitter :

I put in my github account the first version of cloop – Cross Language
Object Oriented Programming.
– https://github.com/asfernandes/cloop

This first version is limited to void and int datatypes, supports C, C++
and Free Pascal, and the makefile works only in POSIX.

Some files in src/tests/test1 are autogenerated. They are flag as this
in their first line.

Tests consists of three (one for each language) executable and three
libraries as well.

The executable is the consumer test part and receives a parameter with
the library name of the supplier test part, so we can test any
combination of C/C++/Pascal as consumer/supplier. Examples:

./output/debug/bin/test1-pascal output/debug/bin/test1-pascal.so
./output/debug/bin/test1-c output/debug/bin/test1-pascal.so
./output/debug/bin/test1-cpp output/debug/bin/test1-pascal.so

./output/debug/bin/test1-cpp output/debug/bin/test1-c.so

(7 votes, average: 5.00 out of 5)

Mini-interviews with speakers Firebird Conference 2014 speakers roundup

October 7, 2014 mariuz Leave a comment

Alexey Kovyazin wrote on linkedin Firebird group :

We started series of mini-interviews with Firebird Conference 2014 speakers:
Ann Harrison: http://www.firebirdsql.org/en/news/mini-interview-with-ann-w-harrison-53224/
Paul Reeves: http://www.firebirdsql.org/en/news/mini-interview-with-paul-reeves-53229/
Mark Rotteveel: http://www.firebirdsql.org/en/news/mini-interview-about-firebird-conference-2014-with-mark-rotteveel-53233/

Stay tuned for more interviews!
Don’t miss the last chance to register at Firebird event of the year: Prague, October 24-25: http://www.firebirdsql.org/en/firebird-conference-2014/

(2 votes, average: 5.00 out of 5)

Mini-interview about Firebird Conference 2014 with Mark Rotteveel

October 3, 2014 mariuz Leave a comment

Today’s guest is Mark Rotteveel, developer of JayBird, Firebird JDBC driver, and speaker at Firebird Conference 2014.

(1 votes, average: 5.00 out of 5)

Q/A : Why does Firebird truncate decimal places when dividing?

October 3, 2014 mariuz Leave a comment

Firebird truncates decimal places when dividing, rather than rounding. Furthermore, it bases the number of decimal points in the returned value on the number of decimal places in the numerator and denominator.

Why is Firebird truncating instead of rounding? And why does it base the returned value on the number of decimal places in the query?

Here is the answer to the Question on StackOverflow

(2 votes, average: 5.00 out of 5)

FB TraceManager V3.5.2 has been released

October 1, 2014 tsteinmaurer Leave a comment

Upscene Productions is excited to officially release FB TraceManager V3.5.2!

This release adds UI docking capabilities, improved Firebird 3 support and fixes minor bugs.

More information is available here:
http://www.upscene.com/news/item/20140930

Feel free to check out the following V3.5 demo video

More information on the product is available in the FB TraceManager section on our website, including an edition comparison sheet, webcasts etc.:
http://www.upscene.com/fb_tracemanager/

Thanks for your continued support.

(3 votes, average: 5.00 out of 5)

ANN: CopyCat LiveMirror 1.3

October 1, 2014 jonneve Leave a comment

I am pleased to announce that CopyCat LiveMirror 1.3 is officially available!

CopyCat LiveMirror is our database mirroring and backup tool, designed to make it trivial to setup a one-way replication between two Firebird databases, so that you can easily have a reliable, up-to-date backup at your fingertips, at all times. Please refer to our product page for more information

Changes in this release :

* Various core changes and minor bug fixes.
* Fixed bug saving database configuration data.
* Fixed bug causing errors with wide string fields in some situations.
* Improved log viewer window so that it’s responsive even when holding a large log file.
* Added an error reporting module allowing for more detailed error messages and bug reports.
* Fixed bug causing automatic replication to stop after database connection loss. In such a case, LiveMirror will now continue trying to reestablish a connection every time replication fires.
* LiveMirror now excludes fields with errorneous field names (DATE, TYPE, USER, etc) that were allowed in older versions of Firebird and can still be present in some databases.
* Automatically grant full rights to all users for RPL$ system tables created by LiveMirror, so that there will be no error when inserting into RPL$LOG through the triggers when a user makes changes to the database.

(1 votes, average: 5.00 out of 5)

Interview with the author of Sqitch (database change management application)

September 29, 2014 mariuz Leave a comment

As you might now Ștefan Suciu created a Firebird port for Sqitch

Bellow is a interview with the author of Sqitch : David Wheeler with a few Firebird mentions

ps: There is a GUI for Sqitch – Simple SQL change management created by Stefan

https://github.com/stefansbv/sqitch-gui

(1 votes, average: 5.00 out of 5)

« 1 … 120 121 122 123 124 … 485 »