Stack Overflow
Stack Overflow

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

3750 questions
8
votes
2 answers

Firebird - database file shutdown error message

I have a problem with my Firebird database. The primary key of one of the tables is referenced by another table that was actually dropped earlier. So this reference from a non-existent table was causing errors when I try to make any changes in the…
zac
  • 4,495
  • 15
  • 62
  • 127
8
votes
18 answers

What do you think of Postgres and Firebird Databases?

I am trying to choose between postgre and firebird databasses. The database will be installed on a windows 2003 server with asp.net 3.5. i don't want to use sql server because of price issues and I don't want MySQL I had a bad experience with it and…
user161433
  • 4,419
  • 5
  • 32
  • 55
8
votes
3 answers

Is DataSnap Optimized for responding to more than 1k users at the same time?

We want to start a big multi-tier application. The server side application must respond to more than 1000 users at the same time. We want to create server application by 64 bit compiler and client side with 32 bit. In this case we don't know…
Shaahin Ashayeri
  • 918
  • 2
  • 13
  • 30
8
votes
3 answers

How to test for object existence in Firebird SQL?

I need to test whether various types of database objects exist in a given database, and I don't know how to formulate these tests in Firebird SQL. Each test has the form "Does object of type X with name Y exist?". For example, I need to test whether…
Paul Lalonde
  • 5,020
  • 2
  • 32
  • 35
8
votes
2 answers

How to optimize DELETE .. NOT IN .. SUBQUERY in Firebird

I've this kind of delete query: DELETE FROM SLAVE_TABLE WHERE ITEM_ID NOT IN (SELECT ITEM_ID FROM MASTER_TABLE) Are there any way to optimize this?
Harriv
  • 6,029
  • 6
  • 44
  • 76
8
votes
2 answers

Firebird SQL Statement to Get the Table Definition

I am writing my own Firebird database browser using the ibpp library. Is there a way I can get the table definition using an SQL statement?
Thomas Turner
  • 2,722
  • 1
  • 27
  • 23
7
votes
3 answers

Which version of Interbase or Firebird was a database created under?

I have a file with an extension .ib. I am guessing it is either an Interbase or a Firebird file, but I am having trouble working out exactly which. Furthermore, it isn't clear exactly which version of Interbase (or Firebird) was used to create the…
awmross
  • 3,789
  • 3
  • 38
  • 51
7
votes
2 answers

Full Text Search with Firebird and Delphi

I'm looking into implementing full text search on our Firebird database. Our requirements are: Every field in several tables should be indexed. When a result is found we should be able to find out the originating table. The index can be stored in…
norgepaul
  • 6,013
  • 4
  • 43
  • 76
7
votes
3 answers

Storing currency symbols in a database table

We are using Firebird as our database. How do we go about storing currency symbols in the database, which character set should we use or what is generally best practice? For example storing "$" or "¥" appears straight forward, but more complex…
Klondike
7
votes
5 answers

Firebird: DBExpress or native components?

I am starting with Firebird and have found components to access a database by Devart. They offer native components (IBDAC) or DBExpress drivers. (I am using Delphi XE2 Pro which doesn't include Firebird drivers) I guess native components are a bit…
Holgerwa
  • 3,430
  • 9
  • 42
  • 50
7
votes
2 answers

Firebird CASE statement inside stored procedure

I was trying to use the case statement inside a stored procedure but I got "Token unknown" on it. case is not supported in stored procedure? Thanks
zac
  • 4,495
  • 15
  • 62
  • 127
7
votes
3 answers

Why is my Firebird database so huge for the amount of data it's holding?

I've been playing around with database programming lately, and I noticed something a little bit alarming. I took a binary flat file saved in a proprietary, non-compressed format that holds several different types of records, built schemas to…
Mason Wheeler
  • 82,511
  • 50
  • 270
  • 477
7
votes
1 answer

How can I bind a Python list as a parameter in a custom query in SQLAlchemy and Firebird?

Environment I am using Firebird database with SQLAlchemy as ORM wrapper. Backgound I know that by using in_ it is possible to pass the sales_id list in IN clause and get the result. I have a use case where I must use textual sql. Question Here is my…
Niranj Rajasekaran
  • 740
  • 9
  • 20
7
votes
2 answers

SQL similar to regex, equivalents for start ^ and end $ of line

I want to use a regex like (^|\s)1001(\s|$) in a Firebird similar to expression: Examples: abc 1001 abc - true abc 121001 abc - false 1001 abc - true 121001 - false abc 1001 - true I try'd to convert it to a regex in…
smoothie
  • 93
  • 1
  • 6
7
votes
1 answer

FBRemoteEvent crashes app

I am having fb remote event with which I listen to database and I start it with my app load inside thread. When I run it on my Windows 10 (local pc) it works normally and perfect BUT when I run it on Windows Server 2003 it start filling RAM Memory a…
Aleksa Ristic
  • 2,394
  • 3
  • 23
  • 54
1 2 3
…
99 100