The second part of webinar, devoted to memory usage in Firebird . In this part, we discuss the optimal values for memory parameters in firebird.conf.
This webinar is devoted to memory usage in Firebird. In the first part of this webinar, we consider main memory types in operation systems, default distribution between them in Windows and Linux, and Firebird memory model.
If you’ve not seen usql before, it’s a universal command-line client for SQL databases , modeled on psql. usql makes it easy to work from the command-line, in a simple and consistent way across any database and on any platform (Windows, macOS, Linux). usql is written in Go, and provides things like syntax highlighting and compatibility with databases other than PostgreSQL
It does have support for Firebird SQL via GO driver
Only for Brazilians:
O 15º FDD acontecerá em Piracicaba – SP, no dia 18 de Agosto de 2018, e contará com a presença mais do que especial de Vlad Khorsun, um dos principais core developers do Firebird! Vlad é responsável pela implementação de alguns dos recursos mais interessantes e úteis do Firebird, como Execute Block, Global Temporary Tables, CTe – Common Table Expressions, além de aperfeiçoamentos no nBackup, execute statement, etc. Alexey Kovyazin, especialista em recuperação e otimização de bases de dados, estará mais uma vez presente além, é claro, de vários nomes da comunidade brasileira. A grade de palestras ainda não está completa, mas já é nítido que o assunto performance terá um grande foco nessa edição. Inscreva-se agora, garanta sua vaga e pague menos!
Lots happened in LibreOffice in May: new releases, events, a new Advisory Board member, a Bug Hunting Session, and more work on LibreOffice 6.1, due in early August! Check out our recap to learn more:
In this note we would like to inform you about running 6.7 million various tests for blobs. On our scale, it is a big testing. Usually we run each IBProvider update through 0.7 million tests.
Performing these 6.7 million tests in one thread would take 150 days. Parallel run in 10 threads reduced this time to 15 days.
We won’t bore you with details and will provide only key information.
Read full text: http://www.ibprovider.com/eng/news/n_180605-load_test.html
Steve Naidamast kindly sent me his personal review of my Firebird 3 Migration Guide. I’m more than happy to share it here:
The Migration Guide to Firebird 3.0 is an excellently written technical manual that is filled with all the essential information anyone wanting or needing to work with Firebird 3.0 (now 3.0.x) will require.
Though called a migration guide, this well designed manual provides far more information than simply being relegated to how to move between earlier versions of the Firebird Database Engine and the most recent version of this highly capable database system. As a result, far exceeding the discussion of moving between database systems, this guide provides thorough explanations in detail on the various, unique server types that Firebird offers and how to decide which one is the best option for the requirements at hand, the necessary security configurations for each type of server and how to define users and their associated roles, enhancements to the PSQL language (the SQL variation used by Firebird), discussions on physical access to the server (ie: wire protocols), connection string enhancements, and last but not least, discussion on the Firebird Embedded Database Engine for desktop application development, which has been upgraded from the current 2.5 version.
Though written from the perspective of the needs of a Database Administrator, this manual should be an addition to any professional’s library who is serious about working with Firebird for the long term.
It is by far one of the superior manuals I have read over the years on the subject of database systems. Such manuals should surely aid in the growth of the Firebird Community so that this database system can take its rightful place among the current standards of use in today’s database application development endeavors…
Sr. Software Engineer
Black Falcon Software
The Migration Guide to Firebird 3 is available both on paper and PDF formats.
The Lazarus team is glad to announce the release of Lazarus 1.8.4. This is a bugfix release.