the most stupid standard i have ever seen

The standard says that a BOOLEAN may be one of the following literals:

• TRUE
• FALSE
• UNKNOWN or NULL (unless prohibited by a NOT NULL constraint)

the boolean values in any sane boleean system are True or false , noooh sql should have other values so you should check them for the not NULL values , more work for nothing

http://troels.arvin.dk/db/rdbms/#data_types-boolean


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

berlios page for firebird is updated

here is the page updated

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

icewalkers page is now updated

it should be on main page soon
http://www.icewalkers.com/Linux/Software/524660/Firebird.html

i have updated firebird page on freshmeat

i have added new firebird 2.1 rc2 links and the changelog

http://freshmeat.net/projects/firebird/

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

Firebird hosting

Today i saw this nice firebird hosting company and i want to share it (it's an very good idea to follow and to create an Firebird+LAP hosting company)

There are many Linux hosting companies, many LAMP (Linux/Apache/MySQL/PHP) environments. But we offer MORE! We offer the Firebird SQL database, Perl and Python scriping languages, FTP and direct shell access, and now Mono, a free implementation of Microsoft's .NET framework! Now you can put put your sites together with VB.NET and C#, but still run on the most popular web server platform.

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

building firebird 2.1.x super from source on ubuntu

$sudo apt-get install automake libtool libreadline5-dev make btyacc bison gawk g++



$wget http://garr.dl.sourceforge.net/sourceforge/firebird/Firebird-2.1.0.17755-ReleaseCandidate2.tar.bz2

$tar -jxvf Firebird-2.1.0.17755-ReleaseCandidate2.tar.bz2

$cd Firebird-2.1.0.17755-ReleaseCandidate2

$./configure --enable-super-server --prefix=/opt/firebird2.1

$make

$sudo make install

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

Choice between MySQL and Firebird?

Which one of the two would you choose and why?

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

Debian Bug report logs for firebird project

some bugs are solved like mips, mipsel firebird port and also the security related
Here is the full report
.:(firebird):..:(databases):..:(sql):..:(debian):..:(bugs):.

debian romanian translations

Eddy Petrisor made an good translation for the debian package
Here are the details with the new translation
.:(firebird):..:(databases):..:(sql):.

building firebird 2.1 from debian git repository

apt-get install libicu-dev libedit-dev git-core

you need to check out the firebird 2.1 repository from debian git

http://lists.alioth.debian.org/pipermail/pkg-firebird-general/2007q3/001125.html

git-clone git://git.debian.org/git/pkg-firebird/2.1
cd 2.1
debuild -i
and wait for it to build it for you

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

lulu pr list

I will work to add them to my pr list and use them for spreading the F word

We recommend these free services – www.pr.com and www.prleap.com and two fee-based services: www.prweb.com and www.prnewswire.com.

Instalando o FirebirdSQL 2 « Hamacker’s Palace

Atualmente o FirebirdSQL encontra-se na versão 2.0 e com a versão 2.1 em fase beta, mas há um problema : para sistemas baseados no debian (ubuntu incluso), o Firebird encontra-se nos repositórios como versão 1.5.3, que possui menos recursos do que a versão 2.0.

[Installing Firebird 2.0 on ubuntu , an very long and a good guide for installing firebird/flamerobin]

Instalando o FirebirdSQL 2 « Hamacker’s Palace

Blogged with Flock

Firebird/InterBase - UDF and NULL parameters - DO not USE NULLs

Do not use NULLs

It is quite a frequent mistake to use NULLs for purposes it was not intended to. For example you have column MIDDLE_NAME in your table; if the person does not have middle name, you should fill in empty string (''); but sometimes people use NULL instead - it is wrong, because NULL means unknown value, not missing/not assigned/empty one. Using NULL as middle name means - "this person probably has a middle name, but we do not know what it is" - and not - "this person does not have any middle name".

Firebird/InterBase - UDF and NULL parameters

Blogged with Flock

Firebird Conference 2007 - New Features in Firebird 2.1

New Features in Firebird 2.1

Firebird Conference 2007 - New Features in Firebird 2.1

mnoGoSearch change history - new version released

Changes in 3.3.5 (17 October 2007)

mnoGoSearch change history

Blogged with Flock

Firebird Conference coverege [LWN.net]

Firebird Conference coveragePhotos and Blog entries from the 2007 Firebird DBMS conference have been posted. "The 2007 Firebird Conference convened from October 18-20 in Hamburg, Germany."

Linux in the news [LWN.net]

Blogged with Flock

Firebird Development release on [LWN.net]

Firebird 2.1 Beta 2 releasedVersion 2.1 Beta 2 of the Firebird DBMS has been announced. "This is the second Beta build of the Firebird version 2.1 series. It is for FIELD TESTING ONLY and should not be put into production systems."

Development [LWN.net]

Blogged with Flock

Firebird 2.1 Beta 2 is available in gentoo portage system

http://gentoo-portage.com/dev-db/firebird
.:(firebird):..:(databases):..:(sql):.

Installing DBI driver for Firebird RDBMS server

DBI driver for Firebird and RDBMS server
This was tested on debian stable with firebird 1.5.x version installed (from repository )
also with perl module DBI aready installed
wget http://search.cpan.org/CPAN/authors/id/E/ED/EDPRATOMO/DBD-InterBase-0.47.tar.gz
tar -zxvf DBD-InterBase-0.47.tar.gz
cd DBD-InterBase-0.47
perl Makefile.PL
make
make test (optional step)
make install

Here are the logs for perl Makefile.PL
perl Makefile.PL
InterBase/Firebird bin directory : [/opt/firebird/bin]
InterBase/Firebird include directory : [/opt/firebird/include]
InterBase/Firebird lib directory : [/opt/firebird/lib]

Full path to your test database:   /tmp/foo.fdb
/tmp/foo.fdb does not exist.
Trying to create the test database..
Please enter a username with CREATE DATABASE permission.
Username :  sysdba
Password :  masterkey
Enter full path to isql:  [/opt/firebird/bin/isql]
Use CONNECT or CREATE DATABASE to specify a database
Checking if your kit is complete...
Looks good
Using DBI 1.51 (for perl 5.008008 on i486-linux-gnu-thread-multi) installed in /usr/local/lib/perl/5.8.4/auto/DBI/
Writing Makefile for DBD::InterBase
For make test
make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base..............ok
t/10dsnlist...........ok
t/20createdrop........ok
t/30insertfetch.......ok
t/40alltypes..........ok
t/40bindparam.........ok
t/40blobs.............ok
t/40cursor............ok
t/40cursoron..........ok
t/40datetime..........ok
t/40doparam...........ok
t/40listfields........ok
t/40nulls.............ok
t/40numrows...........ok
t/41numeric...........ok
t/50chopblanks........ok
t/50commit............ok
t/60leaks.............skipped
        all skipped: Long running memory leak test
t/61settx.............ok
t/62timeout...........ok
        12/14 skipped: wait timeout is not available
t/70nestedoff.........ok
t/70nestedon..........ok
t/80event-ithreads....ok
t/81event-fork........ok 1/17# kid gets sighup
t/81event-fork........ok
t/90dbinfo............ok
        10/13 skipped: active_tran_count is not available
t/91txinfo............ok
t/ak-dbd..............ok
t/dbdadmin............ok
All tests successful, 1 test and 22 subtests skipped.
Files=28, Tests=683, 21 wallclock secs ( 3.02 cusr +  0.32 csys =  3.34 CPU)

And for make install
 make install
Installing /usr/local/lib/perl/5.8.8/auto/DBD/InterBase/InterBase.so
Installing /usr/local/lib/perl/5.8.8/auto/DBD/InterBase/InterBase.bs
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/local/lib/perl/5.8.8/DBD/InterBase.pm
Installing /usr/local/lib/perl/5.8.8/DBD/InterBase/TypeInfo.pm
Installing /usr/local/lib/perl/5.8.8/DBD/InterBase/GetInfo.pm
Installing /usr/local/man/man3/DBD::InterBase.3pm
Writing /usr/local/lib/perl/5.8.8/auto/DBD/InterBase/.packlist
Appending installation info to /usr/local/lib/perl/5.8.8/perllocal.pod

Edwin Pratomo / DBD-InterBase-0.47 - search.cpan.org

Blogged with Flock

gambas 2 (development version) 1.9.90 [LWN.net]

Homepage: http://gambas.sourceforge.net
More Info: http://www.kde-apps.org/content/show.php?content=20018
Description: Gambas is a free development environment based on a Basic interpreter with object extensions, like Visual Basic (but it is NOT a clone!). With Gambas, you can quickly design your program GUI with QT or GTK+, access MySQL, PostgreSQL, Firebird, ODBC and SQLite databases, pilot KDE applications with DCOP, translate your program into any language, create network applications easily, make 3D OpenGL applications, make CGI web applications, and so on...
Changelog: see http://gambas.sourceforge.net/changelog2.html

gambas 2 (development version) 1.9.90 [LWN.net]

Blogged with Flock