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.