Grid-powered network thin clients run embedded Linux and ... Firebird database

"ThinLinx has launched a line of Linux-based thin-clients that access
Ubuntu Linux desktops and commercial Linux applications hosted on
ThinLinx's grid network. The Hot-E initially offers Firebird database,
Compiere and OpenCRX ERP/CRM"

http://www.linuxdevices.com/news/NS4609128375.html

..::firebird::..

99 Bottles of Beer in Firebird relational database SQL

/*
 * beer_song.sql - 99 Bottles of Beer in Firebird relational database SQL
 * Firebird is at firebird.sourceforge.net
 * Author: Jim Dunleavy 
 * 2003-11-27
 */

..::firebird::..

Newest Concern on Sun's Open Source Strategy - Firebird/Interbase mentioned

Firebird/Interbase license is mentioned on theserverside.com

"Several years ago, Borland released the Interbase Database source
code as an Open Source project. They then, quickly, turned around and
brought it back in house. Obviously, it was immediately forked and
today we have Firebird, which as far as I can tell is on a divergent
course from Interbase.

Interbase wasn't free long enough for any community work to have been
done on it before it was taken back, and I'm not familiar with their
license. But it is an example of a company "changing its mind"
regarding an open source project."

http://www.theserverside.com/news/thread.tss?thread_id=35242

..::firebird::..

Firebird switch - dot net provieder story

And MySQL is not being entirely upfront either. What is also interesting is that the new database connectors are being released under GPL only. For example if you were doing .NET development you have to release all of your software under GPL. This switch by MySQL stems from the fact that a court in the US deemed connecting to a database using a standard API is not an infraction of the GPL. As MySQL is trying to squeeze developers and admins to buy commercial licenses I switched to Firebird.

Found it on this blog

..::firebird::..

libgda/libgnomedb 1.3.4 released

libgda/libgnomedb are a complete framewok for developing
database-oriented applications, and currently allow access to PostgreSQL,
MySQL, Oracle, Sybase, SQLite, FireBird/Interbase, IBM DB2, mSQL and MS
SQL server, as well as MS Access and xBase files and ODBC data sources.

libgda/libgnomedb are the base of the database support in the GNOME
Office application suite, providing database access for many features in
both Gnumeric and Abiword.

1.3.4 is another step in the road to 2.0, which will be out with GNOME 2.12

You can find more information at the projects' homepage: http://www.gnome-db.org

..::firebird::..

Firebird Internals: OAT, OIT, and Sweep in Episode 4 (A New Hope)

A long time ago in a galaxy far, far away...

Firebird for the Database Expert: Episode 4 - OAT, OIT, and Sweep by Ann Harrison.

..::firebird::..

New Norwegian Search Vendor using Firebird

It seems like we now have an other Scandinavian contender in the Search Engine space.
They base their technology around SQL and native integration (porting) into each supported database. For the moment they support Microsoft SQL, Oracle, Interbase and Firebird , DB2 later this year or on customer request.

Source of news is unstruct.org

..::firebird::..

Bugtracking With Track+Firebird

Arno from australia wrote this

I have been looking for some decent, easy-to-use bugtracking software lately for one of our projects. My first recommondations were Bugzilla and Mantis, simply because I knew them from the past and they were freely available. But their installation procedures (e.g. Perl, MySQL as prerequisites for Bugzilla) overstrained the sysadmin responsible for setting up and maintaining the server (external staff - to his defense, he had no experience in these areas). Plus I never liked Bugzilla's nor Mantis' user interface.

So I continued searching, and finally found Track+. Originally a Sourceforge project, the licensing model was very attractive (free license for up to ten users), the featureset looked good, it supported all kinds of operating systems and databases, and it came with a complete Windows installer. I did a test installation and had it up and running in ten minutes.

The only prerequisite is an existing JDK1.4.2. The setup package also provides Tomcat 5 as web/application container and the free Firebird database. I only had to add tools.jar to Tomcat's classpath (seems as if the installer forgot about that - otherwise Tomcat's JSP engine Jasper would not be able to compile JSP pages)

..::firebird::..

Firebird Internals Episode 3 - On Disk Consistency (Revenge of the crash)

Ann Harrison published her 3rd expert whitepaper, this time on disk consistency.

Read more

..::firebird::..

Firebird Client 2.0 Alpha 1 for .NET 2.0 Beta 2 - released

Carlos announced the availability of Firebird Client 2.0 Alpha 1 for .NET 2.0 Beta 2, with the following notes: "For now only source and installation packages (for .NET 2.0 Beta 2) are available. Remember that it's an alpha version and it should be used only for testing. Release notes are here.
..::firebird::....::dotnet::....::mono::..

Europe Parliament Nixes Software Patent Law

The European Parliament overwhelmingly rejected a proposed law Wednesday
to create a single way of patenting software across the European Union,
calling instead for comprehensive rules for granting patents to inventions
in all fields.

..::firebird::..

Open Source is the Future. Open Source is Now.

Open source databases white paper (firebird,ibphoenix,fyracle mentioned):
pdf download

More papers on the same site http://virtuas.com/opensource.html

..::firebird::..::databases::..::postgresql::..::mysql::..

firebird on SCO Openserver 5.0.7 ! doh

> I have attempted to build firebird (1.0 and 1.5) on SCO Openserver 5.0.7

I don't think is worth the time to port on it , you can get a
free/open/gnu linux
very easy ;) and firebird is compiling well on recent distro's (minus
ones with gcc 4)

..::firebird::..::linux::..::unix::..

STOP Software Patents in Europe - last day call

How you can help

• Join the web demo
  
• Join the economic-majority.com
  
• Join the demonstration in Strasbourg
  

If you cannot attend the demonstation in Strasbourg in person please phone or fax your member of the European Parliament (MEP). Or better yet discuss the situation with others you work with and send a company FAX to show them how this new legislation will hurt your business if the Buzek-Rocard-Duff amendments are not adopted by parlement on Wednesday. If you don't inform your parliament, mega-corporations are doing the job for you: "The European Parliament is filled with lobbyists of Microsoft, Eicta, CompTIA and so on. There are 30 to 40 lobbyists permanently roaming the halls."

Join us now...

..::firebird::..
..::postgresql::..
..::databases::..
..::debian::..

Firebird SQL Service monitor and Server Config - screenshots

DISCLAIMER:

Software downloadable here is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. If you live or are intended to use this software in countries where this is not applicable ("AS IS" basis), DO NOT USE IT

FBMonitor

Firebird SQL Service monitor

Application Tray can Monitoring, Start, Stop, Restart Firebird SQL 1.5 Services over network.
Like as apache monitor

Download it from, EXE file included

http://www.parmaja.com/downloads/fbMonitor-1.0.0.zip

Forum Page

Screenshots



fbConfig 1.0.0

Firebird SQL 1.5 Config tools
It is a simple tools for edit "firebid.conf" and "aliases.conf" as easy without define the path of server (taked from registry),
- Easy Hash Unhash line (comment it),
- Recognize hashed value for Unhasing it,
- Description for every values.

Download it from, EXE file included

http://www.parmaja.com/downloads/fbConfig-1.0.0.zip

Forum Page

Screenshots




..::firebird::..

what is new in Firebird Alpha3

raw changelog is updated on sf.net

Added some Alpha 3 changes

  **************
 * v2.0 Alpha 3
 **************

   * DDL improvement
       Allow to create foreign key constraints without need to get exclusive lock
       on whole database
     Contributor(s):
       Vlad Horsun 

   * Fixed unregistered bug
       Fix 'partner index not found' error when one classic process
       dropped FK and another process trying to delete master record
     Contributor(s):
       Vlad Horsun 

   * ISQL improvement
       Make SQLDA_DISPLAY display input SQLDA parameters of INSERTs, UPDATEs and DELETEs
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed unregistered bug
       Server crashed when PLAN for VIEW is specified but no table alias was given
     Contributor(s):
       Vlad Horsun 

   * Fixed Alpha 2 bug (SF #1184591)
       Invalid ROW_COUNT variable value after DELETE
     Contributor(s):
       Dmitry Yemanov 

   * Fixed unregistered bugs
       1) redundant attempts to get an exclusive database lock during shutdown
       2) inaccurate timeout counting
       3) database lock is not released after bringing database online in the exclusive mode
       4) removed a 5 sec timeout when bringing database online in the shared mode
     Contributor(s):
       Dmitry Yemanov 

   * Fixed bug SF #1016040
       Missing external libraries causes engine exception
     Contributor(s):
       Adriano dos Santos Fernandes 

   * DML enhancement
       Implemented RETURNING clause for the INSERT statement
     See also:
       /doc/sql.extentions/README.returning
     Contributor(s):
       Dmitry Yemanov 

   * Fixed bug SF #1186607
       Foreign key relation VARCHAR <-> INT
     Contributor(s):
       Vlad Horsun 

   * Fixed bug SF #1211325
       BLOBs in external tables
     Contributor(s):
       Vlad Horsun 

   * New charsets/collations
       1) KOI8-R (Russian language) and KOI8-U (Ukrainian language) charsets and dictionary collations
       2) WIN1257_LV (Latvian), WIN1257_LT (Lithuanian), WIN1257_EE (Estonian) collations
     Contributor(s):
      Oleg Loa 
       Aleksey Karyakin 

   * Parser improvement
       Try report the line/column of an incomplete statement.
     Contributor(s):
       Claudio Valderrama 

   * Fixed unregistered bugs
       1) Charset/collation issues for expression-based view columns
       2) Lost charset/collation for local PSQL variables
     Contributor(s):
       Dmitry Yemanov 

   * Fixed Alpha 2 bug (SF #1171256)
       Local Protocol (XNET) isn't using aliases
     Contributor(s):
       Dmitry Yemanov 

   * Fixed unregistered bug
       Database alises didn't work in WNET
     Contributor(s):
       Dmitry Yemanov 

   * Fixed bug SF #1211354
       Redundant evaluations in COALESCE
     Contributor(s):
       Arno Brinkman 

   * Fixed unregistered bug
       Client crashed while disconnecting with active event listener
     Contributor(s):
       Dmitry Yemanov 

   * Fixed SF bug #1208932
       SHOW GRANT does not distinguish object types
     Contributor(s):
       Claudio Valderrama 

   * Optimizer improvement
       Use more realistic cost value for unique retrieval
     Contributor(s):
       Arno Brinkman 

   * Fixed SF bug #494981
       Bad exception report
     Contributor(s):
       Claudio Valderrama 

   * DDL enhancement
       Implemented ALTER EXTERNAL FUNCTION to change the entry_point or the module_name when the UDF cannot be dropped due to existing dependecies
     Contributor(s):
       Claudio Valderrama 

   * Fixed Alpha 2 bugs
       1) bug with selectivity of non-equality comparisons
       2) changed the invertions selection code to help in both MERGE and JOIN paths
       3) implemented metadata extract for expression indices
       4) the threading issues in fbembed
     Contributor(s):
       Dmitry Yemanov 

   * DDL enhancement
       Implemented the COMMENT statement to set the metadata descriptions
     See also:
       /doc/sql.extentions/README.ddl.txt
     Contributor(s):
       Claudio Valderrama 

   * Fixed bug SF #908319
       1.5 wrong err msg using gbak with service_mgr
     Contributor(s):
       Vlad Horsun 

   * Fixed unregistered bug
       A few internal buffer overflows are fixed
     Contributor(s):
       Alex Peshkov 

   * Fixed unregistered bug
       After an attempt to "create view v(c1) as select 1 from v" all clones of system request remained active forever
     Contributor(s):
       Alex Peshkov 

   * Fixed Alpha 2 bug
       Server crashed in incorrect written EXECUTE BLOCK statement
     Example(s):
       EXECUTE BLOCK AS BEGIN
         INSERT INTO DUMMY (ID) VALUES(?);
       END
     Contributor(s):
       Vlad Horsun 

   * Fixed unregistered bug
       ISQL_disconnect_database overwriting the Quiet flag permanently
     Contributor(s):
       Miroslav Penchev 
       Claudio Valderrama 

   * Fixed unregistered bug
       Server crashed during the table metadata scan in some cases
     Contributor(s):
       Dmitry Yemanov 

   * Fixed unregistered bug
       Error "index key too big" when creating a descending index
     Contributor(s):
       Vlad Horsun 

   * Fixed SF bug #1191006
       Using where params in SUM return incorrect results
     Contributor(s):
       Arno Brinkman 

   * Fixed Alpha 2 bug
       Problem with distributing sort to deeper RSE
     Example(s):
     SELECT RDB$RELATION_NAME FROM (SELECT FIRST 10 * FROM RDB$RELATIONS ORDER BY RDB$RELATION_NAME DESC) ORDER BY RDB$RELATION_NAME
     Contributor(s):
       Arno Brinkman 

   * Fixed SF bug #1122344
       gbak -kill option drops existing shadow
     Contributor(s):
       Dmitry Yemanov 

   * Fixed SF bug #750662
       Multiple declaration of blob filters
     Contributor(s):
       Dmitry Yemanov 

   * Parser improvement
       UNIONs are allowed in ANY/ALL/IN subqueries
     Contributor(s):
       Dmitry Yemanov 

   * Fixed SF bug #743679
       FIRST / SKIP not well implemented
     Contributor(s):
       Dmitry Yemanov 

   * Optimizer improvement
       NOT conditions are simplified and optimized via index when possible
     Example(s):
       (NOT NOT A = 0) -> (A = 0)
       (NOT A > 0) -> (A <= 0)
     Contributor(s):
       Dmitry Yemanov 

   * Fixed SF bug #450404
       ISQL uppercases role in the command line
     Contributor(s):
       Claudio Valderrama 

   * Fixed unregistered bug
       100% CPU load when an I/O error causes a rollover to non-existing shadow
     Contributor(s):
       Dmitry Yemanov 

   * Fixed Alpha 2 bug (SF #1173988)
       Minor glitches in GBAK output
     Contributor(s):
       Claudio Valderrama 

   * Fixed unregistered bug
       Fix for the -b (Bail On Error) option when SQL commands are issued and no db connection exists yet.
       Apply Miroslav Penchev's patch for bug with -Q always returning 1 to the operating system, discovered by Ivan Prenosil.
     Contributor(s):
       Claudio Valderrama 

   * New INTL interface
       A new interface allowing the following enhancements and features
     Contributor(s):
       Nickolay Samofatov 

   * INTL enhancements
       1) Well-formedness checks of string constants and parameters
       2) Uppercase and lowercase all possible (and not only ASCII) characters in default collation orders
       3) Check length of characters (and not bytes) for new MBCS (including UTF8)
       4) Inform original character set in sqlsubtype of XSQLVAR when connecting with NONE
     Contributor(s):
       Adriano dos Santos Fernandes 

   * BLOB enhancements
       1) Allow usage of collations
       2) Perform comparison using entire content
       3) Convert between character sets when assigning from string or BLOB
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Unicode 4.0 support
       UTF8 character set with collations UCS_BASIC and UNICODE
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Brazilian collations
       1) Collation PT_BR for ISO8859_1 and WIN1252 character sets
       2) Collation WIN_PTBR for WIN1252 character set
     Contributor(s):
       Adriano dos Santos Fernandes 
       Paulo Henrique Albanez 

   * New string functions
       LOWER, BIT_LENGTH, CHAR_LENGTH/CHARACTER_LENGTH, OCTET_LENGTH, TRIM.
     See also:
       /doc/sql.extentions/README.length
       /doc/sql.extentions/README.trim
     Contributor(s):
       Adriano dos Santos Fernandes 

   * INTL plugins
       Character sets and collations are installed using a manifest file. Server write to the log when conflicts exist.
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed SF #1073212
       Order by big columns (collate) terminates server
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed SF #939844
       Queries > 263 chars with UNICODE DB throws GDS Exception
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed SF #977785
       Wrong character lengths MBCS (UTF-8, East-Asian charsets)
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed SF #536243
       UNICODE_FSS charset and UPPER function
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed SF #942726
       UPPER does not convert aacute to Aacute for ISO8859_1
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed SF #544630
       Problems when connecting using UNICODE
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed SF #540547
       Concatenation, numeric fields & charset
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed unregistered bug
       Query produce different result depending on index presence when the last character of the string is the first character of a compression pair
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed unregistered bug
       SUBSTRING and multi-byte BLOB don't work correctly
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed unregistered bug
       Pattern matching with multi-byte BLOB is performed in binary mode
     Contributor(s):
       Adriano dos Santos Fernandes 

   * Fixed unregistered bug
       It's not safe to connect with MBCS if database has columns using different character set
     Contributor(s):
       Adriano dos Santos Fernandes 

..::firebird::..

bitweaver released

It's been a while coming, but the Firebird powered wiki site is running
and stable
http://home.lsces.co.uk/tikifirebird
Not much in the way of content yet, apart from the words list, which has
been split down into single letter pages, and just a few logos to start
the gallery. It is powered by bitweaver which is the new name for tikipro. 
There has been a major re-write of the code, much like Firebird, but now 
there is a clean modular shell onto which other packages can be grafted.
http://www.bitweaver.org/
 
It runs on Apache/PHP which means any OS you like, and your favourite
installation of Firebird. I'm running the demo sites split across two
machines, Firebird on one and Apache2/PHP5 on the second, and all
running 'as installed'.
The magic bit is that bitweaver will install 
using Firebird as the database 'out of the box'. Just tell the installer 
where your copy of isql is located (the default location is provided) and 
the bitweaver installer will do the rest. Add an alias before you start 
and you can use that in the install. Now we just need a few more users to 
iron out any remaining bugs and
start to build Firebird pages. 
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services 

source for news : firebird-php

..::firebird::....::apache::....::php::..

New database discussion forum

Martijn Tonies and Arno Brinkman have created a new database-development forum website. It's a single website for discussing all kinds of different database engines.

::databases::firebird::mysql::postgresql::

Fyracle 0.8.8 released

Fyracle is the nick-name for Oracle-mode Firebird. By using Oracle-mode Firebird, you can bring the cost of porting major Oracle based enterprise application down to manageable levels. Fyracle does this by matching Oracle syntax idiosyncrasies and by providing the ability to compile and execute PL/SQL procedures unchanged.

Continued

..::firebird::..::databases::..::oracle::..