/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

345 Subscribers

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

2

ODBC in Excel

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?

1 Comment
2023/10/25
09:41 UTC

6

Thanks Firebird Team!

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. :)

2 Comments
2023/10/20
09:35 UTC

1

Minor Query on mode

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.

1 Comment
2023/09/09
19:47 UTC

1

Upgrading Firebird provider to Entity Framework Core 7 Youtube playlist

0 Comments
2023/08/30
21:53 UTC

Back To Top