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

3372 questions
1
vote
2 answers

Firebird versions and returning value

I am trying to use kinterbasdb and Python 2.7 to write data to a Firebird database on a server, and print the key value of the added data. It works perfectly when I write to a local copy of the database. insert = """INSERT INTO myTable…
lemmyBarnet
  • 37
  • 7
1
vote
3 answers

Backup/Restore of Firebird SQL Server 3.0.2 is slow on Windows Server 2016

I have installed Firebird 3.0.2 SQL database on my Windows Server 2016. No other software has been installed yet. I'm using Superserver mode and an SSD drive. When I just copy my database file of size 6 GB, it is done in 20-30 seconds (same…
mojmir.novak
  • 1,346
  • 19
  • 28
1
vote
1 answer

FluentNHibernate Table DataTypes (different database vendors)

We have a situation where our production database is Firebird but would like to perform in-momory integration testing using SQLite. So far, the only problems we are encountering are differences in Data Types used by both databases. As an example,…
Hugusta
  • 135
  • 1
  • 4
1
vote
0 answers

Calculate row width

I have built a small tool like phpmyadmin for Firebird (2.5.1) in PHP, and I'm running into a few problems. Sometimes I'm dealing with large tables with a lot of columns, some are close to the 64K row width limit. Once I try to execute an ALTER…
Pantalaimon
  • 189
  • 10
1
vote
3 answers

How to select joined rows even if there is no match?

I checked so many similar questions but none apply to Firebird I guess. I have two tables; one stores the customer information and the second stores the stock activities (which also includes orders). I'd like to fetch all customers and the counts of…
Turab
  • 163
  • 10
1
vote
1 answer

What causes error "Procedure unknown"

So at my company we use a billing system which connects to a Firebird database that we have no back-end access to. I am quite new at this company so my familiarity with the Firebird database is not too great. We keep getting this error : ERROR:…
cclewis8104
  • 13
  • 3
1
vote
3 answers

Change default collation for Firebird database and tables

I have Firebird database with charset WIN1251. Database already has several tables. Now I want to change the default collation to WIN1251_UA. So I had execute this statement: ALTER CHARACTER SET WIN1251 SET DEFAULT COLLATION WIN1251_UA According to…
Evgeny
  • 3,605
  • 2
  • 15
  • 32
1
vote
1 answer

Solved: DBI cached statements gone and CGI::Session is stucked

I'm using Apache2.2(worker)/mod_perl 2.0.4/Apache::DBI/CGI::Session and Firebird RDBMS. I also wrote CGI::Session::Driver::firebird.pm to work with Firebird RDBMS. DB connection is pooled by Apache::DBI and give connection handle to CGI::Session…
Yasuto S
  • 19
  • 4
1
vote
1 answer

SQL sum multiple columns by multiple id

I'd like to sum a table by multiple columns and ids. My table (which is the join of 2 tables) looks like this: unique_ID, year, ID1, Amount1, ID2, Amount2, ID3, Amount3, ... , ID6, Amount6; I need to get the sum of amounts…
Jánosi Zoltán János
  • 51
  • 1
  • 7
1
vote
2 answers

Selecting rows from table based on resultset

I've been trying to work with languages in databases for a little while, but this one has me stumped. So here's the simplified structure of two tables DATA descID | descOriginal | deptID | Other Data -----------|--------------|-------…
Toine H
  • 232
  • 2
  • 11
1
vote
1 answer

SQL with nested CASE and joining strings gives trailing spaces

I am using Firebird 2.5. When I run SELECT CASE BILANCA WHEN 1 THEN CASE BILANCA WHEN 0 THEN 'SMALLINT' WHEN 1 THEN 'NUME' END ELSE 'A'||'B' END AS BILANCA1, CASE BILANCA WHEN 1 THEN CASE BILANCA WHEN 0 THEN 'SMALLINT' WHEN 1…
Daniel Vidić
  • 154
  • 1
  • 11
1
vote
1 answer

Empty "LIKE" query with non-Latin letters in Live Search with Firebird and Codeigniter

I am working on live search with jQuery UI autocomplete and CI 3.1.5. It works fine with MySQL, but with Firebird 1.5 I have an empty array. The problem is in my like query. Here is my code: public function get_autocomplete($search_data) { …
pa4o
  • 21
  • 1
  • 4
1
vote
1 answer

Getting the number of the issued SQL statements for a specific table

I am using firebird DB, and for testing reasons I want to know how many times a specific table has been accessed, without doing it manually with some counter in the code.
muaz
  • 368
  • 6
  • 10
1
vote
1 answer

Getting the length of a string in SQL

I'm trying to get the length of a string in SQL (using Firebird version 2.x+). Whenever I select the length of a string it gives me the actual assigned maximum length of that string as opposed to getting the length of how many of the characters are…
amko
  • 117
  • 3
  • 11
1
vote
1 answer

Fill Firebird column with incremental data using Flame Robin

I have a huge Firebird database with a table that counts 41 millions of rows. Recently I have added a new float column and would like to fill it with incremental data. Each next value should be a previous incremented by RAND(). The very first value…
Paul
  • 23,702
  • 36
  • 106
  • 215
1 2 3
…
99
100