Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [firebird]

Firebird is a free and open-source, cross-platform, client-server SQL relational database management system, running on Linux, Unix, and Windows. Please mention your exact Firebird version when asking questions.

Firebird (Wikipedia) is an open-source SQL relational database management system (RDBMS) using the client-server model. It is cross-platform, running on Linux, Unix, and Windows.

It is written in C++, and is ultimately derived from the Borland InterBase 6.0 source code. Firebird is open-source, released under a non-copyleft MPL-like license. It is totally libre and free, for both open-source and commercial applications, but of course you can contribute back with code and donations to the Firebird Foundation.

Firebird and its predecessors have been in use for more than 30 years, which makes it a very mature and stable product.

Resources

Useful links

99 questions
18
votes
1 answer

Term for a one-row table?

Is there a specific term to describe a relation with a cardinality of one? I'm thinking particularly of RDBMS "special" one-row tables, for example, DUAL (Oracle), SYSIBM.SYSDUMMY1 (DB2, Derby) and RDB$DATABASE (Interbase, Firebird).
pilcrow
  • 360
  • 1
  • 6
12
votes
2 answers

Minimizing Indexed Reads with Complex Criteria

I'm optimizing a Firebird 2.5 database of work tickets. They're stored in a table declared as such: CREATE TABLE TICKETS ( TICKET_ID id PRIMARY KEY, JOB_ID id, ACTION_ID id, STATUS str256 DEFAULT 'Pending' ); I generally want to find the…
g.d.d.c
  • 251
  • 1
  • 5
9
votes
3 answers

Creating an index in both asc and desc directions

Over the past few weeks I've been raging against an old Firebird database. This database is crappy for all sorts of reasons, but one thing I noticed was that every single field of every single table has two indexes; each one with a single segment,…
Mark Henderson
  • 561
  • 4
  • 17
8
votes
1 answer

Firebird monitoring tables

I am working with a Firebird 2.1.1 database and I started reading about the Monitoring tables. I am trying to see somehow in real-time what queries does each client performs in the database. I had a look at the MON$STATEMENTS table but it does not…
Valentin Despa
  • 395
  • 1
  • 3
  • 9
8
votes
2 answers

Fixing corrupted Firebird database

I have a 200 GB Firebird database (created with Firebird 2.1.3, currently running 2.1.5), and it appears to be corrupted. When I try to do a backup I get: database file appears corrupt <> wrong page type page 0 is wrong type (expected 0 found…
Sergei Ousynin
  • 196
  • 1
  • 2
  • 9
8
votes
1 answer

Authentication error in Firebird 3.0

Today I though I'd give Firebird 3.0 a shot, but for some reason I can't seem to get it installed - at least not in a way that I can connect from a JDBC application. What I did was to follow this article. This is what…
user1822
7
votes
1 answer

Is it possible in Firebird to create a single index with ascending and descending columns?

For instance, something equivalent to CREATE INDEX Listing_Date_Idx ON ACTIVITY(Listing,Date_ DESC,Time_ DESC);
Alister
  • 173
  • 4
4
votes
1 answer

adjecency list model vs nested sets

I've stumbled upon an article describing nested sets model for storing hierarchical data and was quite intrigued by the supposed performance boost. after implementing this in our database, i've found that the adjecency list model performs far…
lordvlad
  • 147
  • 6
4
votes
2 answers

Improve performance with the WHERE NOT IN sub-select clause

In the following query, I have to count transactions for each customer. However, I have to exclude from the result set entirely, customers that have a transaction older than one year. Shouldn't the query optimizer be smart enough to only evaluate…
jcalfee314
  • 185
  • 1
  • 6
4
votes
1 answer

How do I check if a constraint exists on Firebird?

I'm about to publish a script which will update a lot of Firebird databases all at once. Some will not have this constraint, so I would like to check for the existence of a constraint before I try to drop it. ALTER TABLE PROCESS_CATEGORY DROP…
Jharwood
  • 805
  • 2
  • 11
  • 19
4
votes
1 answer

Problem with enabling System Audit (Firebird's Trace and Audit Services)

I would like to enable System Audit on my Firebird 2.5.9.27139 (x64) database (Windows 10), to inspect all queries performed on it. I've already read some docs about what the configuration file should look like, but most likely I have some trivial…
Adam Przedniczek
  • 143
  • 6
4
votes
1 answer

Firebird COUNT is very slow compared to SQLite

I am using Firebird for past few months and today a customer complained about performance issue. I checked into client's database and they had 167,77,216 rows in one table. So I made a clone of that table into another empty database and loaded with…
Core
  • 164
  • 9
3
votes
1 answer

How does the optimizer of Firebird determine join order?

As Most query optimizers determine join order via a dynamic programming algorithm pioneered by IBM's System R database project, I was wondering whether the optimizer of Firebird uses the same strategy? And is there any documentation I can refer to?
zli89
  • 917
  • 2
  • 11
  • 18
3
votes
3 answers

Why do I get this error "Statement failed, SQLSTATE = 08001"?

When ever I try to connect with Firebird SQL I get this error, firebird$ isql-fb 'db.FDB' -u SYSDBA -p Statement failed, SQLSTATE = 08001 I/O error during "open" operation for file "CAFW.FDB" -Error while trying to open file -Permission…
Evan Carroll
  • 65,432
  • 50
  • 254
  • 507
3
votes
1 answer

What is the difference between Interbase and Firebird?

I'm interested in a broad overview of how they are diverging and why.
Jack Douglas
  • 40,517
  • 16
  • 106
  • 178
1
2 3 4 5 6 7