Category: General news

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

Rodmap is updated with the following schedule:
Alpha 2 has been released in January 2014;
The next testing release (Beta 1) is expected in Q2 2014.
Unstable v3.0 builds can be downloaded from the snapshot area.
Use the “Track Details” icon to discover the list of tasks currently scheduled for v3.0 Beta 1.

From the Dashboard Beta Release: 31 of 63 issues resolved

New Flamerobin snapshot uploaded to Debian unstable with the following changes

  * use xz compression for snapshot source tarball
  * New upstream snapshot
     add support for more Firebird 3.0 reserved keywords
     ask before deleting unsaved changes to SQL files
  * switch to WxWidgets 3.0 (Closes: #742092)
    Thanks to Olly Betts for the patch and the testing

Firebird Perl driver version 1.18 is released with the following changes

• a bit more verbose ok() calls in 90-event-ithreads.t
• disable threaded event tests under AUTOMATED_TESTING
• Makefile.PL: check for ‘ibase.h’ presense in potential include dir
• allow empty (but still defined) DBI_PASS/ISC_PASSWORD for tests
• add support for FIREBIRD_DATABASE in tests’ environment
• adjust double tests to not fail with -Duselongdouble perl builds
• fix statement attr returns and rework 40-alltypes.t
• update installation notes wrt threaded perl and OpenSUSE
• add missing pointer initialization (RT#92821, Vadim Belov)
• dbd_st_finish: ignore “cursor already closed” error when closing the cursor
• dbd_st_execute: finish the statement if still active (RT#92810, HMBRAND)

Sometimes you can be very useful if the content of some tables are migrated to Firebird Excel.

Possibly most applications your users know how to use Excel then be easy for them and easy to make your own queries, view charts, etc.. The steps are: Install […]

Read the rest of this article (Spanish)

What is new in ER/Studio Data Architect Version 9.6.1

New DBMS Platform Support – Firebird

Firebird 2.x: Officially supports Firebird 2.1 and 2.5.

Firebird 1.5: Officially supports Firebird 1.5.

 

This tutorial explains how to create a sqitch – enabled Firebird project, use a VCS for deployment planning, and work with other developers to make sure changes remain in sync and in the proper order.

We’ll start by creating new project from scratch, a fictional antisocial networking site called Flipr. All examples use Git as the VCS and Firebird as the storage engine.

Author tells his story  on the blog first birthday:

When I launched, one year ago I did not knew if it would be read, if anyone is interested in what I had planned to write, but I thought it needed a blog in Castilian language to help us learn more about Firebird, because it is an engine very good data bases and documentation was missing in our language.

My expectations were not so high , I thought hopefully in a year could reach 10,000 visits and would consider myself very lucky and if reached 20,000 visits. Well, at this time and exceeded 116,000 visits so I am more than happy with the good reception that we have It’s really a very pleasant surprise.