Category: General news

Management of Information Technology of the Federal Bailiff Service (FSSP) Russia announced a new phase of implementation of the free software and “import information technology” – the appearance of their own GNU / Linux distribution called GosLinux.

GosLinux distribution is based on CentOS 6.4 and created by “Soft Red” in 2013 after a win of the Russian company in the competition for revision, implementation and maintenance of automated information systems for FSSP Russia. In the server infrastructure of the territorial distribution of the FSSP Russia CentOS was used since 2012, and now all units bailiff service can use a specialized system, which received a FSTEC certificate at the end of March.

Among the major software components of the distribution used in the FSSP Russia, referred to the : Apache Tomcat application server and “Red Soft” database based on relational open source database Firebird.

And another article here
ps: Sorry for google translation

Vjacheslav V. Borisov wrote a tutorial on how to build and debug PDO Firebird driver :

I noticed that there is too many bugs open and too few developers who can
do the work.
And even this list is almost dead. Don’t know what is the cause of that,
but may be it is just hard to start ?
I recently written some patches for php – work, which I never done before.
And i can say, this really not so hard, if you know C/C++ (or at least
php?) and linux.
Most troublesome work is to setup build environment, so i decided to write
instruction how to patch, build and debug PHP extension, so may be more web
developers can contribute to php.

Leyne, Sean asked on Firebird-devel
(You can read in that thread the details about problem requirements and proposed solutions)

Consider a large database (200GB, large tables with 450 Million rows) which is running on a kick-a** server
with pool of enterprise SSDs for storage (more IOPS then Firebird could ever use), which I need to extract
data from on a regular basis throughout the day for use by an external BI system. During the business day,
the database is Live with over 300 connections active with 1 million+ DB transactions.

I need to extract the BI data as a true “snapshot” of data (ensuring FKs are valid), in as short a timeframe as possible.

Because runtime is critical, I want to break the extract process into logical pieces and run each piece is a
separate process/thread (with its own connection) (aka run in parallel).

Discussion was on kde.devel.calligra there is a need for Firebird driver implementation in Kexi in the future.

Any contributors for the new kexi driver ?

You can try to use the Firebird Database within LibreOffice which doesn’t need Java. This feature is still marked as experimental. Firebird Databases are available since LibreOffice 4.2. (see the release notes for further information

To turn the experimental features on, you have to go to the Settings –> LibreOffice –> Advanced –> “Enable experimental features” (see screenshot bellow)
Then you can uncheck the Java from the same Dialog.

There are few components written in Java if you use them :The Wizards, Report Builder, and Report Designer sub-components are written in Java. Full list of Java dependencies here.

Original question and source is on ask.libreoffice.org

To make Firebird Embedded default database in the new database dialog open Expert Configuration and change this key
org.openoffice.Office.DataAccess/EmbeddedDatabases/DefaultEmbeddedDatabase/Value to sdbc:embedded:firebird

Mark Rotteveel wrote on Firebird-java group:
I just published a snapshot of Jaybird 2.2.5 for testing.

Chris Krycho wrote: Setting up IntelliJ IDEA’s built-in database tools to work with FirebirdSQL requires a particular setup configuration, which I’m documenting here for public consumption.

From Amazon AWS console you can launch a ec2 free instance , in my case microinstance (if you don’t want to pay)

Push the button Launch instance AWS Marketplace : type Debian
and select the first one from the list (64 bits version)

Currently selected: t1.micro (up to 2 ECUs, 1 vCPUs, 0.613 GiB memory, EBS only)

Review configuration and push the launch button
with your keyfile generated for example firebird.pem you can now connect to it (initial ssh user is admin for Debian and ubuntu for Ubuntu instance)

ssh -i firebird.pem admin@ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com

after that you can continue to setup firebird on it with the new sudo powers
https://help.ubuntu.com/community/Firebird2.5

and then you can connect securely to it using a ssh tunnel (putty can be used on windows to create the tunnel)
http://mapopa.blogspot.ro/2010/11/securing-firebird-using-ssh-tunnel.html

firebird port is secure by default and is closed to outside world on debian/ubuntu it listens to localhost (127.0.0.1) only

I have updated the Building guide for Firebird Client on Android.
Now you can download and include in your native C/C++/Delphi/Pascal projects libfbclient.so.3.0.0
You can download from here:
http://mariuz.android-dev.ro/android_fbclient/libfbclient.so.3.0.0