Technical articles, How-tos, guides, etc.
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
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
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
Mark Rotteveel wrote on Firebird Java list :
I have started a page on the Jaybird wiki on using Jaybird with Firebird
3.0 alpha 1:
http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=tip:firebird30a1
It lists know problems, compatibility issues and workarounds between
Jaybird 2.2.x and earlier and Firebird 3 (alpha 1).
It is a work in progress, but I hope to have all the basics listed by
Sunday. If you miss something, or something doesn’t work for you with
Firebird 3, let me know.
Mark
New GSOC update for the previous week : Plenty of mountains conquered this week, also some useful work done …
Also default dialect is now 3 for the Firebird SDBC driver
http://www.ahunt.org/2013/07/firebirds-dialects/
Changes to libreoffice and firebird driver can be seen in the git log
And here is announcement :
Firebird has now been integrated into LibreOffice master!
It now builds on Mac and Windows in addition to Linux. (I’ve only tested on Linux but will be testing/fixing as necessary on Mac/Windows this week.)
The database driver itself is almost unusable at the moment as I’ve been refactoring various things to do with transaction control and execution of statements. More and more functionality should be appearing in the course of this week, making the driver more usable .
Firebird .ODB
Paul Beach wrote on his blog :
Based on a document written by Fulvio, a while ago, I finally spent time writing a make file that will automatically create an embedded version of Firebird that will run on MacOSX as a bundle.
New Screencast with FB TraceManager from Thomas Steinmaurer
The transaction simulator uses either scripts or random commands to simulate the Firebird database versioning system and the result of the simulator are checked with Firebird’s outputs. Read committed and Snapshot transactions are presented. Some remarks about long transactions and Firebird slowdown caused by transactions
