Firebird News

Monday, December 20, 2010

News for week 12 - 19 December 2010 : Boolean landing , ibphoenix redesign

The best news seems to be boolean landing in the trunk.
Ibphoenix does have a new face for holidays.
Driver for Django 1.2.x is quite usable these days , this is why firebirdsql.ro works with the latest stable django .
We will have full reference (that means full docs) at the end of winter
Trace support landed in the .dot net driver
Php 5.3.4 is released with the firebird driver enabled (for pdo too) but only for the Visual C++ 9 builds
If you like the firebirdsql console (isql-fb) then there is the add command to interactively insert records/blobs
There is a fixed bug for trunk Fixed the crash about NEXT VALUE FOR reported in fb-devel
Port forward fix for bug CORE-3119 : 100% CPU USAGE with Unilimited Loop & Index corrupted

Wednesday, January 06, 2010

Firebird Weekly News #33

This is the list of firebird related news from week 2 January 2010 - 9 January 2010

Firebird Roadmap for 2009 and the reality : At the end of the year 2009 we see what Firebird development plans were and what is the reality.
Django meets Firebird: Nice blog post about firebird and django.
Philippe Makowski wrote a nice article comparing the performance of Firebird database on different linux file systems.



Firebird Interesting Source Patches and Commits in this week

asfernandes committed 9fa0ccd Thu, 7 Jan 2010 00:16:43 +0000:Feature CORE-832 - Parameterized exceptions
asfernandes committed a60936e Wed, 6 Jan 2010 22:38:20 +0000:Misc
hvlad committed d22e381 Wed, 6 Jan 2010 17:38:54 +0000:Cleanup : remove tree of dirty pages in favor of list based implementation.
dimitr committed a914924 Wed, 6 Jan 2010 15:40:39 +0000:Implement the lazy caching mode. Rows are stored in the buffer while fetching forward. The switch to the fully cached mode is performed upon the first positioned access.
dimitr committed d679186 Wed, 6 Jan 2010 14:16:21 +0000:Fixed the sorting.
robocop committed 248fadb Wed, 6 Jan 2010 12:53:23 +0000:I want to be able to pass const input params.
dimitr committed 2551d2a Wed, 6 Jan 2010 09:32:21 +0000:Added the missing public entrypoint.
asfernandes committed 2c0b883 Tue, 5 Jan 2010 17:32:39 +0000:1) Refactor the EXCEPTION statement 2) Cleanup DSQL nod_abort
robocop committed 95cd4ec Tue, 5 Jan 2010 04:10:25 +0000:Commenting unused sym_type values.
robocop committed a3811b5 Tue, 5 Jan 2010 04:08:46 +0000:Probably this completes Dmitry Sibiryakov's fix.
robocop committed f793ca8 Tue, 5 Jan 2010 04:07:55 +0000:Misc.
aafemt committed ecc92bc Mon, 4 Jan 2010 21:53:24 +0000:Fix BOF on truncation of reference action
hvlad committed 1d49a82 Mon, 4 Jan 2010 09:05:16 +0000:Make RELEASE build compilable
dimitr committed 7312db1 Mon, 4 Jan 2010 07:57:29 +0000:Added the missing license.
dimitr committed 087da87 Mon, 4 Jan 2010 07:54:26 +0000:Simplified the code a bit more (removed the redundant processing).
robocop committed c8313be Mon, 4 Jan 2010 05:09:38 +0000:Misc.
asfernandes committed 798cac7 Mon, 4 Jan 2010 00:43:44 +0000:Misc
asfernandes committed afba8cf Mon, 4 Jan 2010 00:43:41 +0000:Misc
asfernandes committed e03111d Sun, 3 Jan 2010 20:56:37 +0000:Support for new types and support for getters in ResultSet
asfernandes committed 59f89c7 Sun, 3 Jan 2010 18:23:22 +0000:Always use the dialect 3 for system SQL queries
asfernandes committed ec5734b Sun, 3 Jan 2010 15:21:13 +0000:The easy fix to the dialect problem
robocop committed dfb6d00 Sun, 3 Jan 2010 12:43:40 +0000:Show me the backup level when restoring with verbose option.
robocop committed fca10b3 Sun, 3 Jan 2010 10:46:37 +0000:Put more strings into the msg db.
dimitr committed 682f543 Sun, 3 Jan 2010 10:33:21 +0000:Small refactoring (code simplification).
robocop committed b1e392d Sun, 3 Jan 2010 03:45:01 +0000:Finally use the same logic to detect ODS capabilities in backup and restore.
asfernandes committed 33256c1 Sun, 3 Jan 2010 00:19:13 +0000:Some syntactic sugar
asfernandes committed bcd7ac0 Sat, 2 Jan 2010 23:29:32 +0000:Convert an uncached GDML query to equivalent SQL with PreparedStatement
asfernandes committed aac237b Sat, 2 Jan 2010 21:46:11 +0000:Tweaks to PreparedStatement::Builder and support for output parameters (without "demo" code yet)
asfernandes committed 96b1f3e Sat, 2 Jan 2010 21:34:39 +0000:Fix segmentation fault running tcs SVC_API_SWEEP_DB
robocop committed 179e773 Sat, 2 Jan 2010 09:38:40 +0000:Put more strings into the msg db.
robocop committed ed20886 Sat, 2 Jan 2010 06:19:50 +0000:Advancing towards the same logic to detect ODS capabilities in backup and restore.
robocop committed 32d7bb5 Sat, 2 Jan 2010 06:16:06 +0000:Misc.
robocop committed fed57ea Sat, 2 Jan 2010 02:22:25 +0000:Advancing towards the same logic to detect ODS capabilities in backup and restore.
robocop committed 844d20a Sat, 2 Jan 2010 02:02:12 +0000:Style.

Firebird Weekly News #32

This is the list of firebird related news from week 26 December 2009 - 2 January 2010
FBNews is back ;-) seems that The big increase in the website visitors extrapolated (for the first time) it's bandwidth limit.

Firebird 2.5 rc1 package is now uploaded to debian experimental.

Firebird Interesting Source Patches and Commits in this week

The author of change aac237b was asfernandes Sat, 2 Jan 2010 21:46:11 +0000, The title was:Tweaks to PreparedStatement::Builder and support for output parameters (without "demo" code yet)
The author of change 96b1f3e was asfernandes Sat, 2 Jan 2010 21:34:39 +0000, The title was:Fix segmentation fault running tcs SVC_API_SWEEP_DB
The author of change 179e773 was robocop Sat, 2 Jan 2010 09:38:40 +0000, The title was:Put more strings into the msg db.
The author of change ed20886 was robocop Sat, 2 Jan 2010 06:19:50 +0000, The title was:Advancing towards the same logic to detect ODS capabilities in backup and restore.
The author of change 32d7bb5 was robocop Sat, 2 Jan 2010 06:16:06 +0000, The title was:Misc.
The author of change fed57ea was robocop Sat, 2 Jan 2010 02:22:25 +0000, The title was:Advancing towards the same logic to detect ODS capabilities in backup and restore.
The author of change 844d20a was robocop Sat, 2 Jan 2010 02:02:12 +0000, The title was:Style.
The author of change 7862bb4 was asfernandes Fri, 1 Jan 2010 20:23:47 +0000, The title was:Misc
The author of change 42b6ffe was asfernandes Fri, 1 Jan 2010 18:45:27 +0000, The title was:Misc
The author of change 2b42452 was asfernandes Fri, 1 Jan 2010 18:39:39 +0000, The title was:Do not pass -RAW to GPRE in the build, to facilitate the analyse of generated files
The author of change 2b83948 was asfernandes Fri, 1 Jan 2010 18:10:31 +0000, The title was:Remove the noisy of msgs.h when new messages are added
The author of change 26460cf was robocop Fri, 1 Jan 2010 09:53:40 +0000, The title was:Set ODS8 (IB4.0) as the minimum requirement to backup a db. Establish previous enhancements (belonging to older ODS versions) as always present, then clean the code. Added two messages, too.
The author of change 34d925a was asfernandes Fri, 1 Jan 2010 03:00:25 +0000, The title was:Simplification
The author of change 077db07 was asfernandes Thu, 31 Dec 2009 17:08:04 +0000, The title was:A new way to use PreparedStatement. That one preserves code readability and is very like the preprocessed code.
The author of change 5fa150e was asfernandes Thu, 31 Dec 2009 14:58:12 +0000, The title was:1) Write the function return type as domain, like the parameters. 2) Fix storeGlobalField to always store RDB.
The author of change 3700654 was asfernandes Thu, 31 Dec 2009 11:24:22 +0000, The title was:Make referencing and execution (try) of unimplemented packaged routines work correctly
The author of change aac2ba7 was robocop Thu, 31 Dec 2009 09:07:59 +0000, The title was:Silence these two warnings for now.
The author of change 6352c25 was alexpeshkoff Wed, 30 Dec 2009 15:24:12 +0000, The title was:Introduce isc_dpb_version2 - format is WideTagged.
The author of change 5f8fa34 was alexpeshkoff Wed, 30 Dec 2009 15:16:32 +0000, The title was:removed wrong assertion
The author of change 080c985 was asfernandes Wed, 30 Dec 2009 14:50:17 +0000, The title was:Try to collect function signatures like procedures. Not good yet.
The author of change f6a9091 was alexpeshkoff Wed, 30 Dec 2009 12:55:50 +0000, The title was:Removed a number of unused and suspicious functions
The author of change 805a342 was robocop Wed, 30 Dec 2009 04:24:31 +0000, The title was:Misc.
The author of change 461aa5e was asfernandes Wed, 30 Dec 2009 01:40:38 +0000, The title was:Unify even more procedure and function handling. While at it, fix a wrong access to req_procedure when validating function.
The author of change 3681496 was asfernandes Wed, 30 Dec 2009 00:50:34 +0000, The title was:Misc
The author of change 855a7ef was asfernandes Tue, 29 Dec 2009 15:27:53 +0000, The title was:Fixes and completions for packages
The author of change d313dee was robocop Tue, 29 Dec 2009 12:56:09 +0000, The title was:Comment unused items.
The author of change 1a457b6 was hvlad Tue, 29 Dec 2009 12:46:53 +0000, The title was:All memory allocations should be ALLOC_ALLIGMENT aligned. It fixed bug in Win64 DEBUG build.
The author of change d437012 was robocop Tue, 29 Dec 2009 11:32:57 +0000, The title was:Misc.
The author of change 4c2df7c was dimitr Tue, 29 Dec 2009 10:54:08 +0000, The title was:Support the -D switch on Windows.
The author of change 38e02c1 was robocop Tue, 29 Dec 2009 09:07:08 +0000, The title was:Nicer fix for isql v/s v3 schemas.
The author of change d7c2125 was robocop Tue, 29 Dec 2009 08:42:32 +0000, The title was:Support Dmitry's new system fields in backup/restore. Isql is still missing the needed pieces.
The author of change b3ff3ee was robocop Tue, 29 Dec 2009 07:08:56 +0000, The title was:Misc.
The author of change 650aafa was asfernandes Mon, 28 Dec 2009 22:18:40 +0000, The title was:Support for named parameters for PreparedStatement using C++ variables
The author of change 03794a1 was asfernandes Mon, 28 Dec 2009 15:31:08 +0000, The title was:Store the view context type when it doesn't came from backup and simplify the code. Still problems altering procedures used in views.
The author of change b0398c2 was dimitr Mon, 28 Dec 2009 13:25:11 +0000, The title was:Cleanup the deprecated configuration stuff.
The author of change 5d58e2a was robocop Mon, 28 Dec 2009 11:59:36 +0000, The title was:Prevent isql from creating a db when we want to create a schema or worse, that it drops a db when we want to drop a schema. Of course, in the new ODS 12. Probably the change should be backported to avoid disasters with FB2.5 isql working with FB3.0 server.
The author of change f9bd426 was robocop Mon, 28 Dec 2009 11:54:49 +0000, The title was:Change this confusing ROWCOUNT feature to MAXROWS (there's also COUNT) but the old name is accepted for compatibility with FB2.5.
The author of change a002cac was robocop Mon, 28 Dec 2009 11:46:52 +0000, The title was:Misc.
The author of change a88e45b was asfernandes Mon, 28 Dec 2009 10:21:51 +0000, The title was:Misc
The author of change eeedc64 was hvlad Mon, 28 Dec 2009 09:34:17 +0000, The title was:More detailed statistics : fragments, big records and blobs info are now available when records analisys is performed.
The author of change 4637b39 was hvlad Mon, 28 Dec 2009 09:11:20 +0000, The title was:Swept flag implementation. A little optimisation of mark_full() - don't call it if not necessary, don't mark PP if its flags already matched to DP flags.
The author of change 0426cdf was hvlad Mon, 28 Dec 2009 09:08:31 +0000, The title was:Better name for FIRST_SCN_PAGE constant
The author of change e48a296 was robocop Mon, 28 Dec 2009 07:44:46 +0000, The title was:Temporary measure to compile until Adriano finds a better way.
The author of change c902969 was asfernandes Mon, 28 Dec 2009 01:06:35 +0000, The title was:Make packaged functions work
The author of change 767d481 was asfernandes Sun, 27 Dec 2009 22:05:15 +0000, The title was:1) Make procedures and functions member of the same hierarchy (Routine class) 2) Some completion for external functions
The author of change 0c4151f was asfernandes Sun, 27 Dec 2009 19:05:38 +0000, The title was:Consts
The author of change fe26e77 was asfernandes Sun, 27 Dec 2009 16:49:44 +0000, The title was:Misc
The author of change 6891657 was asfernandes Sun, 27 Dec 2009 16:49:23 +0000, The title was:Fix another problem in cursor handling changes
The author of change 34ef450 was asfernandes Sat, 26 Dec 2009 22:06:22 +0000, The title was:Transform two GDML STORE statements that run on database creation time to DSQL statements and preload DSQL cache objects to make that possible
The author of change 1c5acb0 was robocop Sat, 26 Dec 2009 13:24:37 +0000, The title was:More appropriate name.
The author of change aa557ec was robocop Sat, 26 Dec 2009 13:23:29 +0000, The title was:Check.
The author of change 8825a6a was robocop Sat, 26 Dec 2009 13:22:52 +0000, The title was:Totally misc.
The author of change cd99a13 was asfernandes Sat, 26 Dec 2009 02:21:56 +0000, The title was:Fix problem of mixing dbkey and record version on the same internal parameter