Picon

Just a few words about Firebird 3.0 performance.

Hello

First of all I wanted to say that my post has no intention to diminish the value of new Firebird version.
I was in Prague last year on Firebird conference (very nice event BTW) but even then there were doubts how
well FB 3 performs in comparision to FB 2.5. As far as I remember there were two presentations with examples
regarding perfromance and both were indeterminate - sometimes FB 2.5 behaved better or similar.

Few days ago I've decided tu put FB 3.0 under test on a real business application which is working for 24/7.

This application is reading data from PostgreSQL database (stored in JSON), parses the data, inserts it to
Firebird database and then scans the inserted data and inserts some additional information. (Proccess
of scanning the data must be separated from initial inserts).

Here are the tests results for 80000 records stored in PostgreSQL.

 |Test|2.5 CL 1 THR|2.5 CL 4 THR|2.5 SS 1 THR|2.5 SS 4 THR|3.0 CL 1 THR|3.0 CL 4 THR|3.0 SS 1 THR|3.0 SS 4 THR|
| Time(s)  |    201     |    285     |    169     |     107    |    221     |    321     |    216     |    112     |

How to read the tests: 

2.5 CL 1 THR - Firebird 2.5, Classic, 1 Thread.
3.0 SS 4 THR - Firebird 3.0, SuperServer, 4 Threads.

Tests were performed on 32 bit version and no configration changes has been made with one except:
CpuAffinityMask = 255

Tests were made on my dev machine, locally. I've had all unnecessary processes turned off. But these werent
a tests made with a "laboratory" precision. 
However I think you can see here some pattern which may suggest that tests are close to the reality.

(Continue reading)

Picon

Call for papers for Firebird Conference 2016

Hi All!

Call For Papers
Conference to be held at the Barcelo Praha Hotel, Prague, Czech Republic, on the 7th and 8th of October 2016.
The Firebird Foundation is seeking submissions from Firebird users and developers on the theme of "Firebird in the Enterprise". A session submission should have a title and at least 200 words outlining the main points of your talk.

A session will last for 50 minutes plus 10 minutes for turnaround and questions. If your talk takes more than a single session, then it should span multiple sessions. If your session is especially popular you may be asked to repeat it.

You can submit a session draft directly to conf <at> firebirdsql.org
If you have any questions also please contact conf <at> firebirdsql.org

Submissions must be made by the deadline of Midnight July 1st, 2016. Once received there will be a review of the submitted papers and authors will then be informed which papers have been accepted or rejected.

Publication of Papers (after the conference)

Each selected speaker will be expected to turn in a technical paper in electronic format for each abstract topic originally approved.

All illustrations and graphics pertaining to each paper must also be submitted. The papers should contain enough detail to enable a reader to fully understand the topic without benefit of a physical presentation. Speakers may also submit samples of code and/or presentation slides.

All accepted papers will be published electronically after the conference. By submitting materials to the Firebird conference, you grant the Firebird Foundation permission to use, reproduce, audio/video record and distribute your materials.

Regards,
Alexey Kovyazin
IBSurgeon



__._,_.___
Posted by: Alexey Kovyazin <ak <at> ib-aid.com>


Picon

Building Dashboards with FirebirdSQL

Hello,


I recently came across Dashbuilder.org , an open source project that allows you to build interactive Dashboards against  flat files and sql databases.  It does not currently officially support Firebrid, but after some trial and error I was guided by a dev on how to rebuild latest source so it would support Firebird as a datasource.  My initial testing is going well so far.   The only catch is that the repository used by my Dashbuilder install is another open source database not Firebird.  Hopefully the dev's will bake in Firebird support for datasource and possibly more.


Anyway, please check the demo out and  see for yourself.





__._,_.___
Posted by: lfeliz <at> yahoo.com


Picon

Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases



__._,_.___
Posted by: marius adrian popa <mapopa <at> gmail.com>


Picon

Jaybird 2.2.10 released

I have just released Jaybird 2.2.10.

The release can be downloaded from
http://www.firebirdsql.org/en/jdbc-driver/ or
https://github.com/FirebirdSQL/jaybird/releases/tag/v2.2.10

The release is also available on maven(*):

       <groupId>org.firebirdsql.jdbc</groupId>
       <artifactId>jaybird-jdkXX</artifactId>
       <version>2.2.10</version>

* The artifactId depends on your target Java version: jaybird-jdk18,
jaybird-jdk17, or jaybird-jdk16.

The following has been changed or fixed since Jaybird 2.2.9:

* Improvement: Transmit encrypted password (isc_dpb_password_enc and 
isc_spb_password_enc) in pure java protocol (JDBC-406)
* Improvement: Specify isc_tpb_lock_timeout in transaction mapping 
(JDBC-407)
* Fixed: DatabaseMetaData.supportsGetGeneratedKeys does not report real 
availability of generated keys feature (JDBC-412)
* Fixed: FBCachedClob throws SQLException instead of 
SQLFeatureNotSupportedException (JDBC-414)
* Fixed: Transaction mapping cannot be configured through JDBC URL 
(JDBC-421)
* Fixed: FBSQLWarning.getMessage() could return null instead of message 
(JDBC-423)

More information will be available in the release notes
at
http://www.firebirdsql.org/file/documentation/drivers_documentation/java/2.2.10/release_notes.html 
(as soon as I can upload them).

Kind regards,
Mark Rotteveel
--

-- 
Mark Rotteveel

------------------------------------
Posted by: Mark Rotteveel <mark <at> lawinegevaar.nl>
------------------------------------

Picon

Re: Firebird Language Reference 2.5 (English) Beta 1 (pdf) and (html).


I tried to post some comments and suggestions to the newsgroup 
gmane.comp.db.firebird.documentation yesterday.
I cannot see the post (using Mozilla Thunderbird) - is it held in 
quarantine, disposed of, rejected, or something else?
The latest posts I can see in the newsgroup are dated 02.02.2016.

--

-- 
Aage J.

------------------------------------
Posted by: Aage Johansen <aagjohan <at> online.no>
------------------------------------

Picon

New contender on Linux

Hi All,

What is your opinion from Firebird POV?

https://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux

Gabor

------------------------------------

------------------------------------

Picon

Firebird 3.0 RC2 packages for CentOS 7

First version of Centos7, RHEL7 Firebird 3.0 RC2 packages are here :
https://copr.fedorainfracloud.org/coprs/makowski/firebird/

I hope that it will help to have more testing before final release.

------------------------------------
Posted by: Philippe Makowski <pmakowski <at> ibphoenix.fr>
------------------------------------

Picon

Unable to connect to Firebird on Linux guest in VirtualBox.

Hello guys,

After many, many, many hours of trying I've decided to seek for help:)  My situation is like this:

I have host machine - Windows 7 and I have guest machine Ubuntu 15.10 installed on VirtualBox. Thanks to the help on this forum, I've managed to install Firebird on Ubuntu and connect to it.

Now I want to connect to Firebird from my host machine. To do this, I've tried two connection methods: NAT and Bridge (chosen from VB Settings). Bridge is not working for me at all (I can't establish connection between machines). So I am trying the NAT, and as far as I understand I need to make a port forwarding.
So I've made such forwarding:
Protocol: TCP, Host IP: 192.168.0.102, Host Port: 9999, Guest IP 10.0.2.16 Guest Port: 3050.

I am able to ping my host machine from guest. I am trying to connect via FlameRobin from my host machine like this: SYSDBA <at> 127.0.0.1/9999:/var/database/mydb.fdb and I am getting error: "unable to complete network request to host "127.0.0.1""

Could somone help me on this?

Thank you.




__._,_.___
Posted by: un_spoken <at> yahoo.co.uk


Picon

What’s new with Pi 3



What’s new with Pi 3? Onboard WiFi/Bluetooth, a new 64-bit quadcore processor, and 50% more processing power.


https://www.raspberrypi.org/blog/raspberry-pi-3-on-sale/




__._,_.___
Posted by: mapopa <at> gmail.com


Community email addresses:
  Post message: Firebird-general <at> yahoogroups.com
  Subscribe:    Firebird-general-subscribe <at> yahoogroups.com
  Unsubscribe:  Firebird-general-unsubscribe <at> yahoogroups.com
  List owner:   Firebird-general-owner <at> yahoogroups.com

Shortcut URL to this page:
  http://www.yahoogroups.com/community/Firebird-general




__,_._,___
Picon

Fw: [firebird-support] Problem installing ODBC driver on CentOS 7 linux





 
Hello all!

Please somebody help me with installing ODBC driver on CcentOS linux. I need it to make Sphinx work.


I followed Marius Popa's instructions, from FB main site: http://www.firebirdnews.org/howto-install-firebird-odbc-driver-for-unixodbc-from-source/

First i installed firebird-superserver, gcc-c++ and unixodbc packets...no problem here.

But when compiling the ODBC driver i get this error:

[root <at> pali2 Gcc.lin]# make -f makefile.linux
../makefile.environ:6: ARCH is x86_64
../makefile.environ:21: ODBCMANAGER is unixODBC in /usr/lib64
../makefile.environ:50: FBINCDIR is /usr/lib64/firebird/include
../makefile.environ:56: FBLIBDIR is /usr/lib64/firebird/lib
mkdir: cannot create directory ‘Release_x86_64’: File exists
make: [createdirs] Error 1 (ignored)
mkdir: cannot create directory ‘Release_x86_64/obj’: File exists
make: [createdirs] Error 1 (ignored)
g++ -w -D_REENTRANT -D_PTHREADS -DEXTERNAL -DunixODBC -I/usr/include -I/usr/lib64/firebird/include -I/include -I/usr/lib64/firebird/include -fPIC -m64 -DNDEBUG -c ../../IscDbc/Attachment.cpp -o Release_x86_64/obj/Attachment.o
In file included from ../../IscDbc/Attachment.cpp:35:0:
../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory
 #include <ibase.h>
                   ^
compilation terminated.
make: *** [Release_x86_64/obj/Attachment.o] Error 1



Then i tried another way:

I downloaded the ready-to-run version ODBC driver, from FB main site:
November 26, 2014 OdbcFb-LIB-2.0.3.154.i686.gz
1.0 MB
Linux x86 Library


I unzipped and copied it to /usr/lib/firebird/libOdbcFb.so

I also made 2 another copies because the provided odbc config referred to libOdbcJdbc.so and libOdbcJdbcS.so files, and i had none of them. I guess the compiler should create them.

(Note: First i tried with symlinks, but not working i created real copies. But also not working.)


Here are odbc configs:

[root <at> pali2 Gcc.lin]# cat /etc/odbcinst.ini

[Firebird]
Description = Firebird ODBC Driver
Driver = /usr/lib/firebird/libOdbcFb.so
Setup = /usr/lib/firebird/libOdbcJdbcS.so
Threading = 1
FileUsage = 1
CPTimeout =
CPReuse =


[root <at> pali2 Gcc.lin]# cat /etc/odbc.ini
[sample]
Description = Firebird
Driver = Firebird
Dbname = localhost:/data/sample.fdb
User = SYSDBA
Password = masterkey
Role =
CharacterSet = UTF8
ReadOnly = No
NoWait = No


When trying to connect i get this error:

[root <at> pali2 Gcc.lin]# isql -v sample
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/firebird/libOdbcJdbc.so' : file not found
[ISQL]ERROR: Could not SQLConnect

The /usr/lib/firebird/libOdbcJdbc.so file DOES EXIST.
On a forum i read that someone had the same issue and installing libstdc++ solved the problem.
But i had it installed before:

[root <at> pali2 Gcc.lin]# rpm -qa | grep libstdc++
libstdc++-4.8.5-4.el7.x86_64
libstdc++-devel-4.8.5-4.el7.x86_64




Here is my system's architecture:

[root <at> pali2 Gcc.lin]# uname -a
Linux pali2 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
 

Please help me!

Thank you,
Szilveszter



#yiv9807799491 -- #yiv9807799491ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv9807799491 #yiv9807799491ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv9807799491 #yiv9807799491ygrp-mkp #yiv9807799491hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv9807799491 #yiv9807799491ygrp-mkp #yiv9807799491ads { margin-bottom:10px;} #yiv9807799491 #yiv9807799491ygrp-mkp .yiv9807799491ad { padding:0 0;} #yiv9807799491 #yiv9807799491ygrp-mkp .yiv9807799491ad p { margin:0;} #yiv9807799491 #yiv9807799491ygrp-mkp .yiv9807799491ad a { color:#0000ff;text-decoration:none;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ygrp-lc { font-family:Arial;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ygrp-lc #yiv9807799491hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ygrp-lc .yiv9807799491ad { margin-bottom:10px;padding:0 0;} #yiv9807799491 #yiv9807799491actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv9807799491 #yiv9807799491activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv9807799491 #yiv9807799491activity span { font-weight:700;} #yiv9807799491 #yiv9807799491activity span:first-child { text-transform:uppercase;} #yiv9807799491 #yiv9807799491activity span a { color:#5085b6;text-decoration:none;} #yiv9807799491 #yiv9807799491activity span span { color:#ff7900;} #yiv9807799491 #yiv9807799491activity span .yiv9807799491underline { text-decoration:underline;} #yiv9807799491 .yiv9807799491attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv9807799491 .yiv9807799491attach div a { text-decoration:none;} #yiv9807799491 .yiv9807799491attach img { border:none;padding-right:5px;} #yiv9807799491 .yiv9807799491attach label { display:block;margin-bottom:5px;} #yiv9807799491 .yiv9807799491attach label a { text-decoration:none;} #yiv9807799491 blockquote { margin:0 0 0 4px;} #yiv9807799491 .yiv9807799491bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv9807799491 .yiv9807799491bold a { text-decoration:none;} #yiv9807799491 dd.yiv9807799491last p a { font-family:Verdana;font-weight:700;} #yiv9807799491 dd.yiv9807799491last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv9807799491 dd.yiv9807799491last p span.yiv9807799491yshortcuts { margin-right:0;} #yiv9807799491 div.yiv9807799491attach-table div div a { text-decoration:none;} #yiv9807799491 div.yiv9807799491attach-table { width:400px;} #yiv9807799491 div.yiv9807799491file-title a, #yiv9807799491 div.yiv9807799491file-title a:active, #yiv9807799491 div.yiv9807799491file-title a:hover, #yiv9807799491 div.yiv9807799491file-title a:visited { text-decoration:none;} #yiv9807799491 div.yiv9807799491photo-title a, #yiv9807799491 div.yiv9807799491photo-title a:active, #yiv9807799491 div.yiv9807799491photo-title a:hover, #yiv9807799491 div.yiv9807799491photo-title a:visited { text-decoration:none;} #yiv9807799491 div#yiv9807799491ygrp-mlmsg #yiv9807799491ygrp-msg p a span.yiv9807799491yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv9807799491 .yiv9807799491green { color:#628c2a;} #yiv9807799491 .yiv9807799491MsoNormal { margin:0 0 0 0;} #yiv9807799491 o { font-size:0;} #yiv9807799491 #yiv9807799491photos div { float:left;width:72px;} #yiv9807799491 #yiv9807799491photos div div { border:1px solid #666666;height:62px;overflow:hidden;width:62px;} #yiv9807799491 #yiv9807799491photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv9807799491 #yiv9807799491reco-category { font-size:77%;} #yiv9807799491 #yiv9807799491reco-desc { font-size:77%;} #yiv9807799491 .yiv9807799491replbq { margin:4px;} #yiv9807799491 #yiv9807799491ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv9807799491 #yiv9807799491ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv9807799491 #yiv9807799491ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv9807799491 #yiv9807799491ygrp-mlmsg select, #yiv9807799491 input, #yiv9807799491 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv9807799491 #yiv9807799491ygrp-mlmsg pre, #yiv9807799491 code { font:115% monospace;} #yiv9807799491 #yiv9807799491ygrp-mlmsg * { line-height:1.22em;} #yiv9807799491 #yiv9807799491ygrp-mlmsg #yiv9807799491logo { padding-bottom:10px;} #yiv9807799491 #yiv9807799491ygrp-msg p a { font-family:Verdana;} #yiv9807799491 #yiv9807799491ygrp-msg p#yiv9807799491attach-count span { color:#1E66AE;font-weight:700;} #yiv9807799491 #yiv9807799491ygrp-reco #yiv9807799491reco-head { color:#ff7900;font-weight:700;} #yiv9807799491 #yiv9807799491ygrp-reco { margin-bottom:20px;padding:0px;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ov li a { font-size:130%;text-decoration:none;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv9807799491 #yiv9807799491ygrp-sponsor #yiv9807799491ov ul { margin:0;padding:0 0 0 8px;} #yiv9807799491 #yiv9807799491ygrp-text { font-family:Georgia;} #yiv9807799491 #yiv9807799491ygrp-text p { margin:0 0 1em 0;} #yiv9807799491 #yiv9807799491ygrp-text tt { font-size:120%;} #yiv9807799491 #yiv9807799491ygrp-vital ul li:last-child { border-right:none !important;} #yiv9807799491




__._,_.___
Posted by: Nagy Szilveszter <nagy_szilveszter <at> yahoo.com>



Gmane