Database trends survey (Embarcadero)
Marco Cantu posted in his blog:
…While most of the questions are on the choice and number of servers used (MS SQL Server being the most widely adopted, Oracle the most critical, and Firebird has a significant 4% 5.5% presence for large companies). Other questions are tuned for Embarcadero products (like evaluating the need for automating some DBA tasks). A few questions are interesting for their broad perspective, like those focused on the relationship between developers and DBAs…
Btw, interesting that there is no mention of Embarcadero’s Interbase in the survey results.
Howtoforge article: Perfect Database Server: Firebird 2.5 And FreeBSD 8.1
Here is the guide on installing Firebird 2.5 from FreeBSD 8.1 Ports and creating your first test database.
The article now is on howtoforge.com , please retweet 😉
Learning from bugs using together : list,distinct,case,extract weekday
Seems that the bug CORE-3302 is triggered when there are millions of rows and only in firebird 2.5 and 3.0 (Bug is already fixed in svn)
What you can learn from the bug is the usage of list,distinct,case,extract weekday in the same query
First i have created the query to extract the day in string format from current date
select
list(case extract(weekday from CURRENT_DATE) when 0 then 'Sun' when 1 then 'Mon' when 2 then 'Tue' when 3 then 'Wed' when 4 then 'Thu' when 5 then 'Fri' when 6 then 'Sat' end)
from RDB$DATABASE
In my case the result was Fri.
Then you can create a table with different dates:
CREATE table tasks
(
DATE_OF_TASK DATE
);
Populate the table
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-07');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-07');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-07');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-06');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-06');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-06');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-08');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-08');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-08');
Then start to run the query
select
list(distinct case extract(weekday from date_of_task) when 0 then 'Sun' when 1 then 'Mon' when 2 then 'Tue' when 3 then 'Wed' when 4 then 'Thu' when 5 then 'Fri' when 6 then 'Sat' end)
from tasks
Result should be:
Fri,Sat,Thu
Preferences Panel for Max OS X (10.6) testing
ranck.brun wrote to firebird-tools if you want to test a new tool Preferences Panel for Mac:
I’m writing a Preferences Panel for Max OS X (10.6) to control (local) Firebird server. It’s not perfect but you can contact me at lexxis[antispam]at[ANTISPAM]free.fr if you’re interest to test it.
Regards.
Using CMake to Install Firebird embedded on Linux and OS X
As described in previous posts deploying a program that uses an embedded copy of Firebird requires shipping some database server files. For Windows this can be done by the software that creates the installation package.
For Linux and OS X it is possible to use the CMake INSTALL command.
Testing boolean columns in Firebird 3.0
After the new year eve i wanted to test the new boolean columns in the new build that added them for firebird 3.0 , so i have created the columns and then inserted some random bool vaules for test after that i have started to test the bool expressions (and , or …) in a select from the new bool values.
ps: the select worked in isql-fb only , in flamerobin the datatype is not implemented yet (default from ubuntu 0.9.2)
Firebird SQL linkedin Community is now an open group
I am pleased to announce that, as the owner of this group, I have just switched us to an open discussion group. All future discussions will be fully visible, searchable, and shareable on the Web. All past discussions are now closed in a members-only archive. I look forward to our future discussions now joining the broader conversation of the wider Web.
Database Workbench 4.1 released
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
” Database Workbench 4.1.0 Pro ”
This release includes the FREE Lite versions for InterBase, Firebird
and MySQL.
Version 4 introduced full Unicode support, 4.1.0 adds new features,
latest DBMS support and improved functionality.
For more information, see here.
Click here for the full list of changes in v4.1
Database Workbench supports:
– Borland InterBase ( 4.x – XE )
– Firebird ( 1.x, 2.x )
– MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express )
– MySQL 4.x, 5.x
– Oracle Database ( 8i, 9i, 10g, 11g )
– Sybase SQL Anywhere ( 9, 10, 11 and 12 )
– NexusDB ( 3.0 and up )
The Perfect Database Server : Firebird 2.5 and FreeBSD 8.1
Here is the guide on installing Firebird 2.5 from FreeBSD 8.1 Ports and creating your first test database also we show you howto install Flamerobin GUI (administation tool) and the PHP driver for it .
This was tested on fresh freebsd 8.1 on a virtual machine