/r/firebird

Photograph via snooOG

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.

Firebird Database related news / blogs

For support questions please use firebird support mailing list https://groups.google.com/g/firebird-support

/r/firebird

367 Subscribers

1

Error when use 1st time FlameRobin with FireBird

https://preview.redd.it/qaugyg59eayd1.png?width=555&format=png&auto=webp&s=c9521c19733d7735f2033b935b725f17de96f7a0

I tried use the command connect data base, create data base, create user, connect user, but without solution, what can I do?

0 Comments
2024/11/01
12:52 UTC

3

Firebird 3 on Linux - a nightmare ....

Since two days I have been trying to install FB3 on Linux Mint 22.
- There is almost no documentation available (at least none that I could find), no readme no nothing and that little bit I could find is hopelessly outdated or plain wrong.
- I am still not sure which variety and version (Apt Repo, deb or make) is more suitable resp. working.
- missing libs on the deb file - still did not find the proper version (again no doc!)
- Dealing with the proper chown chmod settings is simply try and error - again zero docs.
- cryptic error msg. on permission problems.
etc.etc. - I could write a book by now about this odyssey

This is a prime example of how a very good product goes down the drain due to lousy documentation.

I work with FB/IB since more than 20 years, mostly on Windows but after this experience I am seriously considering another DB.

If FB wants to increase its user base improving the documentation would be a first step in the right direction.

2 Comments
2024/10/25
16:57 UTC

1

Help extracting data from FireBird 2.5.2

Greetings!

I have a bit of a Hail-Mary request for help. I don't think there's a solution based on the info I can give, but thank you for taking the time to read.

I am trying to migrate an old database of records. The original software included a FireBird 2.5 installer and FlameRobin allows me to access the database tables and structure and run SQL against the data. So far, so good. I can see 90%+ of the data.

It's the last 10% that I can't get. When I open the relevant table in FlameRobin, I can see the ID, ORDER, DATE, and other information but the "NAME" filed is blank. A "NAME" field is used in tables that track other information, and I can see those clearly. The "NAME" in this one table doesn't show up. When I view the file in a text editor, I can see the values as text.

I've checked other tables to see if the ID references it there instead, but there is nothing close. I've also tried a few other FireBird to CSV programs without luck. Are there any oddities to how a text field might be stored in Firebird? Is it possible that it's encoded in a way that still makes it visible in Notepad++?

I'm using Firebird-2.5.9.27139_0_Win32.exe as my Firebird installer since it was the closest version on the download page.

Anyway, thanks again for any suggestions.

1 Comment
2024/10/24
19:20 UTC

3

I have firebird 2.5 and this issue

1 Comment
2024/10/03
06:22 UTC

2

Using Firebird 2.5.9 32-bit with Docker on Linux: Solutions for Manual Password Input Issues

Hi everyone,

I have a question. I need to use Firebird 2.5.9 32-bit, but I am a Linux user and want to know if it is possible to use Firebird 2.5.9 32-bit with Docker. I tried creating an image, but Firebird requires me to input a password manually. What should I do? Should I use Windows instead? What do you recommend?

0 Comments
2024/08/29
18:19 UTC

1

Erro

I'm having this problem when trying to generate a backup from the command line, can you help me fix it?

estou tendo este problema ao tentar gerar um backup na linha de comando, podem me ajudar a corrigir ?

gbak: ERRO:comprimento do buffer do segmento menor que o esperado

gbak: ERRO: gds_$get_segment falhou

gbak: ERRO: Saindo antes da conclusão devido a erros

Command used:

Comando utilizado:

C:\Windows\System32>cd "C:\Fortes\Firebird\Firebird_2_5\bin"

C:\Fortes\Firebird\Firebird_2_5\bin>set ISC_USER=sysdba

C:\Fortes\Firebird\Firebird_2_5\bin>set ISC_PASSWORD=masterkey

C:\Fortes\Firebird\Firebird_2_5\bin>gfix -v -f -i "C:\Users\vitor\OneDrive\Área de Trabalho\teste\AC.fdb"

Summary of validation errors

Number of Blob page errors : 1

Number of database page errors : 2

C:\Fortes\Firebird\Firebird_2_5\bin>gfix -m -f -i "C:\Users\vitor\OneDrive\Área de Trabalho\teste\AC.fdb"

Summary of validation errors

Number of Blob page errors : 1

Number of database page errors : 2

C:\Fortes\Firebird\Firebird_2_5\bin>gbak -b -g -l -z -v "C:\Users\vitor\OneDrive\Área de Trabalho\teste\AC.fdb" "C:\Users\vitor\OneDrive\Área de Trabalho\teste\AC.fbk"

0 Comments
2024/05/15
14:29 UTC

2

Firebird 2.5 over Wireguard VPN

Hi, have this cliente with an application running on LAN which database is Firebird 2.5. No problem at all.

Then we bring up an Wireguard so he can stop using RDP. He liked the way it worked but the speed over the VPN is extremely slow. Everything else is fast over the VPN, if I copy a file it reaches above 100Mbps, and the application is running great at LAN.

The application support doenst help, they say the system wasnt developed to be used that way, but I'm spending time on my own to try to make it work for my client.

Can I do anything?

7 Comments
2024/03/19
14:20 UTC

2

Connection over Windows network

Hi guys,

We habe one server in our network which is running a software which provides data to us by using a firebird connection.

How can I setup the odbc connection from an other server to my fdb?

server:c$:path/database.fdb or

server:share:/database.fdb both did not work

What do i have to specify as Database in my odbc setup?

0 Comments
2024/03/14
14:13 UTC

2

Firebird 4.0 with Python

Hi,

I have a software which was using Firebird 2.5 for years and we had some python scripts doing analytics with the data stored in .fdb files.

However, about two months ago the software was updated to Firebird 4.0 and we haven't been able to connect using fdb or firebird-driver.

We are even considering using another language which works with Firebird 4.0 at this point.

Could anyone recommend us a language or a package for Python that works with version 4.0?

Thanks!

1 Comment
2024/03/10
17:58 UTC

4

Allows overflows with Numeric and Decimal data types?

I'm a big fan of Firebird, and used it in many commercial applications. That's why it surprised me, when I discovered this today. 😬 Why does Firebird allow values greater than what the table schema allows?

For example, defining a column as numeric(5,2) or decimal(5,2) allows values like 1234.12

See this as a running example: https://dbfiddle.uk/czNoKM_v

Using dbfiddle, I can see other RDBMS don't allow that, and give a overflow error - which is what I would have expected from Firebird too, but doesn't.

1 Comment
2024/02/04
13:59 UTC

Back To Top