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

NHibernate with Firebird... are these features enabled?

We're using NHibernate to great success with a Firebird backend. My question relates to the features available in NHibernate being supported by Firebird. If you have any expertise with Firebird and NHibernate your comments are welcome. Does…
Kotarsi
  • 81
  • 2
8
votes
4 answers

How do I use transactions in Firebird?

In MS SQL Server, I can easily put multiple insert statements into a transaction, like so: begin tran insert into mytable values (1, 2, 3) insert into mytable values (4, 5, 6) commit tran I'm trying to do the same thing in Firebird, but I can't…
Mason Wheeler
  • 82,511
  • 50
  • 270
  • 477
8
votes
3 answers

Firebird backup restore is frustrating, is there a way to avoid it?

I am using Firebird, but lately the database grows really seriously. There is really a lot of delete statements running, as well update/inserts, and the database file size grows really fast. After tons of deleting records the database size doesn't…
Yordan Yanakiev
  • 2,546
  • 3
  • 39
  • 88
8
votes
3 answers

Selecting Null in SQLAlchemy

I want to do the equivalent of SELECT * FROM (SELECT foo, bar FROM baz JOIN quux ON baz.id = quux.id UNION SELECT foo, NULL AS bar FROM baz) GROUP BY (foo, bar) HAVING foo = 'John Doe'; using sqlalchemy 0.6, but I can't seem to sneak that…
SingleNegationElimination
  • 151,563
  • 33
  • 264
  • 304
8
votes
3 answers

Why we haven't boolean datatype in Firebird?

Unless I'm totally wrong, we have no boolean datatype (1 bit) in Firebird, even SQL Server. Why? I think boolean usefull in various situations... And very low space consuption...
Alex
  • 3,325
  • 11
  • 52
  • 80
8
votes
2 answers

Size of a blob field in Firebird

Is there a way to retrieve (using a select statement) the size of a blob field in Firebird?? I've a field called "data" and I'd like to know the total size of all the records in the table. Thanks.
pablo
  • 6,392
  • 4
  • 42
  • 62
8
votes
2 answers

Entity Framework NullReferenceException calling ToList?

I'm very new to WPF and the EF, and I'm trying to display some data from a table in a datagrid. I've got the entity model pulled from an existing database and simple operations seem to work (getting row counts, using 'first'). I'm running against…
DaveK
  • 709
  • 7
  • 21
8
votes
1 answer

Simple Firebird query very slow

I have a table with roughly 246k records. It has about 25 columns, all are integers except one small blob. If I Query the table on all fields select a.recordid, a.editcount, ect.. from ARTrans a It executes in under a second. But if I include only…
cjmarques
  • 632
  • 1
  • 7
  • 17
8
votes
1 answer

How does suspend work in firebird?

I have a table t with one column i of type int, with a few rows. I want to loop over it. Of course, I can write a select query for this. But I am learning procedures and wrote a procedure, set term ^; create procedure qt returns(a int) as begin …
ericj
  • 2,138
  • 27
  • 44
8
votes
4 answers

Firebird Error while trying to create file, Permission denied

I'm trying to create a Firebird database in my home directory through Flamerobin however I always get *** IBPP::SQLException *** Context: Database::Create Message: isc_dsql_execute_immediate failed SQL Message : -902 Unsuccessful execution caused…
saimiris_devel
  • 667
  • 1
  • 6
  • 19
8
votes
1 answer

Is it possible to know the level from the last incremental backup, made with nbackup from Firebird?

It's a pretty straightforward question. Firebird has a backup tool called nbackup whereas you can make incremental backups. The tool complains if you don't make the backup in the correct order (e.g. you make a level 0 backup, then a level 2). Then,…
user1492491
8
votes
2 answers

Can't connect to local Firebird with ISQL

I'm trying to setup a local firebird instance to test against but am unable to connect to it with even ISQL. I have tried to following by following the quick start guide here: CONNECT ..\examples\empbuild\employee.fdb user SYSDBA password…
Luke Chamberlain
  • 430
  • 2
  • 5
  • 17
8
votes
4 answers

Firebird: Unable to complete network request to host

I'm trying to connect to a remote Firebird database "test" (alias already added). It is not an embedded server, and is installed on VM with IP 192.168.1.147. Here is my connection…
Colt
  • 134
  • 1
  • 1
  • 6
8
votes
1 answer

firebird user with granted privileges cannot access tables

I created a Firebird user (PIPPO) via jaybird, follows gsec "display": GSEC> di user name uid gid admin full name ------------------------------------------------------------------------------------------------ SYSDBA …
Gianluca Pasqualato
  • 135
  • 1
  • 1
  • 8
8
votes
8 answers

Simple multi-user database solution

I've written a Windows desktop application that works with Sqlite very nicely. It was a single user app, and the database sits right on the machine where the app runs. However, the application has grown, and now multiple users should be able to run…
Ben Mc
  • 2,038
  • 6
  • 30
  • 37
1 2 3
…
99 100