I did some testing of the new Firebird inline blob feature and the support in Jaybird that will materialize in Firebird 5.0.3 and Jaybird 5.0.8/6.0.2. In a very artificial test with blobs of 200 bytes, it resulted in a whopping 15,000-25,000% (yes, thousand!) increase in throughput (blobs read per second) compared to Jaybird 6.0.1 and even 30,000-45,000% compared against Jaybird 6.0.0.
This is a very exciting improvement!
Firebird had the best ending of any orchestral piece.
It feels good to finally make a new #release of another #OpenSource C++ library whose maintenance I've inherited: SOCI provides API for accessing different kinds of databases in the same way, see https://soci.sourceforge.net/ for more information and the announcement post (in which I've managed to make a typo, of course...) at
https://sourceforge.net/p/soci/mailman/message/59183493/ for the details about the changes in the latest version.
#CPlusPlus #Database #sqlite #PostgreSQL #Firebird #ODBC #Oracle
ANN: Database Workbench 6.7.0 released
- ability to view vector embeddings in PostgreSQL
- quick CSV import/export
- faster foreign key creation
- bugfixes in PostgreSQL, Firebird, InterBase and SQLite modules
https://www.upscene.com/news/item/20250425
#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench
Как я вуз автоматизировал
Здравствуйте. Меня зовут Андрей. Работаю я в государственном вузе. И, как водится, в такого рода учреждениях люди, которые занимаются компьютерами, занимаются ими в широком смысле слова. Хочу рассказать об одной самописной системе, которую мы используем уже очень давно. И о ее развитии (в другой статье).
I have just released Jaybird 6.0.1 and Jaybird 5.0.7 with a number of blob performance improvements. See also https://www.lawinegevaar.nl/firebird/jaybird_6.0.1_and_Jaybird_5.0.7_released.html
"LibreOffice Base and Firebird – a special relationship"
https://blog.documentfoundation.org/blog/2025/03/28/libreoffice-base-and-firebird-a-special-relationship/
(Translated from the Spanish original.) Juan C. Sanz writes: The Firebird database is distinguished by its unique features within the LibreOffice Base compatible database ecosystem. Why do I consider Firebird to be special? Because it is the only database engine that supports all possible forms of connection in Base and also allows the creation of […]
Video: Adding a foreign key constraint to an existing #SQLite table using Database Workbench.
https://www.youtube.com/watch?v=ZnFf4sj8jro
#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench
Video: Convert a #MySQL database to #PosgreSQL using Database Workbench.
#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench
Mark Rotteveel
Jeff
VZ
Upscene Productions
BCWHS
Habr