Primary Database in Use – Firebird ?

Survey Results – Primary Database in Use on LewisC’s An Expert’s Guide To Oracle Technology

I’m starting to gather the data from my survey. When I get all the data gathered, I will post it as a downloadable file. Until then, I will post some summary data. This data shows the current PRIMARY database in use at the respondents companies. I find the data suspect and you’ll see why. This data has not been cleaned and duplicate IP addresses have not been removed. This is totally raw data and should remain suspect until after cleansing. Still, it is interesting.

Primary Database

Percentage

Respondents

Oracle

20.38%

65

DB2

5.96%

19

SQL Server

8.78%

28

MySQL

25.39%

81

Teradata

0.31%

1

Ingres

0.00%

0

Postgres

7.21%

23

SimpleDB

0.00%

0

Firebird

25.71%

82

LucidDB

0.00%

0

Vetica

0.00%

0

Sybase

0.63%

2

Netezza

0.31%

1

Access

0.31%

1

Excel

0.63%

2

xBase

0.63%

2

ADABAS

0.00%

0

Alpha 5

0.00%

0

Filemaker

0.00%

0

IMS

0.00%

0

Informix

0.63%

2

SQLite

0.63%

2

Paradox

0.00%

0

Progress

0.00%

0

Other

2.51%

8

I have serious doubts that Firebird is primary database at 25.71% of the respondents. I think I may find some duplicate IP Addresses with that answer. I’m not really surprised at the remainder of the answers though.

I also posted a summary of countries who answered and a few questions on open source software usage.

LewisC

ZEOSLib 6.6.3 – stable is out now

We are proud to officially announce the release of the ZEOS DBO Library 6.6.3 – stable

New packages of IBProvider Professional Edition came out

IBProvider v3 Release Candidate 3 [build 3.0.0.4963]

  • NUMERIC-types support was improved.
  • Disabled metadata cache mode performance was increased in 2.5 times.
  • Metadata schemes were updated. Among them in schemes TABLE_INFO and TABLES classification of external (EXTERNAL TABLE) and temporary tables (GLOBAL TEMPORARY PRESERVE/DELETE) was added starting from Firebird 2.1 and Interbase 7.5.
  • Correct processing of active transactions in the connection pool.

New build IBProvider v1.9.9.2547 and IBProvider v2.6.3.2547

  • BLOB-columns metadata description bug was fixed.
  • Correct processing of active transactions in the connection pool.

Details on the Firebird driver site.

Firebird has some funny ways of handling passwords

Firebird has some funny ways of handling passwords. The maximum length of passwords that is evaluated is 8 characters. Every character after the 8th is silently ignored. That’s especially funny because the ‘default’ password for a Firebird-installation is ‘masterkey’, which has 9 characters. You can, however, successfully log in to freshly installed Firebird-servers providing the password ‘masterke’.
I’m working with Interbase and Firebird for more than four years and just now realized that when a co-worker at our company found it out while learning SQL.
The only program that I know that makes note of that is gsec, which prints a warning when setting the password to something longer than 8 characters.

http://daniel-albuschat.blogspot.com/2008/04/passwords-in-firebird.html

[ED:Daniel is working on webkit based browser named arrora ]

Firebird and Suse

Since I helped Mandriva to do their packages for Firebird, I jumped and with Michal, we made things happen
Users of Opensuse 10.0,10.1,10.3 and future 11.0 but also SLE 10 can now just use the server:database repository  and get Firebird 2.0.4
As soon as the Firebird Project will publish Firebird 2.1.1, packages will be there too.

Second beta of Jaws 0.8.0

We are happy to announce the second beta of Jaws 0.8.0
(What we do in life echoes in eternity). And as you
know… this is a release which ‘should’ work better
than beta1 but NOT be used in production systems.

1 9 10 11 12 13 18