Many developers think that transactions are straightforward and easy thing to understand and use, so probably there is no reason to devote 1 day seminar to discover transactions mechanism in Firebird in great details. Is it so?
Here I offer 3 simple questions about transactions which every Firebird developer should answer. Please take a look and choose the correct answer
Reminder from Alexey Kovyazin
As you probably know, November 22, 2013 in in Siegburg (Germany) there
will be Firebird seminar, devoted to all aspects of transactions, from
the basic idea to the internal implementation, about the best practices
and guidance how to effectively use transactions in the applications,
and, of course, performance analysis of transactions and related areas.
More details:
http://www.firebirdsql.org/en/firebird-conference-tour-2013/
Please feel free to ask any questions.
Ștefan Suciu announced his work on Implementing support for Firebird in Sqitch :
I’m workingto implement support for Firebird (in the firebird branch) in Sqitch – a database change management application.
Contributions are welcome! on Github
https://github.com/stefansbv/sqitch/tree/firebird
New GSOC update for the previous week with
current status of the firebird-sdbc driver :
Progress this week: - Some dbexception cleanup. - Fixed ColumnLocate::findColumn implementations (for all db drivers) and api definition. - Fixed index rebuilding. - Tried to experiment with different ICU versions, but haven't managed to actually produce any errors when switching ICU version - Fixed formatting of integers as a currency, integers now show as a number and not currency by default. - Fixed segfault when setting Null as first value in PreparedStatement. - Reintroduce statement specific Mutexes (instead of a connection-wide Mutex). - Implemented simple firebird unit tests to see that we can really transfer a .fdb between machines with different OS/CPU/bit-ness. - Some generic cleanups. - Tried to create a hsqldb cppunit-test.
From: Mateusz Loskot I'm very pleased to announce release of SOCI 3.2.2 which is mainly a bugfix release with some improvements and features too. The source packages are available for download from SF.net: https://sourceforge.net/projects/soci/files/soci/soci-3.2.2/ or directly from the Git repository in 3.2.2 tag: https://github.com/SOCI/soci/tree/3.2.2 By the way, all packages and tags are also available from automatically generated releases at GitHub (new feature): https://github.com/SOCI/soci/releases Documentation for the current 3.2 line is available at http://soci.sourceforge.net/doc.html Version 3.2.2 differs from 3.2.1 in the following ways: ... - Firebird -- Enable memory cleanup to avoid leaks after binding -- Added missing C++ library headers -- Added get_affected_rows() support for bulk operations -- Fixed compilation with VS2008 -- Fixed building tests with the backend built as DLL.
New GSOC update for the previous week with
current status of the firebird-sdbc driver :
Progress this week:
– Made libatomic-ops buildable meaning that we should now be able to build embedded firebird on non-X86 systems too
– Added rebuilding of indices to deal with the icu collation issues.
– Implemented a simple .odb loading test (in gerrit atm.) that also
tests that the embedded firebird .fdb can be connected to.
– Implemented Index retrieval and dropping
– More fixes to do with the firebird temporary and lock directories
– Some coverity fixes
– Started working on foreign key retrieval
Code commits can be reviewed in the LibreOffice git repository
NBackup via Services API is landed in DotNet FirebirdClient
The Lazarus team is glad to announce the release of Lazarus 1.0.12.
This is a bug fix release, built with the current Free Pasca Compiler 2.6.2.
Here is the list of changes for Lazarus and Free Pascal:
http://wiki.lazarus.freepascal.org/Lazarus_1.0_fixes_branch#Fixes_for_1.0.12_.28Merged.29
http://wiki.lazarus.freepascal.org/User_Changes_2.6.2
The release is available for download at SourceForge:
http://sourceforge.net/projects/lazarus/files/
Choose your CPU, OS, distro and then the “Lazarus 1.0.12″ directory.
Minimum requirements:
Windows: 98, 2k, XP, Vista, 7, 32 or 64bit
FreeBSD/Linux: gtk 2.8 or qt4.5, 32 or 64bit
Mac OS X: 10.5, LCL only 32bit, non LCL apps can be 64bit
New GSOC update for the previous week:
Current status of the firebird-sdbc driver is:
– (Var)Char, Numeric and Date/Time types all supported. (No support for blob/clob/array/etc. yet.)
– Data Editing in the GUI works.
– Data Insertion works.
– Table and Column definition/manipulation is mostly complete, there might still be a few minor-to-major issues, indexes aren’t supported at all.
– Usable on Linux, Mac, Windows (thanks to tml for fixing the fbembed
library / loading on Mac).
Editline is used in Firebird isql console client , the last version is already imported in firebird 3.0
https://github.com/asfernandes/firebird/tree/master/extern/editline
So it brings UTF-8 support at last in the console with a few patches
http://tracker.firebirdsql.org/browse/CORE-362
Thanks to Frank Schlottmann-Gödde for his efforts
ps:It’s history in Firebird tree is a little bit convoluted http://firebird.1100200.n4.nabble.com/firebird-devel-Editline-digging-into-not-just-cmdline-history-was-qmtesting-td1124010.html
