Firebird News

Thursday, November 25, 2010

Building quake 2 for android

I followed the instructions from
http://code.google.com/p/quake2android/
What i didn't had on my machine is ant
I downloaded from apache and bunziped in
/opt

so the last step was
/opt/apache-ant-1.8.1/bin/ant debug
started the qemu from eclipse and one machine with android

then i have installed with
adb install bin/Quake2-debug.apk



start the application then click menu button -> tools and
then download



a better idea is to download the data from somewhere else and upload it to emulator
if you don't want to build it here are the instructions to use the generic app
Download didn't finished in ~1h
Seems that i need to download it manually

wget ftp://ftp.uni-frankfurt.de/pub/Mirrors2/gentoo.org/distfiles/q2-314-demo-x86.exe
adb shell mkdir /sdcard/baseq2
unzip -j q2-314-demo-x86.exe Install/Data/baseq2/pak0.pak
Archive:  /home/mariuz/Downloads/q2-314-demo-x86.exe
  inflating: pak0.pak
adb push pak0.pak /sdcard/baseq2
...wait a few hours drink some water ...curse the java systems because they are crap and slow
come back and check the status until it reaches 48M
adb shell ls -l /sdcard/baseq2/pak0.pak

Then start the game :) 5fps in emulator (rockets slideshow)

A personal Apeal from Thom Yorke for Wikipedia

Doesn't Thom Yorke looks a little bit like Jimmy Wales ?
I always have the song I'm a creep in mind when i see this black banner

http://en.wikipedia.org/wiki/Thom_Yorke







ps: you should install the google chrome extension to have the image on any page you visit

Friday, November 19, 2010

Compiling Firebird 2.5 on the amazon ec2 linux microinstance (centos based)

I have checked out Firebird 2.5 source from svn then i have installed the gnu c++ compiler also the readline libs also the icu ones
after that i have started the compilation process (i know it's easier to install firebird from rpm but i wanted to see how fast is the free microinstance: it compiled in something of more than one hour)

yum install gcc-c++ libicu-devel readline-devel automake autoconf libtool

after configure check if the firebird server is up
netstat -tap | grep fbserver
tcp        0      0 *:gds_db                    *:*                         LISTEN      22144/fbserver
Install python and firebird driver for it and we will do some benchmarks
yum install python26-develyum install python26-devel
wget http://downloads.sourceforge.net/firebird/kinterbasdb-3.3.0.tar.bz2
tar -jxvf kinterbasdb-3.3.0.tar.bz2
cd kinterbasdb-3.3.0
python setup.py install
python -c "import kinterbasdb as k; print k.__version__"
(3, 3, 0, 'pre-alpha', 0)
wget http://www.firebirdsql.org/download/rabbits/pmakowski/ibench1.py
create test db


at last run the benchmark and compare with a desktop machine (at the end of the post)
python ibench1.py --db_user=sysdba --db_password=******* --db_name=/tmp/test.fdb --setup

Here are the results for a desktop machine (core 2 duo )
#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
..........................................................

And here are the rezults for ec2 micro machines
#rows #seconds cum_ips last_ips #queries cum_qps last_qps
10000 207 48.4 48.4 1640 7.9 7.9
20000 551 36.3 29.0 4069 7.4 7.0
30000 1058 28.3 19.7 7733 7.3 7.2
40000 1920 20.8 11.6 12517 6.5 5.6
50000 2967 16.9 9.6 18489 6.2 5.7
60000 3944 15.2 10.2 24041 6.1 5.7
70000 4876 14.4 10.7 28416 5.8 4.7
80000 5845 13.7 10.3 32274 5.5 4.0
90000 6890 13.1 9.6 36649 5.3 4.2
100000 7869 12.7 10.2 39876 5.1 3.3
110000 8971 12.3 9.1 43522 4.9 3.3
120000 10092 11.9 8.9 47221 4.7 3.3
..........................................................

i will redo the tests tomorrow

also here are the partial results on AMD Athlon(tm) 7850 Dual-Core Processor

#rows #seconds cum_ips last_ips #queries cum_qps last_qps
10000 277 36.1 36.1 4830 17.5 17.5
20000 688 29.0 24.3 12028 17.5 17.5
30000 1117 26.9 23.3 20474 18.3 19.7
40000 1558 25.7 22.7 28505 18.3 18.2
50000 2021 24.7 21.6 37056 18.3 18.5
60000 2514 23.9 20.3 45290 18.0 16.7
70000 3053 22.9 18.6 54310 17.8 16.7
80000 3607 22.2 18.1 62826 17.4 15.4
90000 4162 21.6 18.0 71875 17.3 16.3
100000 4713 21.2 18.1 80515 17.1 15.7
110000 5328 20.6 16.3 89286 16.8 14.3
120000 5878 20.4 18.2 97864 16.6 15.6
130000 6431 20.2 18.1 106757 16.6 16.1
140000 6984 20.0 18.1 115589 16.6 16.0
150000 7565 19.8 17.2 124362 16.4 15.1
160000 8147 19.6 17.2 133129 16.3 15.1
170000 8687 19.6 18.5 141953 16.3 16.3
180000 9245 19.5 17.9 150991 16.3 16.2
190000 9820 19.3 17.4 159820 16.3 15.4
..........................................................

good night i have now my own firebird machine to experiment and will be kept online for a year at least

Amazon Free EC2 micro instance started success , time for #Firebird #Sql tests

after using my card with some money on it where money > 1$
i got the instance running , now is time to run some firebird 2.5/3.0 benchmarks on it

What it sux ? well i can't choose a debian 6.0 microinstance from the menu
but for the moment i can choose only some centos like crap

ssh -i .ssh/xxx.pem root@ec2-75-101-206-xx.compute-1.amazonaws.com
Please login as the ec2-user user rather than root user.
Connection to ec2-75-101-206-xx.compute-1.amazonaws.com closed.
mariuz@borkstationX64:~$ ssh -i .ssh/xxx.pem ec2-user@ec2-75-101-206-xx.compute-1.amazonaws.com

       __|  __|_  )  Amazon Linux AMI
       _|  (     /     Beta
      ___|\___|___|

See /etc/image-release-notes for latest release notes. :-)
[ec2-user@domU-12-31-39-14-C6-7E ~]$ cat /proc/cpuinfo 
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model  : 23
model name : Intel(R) Xeon(R) CPU           E5430  @ 2.66GHz
stepping : 10
cpu MHz  : 2660.000
cache size : 6144 KB
fpu  : yes
fpu_exception : yes
cpuid level : 13
wp  : yes
flags  : fpu tsc msr pae cx8 cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht pbe syscall nx lm constant_tsc up arch_perfmon pebs bts rep_good aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm dca sse4_1 lahf_lm tpr_shadow vnmi flexpriority
bogomips : 5320.00
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

Thursday, November 18, 2010

Game of the day Sauerbraten in #ubuntu / #debian

It's quite cool that Sauerbraten cube2 inspired minecraft also you can load minecraft maps in sauerbraten






The ingame editor is quite cool


Tuesday, November 16, 2010

Testing #Firebird 3.0 on #Debian experimental

Firebird 3.0 final is now uploaded to debian experimental

Here is my sources.list
cat /etc/apt/sources.list

deb http://ftp.us.debian.org/debian/ unstable main
deb-src http://ftp.us.debian.org/debian/ unstable main
Add:
deb http://ftp.us.debian.org/debian/ experimental main
deb-src http://ftp.us.debian.org/debian/ experimental main

Then:
# apt-get update -t experimental

Then install server package that includes all the versions Super , Classic , SuperClassic into one binary (the difference compared with 2.5 packages will be that the startup script will start in mode you need)
# apt-get install -t experimental firebird3.0-server
dpkg-reconfigure firebird3.0-server

You can read what is about the new superclassic architecture introduced in 2.5


Install examples and flamerobin
apt-get install -t experimental firebird3.0-examples flamerobin

cd /usr/share/doc/firebird3.0-examples/examples/empbuild/
sudo gunzip employee.fdb.gz
sudo chown firebird.firebird employee.fdb
sudo mv employee.fdb /var/lib/firebird/3.0/data/

you can connect to the database with flamerobin




you can also build the firebird 3.0 package from git if you feel the urge.
A good idea is to check the git summary to  know what is changed.

The most beautiful os part two : #Debian

Here are new themes created for Debian release

Space Fun is well Fun (People relax we know Linux must be just Fun and Enjoyable and not Ugly like the Old farts Windows )




































by @StingBL in http://stingbl.deviantart.com/art/Screenshot-Intergalactic-182283320

I like also Nightly

http://wiki.debian.org/DebianArt/Themes/Nightly


Lisp machines are really cool

Monday, November 15, 2010

What linux sites i read

Cristi Gherman asked me what is that page with linux news that i read
well is linuxhomepage.com
also to the mix add reddit.com/r/linux


digg is now less reliable source for linux news
at least i can't find the section for linux anymore ...

Saturday, November 13, 2010

Installing the #Romanian dictionary in #OpenOffice / #LibreOffice

First you need to install it the good one from this list

http://extensions.services.openoffice.org/en/search/node/romanian

What is the good one ? this one seems to be up to date and it installs without errors

I found it the hard way that i need installing the second one (i had to rename the extensions to zip and remove the nul file from install on a windoze machine, in debian/ubuntu works without issues)

Now the spellchecker works and we are happy :)

So there is no need for Microsoft Office in School libre office is quite phenomenal

Saturday, November 06, 2010

Wolfenstein Qt. Qt widgets in a 3D environment - Update 2010

3D linux desktop is here
in 2008 there was a demo but it was quite hard to compile it
http://www.youtube.com/watch?v=Py_eUAQS1UY

well now the compilation works smooth without the need for a qt snapshot
all you need it some qt 4.6.x headers that come by default in ubuntu and debian
I will spare you about the details and some opengl ones

something like
git clone git://gitorious.org/qt-labs/wolfenqt.git
qmake
make
search for headers needed in the ubuntu/debian repository (I will write an article about what is needed later)

./wolfenqt

the results are impressive :the video player works , the browser does work with some issues (flash related) but the engine is impressive i wonder why the fonts are smoother than in the xorg browser , maybe the AA from opengl helps ...There is still a lot of work
and what i miss mostly is a quake style terminal and a cool desktop like hud but that will come later

Update:
Here is video that can be played in vlc/mplayer





youtube didn't converted my video correctly
and vimeo gives some errors http://vimeo.com/16559779

God this is why we need html5 for interweb , simple ogv upload and share

Securing #Firebird using #Ssh tunnel

there is a very easy way to do a secure connection with firebird

create a ssh tunnel to  FirebirdRemoteHost
add in .ssh/config

host FirebirdRemoteHost
  LocalForward 3050 127.0.0.1:3050

Then when you do ssh FirebirdRemoteHost a ssh tunnel is created
between your machine to remote firebird server

so port 3050 is tunneled to remote host and  when you connect to localhost 3050 you will connect in fact
to the remote host (127.0.0.1 is local address on that machine) and the port 3050

In flamerobin you can work on it like on local machine server installation


if you have already a firebird installation on your local workstation then is good to put another port for the tunnel

LocalForward 3051 127.0.0.1:3050