I use Firebird exclusively, and recently I've moved from Linux to FreeBSD (well, I helped port Interbase to FreeBSD when it got open sourced).

I've been reading some Oracle docs on tuning ZFS for various database servers, and I'm hunting for a schema with a stored procedure that will cause a few hours of solely DB workload.

It'll need to: Programically fill lots of large tables to test. fragmentation and ZFS's copy-on-write behaviour. Perform heavy updates and deletes to test file garbage collection, And hopefully stress at least 16cores.

I wish to configure the ZFS layes with certain buffers, caches, ZIL drives and block sizes, run the test for a few hours, a few times, and document. Then make a change, and retest.

Does anyone have an example stores inventory / banking schema that they could release?

Hi everyone,

I read that firebird is not the best when using it remotely, and also the client i am working with is poorly optimized, but i wanted to ask if anyone has successfully used firebird 3 / 4 through a vpn connection.

I tried it out yesterday, and althought i have 3-5ms ping becase both client and server is almost the same location and both using gigabit up/down a single in the client still takes like 1-2 seconds to process over the wire.

Has anyone solved this, could firebird / vpn be optimized so its less than 1 second?

The db files are relatively small under 50mb each, and there would be only a single user using it.

I love its simplicity and but is very dificult to manager data at isql.

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?

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.

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.

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?

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"

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?

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?

​

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!

​