/r/firebird
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
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!
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.
Hi everyone, very much a rookie question here, just looking for advice.
My accounting package uses Firebird server. I would like to view (not edit) the contents of the database to create excel dashboards etc. with the data.
Is it as simple as adding an external data source in Excel? I asked the accounting company and they advised against it, saying it would break the database. Do you think they are correct?
Another project powered by Firebird is now being tested by the clients champion users, and they're loving the speed.
I simply love using Firebird for every storage solution I come up with - from tiny inventory systems for my shed, right up to Volunteer One, with hundreds of volunteers hooking simultaneously!!
Ive been using FB since the Interbase release, and I've never found a need to switch to anything else!
Thanks legends!
https://v l n t r . o n e/ - its not a link, as I'm not actually promoting it - just saying thanks. :)
if there is a better place to ask newbie question please point me there.
We have an app that uses FB in classic mode. local clients also open the app from the host, and corresponding Firebird database .
we run the database in classic mode.
backups on some machines can take up to 20 minutes.
everything about the database v4 is default bar selecting classic mode.
I am wondering about going super secret for multi threaded and also curious about what else can be done.
if anyone could point me at the right material or shed some light, it would be greatly appreciated.