Firebird Weekly News #9

This is the list of firebird related news from week 18 July 2009 - 25 July 2009

Firebird Interesting Source Patches and Commits in this week

The author of change 420f9be was paulbeach, Fri, 24 Jul 2009 13:10:05 +0000 The title was:Missing symbols on MacOSX
The author of change 53c2c57 was alexpeshkoff, Fri, 24 Jul 2009 13:01:13 +0000 The title was:Fixed CORE-2572: Locks of type LCK_page_space processed incorrectly
The author of change fb41b85 was asfernandes, Fri, 24 Jul 2009 02:15:06 +0000 The title was:Misc
The author of change 4ee050b was alexpeshkoff, Thu, 23 Jul 2009 08:58:21 +0000 The title was:HPUX port by Bill Oliver and Jerry Adair
The author of change 5be758d was asfernandes, Thu, 23 Jul 2009 00:56:15 +0000 The title was:Misc
The author of change 8f6c89c was alexpeshkoff, Wed, 22 Jul 2009 13:43:31 +0000 The title was:This fixes bugs with blob_filter in my recent commit and at the same time should be compileable on SUn Studio. Thanks to Dmitry Yemanov.
The author of change beb2687 was alexpeshkoff, Wed, 22 Jul 2009 06:36:33 +0000 The title was:fixed "make clean" after my changes
The author of change 2cca27b was paulbeach, Tue, 21 Jul 2009 14:18:34 +0000 The title was:And the long march to making Firebird build and run on MacOSX continues
The author of change 0d57de5 was paulbeach, Tue, 21 Jul 2009 13:59:43 +0000 The title was:And the long march to making Firebird build and run on MacOSX continues
The author of change 46ed3b4 was alexpeshkoff, Tue, 21 Jul 2009 13:55:33 +0000 The title was:Fixed build for systems with old glibc
The author of change 8bafd5f was alexpeshkoff, Tue, 21 Jul 2009 13:39:57 +0000 The title was:Applied Dan's patch to start port for s390 - primarily to reserve CLASS and IMPLEMENTATION
The author of change fa64ad4 was paulbeach, Tue, 21 Jul 2009 13:34:19 +0000 The title was:And the long march to making Firebird build and run on MacOSX continues
The author of change 1de288b was alexpeshkoff, Tue, 21 Jul 2009 13:00:53 +0000 The title was:Applied sligtly modified patch from Dan Horak to use system libread
The author of change ef37c35 was alexpeshkoff, Tue, 21 Jul 2009 11:51:27 +0000 The title was:Use more standard macro
The author of change 98284fe was alexpeshkoff, Tue, 21 Jul 2009 11:02:30 +0000 The title was:Updated startup script from Philippe Makowski
The author of change d64b512 was alexpeshkoff, Tue, 21 Jul 2009 10:01:18 +0000 The title was:Deeper handler for ENOTSUP in mutex_init - avoid any attributes, potentially known to cause it
The author of change 05922f2 was robocop, Tue, 21 Jul 2009 09:46:09 +0000 The title was:Misc.
The author of change 08f263f was robocop, Tue, 21 Jul 2009 08:59:16 +0000 The title was:Typo.
The author of change 6e0ffe9 was alexpeshkoff, Tue, 21 Jul 2009 08:58:22 +0000 The title was:Solaris 9 patch from SAS
The author of change 9afca9f was alexpeshkoff, Tue, 21 Jul 2009 07:48:21 +0000 The title was:Style
The author of change 7bcd023 was alexpeshkoff, Tue, 21 Jul 2009 07:45:20 +0000 The title was:We have no more gds_drop, but we do have fbtracemgr
The author of change 6b7d5d2 was dimitr, Mon, 20 Jul 2009 20:47:53 +0000 The title was:More docs.
The author of change 1cd1fba was dimitr, Mon, 20 Jul 2009 19:20:31 +0000 The title was:Fixed the service restart option issue reported by Gabor Boros in fb-devel.
The author of change f66ae1b was dimitr, Mon, 20 Jul 2009 15:52:25 +0000 The title was:Re-scheduled this ticket for RC1.
The author of change 0884f0b was asfernandes, Mon, 20 Jul 2009 15:46:44 +0000 The title was:Fixed CORE-915 - ISQL extract procedures body with double line break
The author of change 041b7a8 was dimitr, Mon, 20 Jul 2009 14:34:57 +0000 The title was:Update.
The author of change 904dd01 was dimitr, Mon, 20 Jul 2009 14:05:39 +0000 The title was:Fixed two issues for the case of non-authorized op_connect_request: 1) Missing error reporting which makes the client to stall forever 2) CORE-2563: Possible DoS attack using the malformed packet sent into the connection port
The author of change 8e6d608 was alexpeshkoff, Mon, 20 Jul 2009 13:44:02 +0000 The title was:Fixed CORE-2564: alignment error on risc machines
The author of change 5aae95e was hvlad, Mon, 20 Jul 2009 12:59:16 +0000 The title was:Correct a typo, noted by Claudio.
The author of change ab2cf07 was robocop, Mon, 20 Jul 2009 12:44:11 +0000 The title was:Misc (obsolete utilities)
The author of change 425d356 was asfernandes, Sun, 19 Jul 2009 17:33:51 +0000 The title was:Fixed CORE-2561 - Incorrect database name transliteration when connecting using WNET or XNET
The author of change 4885d9e was robocop, Sun, 19 Jul 2009 16:00:59 +0000 The title was:Typo :-)
The author of change 7d9bad4 was hvlad, Sun, 19 Jul 2009 13:55:19 +0000 The title was:Update usage text to include required connection parameters
The author of change 2d8b43e was robocop, Sun, 19 Jul 2009 13:31:01 +0000 The title was:Misc and constants.
The author of change b67d9bd was robocop, Sat, 18 Jul 2009 12:39:15 +0000 The title was:Style.
The author of change c12f9fa was robocop, Sat, 18 Jul 2009 12:13:21 +0000 The title was:Switches changed to SvcSwitches to allow code that resembles other utilities (needed also for impending commit after 2.5).

Firebird Weekly News #8

This is the list of firebird related news from week 11 July 2009 - 18 July 2009

Firebird Interesting Source Patches and Commits in this week 





The author of change 7b5cd2b was robocop, Fri, 17 Jul 2009 17:13:24 +0000 The title was:The original message about FP overflow was not very useful for built-in functions (unlike other msgs, it didn't identify the cause). Made a special message for it. Also, one alice (gfix) help item was put erroneously by IB engineers in system_errors.sql; delete it.
The author of change 4ced331 was robocop, Fri, 17 Jul 2009 17:03:02 +0000 The title was:Seems more readable to me.
The author of change 6297f2b was robocop, Fri, 17 Jul 2009 09:29:44 +0000 The title was:The flags field is SINT64, not ULONG (upgrade it). "switches" changed to "flags" in tdr.cpp to allow code that resembles other utilities (need also for impending commit after 2.5).
The author of change 04d29ce was robocop, Fri, 17 Jul 2009 09:03:14 +0000 The title was:Misc.
The author of change 59d0d89 was robocop, Fri, 17 Jul 2009 09:02:38 +0000 The title was:Comments and use MAX_SQL_IDENTIFIER_SIZE.
The author of change ccb57ea was robocop, Fri, 17 Jul 2009 09:01:15 +0000 The title was:Warnings.
The author of change 10476c5 was robocop, Fri, 17 Jul 2009 08:57:11 +0000 The title was:Misc.
The author of change d94694a was robocop, Fri, 17 Jul 2009 08:56:35 +0000 The title was:Style.
The author of change 8c270fc was asfernandes, Thu, 16 Jul 2009 15:08:38 +0000 The title was:Warning
The author of change 466fc19 was asfernandes, Thu, 16 Jul 2009 13:09:00 +0000 The title was:Do not return isc_no_cur as warning, as it's an error - thanks to Dmitry
The author of change 8829910 was asfernandes, Wed, 15 Jul 2009 20:18:03 +0000 The title was:1) Fix abort when converting dbkeys to strings with not capable lengths 2) Fix storage of malformed bytes when converting from dbkeys to non-octets strings
The author of change 98f1615 was asfernandes, Wed, 15 Jul 2009 20:03:28 +0000 The title was:Misc
The author of change c88b4ec was asfernandes, Wed, 15 Jul 2009 19:45:57 +0000 The title was:Misc
The author of change 0af2be6 was hvlad, Wed, 15 Jul 2009 15:28:04 +0000 The title was:Fixed bug in my prevoius commit.
The author of change f7006b0 was alexpeshkoff, Wed, 15 Jul 2009 09:31:41 +0000 The title was:One more wrong comparison - thanks to Adriano
The author of change f1b5395 was asfernandes, Wed, 15 Jul 2009 03:13:13 +0000 The title was:Misc
The author of change 813cbb7 was asfernandes, Wed, 15 Jul 2009 00:25:35 +0000 The title was:Fix another similar problem of CORE-2552. Now successfull_completion has wrong in the fetch API, when that warning is posted. Alex: please verify if ERR_warning could be removed. It's not used anymore.
The author of change ce17b38 was asfernandes, Tue, 14 Jul 2009 18:52:53 +0000 The title was:Fixed problem reported by Dmitry Kovalenko in fb-devel
The author of change 6c3316f was asfernandes, Tue, 14 Jul 2009 15:51:41 +0000 The title was:Misc
The author of change ae1b780 was asfernandes, Tue, 14 Jul 2009 15:49:35 +0000 The title was:Fixed CORE-2552 - isc_dsql_execute2 does not return errors when called with a non-NULL output SQLDA
The author of change 0658d2a was robocop, Tue, 14 Jul 2009 14:29:30 +0000 The title was:Totally misc.
The author of change a2f58d6 was robocop, Tue, 14 Jul 2009 14:24:45 +0000 The title was:It seems more readable English to me.
The author of change 4217ba3 was dimitr, Tue, 14 Jul 2009 12:23:31 +0000 The title was:Totally misc.
The author of change b6aede2 was alexpeshkoff, Tue, 14 Jul 2009 11:34:46 +0000 The title was:This hack caused by bug in glibc should help have same binaries for RT-enabled and not linux kernels
The author of change a0621ac was robocop, Tue, 14 Jul 2009 09:08:53 +0000 The title was:Follow Dmitry's cleanup.
The author of change 8644d56 was alexpeshkoff, Tue, 14 Jul 2009 08:58:08 +0000 The title was:Fixed conversion from dbkey to string - thanks to Adriano
The author of change 86a581c was alexpeshkoff, Tue, 14 Jul 2009 08:24:59 +0000 The title was:Fixed comparison sign - thanks to Claudio
The author of change 4607e59 was dimitr, Tue, 14 Jul 2009 06:14:56 +0000 The title was:Update.
The author of change bd74967 was dimitr, Tue, 14 Jul 2009 05:31:05 +0000 The title was:Cleanup.
The author of change 64dbc64 was robocop, Tue, 14 Jul 2009 04:20:42 +0000 The title was:Fix the MSVC builds after Dmitry's cleanup.
The author of change 6a21641 was asfernandes, Tue, 14 Jul 2009 01:18:12 +0000 The title was:Misc
The author of change 090ec6b was dimitr, Mon, 13 Jul 2009 19:45:08 +0000 The title was:1) Let the collation existence locks respect the database shutdown. In particular, let's distinguish between "releasing" and "destroying" the lock. 2) Explicitly invalidate and release the cached system requests.
The author of change 8755eda was asfernandes, Mon, 13 Jul 2009 19:21:56 +0000 The title was:Allow conversion of system filenames resulting in more than MAX_PATH bytes. Let the callers and others complaim, as they already do.
The author of change ed40545 was dimitr, Mon, 13 Jul 2009 15:40:32 +0000 The title was:Let's not throw any shutdown related errors when rescheduling happens during the detaching (rare but possible case).
The author of change 76d50d7 was asfernandes, Mon, 13 Jul 2009 15:26:37 +0000 The title was:Fixed the problem with trusted authentication
The author of change c4fc97e was dimitr, Mon, 13 Jul 2009 15:19:26 +0000 The title was:Totally misc.
The author of change 6837f80 was dimitr, Mon, 13 Jul 2009 15:18:57 +0000 The title was:1) Complete the Alex's changes for CORE-2526 (Windows part). 2) Cleanup the license, help and settings parts of the server properties window (they're unused for a long time already). 3) Misc changes.
The author of change 49d868c was dimitr, Mon, 13 Jul 2009 15:15:07 +0000 The title was:Similar cleanup for the guardian.
The author of change aaa05cf was dimitr, Mon, 13 Jul 2009 15:13:23 +0000 The title was:Deleted the unnecessary files.
The author of change 2750977 was dimitr, Mon, 13 Jul 2009 15:09:58 +0000 The title was:1) Complete the Alex's changes for CORE-2526 (Windows part). 2) Cleanup the license, help and settings parts of the server properties window (they're unused for a long time already). 3) Misc changes.
The author of change edea677 was alexpeshkoff, Mon, 13 Jul 2009 12:09:37 +0000 The title was:Fixed CORE-2526: Server can be shut down disregarding services' connections
The author of change 6bc9059 was robocop, Mon, 13 Jul 2009 10:00:41 +0000 The title was:Misc.
The author of change fc7cbab was hvlad, Sun, 12 Jul 2009 17:37:55 +0000 The title was:Disable "parent redirect" feature and allocate memory for child pool from parent pool instead. It will improve speed of "deallocate by pool" mechanism for child pools (primary DSQL and CMP pools). Regression (slowdown) was reported by Gabor Boros in fb-devel.
The author of change 6b04b4d was robocop, Sun, 12 Jul 2009 12:39:45 +0000 The title was:Change minimal option length from S[SUSPEND] to SU[SPEND] in trace manager with Vlad's agreement.
The author of change 9a2b577 was robocop, Sun, 12 Jul 2009 12:12:04 +0000 The title was:Get rid of variable shadowing.
The author of change 2869751 was dimitr, Sun, 12 Jul 2009 10:24:10 +0000 The title was:Update.
The author of change 26d9ade was dimitr, Sun, 12 Jul 2009 10:16:14 +0000 The title was:Fixed CORE-1971: Set the fixed and documented check order for WHERE clause and other conditional sentences. The order of evaluation is now always from left to right.
The author of change 3d4fad9 was asfernandes, Sat, 11 Jul 2009 20:05:55 +0000 The title was:Update for CORE-2551 and note for CORE-2398
The author of change 1deed50 was asfernandes, Sat, 11 Jul 2009 19:58:26 +0000 The title was:Improvement CORE-2551 - Interpret DPB items as now the database name parameter is interpreted and change MON$ filenames fields from NONE to UNICODE_FSS.
The author of change c6d2145 was asfernandes, Sat, 11 Jul 2009 19:03:09 +0000 The title was:Fix warnings
The author of change e3fd4fb was dimitr, Sat, 11 Jul 2009 12:24:00 +0000 The title was:Update.
The author of change 79ba046 was asfernandes, Sat, 11 Jul 2009 03:01:18 +0000 The title was:Misc

Firebird Weekly News #7

This is the list of firebird related news from week 04 July 2009 - 11 July 2009

Firebird Interesting Source Patches and Commits in this week 





The author of c877315 was asfernandes, Fri, 10 Jul 2009 15:14:07
The title was Increase the "probe stack" test to 128K, as there may be > 64K local variables (like DatabaseSnapshot::DumpRecord).
The author of 47a7b4b was alexpeshkoff, Fri, 10 Jul 2009 12:31:12
The title was Fixed CORE-2518: Can no longer connect to database when using isc_dpb_num_buffers parameter, Make SS ignore it silently
The author of 707f97d was alexpeshkoff, Fri, 10 Jul 2009 11:43:21
The title was Cleanup - overflow_handler() is not needed cause now we use class FpeControl for that purpose
The author of c5bbbd3 was alexpeshkoff, Fri, 10 Jul 2009 07:52:56
The title was Fixed gbak logic when using -TRUSTED switch - thanks to Claudio
The author of a73a202 was asfernandes, Thu, 9 Jul 2009 17:30:29
The title was Initialize xcc struct. After its creation, things may go wrong and then cleanup_comm access not initialized members.
The author of e386d4d was alexpeshkoff, Thu, 9 Jul 2009 14:04:39
The title was Fixed CORE-2550: Bus error when working with DB_KEY on bigendian machines. Introduced dtype_dbkey inside engine.
The author of fdd05ad was robocop, Wed, 8 Jul 2009 01:15:01
The title was booleans.
The author of f2c1795 was robocop, Tue, 7 Jul 2009 10:25:42
The title was CORE 2540: Utilities need a more coherent way to show help and version Now all utilities react to -z for version and -? for help (qli was left for another time) CORE-2541: Too many
hardcoded messages in nbackup (done partially)
The author of 2e076e3 was robocop, Tue, 7 Jul 2009 08:50:26
The title was Leave xdr and friends in peace for now.
The author of 1771a2c was robocop, Tue, 7 Jul 2009 07:21:34
The title was Undo some particular cases of signed/unsigned conversions.
The author of 68244a6 was dimitr, Tue, 7 Jul 2009 05:17:55
The title was Fixed my yesterday's commit.
The author of e920bd8 was asfernandes, Mon, 6 Jul 2009 15:29:12
The title was 1) Move some StringBase methods to AbstractString, so AbstractString could be used
to mean PathNames or strings 2) Change ISC_escape / ISC_unescape accordingly 3) Fix bug in ISC_systemToUtf8 and ISC_utf8ToSystem when str is empty
The author of 7556525 was robocop, Mon, 6 Jul 2009 10:43:46
The title was Isolate more scrollable cursors code.
The author of fe5ceb0 was dimitr, Mon, 6 Jul 2009 09:19:26
The title was Front-ported my recent rework of the monitoring stuff.
The author of 9cd2fcc was robocop, Mon, 6 Jul 2009 07:32:05
The title was Delete debris of copy-paste from gbak. :-)
The author of db2fa45 was robocop, Sun, 5 Jul 2009 10:12:06
The title was Ged rid of a lot of reinterpret_cast cases.
The author of 170af1b was asfernandes, Sun, 5 Jul 2009 00:48:36
The title was Fixed CORE-2538 - PSQL doesnt allow to use singleton query result as input parameter of stored procedure when procedure accessed using 'execute procedure'
The author of 67ed33a was asfernandes, Sun, 5 Jul 2009 00:25:07
The title was Fix scope problem in DEV_BUILD



.:(firebird):..:(databases):..:(sql):.

Firebird Weekly News #6

This is the list of firebird related news from week 28 June 2009 - 04 July 2009






Firebird Interesting Source Patches and Commits in this week 






The author of 10aa7ed was robocop, Fri Jul 3 12:59:55 2009 +0000
The title was Style.

The author of 059f8c8 was robocop, Fri Jul 3 10:57:17 2009 +0000
The title was Style.

The author of 74237ae was dimitr, Tue Jun 30 12:29:58 2009 +0000
The title was Updated the MSVC9 build.

The author of 7e4a7cc was hvlad, Sun Jun 28 20:43:05 2009 +0000
The title was Fixed bug CORE-2532 : Incorrect size of volumes in multi volume database

The author of ade7b32 was robocop, Sun Jun 28 10:26:22 2009 +0000
The title was Style.


.:(firebird):..:(databases):..:(sql):.

Firebird Weekly News #5

This is the list of firebird related news from week 21-28 June

Firebird and FirebirdClient used in IBM’s AppScan Standard Edition. Read more.
Pave Cisar is happy to announce the public release of PowerConsole v0.7.5 and
Firebird Pack for PowerConsole v0.9.1.
Embarcadero officialy announces participation on FDD.
Firebird positive feedback from customers.
Firebird V2.1.3 Release Candidate 1 is available for testing.
Firebird Centos prerelease repository announced on Philippe Makowski’s blog (firebird 2.1.3 rc1).
Do you want a faster communication protocol for Firebird? Please vote for this feature.
Local protocol and multi-core processors and interesting situations with gbak.
Howto add job-event based plugin to Pentaho Data Integration (PDI), aka Kettle.
New php 5.2.10 firebird repository for CentOS announced.
PHP 5.3.0 RC4 repository for centos, fedora announced with firebird support.
New features in Entity Framework v4 and Firebird.

Firebird Interesting Source Patches and Commits:
MONDAY JUNE 22 2009
robocop committed 4d6d428 , d67d46e
Isolate even more the scrollable cursors-related code.
TUESDAY JUNE 23 2009
robocop committed 0bc6559
fixed CORE-1411 and CORE-1412.
WEDNESDAY JUNE 24 2009
hvlad committed 90808fa
Fixed bug CORE-2268 : GFIX causes BUGCHECK errors with non valid transaction numbers.
hvlad committed 8423160
Fixed bug CORE-2523 : gfix reports "unknown ISC error 0" in some cases.
hvlad committed b3c3c6d , 03d1f16
New feature 2524 : Command line utility to work with Trace Service.

THURSDAY JUNE 25 2009
asfernandes committed 1f8f19f
Add fbtracemgr to POSIX builds.
robocop committed be7d835
CORE-756 and CORE-2528.
robocop committed 3b45dd2
Convert goto into a for() loop.
robocop committed e0f3749
Some paranoid checks.
robocop committed 545d857
Apply the same trick as in evl.cpp for scrollable cursors' conditional code.
robocop committed ef02be0
I'm putting this strange assertion because I bet this code will never be called.
hvlad committed df5facb
Replace hard-coded array with isc_info_svc_timeout by correct endianess code.

FRIDAY JUNE 26 2009
robocop committed 8580b59
Moved DEFAULT_CLASS to constants.h;
SATURDAY JUNE 27 2009
robocop committed cdd2669
Avoid variableshadowing.
dimitr committed ed111c8
Fixed CORE-2462: 2.5 beta 1 has huge, fast-growing log files.So the bird was saved


SUNDAY JUNE 28 2009
hvlad committed 7e4a7cc
Fixed bug CORE-2532 : Incorrect size of volumes in multi volume database





.:(firebird):..:(databases):..:(sql):.

Firebird Weekly News #4

This is the list of firebird related news from week 14-21 June

Slackware 12.2 and firebird user introduction on LQ.
Firebird ODBC Acrobat and JavaScript question of the day.
Firebird 2.1.2 is included in OpenSUSE 10.3.
Here is an interview with Vlad Khorsun, done for the Brazilian ActiveDelphi Magazine.
New poll at FirebirdNews.org .We have a new poll running on the site. Vote now (look at the sidebar).
Dmitry Kuzmenko wrote on his own blog What is sort? Part 1 and 2 articles
Prism9’s HelixGL Accounting System – powered by Firebird.
mojoPortal 2.3.0.8 Released
Tunnelling a Firebird Backup with SSH.
Hugues Van Landeghem reports that DevGems DataModeler supports Firebird.

Open Source Delphi based ERP with Firebird.

Firebird Interesting Source Patches and Commits:

WEDNESDAY JUNE 17 2009
robocop committed b764edb
Use our common code to deal with NaN and Infinity.
committed 4d14694
Fix CORE-2505: beware of built-in functions returning NaN and Inf. Some functions were added, but they are called from the debugger only because they aren't exposed through DSQL.
asfernandes committed 0c145b0
Make the VC++ Express build not show a popup everytime setenv.bat is called - one time is enough

THURSDAY JUNE 18 2009
robocop committed 0eef56c
CORE-2509. Took the opportunity to fix several data types.
asfernandes committed c3cab2d
Fix build
FRIDAY JUNE 19 2009
asfernandes committed 5a01b8b
Put apples and oranges in different baskets
aafemt committed 60280f3
Fix parsing of constructions like /*/ and /**/*
dimitr committed 4ad2806
Fixed some issues with the optimizer, namely: (1) incorrect cost calculation for indexed retrievals in joins and (2) too pessimistic heuristics for indices with zero selectivity.
paulbeach committed e6fafc0
O_DIRECT and MacOSX problem (lack of)
hvlad committed 79ae46e
Initialize variables before it could be used.
paulbeach committed 1629d25
O_DIRECT and MacOSX problem (lack of) - better ifdefs (I hope)

asfernandes committed 04d9688
Revert this change. HEAD was fine.

asfernandes committed 76a3d7a
Fixed CORE-2516 - Wrong processing SP parameters with arrays

SUNDAY JUNE 21 2009
robocop committed 664ebab
Give idx_id and associated values a consistent data type and treatment.
robocop committed 83a57c6
Validations (do not crash).
hvlad committed 651528d
Fixed bug CORE-2519 : GSTAT output is incorrect for tables with more than 2 billion records

.:(firebird):..:(databases):..:(sql):.

Firebird Weekly News #3

This is the firebird related news from week 7-14 June
News around firebird world:
Firebird django backend call for testing help and progress.
Firebird 2.1.2 included in SourceMage Linux.
Flamerobin 0.9.2 packages into Fedora Linux and epel repository
Fedora 11 released with Firebird included in the main repository

New IBProvider version with enhanced Firebird 2.5 support
About FB support in Delphi Weaver
How to Query the Firebird Fisheye
Firebird: Deal with Unavailable Database
Firebird DTP Plugin for Eclipse released

Firebird Source Patches and Commits:
Fix CORE-2370: SQL Plan greater than 2048 characters is not printed at all in ISQL.
This is the client side fix. Server-side fixes will follow.
We should be careful to not upset FB2.1 and before.
New messages to fix CORE-2505: beware of built-in functions returning NaN and Inf. Code will follow in one day.
Better input type for SQZ_decompress plus a bit of style
Apply Alex/Bill/Jerry/me patch re. portability in redefinition of operator new
Sign extension problem, thanks Bill Oliver.
Update logic for ininf() in POSIX and use macro isnan instead of _isnan in Windows.
Update to-do a tad.
Locking something in AST turns out to be a bad idea. Let's use a "dirty read" approach and honestly return the "unknown" state for a not initialized backup manager (quite rare situation in practice).
The third incarnation of the monitoring internals. I'm not happy to commit such big changes into the point release, but this is the only solution for the AST signal safety issues in POSIX (see CORE-2483).
The change consists of a few parts

Remove unneeded reference to isc_ipc, since this file is not needed to build gpre_boot
In 3.0 binreloc should be turned on

Opportunist developer sees the place to constify the code.
:-)
Undo huge and not friendly fix for Sun compiler. Missed file
Patch by DS and VKh to speed up SQZ in some cases
Avoid sign extension problems in CVT
Much more easy way to please Sun compiler and not touch anything more
isc_ipc usage cleanup

Though we do not actively use signals since 2.5, let's better initialize paths before setting handlers

Rename function as agreed with Alex and Dmitry.

Don't be strictive with compiler warnings

Reworked class Semaphore:

1. Mach semaphores on Darwin.
2. No more local SysV semaphores.
3. Fixed bugs in conditional var based semaphore.
4. Moved big methods from .h to .cpp file.

Mac port - use correct full name for libib_util

Fix CORE-2501: bin_shl and bin_shr shouldn't accept negative shifts.

Put bad_port_context() in alphabetical order and created a little helper, send_error().

Use PORT_FILE for port file lock - thanks to Claudio

Make initialization distributed - each subsystem does what it needs when needs, removed gds.cpp:init()

Backport improvement CORE-1171: make floating point's exponential format the same across platforms.

After asking Alex, he confirms that calling fb_shutdown_callback in isql is for everything except WIN_NT (make code equivalent to previous versions).

Improvement CORE-1171: make floating point's exponential format the same across platforms.

Declare exported functions correctly - thanks to Paul Beach

Robocop added Paranoid checks in server.cpp

Slightly improve the retry loops in inet.cpp. Let's give up as soon as the call fails with any unexpected error.

CORE-2263: RemoteAuxPort for SuperClassic and regular Classic.
This change also fixes the possible races in SuperServer (possible after getting rid of the global mutex in the remote subsystem).

robocop is Minimizing casts (reinterpret_cast).

Fixed use of monitoring tables in on disconnect trigger, make pool for DatabaseSnapshot independent

.:(firebird):..:(databases):..:(sql):.

Firebird Weekly News #2

This is the firebird related news from week 1-7 June
News around firebird world:
phpBB “quite furry” 3.0.5 released
Under the Firebird umbrella - site updates
Lazarus and Firebird Embedded tutorial on Windows 32 bits
Embarcadero Tools and FB , news from Delphi Day Italy

Here is an interview with Jim Davis, SAS Institute SVP and Chief Marketing Officer.

Firebird Source Patches and Commits:
Improvement CORE-2498 - Make a single attachment usabe by more than one simultaneous threads in embedded

Fixed CORE-2499 - Implementation limit of DISTINCT items are not enforced, causing generation of incorrect BLR
Backported changes extending range of usable auto* tools

What is new and fixed in Version 2.1.x

Backport fix for bug CORE-2348 : More problems with transaction numbers overflowing 32-bit signed integer and corrupting database

Backport sub-task CORE-1647 : Close external table's file even if it used by some cached (inactive) requests.
It also fixed bug CORE-2475 : External table data not visible to other sessions in Classic.

Backport fix for bug CORE-2416 : AV preparing a query with aggregate over derived table

Minor cleanup by robocop

Dimitry Added timeouts to the network event listener code.
Fixed wrong usage of SO_REUSEADDR on Windows.

Alex Fixed Sun compiler warnings

Fixed CORE-2483: Database permanent pool may get corrupted when working with monitoring tables.

Better way to compile utilities/ntrace/os/*/platform.cpp for different platforms

Alex Fixed SYSV semaphores + const correctness + cleanup

Code simplification by robocop (claudio)

This is already a Windows file, no need to check for the WIN_NT macro.

Alex Fixed posix build

Firebird Weekly News #1

This is the firebird related news from 25-31 May Week

News around firebird world:
Firebird Romanian community had an small booth and tequila/beer meeting at eliberatica.ro event
I was in the middle of ubuntu.ro/fedoraproject.ro people also one suseromania.ro guy also I want to mention www.rosedu.org and softwareliber.ro.

Here are the picture with faces and names on it



Music/Book/Movie Label uses Firebird
Preparing for 6th FDD - Firebird Developers Day
Firebird Maestro 9.5 released

FirebirdConfig 0.2.0.34 released
Change Manager from Embarcadero will add Firebird support (at last)
Firebird Python PowerConsole 0.7 is released

Flamerobin will switch from subversion to git
Flamerobin Blob Editor on the way

Nice Requests and Bugs:
Ability to rename a table

Firebird Source Patches and Commits:
Make engine create lock files in /tmp/firebird

Lock files location should not be affected by value of TMP environment variable
Do not overload placement new operator. That is not valid accordingly to C++ standard.
Robocop fixed the VC9 project files.
Feature CORE-2470 - Support for alternate format of strings literals but on Firebird-Architect there was an long thread about it .
Added possibility to user inform external routines body , Made external routines entrypoint optional.
Fixed issue with two-phase procedure store and DDL triggers
HVlad Fixed MSVC8 build
Firebird Use COMMONAPPDATA folder on Windows for shared memory files placement (lock table, even table, etc).
Alex Peshkoff worked on Solaris port, related cleanup
Let's not crash while internally disconnecting a Classic process after a database shutdown.
Fix AV in trace when UNICODE collation is not found - thanks to Alex
Multi Threaded safe floating point exceptions control. Raise error in case of FP overflow according to SQL standard requirements.
Alex Peshkoff fixed warnings in AIX port.
Better error reporting. Also, don't block the requester in the case of error.
More fixes for bug CORE-2444 : make remapping of shared memory work correctly.
Fixed CORE-2482: Monitoring tables data collection is unstable when attaching or detaching database.

.:(firebird):..:(databases):..:(sql):.

Firebird issues with ruby on centos - ruby: symbol lookup error

Here is the thread , it looks familar to me

.:(firebird):..:(databases):..:(sql):.

firebird driver for ruby updated to 0.6

you can see the latest fixes for ruby 1.9 and version is now at 0.6 in the gem.spec

seems that you can install directly from github with gem (see the gem ruby icon in the right )

http://github.com/wishdev/fb/tree/master

.:(firebird):..:(databases):..:(sql):.

databene benerator - added support for firebird

The new freshmeat website is now at version 3.0 and in the new clean interface you can read about this new

tool databene benerator

.:(firebird):..:(databases):..:(sql):.

The true story of Blob on reddit

You can read the true story of blob on reddit also an good thing is to vote if you have an account

Jim Starkey showed me the movie that inspired his boss

in requesting the Blob inside the RDBMS

.:(firebird):..:(databases):..:(sql):.

Redhat/Fedora port in progress for Firebird

Here is the bug with Firebird Port in progress for Fedora/Redhat

.:(firebird):..:(databases):..:(sql):.

Installing Firebird on FreeBSD - FFAP (Firebird Apache Php)

By far the easiest way to install Firebird is via a package, or the ports tree.
When people in the FreeBSD community get a package running on FreeBSD, they often submit how they did it as a 'port', back to FreeBSD.
( This saves you working out what configure scripts to change, which make to use (make, gmake, bmake, aimk, etc) )

So we'll follow the road they've already blazed. Of course, feel free to download the source tarball, and get it building yourself, but it could take a while...


If you can't find a pre-compiled binary package on FreeBSD.org, firebirdsql.org, or ibphoenix.com, sync up your ports tree.
(Building it yourself ensure's it's built using optimisations for the processor you're running, too)


once ports tree is updated, do:


code:

---

cd /usr/ports/databases/firebird2-server
make install

---

Once this is finished, all dependencies are installed, the database is installed, the startup scripts are in place, the firebird user is added, and we're ready to go.

As the comment at the end of the install process suggests, we should change the password of the sysdba user, so lets do that now.

Starting Firebird
This involves running

code:

---

/usr/local/etc/rc.d/000.firebird.sh start
killall -HUP inetd

---

Or, simply reboot

Setting up Firebird's SYSDBA User

code:

---

cd /usr/local/firebird
./bin/gsec -user SYSDBA -pass masterkey
( the ./bin/ is required if you haven't got /usr/local/firebird/bin in your path )
GSEC> modify SYSDBA -pw

( We might add a user while we're here )
GSEC> add testuser -pw testuser

( Now quit out )
GSEC> quit

---

Done. Now we're ready for databases. the Firebird runs as the user firebird, thusly needs read/write permissions to a directory to store the databases.
I usually make one called '/usr/db':

code:

---

mkdir /usr/db
chown firebird /usr/db
chgrp firebird /usr/db
chown 770 /usr/db

---

There we have a nice, secure little home for our databases.
This directory isn't created by the install,as people will always want their databases stored in a different place, on a different HDD controller, etc.

Lets make a database

using your favourite editor, start a file in your home directory called 'fire1.sql', and in it, put the following:

code:

---

CREATE DATABASE "localhost:/usr/db/fire1.gdb".
COMMIT.

CREATE TABLE tbl_test1(
str_name VARCHAR(100) NOT NULL,
str_phone VARCHAR(20),
PRIMARY KEY(str_name)
).

---

Then save, and exit the file

Now, well create the database
( It may pay to put '/usr/local/firebird/bin' in your path, to save using the full path to the binaries every time )

code:

---

isql -u testuser -p testuser <>
Logging in for the very first time
Lets log in, and have a look. Run:

isql -u testuser -p testuser localhost:/usr/db/fire1.gdb

Database: localhost:/usr/db/fire1.gdb, User: testuser
SQL>

You're in! Lets see what's inside:
( Note. Put a semi-colon at the end of every command. It's the terminator at the moment )


SQL> show tables;
TBL_TEST1
SQL>

Let see how that table's made up:
SQL> show table tbl_test1;
STR_NAME VARCHAR(200) Not Null
STR_PHONE VARCHAR(20) Nullable
CONSTRAINT INTEG_2:
Primary key (STR_NAME)
SQL >

Lovely! put some data in
SQL> insert into tbl_test1 (str_name, str_phone)
CON> values ('henry','12345678');
SQL>

( Note the 'CON>' appears while a statement is continuing )

Let's select everything in the table
SQL> select * from tbl_test1;
STR_NAME STR_PHONE
===== ===
henry 12345678

Lets put some more in
SQL> insert into tbl_test1 (str_name, str_phone)
CON> values ('jane','87654321');
SQL>

Select all
SQL> select * from tbl_test1;
STR_NAME STR_PHONE
==== ========
henry 12345678
jane 87654321

Select henry
select * from tbl_test1 where str_name = 'henry';

select people starting with 'h'
select * from tbl_test where str_name like 'h%';

select the first record
select first 1 * from tbl_test1;

select 1 record, but skip 1
select first 1 skip 1 * from tbl_test1;

select any records with the letter 'e' in them
select * from tbl_test1 where str_name containing 'e';

As you can see, the SQL is very similar to other databases.

Next we will instal the apache to FAP (Firebird,Apache, Php)

portsnap fetch
portsnap extract
Installing apache 2.2
cd /usr/ports/www/apache22/
make install clean

Installing php extension
cd /usr/ports/lang/php5
make install clean
cd /usr/ports/lang/php5-extensions
make install clean
cd /usr/ports/database/php5-interbase
make install clean

We need now to enable the Php and firebird extension for it (interbase.so)

Firstly we will edit apache’s config - this lives in /usr/local/etc/apache22/

Open /usr/local/etc/apache22/httpd.conf in your favroute editior (or nano while your learning to love vi)

Look for this line : LoadModule rewrite_module libexec/apache22/mod_rewrite.so
directly underneath this line add the following 3


LoadModule php5_module libexec/apache22/libphp5.so
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

Then find this line : DirectoryIndex index.html and change it to DirectoryIndex index.php index.html

After this is done we need to give php an ini - the easiest way to do this is to copy the dist one into place

cp /usr/local/etc/php.ini-dist /usr/local/etc/php.ini

open /usr/local/etc/php/extensions.ini in your favroute editor and look for this line : extension=interbase.so if it isnt there, add it.

one last change and we are good to go!

open /etc/rc.conf in your text editor of choice and add these lines :


apache2_enable="YES"

once your done reboot and enjoy!



Recomdeded Reading :
1.The Complete FreeBSD Book
2.Free BSD Handbook
I was inspired for the Apache/Php install from this article

Bug of the day fixed :Penguin Semaphores exhausted

From bug of the day category we present you Linux Semaphores exhausted

http://pmakowski.ibphoenix.fr/post/2009/03/05/From-the-support-list

http://tech.groups.yahoo.com/group/firebird-support/message/100649

.:(firebird):..:(databases):..:(sql):.

creating an db with isql-fb in firebird classic

If you try to create an db from isql-fb utility and you use firebird classic

then you might need to add the host in the connection string

$ isql-fb -user SYSDBA -password masterkey

Use CONNECT or CREATE DATABASE to specify a database

SQL> create database "/var/lib/firebird/2.1/data/fooozz.fdb"

CON> ;

Statement failed, SQLCODE = -902

cannot attach to password database

SQL>

Here is the correct way to create the database with classic

$ isql-fb -user SYSDBA -password masterkey

SQL> create database "localhost:/var/lib/firebird/2.1/data/fooozz.fdb"

CON> ;

.:(firebird):..:(databases):..:(sql):.

Even Postgresql developers prefer Firebird over Mysql

Read an interesting interview where one developer when asked

If you should decide between Firebird and MySQL, though it would not be available to PostgreSQL, what with you in a generally won? And why?

I have three years of application development platform for Interbase / Firebird. So it is clear what I have preferences. Firebird is a very nice small compact database that I like and fandím it.

.:(firebird):..:(databases):..:(sql):.

News of the Libgda front

New jdbc wrapper and updated firebird drivers 
see the article 


.:(firebird):..:(databases):..:(sql):.

convert security.fdb to security2.fdb in firebird

converting sercurity.fdb to security2.fdb (needed during 1.5 to 2.0 migration)
.:(firebird):..:(databases):..:(sql):.