remember to upgrade to firebird 2.0.4 or firebird2.1

Stack-based buffer overflow in Firebird before 2.0.4, and 2.1.x before 2.1.0 RC1, might allow remote attackers to execute arbitrary code via a long username.

http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2008-0467

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

firebird2.0 2.0.3.12981.ds1-14 (source) in Ubuntu

latest package 2.0.3 from debian is now imported in ubuntu intrepid
https://bugs.edge.launchpad.net/ubuntu/+source/firebird2.0/2.0.3.12981.ds1-14

and here are the successful (power and sparc are new )

Builds

• intrepid sparc Successfully built (DONE)
• intrepid powerpc Successfully built (DONE)
• intrepid lpia Successfully built (DONE)
• intrepid i386 Successfully built (DONE)
• intrepid amd64 Successfully built (DONE)

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

Firebird downloads for April

there is an high number of downloads for April , traffice is at ~600GB and downloads at 117,467
http://sourceforge.net/project/stats/detail.php?group_id=9028&ugn=firebird&mode=year&&type=prdownload

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

The ministry's Money Laundering Prevention Directorate (MLPD) uses Firebird

The ministry's Money Laundering Prevention Directorate (MLPD) used Gnu Privacy Guard (GPG) between 2004 and 2007. This is Open Source software for encrypting and electronically signing data, allowing it to be transmitted securely even through public networks. The directorate also uses the Open Source relational database management system Firebird. "Both the banks and the MLPD accepted our solution without any objections, and it did not introduce any costs", comments Jovanovic.

http://ec.europa.eu/idabc/en/document/7370/469

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

FB 2.1 Week of Year Feature

With new functions in FB 2.1 extracting week of year is supported (based on ISO-8601). So this past article is more simple to do with the new syntax :

extract(week from some_date_field)

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

wordpress for firebird

i wonder if i can apply pdo patches to the wordpress 2.5
and maybe after that make it work with firebird later
(pdo is suported by other databases too)

ps:why wordpress team ignores the rest of the world ?

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

firebird + genotoo blog post

One blog post with charset issues on gentoo in Russian language




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

LINQ To Dataset DBNull problem

I've got a connection to a Firebird Database.
I've linked DataSources in the IDE. I've got all my 8 tables from which I can retrieve data.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3222905&SiteID=1

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

someone is using firebird on ubuntu

here is his blog where machines are described

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

phpBB 3.0.1 released

phpBB 3.0.1 has just been released, this means some small bug fixes, which were of course necessary in order to ensure the continuous stable release rate of phpBB. The official release topic is posted below.

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

OpenDBX 1.3.7 released

Release focus: Major bugfixes

Changes:
Many improvements and bugfixes are included in this release and it's recommended to all developers to upgrade to the latest version. The existing odbx_result_free() is deprecated in favor of the new odbx_result_finish(). Additionally, the C++ Stmt::bind() method of the API was removed and the Stmt::escape() method was moved to the connection object. It's now also possible to write data into large objects using the Firebird and Oracle backends, but the Oracle LOB implementation doesn't work at the moment.

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

We went with Firebird 2.0 because

Quote from firebird-general

Yes. We were evaluating various embedded engines a few years ago,
including Firebird, MSSQL XP, Oracle XP, DB2 XP, MySQL, SQL Lite, MS
Access and PostgreSQL. In addition to standard SQL capabilities, our
application required us to be able to mimic the behaviour of other
database engines we support fairly closely.

We went with Firebird 2.0 because:

- Smallest footprint.
- File based databases.
- Lack of size restrictions.
- Friendly license terms.
- Extensive set of data types (with domains to handle anything
funky we run into later)
- Extensive set of collations
- Extensibility
- Active and responsive development community
- Easy installation.
- Easy configuration
- Standards compliance

Limitations we ran into:

- Database files must be local
- Collations are all case sensitive ( we may be able to deal with
this in 2.1, but my 2.0 attempts all failed)
- No built in functions to speak of required a third party UDF
library (this has changed in 2.1)
- No session scoped (i.e. local) temporary tables (global temps are
in 2.1 but not local)
- Different instances of the application cannot both access the
same database file.

The limitations were fairly minor and easy to work around. In
general we are extremely happy with our choice!

Incidentally, our reasons for rejecting MS-SQL XP were:

- Forces our users to install .NET (this was the big show stopper)
- Relatively largish footprint (60Mb if memory serves)
- 2GB database size restriction (this made us nervous as we have no
control over the user's data)
- Missing data types (DATE, TIME)

HTH,
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html

.:(firebird):..:(databases):..:(sql):..:(mssql):..:(mysql):..:(postgresql):..:(oracle):.

Firebird Project Releases Firebird 2.1 Zeta 2

The Firebird Project today officially releases
the much-anticipated version 2.1 Zeta 2 of its
open source Firebird relational database software
The 2.1 release has many interesting new features that you can play
with, like database triggers, temporary and monitoring tables, common
table expressions, recursive queries and dozens of new inbuilt
functions. We encourage you to see what you can achieve with these new
features and let us know about any deficiency.

Windows ,MacOSX ,Linux kits fir 32-bit and 64-bit
platforms are ready to download now
You are invited to test it furiously
and report your experiences (good or bad) back to the firebird-devel list.
It brings with it a large collection of long-awaited enhancements that significantly improve performance, security and support for international languages and realise some desirable new SQL language features. Under the surface, it also provides a much more robust code platform from which the re-architecting planned for Firebird 2.5/3.0 is proceeding.
The Firebird project roadmap for 2008 is now available.

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

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

IBPhoenix Open Source ODBC Driver

compiling and installing it on ubuntu
cvs -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird login
cvs -z3 -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird co OdbcJdbc

cd OdbcJdbc/Builds/Gcc.lin
make -f makefile.linux

Next read the readme.linux

driver seems to be in OdbcJdbc/Builds/Gcc.lin/Release
sudo cp *.so /usr/lib
sudo ln -s /usr/lib/IscDbc.so /usr/lib/IscDbc

sudo ln -s /usr/lib/libIscDbc.so /usr/lib/IscDbc

cat /etc/odbcinst.ini
[Firebird]
Description = InterBase/Firebird ODBC Driver
Driver = /usr/lib/libOdbcJdbc.so
Setup = /usr/lib/libOdbcJdbcS.so
Threading = 1
FileUsage = 1
CPTimeout =
CPReuse =

cat /etc/odbc.ini
[help]
Description = Firebird
Driver = Firebird
Dbname = localhost:/var/lib/firebird/2.0/system/help.fdb
User = SYSDBA
Password = masterkey
Role =
CharacterSet =
ReadOnly = No
NoWait = No


isql -v help
+---------------------------------------+
| Connected!                 |
+---------------------------------------+
SQL> select * from topics;
IBPhoenix Open Source ODBC Driver

Blogged with Flock

firebird compile times on ec2 extra large instance (fedora core 6)

Extra Large Instance 15 GB memory, 64-bit platform 8 EC2 Compute Units (4 virtual cores with 2 EC2 Compute Units each) 1,690 GB instance storage (4 x 420 GB plus 10 GB root partition) Instance Type name: m1.xlarge (used in EC2 APIs)

wget http://garr.dl.sourceforge.net/sourceforge/firebird/Firebird-2.1.0.15999-Beta1.tar.bz2

yum install automake libtool readline-devel libtermcap-devel make btyacc bison gawk gcc-c++ xinetd ncurses-devel
tar -jxf Firebird-2.1.0.15999-Beta1.tar.bz2
./autogen.sh --prefix=/mnt/firebird2.1.x
time make
real    11m49.195s
user    10m11.510s
sys     1m19.200s
cd /mnt/firebird2.1.x/bin

./isql -u sysdba -p **********
connect "/opt/firebird2.1.x/examples/empbuild/employee.fdb"
SQL> SHOW version;
ISQL Version: LI-T2.1.0.15999 Firebird 2.1 Beta 1
Server version:
Firebird/linux AMD64 (access method), version "LI-T2.1.0.15999 Firebird 2.1 Beta 1"
on disk structure version 11.1

Amazon Web Services Developer Connection : Feature Guide: New Instance Types

Blogged with Flock

building times for firebird 2.1 on amazon ec2 (fedora core 6)

Large Instance 7.5 GB memory, 64-bit platform 4 EC2 Compute Units (2 virtual cores with 2 EC2 Compute Units each) 850 GB instance storage (2 x 420 GB plus 10 GB root partition)
Instance Type name: m1.large (used in EC2 APIs)

Here how can firebird can be build and the time

wget http://garr.dl.sourceforge.net/sourceforge/firebird/Firebird-2.1.0.15999-Beta1.tar.bz2
yum install automake libtool readline-devel libtermcap-devel make btyacc bison gawk gcc-c++ xinetd ncurses-devel
 cd Firebird-2.1.0.15999-Beta1
./autogen.sh --prefix=/opt/firebird2.1.x
time make
real    12m9.498s
user    10m16.980s
sys     1m19.880s
make install


cat /proc/cpuinfo
processor       : 0
vendor_id       : AuthenticAMD
cpu family      : 15
model           : 33
model name      : Dual Core AMD Opteron(tm) Processor 270
stepping        : 2
cpu MHz         : 2004.542
cache size      : 1024 KB
physical id     : 0
siblings        : 1
core id         : 0
cpu cores       : 1
fpu             : yes
fpu_exception   : yes
cpuid level     : 1
wp              : yes
flags           : fpu tsc msr pae mce cx8 apic mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt lm 3dnowext 3dnow pni lahf_lm cmp_legacy
bogomips        : 4010.62
TLB size        : 1024 4K pages
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp

processor       : 1
vendor_id       : AuthenticAMD
cpu family      : 15
model           : 33
model name      : Dual Core AMD Opteron(tm) Processor 270
stepping        : 2
cpu MHz         : 2004.542
cache size      : 1024 KB
physical id     : 1
siblings        : 1
core id         : 0
cpu cores       : 1
fpu             : yes
fpu_exception   : yes
cpuid level     : 1
wp              : yes
flags           : fpu tsc msr pae mce cx8 apic mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt lm 3dnowext 3dnow pni lahf_lm cmp_legacy
bogomips        : 4010.62
TLB size        : 1024 4K pages
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp

Amazon Web Services Developer Connection : Feature Guide: New Instance Types

Blogged with Flock

Firebird Development: Firebird 3.0 is with 7-10% faster than firebird 2.1.x

The most important of what was done during last months is certainly start of FB3 project. This is B3_0_transition tree. We try to keep it stable at the same time making big code cleanup, including MT stability. This tree is going to become a base for FB3. For today the main result that after cleanup it's stable on linux, at the same time showing 7-10% better performance compared with fb2.1. I do not mention separately later problems, fixed in 3.0 transition.

Firebird Development: Database Engine

Blogged with Flock

Amazon.com: New EC2 Instances - quad core and so on

Large Instance 7.5 GB memory 4 EC2 Compute Units (2 virtual cores with 2 EC2 Compute Units each) 850 GB instance storage (2 x 420 GB plus 10 GB root partition) 64-bit platform I/O Performance: High Price: $0.40 per instance hour

Soon i will test with bonie++ and databases load

Amazon.com: Instances - Amazon EC2: Help

Blogged with Flock

building firebird 2.1.x classic from source on ubuntu

cd /opt/build

wget http://garr.dl.sourceforge.net/sourceforge/firebird/Firebird-2.1.0.15999-Beta1.tar.bz2

tar -jxvf Firebird-2.1.0.15999-Beta1.tar.bz2

cd Firebird-2.1.0.15999-Beta1

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

./autogen.sh --prefix=/opt/firebird2.1.x

make

sudo make install

technorati tags:firebird classic, firebird, ubuntu, gutsy, feisty, linux, freebsd, *bsd, unix, ec2, amazon

Blogged with Flock

Firebird clustering - the bad news

The bad news is that it involves coding in firebird core (at least in the lock manager code)

I'm afraid it won't work. The Classic processes should be able to
synchronize the logical I/O operations (page reads/writes) in order to
perform properly. It's done by the integrated lock manager, but it
cannot work between cluster nodes. As soon as the lock manager is
enhanced (or better say fixed) to delegate the calls to the external
distributed lock manager (e.g. RedHat DLM), this would become a workable
solution.

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

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

Firebird SQL Clustering questions

Here comes the fire cluster question
I want to build an Load Balanced Active/Passive Firebird SQL Cluster
(two Active/Passive clusters which have access to the same data). So
the set up will be as follows:
1. Two Redhat GFS Clusters
2. One shared storage of 1TB
3. Layer7 Switch

So my idea is to implement GFS on the shared storage (/shared/db) and
then create two quorums one for one cluster, and the other for the
second cluster. After that I would register the following into a
cluster service:
- Shared IP address
- Shared Storage
- Firebird init.d script

So have anyone managed to create such scenario or is this kind of
scenario supported on Firebird 2.0.1 Classic.


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

quote of the day - mysql , HTTP engine

I was explaining the HTTP engine to a group at the bar there. And this one guy is watching, and he talks to me a little bit, and he goes off. We’re sitting around for the bar for like another hour, and he comes back and says, "Look at this." He had been to Google Spreadsheets, and what he had done was written a RESTful URL and placed it into the HTTP engine and then started collecting data off of a Google spreadsheet and displaying inside the database. So every time he did a SELECT on the database, it was actually pulling data from this Google spreadsheet that he had connected to

Interview with Brian Aker - LinuxWorld

technorati tags:firebird, mysql, http, engine, restful, google, spreadsheet, select *

Blogged with Flock

Did you know stored procedures are atomic in Firebird?

that is quote of the day

Did you know stored procedures are atomic? from the presentation

Real World Applications Using Firebird

technorati tags:firebird, flamerobin, sas, java, jdbc

Blogged with Flock

Great Expectations for Jruby 1.0

[Can someone try Firebird with ActiveRecord Jdbc before the Jruby1.0 release??]
Since the release of JRuby 0.9.8 about a month ago, information about JRuby progress has been a little hard to find. But the latest news out of the JRuby camp leaves us no doubt that it is because the team is working harder than ever in order to deliver JRuby 1.0 before JavaOne.

InfoQ: Great Expectations for JRuby 1.0

technorati tags:firebird, jruby, ror, ruby, jdbc, activerecord, activerecordjdbc, infoq, arjdbc

Blogged with Flock

Firebird 2.1 Alpha 1 Ready for Field Testing

The Firebird team is pleased to announce that the first Alpha builds of Firebird V.2.1 are ready for testing. Binary and source kits for Linux and and some Win64 and Win32 kits should start appearing at the Sourceforge mirrors today. For a summary of new features and bug fixes, see HERE.

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

win64 crazyness for labraries

In the same vein, the System32 directory is reserved for 64-bit libraries. 32-bit libraries go into SysWOW64. That's right: 64-bit libraries are in System32, 32-bit libraries in SysWOW64.You should be aware of this, otherwise you may have a hard time locating your 32-bit Firebird components on a 64-bit Windows system.(Incidentally, WOW stands for Windows on Windows. Now you can also work out what LOL means.)

Default disk locations

technorati tags:win64, firebird, system32, win32, LOL, WOW64

Blogged with Flock

firebird (evil mode) - sometimes i'd rather be a Penguin

Ann Harrisonshowing a sample of the Borland InterBase OpenSource 6.0 announcement T-Shirt. 500 of these have been made, so it's kind of a rarity.
Linux - damn! How Often Do You Do That ?!
Firebird - sometimes i'd rather be a Penguin!
 

Firebird Conference 2006 - Ann Harrison

technorati tags:evil, firebird, tux, interbase, borland, linux, t-shirt

Blogged with Flock

Firebird 3.0 Roadmap

Firebird 3.0 Roadmap

Firebird Conference 2006 - Firebird 3.0 Roadmap

technorati tags:firebird, firebird3.0, roadmap, conference, praga

Blogged with Flock

Firebird Development Priorities - screen shot at firebird conference

Firebird Development Priorities I like these

Firebird Conference 2006 - Firebird Development Priorities

technorati tags:firebird, priorities, conference, praga

Blogged with Flock

Merging Vulcan and firebird code

Dmitry Yemanov today posted to the Firebird-devel list his proposals for merging the Firebird 2 code with the Vulcan code. If you are interested in how it will be done and who will be doing it, subscribe to the list and watch the thread entitled "Merge Proposal".

Firebird - Relational Database for the New Millenium

technorati tags:firebird, vulcan, databases, firebird-devel, firebird2.x, firebird3.x

Blogged with Flock

Big in Japan - Firebird Japanese user comunity

It does the business regarding the spread and development of [rireshiyonarudetabesu] Firebird

Official site :

http://firebird.gr.jp Birthplace sight

http://www.firebirdsql.org//

Mailing list

http://groups.yahoo.co.jp/group/Firebird-jp-general/

spotted via jp.sun.com -> Open comuity directory

Translated version of http://jp.sun.com/communities/open/directory/firebird.html

ZybaCafe - sofware written with Lazarus

ZybaCafe (formerly DireqCafe) is a next-generation free and open-source internet cafe management suite.ZybaCafe comprises a server-side administration suite, as well as clients to manage time-control on machines. The standard version uses postgresql as an RDBMS but porting it to other database systems should not be very difficult.[ED:It Might be easily ported to firebird]

silentcoder.co.za - ZybaCafe

technorati tags:lazarus, freepascal, pascal, delphi, firebird, postgresql, oopascal

Blogged with Flock

upgrading firebird 1.5 to 2.0 latest stable

Yeah, last week I try to install the new Firebird 2.0. And it's easy to migrate the old ODS 10.1 (FB 1.5) to ODS 11 (FB2.0) what you need to do is:

My Personal Interest & Activity: Upgrading Firebird 1.5 to 2.0

technorati tags:firebird, upgrade, databases, gbak

Blogged with Flock

hunting for code

Technically Speaking, Krugle couldn’t have come to my attention at a more opportune time as I am starting to play around a bit with Firebird, and I’m beyond rusty on simple SQL these days!

Krugle - Stop hunting, go Krugling! « Technically Speaking

technorati tags:firebird, krugle, google

Blogged with Flock

computer world slowdown please...

[ED: isn't an cell world ? the number of embedded devices > computers , Here are some comments from Dimitri Kuzmenko]
Interesting that press starting to write more news about Firebird. For example, look at Firebird 2.0 announce at Computerworld. This is great, but, a lot of mistakes.

IBDeveloper: Computerworld, slowdown please....

technorati tags:firebird, computerworld, ibdeveloper

Blogged with Flock

it's a new day , it's a new *bird - blog of the day about firebird

During the conference two new versions of Firebird were discussed and are expected to see the light of day during 2007. These will be 2.1 and 3.0.

New IT Trends: A new Firebird

technorati tags:firebird, flamerobin

Blogged with Flock

firebird headline on neowin

"my company uses firebird and we've been waiting for 2.0 for a while."

Neowin.net - Firebird Project Releases Firebird 2.0 Final

technorati tags:firebird, neowin, windows

Blogged with Flock

spreading the word about latest firebird 2 (gold)

The Firebird Project today officially releases the much-anticipated
version 2.0 of its open source Firebird relational database software
during the opening session of the fourth international Firebird
Conference in Prague, Czech Republic.

Firebird 2.0 is the happy culmination of more than two years' efforts
from a broad-ranging, truly international community of dedicated
developers and supporters. It brings with it a large collection of
long-awaited enhancements that significantly improve performance,
security and support for international languages and realise some
desirable new SQL language features. Under the surface, it also
provides a much more robust code platform from which the
re-architecting planned for Firebird 3.0 is proceeding.

Read and download: i started with these sites (google spreadsheet)]

News i will send to (over time):

http://news.google.com/news?q=mysql
http://www.google.com/search?q=mono+1.0
http://news.google.com/news?hl=en&um=1&tab=wn&q=postgresql+&btnG=Search+News

other good linux/bsd/mac/windows/vms sites

leftovers from spreadsheet

- betanews.net [DONE ]
- devshed.com [ on forum]
- lwn.net[DONE]
- linuxelectrons.com []
- phoronix.com [DONE by email]
- eweek.com [ sent to LisaVaas]
- informationweek.com [NOT ]
- infoworld.com [ sent to Neil McAllister]
- freshmeat.net
- linuxquestions.org
- debcentral.org
- opensourcexperts.com - > PR
- databasejournal.com
- linuxgazette.net [NOT ]
- linuxcompatible.org [NOT ]
- pclinuxonline.com [NOT ]
- tuxmachines.org [NOT ]
- prweb.com [NOT  ]
- sourcewell.berlios.de[NOT ]

- warp2search.net [NOT ]
- forum.amd.com []
- geek.com []
- aceshardware.com []

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

firebird with mono 1.2

Ok here's what I have: Lastest Mono (1.2) - and it worksFirebirdsql.data.firebird version 1.7 as it came bundled with this Monoinstallation.

Getting Firebird .net provider to work in Mono 1.2 | Firebird Questions .NET

technorati tags:firebird, mono, fx3.0, .net2.0, .net, .net1.0, .netprovider

Blogged with Flock

Firebird dot net provider 2.0 in mono issue

I will be glad to see v2.0 of provider coming with mono, butmono people are who needs to decide if they want that and how thatshould be done not me.

Re: Using the 2.0 Provider on Mono | Firebird Questions .NET

technorati tags:firebird, mono, .net, dotnet, asp.net, microsoft, linux

Blogged with Flock

Osdbconf - impressions

There were number of talks about MySQL by Arjen Lentz, Me and Giuseppe Maxia . There also were talks about Firebird, Apache Derby, Ingres and DB40. There however were no talks about PostgreSQL which is probably second most popular OpenSource Database or any others.

MySQL Performance Blog » Back from OpenSource Database Conference

technorati tags:mysql, db40, ingres, derby, postgresql, php, firebird, ibexpert

Blogged with Flock

blog of the day about firebird 2.0 release

I've personally seen some fairly dramatic performance improvements with this release, as well as some fairly significant new features for the project.

Jesse Sightler's Weblog

technorati tags:firebird, databases, java, jroller, javalobby

Blogged with Flock

phpbb 3.0 beta 3 - any firebird testers ?

We are pleased to announce the availability of the phpBB3 Beta3 package. With this third beta release we are again a great step forward. With this beta no update path is provided due to a number of extensive database schema changes and us having decided to implement full UTF-8 capability. But what we did is implementing the first steps to provide you with an automatic update tool which should lay the ground for providing updates later.

phpBB.com :: View topic - phpBB 3.0 Beta3 released

technorati tags:firebird, phpbb, phpbb3, bb, php

Blogged with Flock

oscon blog mention

I mainly followed the database track, which for the most part meant PostgreSQL and MySQL. I can't say I even heard Firebird mentioned, which surprised me a little.

More OSCON to come

technorati tags:firebird, mysql, firebird, oscon

Blogged with Flock

kernel koroner - io scheduler

Interesting read (see the article bellow), I will check if linux io scheduler has some effect on firebird databases too , I saw some redhat benchmarks with oracle and seems that io schedulers do have some performance gain (that is scheduler's sole raison d'être after all )
some related papers
http://www.google.com/search?q=linux+2.6+i%2Fo+schedule
I'm really interested into this because we have one raid-5 setup and when one of the drives failed and added an new drive to the raid (soft array) the io speed was very poor (1M/s reconstruction speed) and killed the server (booted ant took 1 hour until the login prompt), also we had an mysql 5.1 instance with gigs of data that crashed the centos box when updating/reconstructing some table (4G of ram , athlonX2 and raid5 setup ) I couldn't even press ctrl-alt-del or even sysrq keys (no console error or kernel panik) I call it blank sceen of death (no video output) it might be related to ACPI or freq scaling but now we replaced with another box (same specs) and cpu scalling is disabled in bios

mySQL DBA: IO schedulers matter

technorati tags:firebird, mysql, kernel, koroner, io+scheduler, linux, databases

Blogged with Flock

configuring firebird on large databases (linux kernel)

I took some tips from the oracle instalation notes [scroll down to Configuring Kernel Parameters]

Oracle instances consume memory and CPU resources on servers, and Ubuntu doesn't come configured to allow the quantity of resources to be consumed that we'll end up needing. To fix that, we therefore have to specify a set of new Kernerl Parameters which the operating system should use. That's easily done by editing one file, like so:

Installing 10g Release 2 on Ubuntu (Breezy Badger and Dapper Drake) | Dizwell Informatics

technorati tags:firebird, vldb, oracle, ubuntu, linux, centos, mysql

Blogged with Flock

linux on vax - project of the day

I guess someday firebird will run on linux on vax
Here you will find all you need to get the Linux Kernel up and running on a VAX computer.

Linux/VAX Porting Project

technorati tags:firebird, vms, vax, linux, netbsd, simh, emulator

Blogged with Flock

new jaybird release added on freshmeat

Release focus: Major feature enhancements

Changes:
Support for Firebird events, few other features and fixes

http://jaybirdwiki.firebirdsql.org

technorati tags:firebird, jaybird, jdbc, jdbc3, jdbc2, java, transactions, security, connections

Blogged with Flock

ajax+firebird mention on lockergnome

You have to admit, this concept of an Ajax builder could end up providing us with some pretty amazing products in the not too distant future.

AJAX made easier Down Under ~ Web Developers

technorati tags:firebird, ajax, csharp, rad, ide, javascript

Blogged with Flock

Easy Ajax with Firebird down under

The AJAX-based product features a visual designer and cross-compiling capabilities for programming in C#, Java, Visual Basic and Object Pascal. An embeddable Firebird database and Apache Web server are also included for application deployments. With WebOS AppsBuilder, Morfik saves developers from having to learn new languages for Web development, such as PHP (Hypertext Preprocessor) or Python.

AJAX made easier down under

technorati tags:firebird, firebird+database, ajax, php, csharp, pascal, delphi, oopascal, perl, python, webos

Blogged with Flock

Quote of the day "Interesting that they call if Firebird...Firebird Suite "

"Interesting that they call if Firebird. The obvious next step would be to bundle it with a word processor and spreadsheet. Then call it the Firebird Suite."
by Andrew B. on http://www.desktoppublishingforum.com/bb/showthread.php?t=3175

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

free pascal , free beer meeting

Lazarus and FPC will be on the Systems 2006 in Munich in October in hall A3 booth 542. We will try to be there on all 5 days. You can find more information about the Systems 2006 here.[Ed:you can meet the team and talk about the lazarus ide, oopascal , firebird , open source , free beer ;) ]

Firebird News

Blogged with Flock

Firebir, Firefox mention in nepal - is time for iceweasel

The next major change came with the release of Firebird browser. Mozilla changed the name of the browser from Phoenix to Firebird. This was done to avoid trademark issues with a company called Phoenix Technologies, which makes a browser of its own. After months of brainstorming, the Mozilla team rested on a new name, Firebird. However, the name Firebird had to be changed again later because Firebird was the name of an open source development project that makes a relational database.

http://www.gorkhapatra.org.np/content.php?nid=4493

.:(firebird):..:(databases):..:(sql):..:(firefox):..:(iceweasel):.

qemu powerpc cpuinfo

cat /proc/cpuinfo
processor : 0
cpu : 604
clock : 200MHz
revision : 0.0 (pvr 0004 0000)
bogomips : 494.79
machine : PReP Mesquite cPCI (MCP750)
l2 cache : none
simms : 0:144M

uname -a
Linux debianppc 2.4.27.001 #1 Tue Oct 27 00:32:19 EET 1970 ppc GNU/Linux

.:(firebird):..:(databases):..:(sql):..:(qemu):..:(debian):..:(powerpc):.

steps for porting on powerpc64

sudo apt-get install autoconf libtool g++-4.1 libreadline5-dev valgrind bison

checkout latest release version  (almost stable)
cvs -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird login
cvs -z3 -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird co -r B2_0_Release firebird2

implementation error (ppc is not defined)
../src/jrd/inf.cpp: In function 'int INF_database_info(const SCHAR*, SSHORT, SCHAR*, SSHORT)':
../src/jrd/inf.cpp:406: error: 'IMPLEMENTATION' was not declared in this scope


patch the src/jrd/common.h

--- src/jrd/common.h    2004-12-01 07:49:10.076214624 -0800
+++ src/jrd/common.h_ppc        2004-12-01 07:46:23.809196816 -0800
@@ -129,6 +129,11 @@
 #define IMPLEMENTATION  isc_info_db_impl_linux_amd64 /* 66  next higher unique number, See you later  */
 #endif

+#ifdef PPC64
+#define IMPLEMENTATION  isc_info_db_impl_linux_ppc64 /* 68 next higher unique number, See you later  */
+#endif
+
+
 #ifdef i386
 #define I386
 #define IMPLEMENTATION  isc_info_db_impl_i386 /* 60  next higher unique number, See you later  */


in src/jrd/inf_pub.h search for isc_info_db_impl_freebsd_amd64 and add 


        isc_info_db_impl_freebsd_amd64 = 67,
        isc_info_db_impl_linux_ppc64 = 68,


in src/jrd/pag.cpp search for CLASS_FREEBSD_AMD64 

and add new class

static const int CLASS_LINUX_PPC64 = 26;// LINUX  on PPC64

change CLASS_MAX to 

static const int CLASS_MAX = CLASS_LINUX_PPC64


add ArchitectureType in archMatrix (in our case BigEndian)

archBigEndian // CLASS_LINUX_PPC64

Define the const SSHORT CLASS after the AMD64 one 


#if defined LINUX && defined AMD64
const SSHORT CLASS              = CLASS_LINUX_AMD64;
#endif

in src/jrd/utl.cpp
search for  "Firebird/FreeBSD/amd64",   /* 67 */
and add 
 "Firebird/linux PPC64",     /* 68 */


in src/remote/xdr.cpp search for 
#elif defined(sparc) || defined(PowerPC)
and replace and add PPC64 define check 

#elif defined(sparc) || defined(PowerPC) || defined(PPC64)

change in the 
 gen/make.platform 
and add DEV_FLAGS=-DPPC64

it should look like this
DEV_FLAGS=-ggdb -DLINUX -pipe -MMD -p -fPIC -Wall -Wno-switch -DPPC64

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

compiling on an powerpc VM

I have started compiling firebird on an 32 bit powerpc emulated machine
here is the guide for installing debian on powepc (qemu)
is good to install dhcpd and vde interface
so you can work with ssh on the emulated machine

.:(firebird):..:(databases):..:(sql):..:(powerpc):..:(debian):..:(ubuntu):.

quote of the day from php source code

 /**
 * These aliases are provided in order to maintain forward compatibility. As Firebird
 * and InterBase are developed independently, functionality might be different between
 * the two branches in future versions.
 * Firebird users should use the aliases, so future InterBase-specific changes will
 * not affect their code
 */

you can browse firebird extension on php.net

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

building time on dual cores (amd athlon x2 4200+ am2)

Today i tested a new machine based on amd athlon x2 4200+ am2 with 1G of ddr2 4200 (@533Mhz) and 3x320G drives (it will have 4G of ddr2 in dual channel soon with max of 8G)
Motherboard is asus m2npv

here are the build times for firebird 2 rc5
cvs -z3 -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird co -r B2_0_Release firebird2
cd firebird2
./autogen.sh --prefix=/opt/firebird2 --enable-debug --enable-superserver
time make
real 4m38.617s
user 4m2.259s
sys 0m27.574s

cat /proc/cpuinfo
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 75
model name : AMD Athlon(tm) 64 X2 Dual Core Processor 4200+
stepping : 2
cpu MHz : 1000.000
cache size : 512 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt lm 3dnowext 3dnow pni cx16 lahf_lm cmp_legacy svm cr8legacy ts fid vid ttp tm stc
bogomips : 2007.24

processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 75
model name : AMD Athlon(tm) 64 X2 Dual Core Processor 4200+
stepping : 2
cpu MHz : 1000.000
cache size : 512 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt lm 3dnowext 3dnow pni cx16 lahf_lm cmp_legacy svm cr8legacy ts fid vid ttp tm stc
bogomips : 2007.24


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

booting netbsd on vax

Here is one howto
boot netbsd on an emulated vax machine , I wonder if firebird will work on it ;)
someday

.:(firebird):..:(databases):..:(sql):..:(vax):..:(bsd):..:(netbsd):.

firebird on other architectures (powerpc/arm/ultrasparc/s390)

I read the mips porting thread and here is the one thing to care when doing the port (besides code patches)

Alex Peshkov wrote:
As I see from your answer about cross-compilation, security.fdb in your
package is created by INTEL, not MIPS, binary. And, therefore, it can't
be opened on MIPS, which, I suppose, may have different endianness,
different alignment rules, etc. Therefore you must create security
database at MIPS box to have it usable. But to do it you must attach to
the server, and to attach you need security.fdb => dead lock.

Let's start from the simplest opportunity - do you have isql_static for
MIPS (it's created during normal BOOT_BUILD) ?


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

building firebird 2.0 rc5 on ubuntu edgyeft beta

I have just installed my ubuntu edgy and wanted to test the new machine
so i will show how i compiled it on it (32 bit system = sempron 2800+ )

sudo apt-get install autoconf libtool g++-4.1 libreadline5-dev valgrind bison
checkout latest release version (almost stable and soon will be officially)
cvs -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird login
cvs -z3 -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird co -r B2_0_Release firebird2
cd firebird2
./autogen.sh --prefix=/opt/firebird2 --enable-debug --enable-superserver
make
sudo make install
ps -ax | grep firebird
/opt/firebird2/bin/isql -u SYSDBA -p ********** /opt/firebird2/examples/empbuild/employee.fdb




.:(firebird):..:(databases):..:(ubuntu):..:(edgy):..:(edgyeft):.

big table google video presentation

You can watch the video presentation how bigtable based database is working for google.com
(inside view).
Another related paper (pdf) with bigtable info is located at google's labs

http://labs.google.com/papers/bigtable-osdi06.pdf

.:(firebird):..:(databases):..:(sql):..:(google):..:(bigtable):..:(clusters):.

Don't tell us that is Marina! - we sent her to indonesia

That is marina novikova ? Don't tell us that she is :)
Now is doing well in her dream trip
Firebird never looked so good

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

firebird rc4-5 soon

i submitted the news about rc4 and 5 on the bsdnews channel
I try to find new sites where to spread the word about firebird and new ways of doing pr (any wacky ideas are allowed)

.:(firebird):..:(databases):..:(sql):..:(bsd):..:(openbsd):..:(freebsd):.

Firebird Conference 2006 Initial Programme

..has been released on the Conference pages. It's a tightly-drawn selection of highly interesting topics with something for everyone. Notice that, this year, several papers will be presented on the Sunday afternoon, in advance of the Welcome session in the evening.

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

Firebird and phpbb 3.0

I tested the new phpbb 3.0 setup with firebird 1.5.3 and php 4.4.x
and almost i finished the creation of all the tables then it crashes at some point

A fatal and unrecoverable database error has occured. This may be because the specified user does not have appropriate rights to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.

install_install.php [ 1323 ]

SQL : INSERT INTO phpbb_modules (module_basename, module_enabled, module_display, parent_id, module_class, module_langname, module_mode, module_auth, left_id, right_id) VALUES ('attachments', 1, 1, NULL, 'acp', 'ACP_ATTACHMENT_SETTINGS', 'attach', 'acl_a_attach', 1, 2)

.:(firebird):..:(databases):..:(sql):..:(php):..:(phpbb):.

firebird client for ARM platform (KinterbasDB interface)

Hi,
following question was allready posted on firebird-support but no answer:

Se would like to connect our ARM based computers (Linksys NSLU2 with
the DebianSlug Linux) to the firebird database running on the server.
Is there a way how to compile linux Firebird (client ONLY!!!) for ARM
platform?

We are using Python and KinterbasDB Firebird interface, which runs
only, when the Firebird is installed on the machine.

Best regards

Petr Jakes on the firebird-python group


.:(firebird):..:(databases):..:(sql):..:(debian):..:(python):.

Can I install Firebird on Asus WL-HDD

Asus WL-HDD is an mipsel machine so with custom firmware (linux toolchain) it may be possible
to install firebird on it .
Here is the mipsel port status
http://www.firebirdnews.org/?p=559
Here is the request (thread)
http://wl500g.info/showthread.php?t=6502

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

Some books about distributed databases / systems (principles)

Here are the list of books i want to read these days (on my desk)

http://www.aw-bc.com/catalog/academic/product/0,1144,032131283X,00.html
http://www.aw-bc.com/catalog/academic/product/0,1144,0321263545,00.html
http://vig.prenhall.com/catalog/academic/product/1,4096,0130888931,00.html
http://www.amazon.com/gp/product/0136597076/sr=1-1/qid=1155718008/ref=sr_1_1/102-8280438-8944144?ie=UTF8&s=books

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