Resolving Firebird performance problems (presentation)
Presentation from Firebird Developers Day 2012 is online http://www.slideshare.net/ibsurgeon/resolving-firebird-performance-problems
Author: mariuz
http://wiki.ubuntu.com/Mariuz
Lazarus Free Pascal RAD IDE 1.0 RC1 is released
The Lazarus team is glad to announce that Lazarus 1.0RC is available for download .
Choose your CPU / OS / distro and then the 1.0RC1 directory and read the release notes
Jaybird code repository migrated to Subversion
News from Mark Rotteveel : The Jaybird code repository has been migrated from CVS to Subversion.
The code is now available from
https://svn.code.sf.net/p/firebird/code/client-java/
It can also be viewed from
https://sourceforge.net/p/firebird/code/HEAD/tree/client-java/
.
FBConfig 2.0 source code now moved to github.com
FBConfig 2.0 source code now moved to github.com with many modification to use Firebird SQL 2.5 features, check it please and test.
We can now say that the libfbclient 3.0 for #Android is running !
Firebird support for Solaris added to Free Pascal in svn trunk
Here is the bug fixed in Free Pascal 2.7.1 (svn)
South 0.7.6 released with Firebird minors fixes
Incorrectly linked libjaybird22.so and libjaybird22_64.so with Jaybird 2.2.0 on Linux (x86-32 and x86-64)
The libjaybird22.so (Linux x86) and libjaybird22_64.so (Linux x64)
included in the Jaybird 2.2.0 download are incorrectly linked (libstdc++
and libdl are missing from the symbol table).
This manifests itself when the native or embedded protocol is used
(jdbc:firebirdsql:native or jdbc:firebirdsql:embedded). The resulting
error is UnsatisfiedLinkError occurs in libjaybird22_x64.so undefined
symbol: _ZTVN10__cxxabiv117__class_type_infoE
This error does not occur on all systems (eg my Ubuntu 11.10 systems
with the OpenJDK-6 and OpenJDK-7 from the Ubuntu-repository don’t have
this error).
Correctly linked versions of libjaybird are attached to
http://tracker.firebirdsql.org/browse/JDBC-259
The next release of Jaybird will include correctly linked versions of
this library (release date is not yet known).
How to implement FROM_UNIXTIME() like function in Firebird
Here is the example explained in Spanish :
select dateadd(second, 1255033470, cast(’01/01/1970 00:00:00.0000′ as timestamp)) from rdb$database;