An open-source DBMS platform descended from Interbase.

learn more… | top users | synonyms

0
votes
1answer
45 views

Migrating data from Firebird to CSV on OSX

I have a .gdb Firebird database file that I would like to partially transform to .csv. From the CLI tool, I'm able to do the following: CONNECT "/Users/jpmonette/Desktop/file.gdb"; OUTPUT ...
0
votes
0answers
31 views

Firebird Cross Platform Blob Charset Issues

I developed a cross platform (win, mac, linux) application with Free Pascal Lazarus 1.4.4 and Firebird 2.5.1. To do this I compiled the application on the different platforms. For the database, ...
2
votes
1answer
50 views

how many cores uses gbak (firebird) on restoring?

I'm restoring db, and I see that firebird uses only one core of my CPU for gbak and fb_smb_server: Is it normally? I've 4 cores in my CPU. CpuAffinityMask parameter in firebird.conf is commented ...
0
votes
1answer
42 views

Get value from nearest (lower) integer

As jkavalik sais: I'm looking for "the greatest value not greater than". I have a table containing a kind of IDs and values like those ID value 101 A 2003 B 4005 C when searching for ...
0
votes
0answers
95 views

Firebird 2.5 - difference between starting with and = (equal) string searches

Background I have DB that was created on Windows, FB 2.5.0 (long ago). It was subsequently upgraded, over the years, to 2.5.4. Yesterday I wanted to test it on Ubuntu, which has FB 2.5.2 maintained ...
2
votes
1answer
45 views

Detect circular relations in a distribution table

I have the following two tables, that will define distribution rates from items on table A to other items on table A (I think I can say B defines a many-to-many relationship for A with itself). ...
0
votes
0answers
34 views

Getting historic Meta data in firebird

I have run a query and then commited it in firebird, but I cant see this query in monitoring tables (like MON$STATEMENTS). What should I do to see last running queries in monitoring tables? which ...
0
votes
1answer
837 views

How to GRANT/REVOKE user permissions for user on Firebird 1.5?

I need to create a user in firebird 1.5 and give him permissions to access only some specific tables. I have managed to create the user, but apparently GRANT/REVOKE operations only work on version 2.1 ...
0
votes
0answers
430 views

Firebird Guardian

Is there an opinion on running Firebird Guardian. According to the FAQ - The Firebird FAQ: On Windows, having guardian running can even be counter-productive as it would run fbserver.exe ...
2
votes
1answer
131 views

Join more than 3 tables in one single query, with many comparisons and no IDs

I use an overlycomplex and poorly designed software at my work, and now I need to produce a report of invoices issued between a period of time. Invoices are held at table ENTR2012, which uses the ...
1
vote
1answer
262 views

Firebird Index Creation Fails

I'm creating an index in a table with the following command: CREATE INDEX IDX_CVE_OBS ON FACTF01 (CVE_OBS); But it returns me the following error: this operation is not defined for system tables. ...
0
votes
1answer
247 views

Firebird linked tables in Access 2010

I have multiple data sources in multiple databases that I have been tasked with correlating for business analytics. I currently have ODBC connections to two (one Pervasive, one Firebird) that I can ...
1
vote
0answers
78 views

ExecuteNonQuery struck and control never come back to next line in vb.net with firebird

I am using vb.net with firebird 2.5. I have a grid which has 100,000 records have to insert/update in the database but as I run loop it stuck in ExecuteNonQuery statement. few lines work but after ...
1
vote
1answer
231 views

How to stop Firebird SuperClassic (run as application) in Win 7?

I run Firebird 2.5.3 SuperClassic as application in Windows 7 64-bit with this command: fb_inet_server -a -m Now, how can I stop/shutdown it from command prompt? I know that I could right-click its ...
1
vote
1answer
326 views

Can't restart or stop Firebird 1.5 on linux

I have an ubuntu server running firebird 1.5. It was working fine, but recently it started hanging (firebird does not respond anymore). Even when trying to restart or stop the server, it shows an ...
1
vote
1answer
3k views

Firebird 2.5. Windows 8.1. Can't connect to any database! Why?

I'm trying to use a FireBird database engine. OS: Windows 8.1 x64(SmartScreen enabled, UAC enabled, Custom AntiVirus installed(with firewall)) FireBird: Version 2.5, Installed as SuperServer, as ...
1
vote
0answers
205 views

firebird update very slow

I am writing a stored procedure for Firebird 2.5 in which I sometimes need to update a single row in a data table more than once in the same transaction. However, I have noticed that the performance ...
2
votes
1answer
196 views

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 ...
1
vote
1answer
234 views

How to deploy case-insensitive embedded firebird database?

I'm trying to find out how to create CI firebird embedded database. I've found (here) that there are some character sets each of them has one or many collations. So, UTF8 has UCS_BASIC, UNICODE and ...
1
vote
1answer
2k views

Using ODBC Connection to Access Firebird Database

I have an ODBC connection to a Firebird database that tests successfully. Is there a way to use this ODBC connection within SQL Server 2008 R2 to access the tables? I haven't used Linked Servers ...
1
vote
0answers
128 views

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 ...
2
votes
0answers
521 views

Firebird2.5 error with collation in POSITION

Why does the following query succeed in Firebird 2.1, but fail in Firebird 2.5? select POSITION(_UNICODE_FSS 'alcu' IN _UNICODE_FSS 'Calculation') from "Election" The error is Error: *** ...
1
vote
2answers
3k views

Why do I get this error?

When ever I try to connect with Firebird SQL I get this error, firebird$ isql-fb 'db.FDB' -u SYSDBA -p <PASS> Statement failed, SQLSTATE = 08001 I/O error during "open" operation for file ...
0
votes
1answer
1k views

row_number over partition at Version < Firebird 3

I´m currently at the end. Given facts: ID ID2 FROM TO COSTS 4985 501671 2013-07-25 00:00:00 2013-12-30 00:00:00 17.8 4985 501671 2013-09-05 00:00:00 ...
2
votes
0answers
51 views

Set default fields

Is there a way to inform the database that some fields are default (have always the same value) so that I don't need include them in all my queries? Suppose: Select ... where f1=a, f2=b, f3=c, f4=d ...
1
vote
1answer
326 views

Firebird query performance with text search, also some numbers

I have situation as follows: I'm having a table OFERTY of 10k+ records, and when I select * from it, I get PLAN (OFERTY NATURAL) Executing... Done. 656 fetches, 0 marks, 0 reads, 0 writes. 0 inserts, ...
2
votes
1answer
298 views

Set up Firebird with shared storage?

I am new to firebird and confused with SuperServer SuperClassic thing. But what i wonder is how should i set up this scenario on Linux? Single shared storage that store database file on SAN 4 ...
0
votes
2answers
1k views

Firebird-Time Interval- between 2 Dates

I try to select the period of employment for the members in a Company. Example: Date of join: 01.01.2001 Today: 27.02.2014 Now, I want this: 13 years, 1 month and 27 days I have a Statement which ...
2
votes
1answer
576 views

What is the difference between Interbase and Firebird?

I'm interested in a broad overview of how they are diverging and why.
1
vote
2answers
935 views

Is it possible to Install two (2) Firebird instances of different names & ports (gds_db port 3050 & fbsvc port 3051) running as service?

Is it possible to Install two (2) Firebird instances of different names & ports (gds_db port 3050 & fbsvc port 3051) running as service !? I mean the two running as service not application ...
2
votes
1answer
498 views

Firebird database recovery and protection

I'm sure many companies are running critical Firebird database servers in production 24/7. Other than regular backups, what backup/recovery/protection techniques are available? I am also interested in ...
0
votes
1answer
343 views

sort a large table by its primary key and save it back

So I have a large table (>50 million rows) with an auto incremented primary key column, which is filled by a script running on multiple cores. Now, when I do a SELECT, entries are returned 'out of ...
1
vote
2answers
2k views

Improve performance with the WHERE NOT IN sub-select clause

In the following query, I have to count transactions for each customer. [EDIT]However, I have to exclude from the result set entirely, customers that have a transaction older than one year. ...
3
votes
1answer
175 views

Minimizing Page Fetches

I have a complicated database structure and am trying to use it to retrieve Records based on multiple selection criteria from several tables. As a general rule, is it better to attempt to use ...
1
vote
0answers
356 views

Firebird database performance after server upgrade/restart

Got a 350 GB database (more than 40M records plus 0 - 1000 BLOBs for each record in another table). After upgrading Firebird to version 2.1.5 (mainly because of filesystem cache issue) database became ...
1
vote
1answer
2k views

how to set a column to fetch the date now?

hi i have a sample table named datenow and used the following to create my table on flamerobin to have a column that gets the date today automatically when an entry is added. CREATE TABLE "DATENOW" ( ...
2
votes
1answer
307 views

how to build table relationships in a firebird database?

I am a beginner in Delphi and I have a Firebird database with 2 tables namely masterlist and daily collection. I used Zeos 7.0.3 to access my Firebird database. My masterlist contains the following ...
1
vote
1answer
3k views

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 ...
1
vote
2answers
651 views

Storing a transaction sensitive constant in Firebird

I'd like to store a number in my Firebird database that indicates the revision of its structure. The number is supposed to be updated only when the structure has successfully been altered by some ...
5
votes
1answer
5k views

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 ...
6
votes
2answers
5k views

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 <> ...
10
votes
2answers
400 views

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 ...
7
votes
3answers
1k views

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 ...
5
votes
2answers
4k views

No luck trying out 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 ...
14
votes
1answer
311 views

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 ...