Firebird News

Sunday, October 31, 2010

Installing Antico Light (QTDE is like LXDE but more "cute")

I found Antico Light a good and light wm based on qt (similar to lxde)
and is very easy to install (I have allready the qt related build tools)

git clone http://github.com/gustavosbarreto/antico.git
cd antico/
qmake 
sudo make install 

And now logout and choose the Antico session for WM and it will start in all it's glory

Did i mentioned that is very spartan and light ? 32M for all the wm , it's smaller than many gnome phat processes ... let's not talk about kde bloat


Friday, October 29, 2010

Using Firebird 2.5 official tar.gz installer on #Ubuntu Maverick Meerkat 10.10.10.10.10.10.10.10.10.10.10.10

get a old libstdc++5 from debian archives
in my case ubuntu is on 64 bit so i need amd64 (aka x86-64 and can be used even on Intel machines)
for 32 bit use the following link

you can determine you type of installation with
$ uname -m
x86_64

wget http://ftp.us.debian.org/debian/pool/main/g/gcc-3.3/libstdc++5_3.3.6-18_amd64.deb
sudo dpkg -i libstdc++5_3.3.6-18_amd64.deb

Download the Firebird tar.gz installer from Firebird 2.5 release page

The easiest way is to install FirebirdSS (aka Super Server)
in my case i choose the 64 bit version for Linux
wget http://downloads.sourceforge.net/project/firebird/firebird-linux-amd64/2.5-Release/FirebirdSS-2.5.0.26074-0.amd64.tar.gz

tar -zxvf FirebirdSS-2.5.0.26074-0.amd64.tar.gz
cd FirebirdSS-2.5.0.26074-0.amd64/


sudo ./install.sh

Firebird super 2.5.0.26074-0.amd64 Installation

Press Enter to start installation or ^C to abort
Extracting install data

Starting Firebird server: Please enter new password for SYSDBA user: SYSDBApassword
Install completed

(ignore the insserv warnings )

Now work withe the example database

/opt/firebird/bin/isql
SQL> connect "/opt/firebird/examples/empbuild/employee.fdb " user 'SYSDBA' password 'SYSDBApassword';
Database:  "/opt/firebird/examples/empbuild/employee.fdb ", User: SYSDBA
SQL> show tables;
       COUNTRY                                CUSTOMER                       
       DEPARTMENT                             EMPLOYEE                       
       EMPLOYEE_PROJECT                       JOB                            
       PROJECT                                PROJ_DEPT_BUDGET               
       SALARY_HISTORY                         SALES                          

SQL>

Next install flamerobin and you start working with your new shinny firebird server (create databasese ...)

sudo apt-get install flamerobin

SQL> CREATE DATABASE '/tmp/myshinnymetal*ss' user 'SYSDBA' password 'SYSDBApassword';
SQL> connect "/tmp/myshinnymetal*ss" user 'SYSDBA' password 'SYSDBApassword';
Database:  "/opt/firebird/examples/empbuild/employee.fdb", User: SYSDBA

Where #Firebird is better than #postgresql features included

I wanted to mention so will not forget when i will write a more extensive paper

1.Firebird required 0 Administration and is simpler to use than Postgresql
(think of sqlite like easy of use with oracle/postgresql like features)
I always hated the vacuum and complex installations for postgresql and yes
simplicity is a feature

See the postgresql features that they don't want (Scroll down to bottom)

2.Firebird does have Embedded mode and is fully multi threaded in 2.5

So yes i can build a single Firebird so/dll and put it on Android, Meego for example
and there is no need for a SuperServer , SuperClassic for it I just deploy it on the target device

3.And yes Firebird is fully multithreaded where Postgresql is NOT

so we are ahead in this area with at least 2 or more years

"All backends running as threads in a single process (not wanted)
This eliminates the process protection we get from the current setup. Thread creation is usually the same overhead as process creation on modern systems, so it seems unwise to use a pure threaded model, and MySQL and DB2 have demonstrated that threads introduce as many issues as they solve. Threading specific operations such as I/O, seq scans, and connection management has been discussed and will probably be implemented to enable specific performance features. Moving to a threaded engine would also require halting all other work on PostgreSQL for one to two years."

Tuesday, October 26, 2010

Now the benchmark results :Firebird 2.5 seems that clang++ is faster!

clean run , the old llvm results were when the system was under high load
now i have the clean results and seems that clang++ is faster

clean run

running on the g++ (compiled from source)

python ibench1.py --db_user=sysdba --db_password=masterkey
--db_name=/tmp/test.fdb --setup --max_rows=100000 --setup
#rows #seconds cum_ips last_ips #queries cum_qps last_qps
10000 39 257.5 257.5 1920 49.4 49.4
20000 117 171.6 128.6 5376 46.1 44.5
30000 230 130.6 88.4 10469 45.6 45.0
40000 366 109.3 73.4 16763 45.8 46.2
50000 509 98.2 69.7 24325 47.8 52.7
60000 663 90.5 65.2 31234 47.1 45.1
70000 832 84.1 59.1 37080 44.6 34.5
80000 998 80.2 60.2 42211 42.3 30.9
90000 1179 76.4 55.3 47324 40.1 28.3
100000 1372 72.9 51.7 52632 38.4 27.4
Done

clang++ clean

python ibench1.py --db_user=sysdba --db_password=masterkey
--db_name=/tmp/test.fdb --setup --max_rows=100000 --setup
#rows #seconds cum_ips last_ips #queries cum_qps last_qps
10000 30 338.9 338.9 1870 63.4 63.4
20000 91 219.3 162.1 5191 56.9 53.8
30000 179 167.2 113.3 10145 56.5 56.1
40000 294 136.1 87.4 16250 55.3 53.3
50000 469 106.6 57.1 23999 51.2 44.3
60000 639 93.9 58.8 30649 48.0 39.1
70000 798 87.7 62.9 36553 45.8 37.1
80000 957 83.6 63.0 41553 43.4 31.5
90000 1128 79.8 58.4 46852 41.5 30.9
100000 1301 76.9 58.0 51411 39.5 26.4
Done


clang++ fronm ubuntu 10.10

after each run i have run the following scripts

cat killall.sh
sudo killall -9 fbguard
sudo killall -9 fbserver
cat delete.sh
sudo rm -rf /opt/firebird2.5
sudo rm -rf /etc/init.d/firebird
cat config.sh
make clean
rm -rf gen
./configure --prefix=/opt/firebird2.5 --enable-superserver
--with-system-icu --with-system-editline

sudo make install

(in the firebird 2.5 from subversion tree)

ps:
make install doesn't work quite correctly in g++ and clang++ there are
some bugs on ubuntu 10.10
I have to CTRL-C the installer after i put the password , so i will
mark it as bug in jira for both compilers

Saturday, October 23, 2010

#Firebird on #Reactos

1. Firebird 2.5 Installer works !
2. fbserver it doesn't finds the msvcrt80.dll so i must investigate why
3. maybe a better idea is to compile it with mingw and skip the Microsoft crap

Wednesday, October 20, 2010

clang++ production tests (fbench) with Firebird 2.5 part two

I have ran a new set of benchmarks at Phillipe's suggestion (with some minor tweaks to the fbench script)
and all finished ok
sudo apt-get install python-configglue
sudo apt-get install python-configobj

svn co https://firebird.svn.sourceforge.net/svnroot/firebird/qa/trunk/benchmark/
cd benchmark/

cp fbenchdb.fbk /tmp/

Restore it with flamerobin or any other tool
in /tmp/fbenchdb.fdb

./fbenchrun.py /tmp/fbenchdb.fdb 
Database  /tmp/fbenchdb.fdb
Running ComputeClient 5x100000 . . . . . .
Running ComputeClientProxy 5x100000 . . . . . .
Running ComputeServer 5x1 . . . . . .
Running ComputeServerProxy 5x1 . . . . . .
Running ComputeServerProxyNofetch 5x1 . . . . . .
Running GeneratorClient 5x100000 . . . . . .
Running GeneratorClientProxy 5x100000 . . . . . .
Running GeneratorServer 5x1 . . . . . .
Running GeneratorServerProxy 5x1 . . . . . .
Running GeneratorServerProxyNofetch 5x1 . . . . . .
Running GeneratorTableClient 5x100000 . . . . . .
Running GeneratorTableClientProxy 5x100000 . . . . . .
Running GeneratorTableServer 5x1 . . . . . .
Running GeneratorTableServerProxy 5x1 . . . . . .
Running GeneratorTableServerProxyNofetch 5x1 . . . . . .
Calibrating Index2AndFilterAll ... set to  100  iterations.
Running Index2AndFilterAll 5x100 . . . . . .
Calibrating Index2AndFilterOne ... set to  100  iterations.
Running Index2AndFilterOne 5x100 . . . . . .
Calibrating Index2OrFilterAll ... set to  10  iterations.
Running Index2OrFilterAll 5x10 . . . . . .
Calibrating Index2OrFilterOne ... set to  100  iterations.
Running Index2OrFilterOne 5x100 . . . . . .
Calibrating Index3OrAndFilterAll ... set to  10  iterations.
Running Index3OrAndFilterAll 5x10 . . . . . .
Calibrating Index3OrAndFilterOne ... set to  100  iterations.
Running Index3OrAndFilterOne 5x100 . . . . . .
Calibrating IndexFilterAll ... set to  100  iterations.
Running IndexFilterAll 5x100 . . . . . .
Calibrating IndexFilterOne ... set to  100  iterations.
Running IndexFilterOne 5x100 . . . . . .
Calibrating JoinAll ... set to  1  iterations.
Running JoinAll 5x1 . . . . . .
Calibrating JoinOne ... set to  100  iterations.
Running JoinOne 5x100 . . . . . .
Calibrating NaturalFilterAll ... set to  1  iterations.
Running NaturalFilterAll 5x1 . . . . . .
Calibrating NaturalFilterOne ... set to  10  iterations.
Running NaturalFilterOne 5x10 . . . . . .
Calibrating NaturalFullAll ... set to  1  iterations.
Running NaturalFullAll 5x1 . . . . . .
Calibrating NaturalFullOne ... set to  100  iterations.
Running NaturalFullOne 5x100 . . . . . .
Calibrating OrderAll ... set to  1  iterations.
Running OrderAll 5x1 . . . . . .
Calibrating OrderOne ... set to  1  iterations.
Running OrderOne 5x1 . . . . . .
Calibrating SortAll ... set to  1  iterations.
Running SortAll 5x1 . . . . . .
Calibrating SortOne ... set to  1  iterations.
Running SortOne 5x1 . . . . . .

#OpenGL nehe lesson01 tip on #debian #ubuntu

Download the first lesson
Linux Code For This Lesson. ( Conversion by Richard Campbell )

mkdir lesson01
$ cd lesson01/
wget http://nehe.gamedev.net/data/lessons/linux/lesson01.tar.gz
tar -zxvf lesson01.tar.gz

sudo apt-get install freeglut3-dev
apt-get install libxmu-dev
apt-get install libxi-dev

make
./lesson1
you will get a beautiful beautiful black screen

press ESC
The webgl lesson is a little bit longer and tougher
http://learningwebgl.com/blog/?p=28

Tuesday, October 19, 2010

clang++ production tests with Firebird 2.5

Two good news and a bad one
I will start with the bad one , small bug in make install (I call it Stopping Firebird server forever on make install)

Seems that there is still bug while doing make install in
the Release 2.5 branch
./configure --prefix=/opt/firebird2.5 --enable-superserver --with-system-icu --with-system-editline
make install 
...
(cd ../gen/FirebirdSS-2.5.0.26107-0.amd64; FIREBIRD= ./install.sh)

Firebird super 2.5.0.26107-0.amd64 Installation

Press Enter to start installation or ^C to abort
Extracting install data
Stopping Firebird server: Stopping Firebird server: Stopping Firebird
server: Stopping Firebird server: Stopping Firebird server: Stopping
Firebird server: Stopping Firebird server: Stopping Firebird server:
Stopping Firebird server: ^Cmake[2]: *** [install] Interrupt
make[1]: *** [install] Interrupt
make: *** [install] Interrupt

2. I checket out the 2.5 branch and all compiles fine and installs somehow (password is ok)
and i can start the super server with /etc/init.d/firebird script after i press ctrl-C
on make install
Here are some entries from the log (while installing the super server)


borkstationx64 (Client) Tue Oct 19 15:20:32 2010
/opt/firebird2.5/bin/fbguard: guardian starting
/opt/firebird2.5/bin/fbserver
borkstationx64 (Server) Tue Oct 19 15:20:32 2010
Database: /opt/firebird2.5/security2.fdb
Can't access lock files' directory ../gen/firebird
borkstationx64 (Client) Tue Oct 19 15:20:32 2010
/opt/firebird2.5/bin/fbguard: /opt/firebird2.5/bin/fbserver
terminated due to startup error (2)
borkstationx64 (Client) Tue Oct 19 15:20:38 2010
INET/inet_error: connect errno = 111

3.the firebird tests are running (for about a few hours) and all sems
to be fine ! I was expecting some errors any errors but all seems to be fine as you will see from bellow numbers (I will test/show the g++ vs clang++ numbers later)
Database was created with flamerobin in /tmp/test.fdb
and then i have installed kinterbasdb 3.3.x

wget http://www.firebirdsql.org/download/rabbits/pmakowski/ibench1.py
python ibench1.py --db_user=sysdba --db_password=masterkey --db_name=/tmp/test.fdb --setup
#rows #seconds cum_ips last_ips #queries cum_qps last_qps

10000 56 179.4 179.4 2210 39.7 39.7
20000 136 147.1 124.7 5525 40.6 41.3
30000 250 119.9 87.5 10592 42.3 44.3
40000 399 100.4 67.4 16841 42.3 42.1
50000 551 90.7 65.4 23991 43.5 46.8
60000 708 84.7 63.7 30445 43.0 41.1
70000 866 80.8 63.5 35920 41.5 34.8
80000 1038 77.1 58.2 41111 39.6 30.2
90000 1217 73.9 55.7 46142 37.9 28.0
100000 1408 71.0 52.4 51142 36.3 26.2
110000 1607 68.4 50.2 55951 34.8 24.2
120000 1803 66.5 51.0 60282 33.4 22.1
130000 2000 65.0 50.9 64400 32.2 21.0
140000 2212 63.3 47.2 68577 31.0 19.7
150000 2414 62.1 49.3 71987 29.8 16.8
160000 2625 61.0 47.5 75301 28.7 15.8
170000 2830 60.1 48.7 78098 27.6 13.6
..........................................................



I will run the other set of tests fbtcs, and the ones from qa

Monday, October 18, 2010

clang++ compiling successful experiments with Firebird 2.5

I started playing with clang and Firebird sourcecode in a lunchbreak
on Lubuntu 10.10 amd64
If you wonder why seems to be a faster compiler and anyway is good to test the code in at least two modern compilers

The results are impressive : i mean i didn't expecting that clang++ to be so advanced that my Firebird 2.5 compilation finished in the end resulting in working binaries for Firebird 2.5

Read the full thread on Firebird-devel , on small patches needed to get it on .

See my screenshot with flamerobin (compiled with g++) connecting to just compiled Firebird 2.5 with clang++



ps: I like the error message , they look more human readable than the ones from g++ (colored)
Update: compilation works by default now if you use B2_5_Release Branch of Firebird
svn co https://firebird.svn.sourceforge.net/svnroot/firebird/firebird/branches/B2_5_Release firebird_2_5_Release

cd firebird_2_5_Release

./autogen.sh --prefix=/opt/firebird2.5 --enable-superserver --with-system-icu --with-system-editline

export CXX="clang++"

make

Saturday, October 16, 2010

Playing safe doesn't make you a good player #IBM #Java #Cobol

This is my state of mind , you know IBM played safe with joining Oracle in their quest of COBOLisation of Java , in fact they are the COBOL in Java
you know :xml , and all the crappy 7 layers of bloatware   you can throw at it
swing and other swt ....

You know maybe they just don't care about the mobile space after all ...
The retarded t-rex (mainframe) doesn't care about the small mamals like Androids



it's just stoned in stone like a an ancient relic of an ancient past with big letters engraved on it's grave
It's just doesn't care about the modern civilization and of course it doesn't care about the Star Trek



All it cares is about COBOL the big evolution's mistake

http://www.infoworld.com/d/developer-world/java-becoming-new-cobol-204
"That deal ultimately went south when Sun refused to consider any deal that IBM wouldn't promise to carry to completion, even in the face of regulatory roadblocks sure to come up. Many of us breathed a sigh of relief; if there's any Java company even more firmly stuck in the old world than Sun, it's IBM...and we weren't looking forward to dealing with that."

http://blog.headius.com/2010/08/my-thoughts-on-oracle-v-google.html

it' doesn't care about your opengl , games ... all it needs to rest in peace is COBOL and JAVA and the three fingers salute XML engraved on the black immortal business (evil) soul
http://harmful.cat-v.org/software/java

And xml was invented to replace text files and just to suck at at
http://www.c2.com/cgi/wiki?XmlSucks

Some of the good things made by IBM corporation in the past ...
http://www.ibmandtheholocaust.com/excerpts.php

Thursday, October 14, 2010

html5 is here and ready , thanks microsoft we don't want silvercrapware or DRM !

Philippe Le Hégaret seems to be payed by Microsoft :
he seems to work on  xml crapware tracks on w3c (you see the dots: office open xml , odt , word ... ?) and he want's let me put it this way to NOT use w3c standards like html5 and you wonder why ?
because he want's that we should use DRM ? and silverlight instead of html5 video in youtube
and his reasoning is that html5 is not ready for Microsoft maybe ?

http://blog.grahamlicence.co.uk/post/Hold-off!-HTML5-is-Ready.aspx
and here another response to the FUD
http://joshuakehn.com/blog/view/20/W3C-Holding-off-on-HTML5
and more from smarter people than me
http://remy.tumblr.com/post/1261575750/hold-off-on-deploying-html5-in-websites

only microsft shills use the word "interoperability" when they say that something must work only on windows platforms the rest of the world doesn't need "interoperability" because your website will just work on mac, linux , haikuos ... only microsft wants te be incompatible with itself

http://www.infoworld.com/print/140041
From my point of view is the most retarded attack html5 from Microsoft part

IE6 is f**ing dead already what he is smoking and i wonder what is his salary at Microsoft
"We're not going to retire Flash anytime soon," Le Hegaret said. It will take years before all Web clients support HTML5, he said. He cited Microsoft's IE6 browser as an example of popular client not supporting the standard. "IE6 is still being used on the Web today, and it is 10 years old."

http://ie6funeral.com/

Tuesday, October 12, 2010

#MySQL price hikes reveal depth of #Oracle 's wallet ,Time for #Firebird?

These emails promise "changes to MySQL's pricing and possibly pricing model soon," with a further stealth price increase in the form of removal of MySQL's Basic and Silver support options.

Here is the Oracle letter in its entirety:

http://www.theregister.co.uk/2010/10/08/oracle_jacking_up_mysql_prices/

Sunday, October 10, 2010

webgl lesson 0 finished

Now it's easier to get your browser up to learn webgl
http://learningwebgl.com/blog/?p=11.
webgl is enabled by deafault in chrome (devel) and firefox beta

The biggest news is that the Mozilla and Chrome teams have turned WebGL on by default in their latest beta builds, for versions 4 and 7 respectively


http://learningwebgl.com/blog/?p=2611

mindthebird_press_release_ro

Firebird 2.5 introduce noi facilităţi de audit şi scalabilitate îmbunătăţită.

 

4 Octobrie 2010

 

Proiectul Firebird anunţă astăzi Firebird 2.5, a cincea şi cea mai recentă versiune majoră a sistemului relational de gestiune a bazelor de date open source. Îmbunătăţirile acestei versiuni vizează o mai bună scalare la nevoile afacerii pe care o serveşte, de la dispozitive embedded până la soluţii complexe ERP.

 

Philippe Makowski, preşedintele fundaţiei non-profit Firebird a remarcat că  lansarea versiunii Firebird 2.5 constituie un pas foarte important în anul în care aniversăm 10 ani de Firebird, nu numai pentru  proiectul Firebird, dar şi pentru lumea open source deopotrivă.

 

"Afacerile de astăzi au nevoie de o soluţie matură pentru un cost eficient iar Firebird 2.5 le oferă soluţia, atât cu adevărat puternică cât şi cu sub licenţă cu adevărat liberă", a precizat Philippe Makowski.

 

Îmbinarea de performanţă ridicată, amprenta mică de memorie, scalabilitate supremă, instalare simplă şi facilă şi licenţa de utilizare şi distribuţie liberă transformă Firebird în alegerea cea mai atractivă pentru orice fel de dezvoltatori sau integratori de software. Există astăzi instalări de Firebird în număr mare la nivel global ce servesc volume de date care depăşesc curent 300GB pentru sute de mii de sisteme pentru afaceri.

 

Instalările cunoscute de Firebird numără mai mult de 2000 pe zi, după cum confirmă statisticile de  descărcare.

 

"Majoritatea clienţilor noştri au baze date Firebird cu mărimi cuprinse între 200GB şi 400GB care continuă să crească", declară Stewart Spink, CTO la Watermark Software. "Îmbunătăţirile de performanţă din versiunea Firebird 2.5 ne asigură că cererinţele lor viitoare vor fi complet satisfăcute."

 

Alexander Shaposhnikov, CIO la distribuitorul Profitmed estimează că Firebird 2.5 va suporta cerinţele în continuă ale afacerii Profitmed. "Acum avem o bază de date de 65GB şi 250 conexiuni concurente active 24x7. Ne aşteptăm să dublăm atât mărimea bazei de date cât şi numărul de utilizatori în următorii doi ani şi am ales Firebird 2.5 pentru acestă misiune critică pentru afacere."

 

Distribuţii Firebird binare sunt disponibile pentru o largă varietate de platforme hardware şi sisteme: Windows, Linux, MacOS, Solaris, HP-UX şi altele. Firebird rulează pe x86, x64, PowerPC, Sparc şi alte platforme hardware, oferind posibilitătea de a migra uşor între diverse platforme.

 

Distribuţiile binare versiunea 2.5 sunt disponibile pentru platforme 32-bit şi 64-bit pentru Windows şi Linux, urmate în curând de cea pentru MacOSX x86.  În funcţie de cerere, versiuni binare pentru alte platforme POSIX vor fi disponibile până la finele acestui an.

 

Facilităţi noi în Firebird 2.5

 

    * Prin SuperClassic Firebird 2.5 introduce o nouă arhitectură denumită "SuperClassic", destinată exploatării eficiente a platformelor multicore şi multiprocesor care asigură o utilizare judicioasă a resurselor pe sisteme cu baze de date mari şi mulţi utilizatori concurenţi.

 

    * Auditarea sistemului, sesiunilor şi utilizatorilor prin interfaţa API oferă posibilitatea monitorizării a tot ce se întâmplă în baza de date aproape în timp real.

 

    * Interogările peste mai multe baze de date din Firebird 2.5 oferă posibilitatea mai multor instanţe de baze de date Firebird să se interogheze reciproc şi să schimbe eficient date.

 

    * Managementul îmbunătăţit al utilizatorilor este acum accesibil prin comenzi SQL transmise din baza de date de securitate.

 

    * Alte facilităţi incluse : Tranzacţii autonome permise în interiorul modulelor PSQL (proceduri stocate, triggere, blocuri SQL), suport pentru expresii ca argument în SQL utilizând predicatul  SIMILAR TO, închiderea asincronă a unei conexiuni, îmbunătăţiri ale capabilităţilor de monitorizare şi multe altele.

 

Paul Beach, preşedinte şi CEO la IBPhoenix, una din organizaţiile care oferă servicii profesionale şi contribuie la dezvoltarea Firebird, consideră că noile facilităţi de securitate şi capabilităţile impresionate de scalare Firebird 2.5 vor fi binevenite şi bine primite de majoritatea utilizatorilor curenţi de Firebird.

 

"In particular, aceste facilităţi vor fi de mare sprijin în întâmpinarea cerinţelor în continuă creştere din verticalele finanţe şi sănătate.", a precizat, "în special în a forţa limitele performanţei."

 

David Wilder, CTO la Bas-X, a salutat versiunea Firebird 2.5 pentru disponibilitatea şi flexibilitatea îmbunătăţite. "Va permite clienţilor noştri un număr crescut de utilizatori concurenţi şi rularea mai multor tranzacţii pe acelaşi hardware," a precizat.

 

Preţ şi disponibilitate

 

Sistemul de gestiune al bazelor de date realţionale open source Firebird 2.5 este disponibil gratuit în orice formă de utilizare, fie în scop comercial, în educaţie, non-profit sau pentru uz personal. Atât distribuţiile binare cât şi codul sursă sunt disponibile şi pot fi descărcate şi instalate gratuit şi imediat de pe site-ul proiectului Firebird. Nu este necesară înregistrarea pe site sau activarea produsului.

 

Despre fundaţia Firebird.

 

Fundaţia Firebird este organizaţie non-profit care are ca scop să spijine dezvoltarea sistemului de gestiune de baze de date relaţionale Firebird. Fondarea ei a avut loc în anul 2002 şi numără acum mai mult de 300 de membri activi, printre care şi mulţi sponsori. Acceptă şi gestionează de asemenea şi donaţii financiare sau de resurse şi de la persoane care nu sunt membrii în fundaţie. Fundaţia redistribuie aceste fonduri în scopuri specifice către unii din contribuitorii cheie ai proiectului Firebird. Proiectul Firebird nu are alte surse de venit.

 

Contact Media : Alexey Kovyazin * +7 910 402 94 34 * admin AT mindthebird DOT com


Firebird 2.5 (final) released and overview after 10 years

The community project Firebird 2.5 is released. You can read the press release and most importantly release notes. And sure, you can download it and use/test/deploy.

Congratulation to us, the Firebird Project, especially the core team. And also to you, users, I hope you will enjoy and like the new Firebird 2.5 version as we (I) do. You can read the overview after 10 years for this aniversary release

Saturday, October 09, 2010

Borkstation x64 Upgrade for Xmass ? on My Wishlist santa , boss ... god

I don't want a quad core , now i have a dual core and is great but i want something more
so i guess a six core monster from amd would suffice and is quite cheap compared with intel i7 beasts

yes i compile c++/c/pascal a lot and transcode ogg and i need that kind of power
also i use linux-kvm(qemu)+virtualbox to run varios os-es : freebsd , windows , haikuos , ubuntu ,
also i needed for eclipse to develop android apps

For videocard my hope is a ati radeon 5750 that is quite good in opengl benchmarks and is cheap (or any ati 5000 series would do ) , I want to study and learn opengl and in the current version aka 4.x
http://www.opengl.org/documentation/current_version/

http://rastergrid.com/blog/2010/03/a-brief-preview-of-the-new-features-introduced-by-opengl-3-3-and-4-0/
and the amd/ati board is what i need also i want to play with opencl and firebird too and here is why opengl and onpecl won the api battle
http://blogs.arm.com/multimedia/why-opencl-will-be-on-every-smartphone-in-2014/

Sunday, October 03, 2010

Game du jour: Steel Storm Episode I



via planet quake
http://planetquake.gamespy.com/fullstory.php?id=163480

real programmers do hex and asm , and they don't eat burgers : Java , C# ...

This is my response to this post Tiobe index decomposed
http://compaspascal.blogspot.com/2010/10/tiobe-index-decomposed.html
I found the same with debian generic test but also with my programming experience
We are served with slow and bloated languages (burger king) like
C#,vb.net,java and we are somehow forced by companies stupid rules to work on thouse but in fact if you want fast things you need to code in c++, and pascal on the server side (some might say the real
http://mapopa.blogspot.com/2010/09/why-free-pascal-on-server-side-speed.html

programmers do hex or asm :P)
heck i can run >10 instances of quake engine written in c in the native form implementation in the same time in the browser
so native code rulz for speed and low memory usage (see the pascal low memory footprint compared with java)
http://mapopa.blogspot.com/2010/01/google-nacl-quake-demo.html

so why the heck we are still continue eating burgers ? it's time for a low carb diet , we want real food with good taste and in classy
restaurant with good history
not the fake food and fatness on our bottoms

Howto and tips :converting from #mysql to #firebirdsql Part 2

In the first part i have showed you a method using csv files but there is
a smarter way to migrate from mysql or mssql , get the column info :name,type,pks http://www.php.net/manual/en/function.mysql-fetch-field.php
after that for each table we can create the table in firebird
1. get tables,get tables columns , types relations from mysql , or mssql (for that i will do an article later)
2. for each table, column create new tables with columns in firebird
3. for each row in each table select from mysql,mssql and insert in corresponding table in firebird
in a similar way we did in previous example but there i have inserted from csv
http://gist.github.com/589903
for mssql i will write another script for info , there is one sp that gives you just that
and we can use one query to get it

Here is the first sub step get all the columns info for one table