Firebird Friday Joke #9 - How to execute SQL query with isql in command prompt.
https://ib-aid.com/en/articles/how-to-execute-sql-command-with-isql-in-command-prompt/
https://ib-aid.com/en/articles/how-to-execute-sql-command-with-isql-in-command-prompt/
Did you do any actions to conform GDRP (DSGVO)?
Anonymous Poll
19%
Yes, I completed the quest
24%
It is in progress
16%
I am thinking to start
40%
No (Not needed/not related to me)
Firebird Friday Joke #9
How to force caching of Firebird database file into the file cache of OS
(please don't consider this joke as a recommendation to do it! It is a nice joke to try at your development machine)
https://ib-aid.com/en/articles/how-to-force-caching-of-firebird-database-to-file-cache-of-os/
How to force caching of Firebird database file into the file cache of OS
(please don't consider this joke as a recommendation to do it! It is a nice joke to try at your development machine)
https://ib-aid.com/en/articles/how-to-force-caching-of-firebird-database-to-file-cache-of-os/
✔Firebird recovery, optimization, and technical support.
✔HQbird - Firebird for big databases with replication, backups, monitoring, and optimization tools
✔HQbird - Firebird for big databases with replication, backups, monitoring, and optimization tools
How to force caching of Firebird database to file cache of OS
As you know, Firebird uses the file cache of OS intensively (especially important on Classic/SuperClassic), and on modern servers, we can often have a lot of RAM, so, potentially, the database file can be 100% cached in RAM.
So, how to force it?
So, how to force it?
Please indicate what Firebird Architecture and Version do you prefer?
Anonymous Poll
14%
1.5 - 2.5 SuperServer
8%
2.5 SuperClassic
12%
1.5 - 2.5 Classic
56%
3.0 SuperServer
4%
3.0 Classic
8%
3.0 SuperClassic
9%
Embedded (any version)
3%
Other
Firebird Friday Joke #10
So, another week passed, and time for another tip for Firebird.
Today the story is about undocumented switches for Firebird https://ib-aid.com/en/articles/how-to-enable-or-disable-connection-protocols-for-firebird-on-windows/
So, another week passed, and time for another tip for Firebird.
Today the story is about undocumented switches for Firebird https://ib-aid.com/en/articles/how-to-enable-or-disable-connection-protocols-for-firebird-on-windows/
✔Firebird recovery, optimization, and technical support.
✔HQbird - Firebird for big databases with replication, backups, monitoring, and optimization tools
✔HQbird - Firebird for big databases with replication, backups, monitoring, and optimization tools
How to enable or disable connection protocols for Firebird on Windows
Firebird on Windows has undocumented (yet) switches to enable and disable connection protocols.
Firebird Friday Joke #11
How to estimate number of records in the table using statistics value of the unique index
https://ib-aid.com/en/articles/how-to-estimate-number-of-records-in-the-table-using-statistics-value-of-the-unique-index/
How to estimate number of records in the table using statistics value of the unique index
https://ib-aid.com/en/articles/how-to-estimate-number-of-records-in-the-table-using-statistics-value-of-the-unique-index/
✔Firebird recovery, optimization, and technical support.
✔HQbird - Firebird for big databases with replication, backups, monitoring, and optimization tools
✔HQbird - Firebird for big databases with replication, backups, monitoring, and optimization tools
How to estimate number of records in the table using statistics value of the unique index
How to estimate the number of records in the table using the value of the statistics of the unique index
Hello All! Today will be no joke - we are working on very serious thing - new version of the collection of optimized configuration files for Firebird. to be released next week. Stay tuned!
Firebird Friday Joke #12
Hello All and good Friday for everyone! Hope everybody is well, and not infected neither by coronavirus nor by panic about it :)
Today we have an evil joke (dark times! dark jokes!) - how to inflate Firebird database with temporary blobs with speed 2-3Gb per minute (on SSD). Of course, just an example, don't run it on production databases!
Details and very evil sample code: https://ib-aid.com/en/articles/how-to-inflate-firebird-database-with-temporary-blobs/
Hello All and good Friday for everyone! Hope everybody is well, and not infected neither by coronavirus nor by panic about it :)
Today we have an evil joke (dark times! dark jokes!) - how to inflate Firebird database with temporary blobs with speed 2-3Gb per minute (on SSD). Of course, just an example, don't run it on production databases!
Details and very evil sample code: https://ib-aid.com/en/articles/how-to-inflate-firebird-database-with-temporary-blobs/
✔Firebird recovery, optimization, and technical support.
✔HQbird - Firebird for big databases with replication, backups, monitoring, and optimization tools
✔HQbird - Firebird for big databases with replication, backups, monitoring, and optimization tools
How to "inflate" Firebird database with temporary blobs
This is one of the don't-do-this article - just as an example. If you encounter the abnormal growth of your Firebird database, check that you did not write a stored procedure, trigger or execute block, which uses BLOBs concatenation.
Should we cancel Firebird Conference (preliminary is around October) in this year due to coronavirus? It was not announced yet, of course, just want your advice.
Anonymous Poll
32%
Cancel Conference
68%
No, let's do it!
Annual General Meeting of Firebird Foundation started today - there will be elections of FF Committee and President of FF.
Firebird Friday Joke #13
Todays's joke is devoted to the method how to speed up backup and restore from/to network server to the client machine with gbak using Services API.
In essence:
fbsvcmgr remotehost:service_mgr -user sysdba -password XXX \
action_backup -dbname some.fdb -bkp_file stdout >some.fbk
and to restore it:
fbsvcmgr remotehost:service_mgr -user sysdba -password XXX \
action_restore -dbname some.fdb -bkp_file stdin <some.fbk
Details are described in the document README.services_extension, #4 in the folder doc of your Firebird installation.
Todays's joke is devoted to the method how to speed up backup and restore from/to network server to the client machine with gbak using Services API.
In essence:
fbsvcmgr remotehost:service_mgr -user sysdba -password XXX \
action_backup -dbname some.fdb -bkp_file stdout >some.fbk
and to restore it:
fbsvcmgr remotehost:service_mgr -user sysdba -password XXX \
action_restore -dbname some.fdb -bkp_file stdin <some.fbk
Details are described in the document README.services_extension, #4 in the folder doc of your Firebird installation.
Just received very interesting case of data loss, related with the loss of database file due to phantom file problem on Linux.
In essence, administrator deleted old database file, when it had active connections - as a result, Firebird keeps the handle of deleted file and retains it from the actual deleting.
Then, administrator restored database under the same name, and enabled users to work. Obviously, new entered data went not to the new (visible) file, but to the deleted, because Firebird SuperServer retained the connection.
Such phantom file exists till the disconnect of the last Firebird user. Database worked several days in this state, but eventually all clients disconnected and Firebird server released the old deleted file.
After disconnect and reconnect, all data since restore were missing.
Classic case of using evil switch -rep in gbak? Of course, without backups?
Yes, but it has additional flavour: administrator did backup of the virtual machine each 4 hours, and was absolutely sure that it contains more or less actual version of the database file!
However, restored image does not contain deleted phantom file...
Conclusion: use true database backup for the databases, VM backup is for hipsters and marketing managers :)
In essence, administrator deleted old database file, when it had active connections - as a result, Firebird keeps the handle of deleted file and retains it from the actual deleting.
Then, administrator restored database under the same name, and enabled users to work. Obviously, new entered data went not to the new (visible) file, but to the deleted, because Firebird SuperServer retained the connection.
Such phantom file exists till the disconnect of the last Firebird user. Database worked several days in this state, but eventually all clients disconnected and Firebird server released the old deleted file.
After disconnect and reconnect, all data since restore were missing.
Classic case of using evil switch -rep in gbak? Of course, without backups?
Yes, but it has additional flavour: administrator did backup of the virtual machine each 4 hours, and was absolutely sure that it contains more or less actual version of the database file!
However, restored image does not contain deleted phantom file...
Conclusion: use true database backup for the databases, VM backup is for hipsters and marketing managers :)
What kind of backup do use for Firebird databases?
Anonymous Poll
81%
Verified backup with gbak.exe
15%
Incremental backup with nbackup.exe
3%
Backup of VM (with Veeam, etc)
10%
Simple copy of the database file
0%
Backups are for cowards :)
Continuing the story - VM backup was mounted in read-only mode and then the administrator used file undelete software. As a result, the database file was extracted from the image. It is corrupted (often case for VM backups and especially for deleted file), but FirstAID was able to extract corrupted data and merge them into the database file, so losses of data are minimized. Pretty good outcome of the very bad case!
nbackup with switch -D ON does not work on ZFS on Linux. More details here: https://ib-aid.com/en/articles/nbackup-with-switch-d-on-does-not-work-on-zfs/
Firebird Friday Joke #14
Today's joke is devoted to inserts, specifically - how to insert millions of different test records as fast as possible.
In the code example below, we can insert 1mln records in 5.6 seconds:
https://ib-aid.com/en/articles/how-to-quickly-fill-table-in-firebird-with-millions-of-records/
Today's joke is devoted to inserts, specifically - how to insert millions of different test records as fast as possible.
In the code example below, we can insert 1mln records in 5.6 seconds:
https://ib-aid.com/en/articles/how-to-quickly-fill-table-in-firebird-with-millions-of-records/
Please take a look at FirebirdSQL website at mobile phone
http://www.firebirdtest.com/
and provide some feedback to mail group firebird-website@lists.sourceforge.net
http://www.firebirdtest.com/
and provide some feedback to mail group firebird-website@lists.sourceforge.net
Home
Firebird: The true open source database for Windows, Linux, Mac OS X and more
Firebird SQL: The true open-source relational database
It is unbelievable how our world is tightly connected nowadays. Watching all these videos about disease and panic from China and Italy, I did not realize that Firebird technology can be somehow involved in it... However, one of the popular DNA sequencers models has the software backed by Firebird database and one of these databases from Chinese hospital which is directly involved in COVID investigations, was corrupted. It uses Firebird 1.5, old version, of course, but DNA device also was designed several years ago. They contacted us this morning, we started recovery immediately and were able to save available data. Now awaiting the feedback from the scientists. I hope it will help a bit...