Firebird News

Tuesday, March 31, 2009

microsoft smells like an graveyard
i went to an java script presentation in mit campus nearby
and the big shock and horror was the new firebug clone and separated processes like in chrome
no wonder jobs told them "microsoft start your xeroxes"
at least if they want to copy they should copy paste the code so ie 8.x can pass that dreadful
acid3 test
even my pesky arora-browser passes the acid test 100%
http://acid3.acidtests.org/
thank you nokia for qt , thank you google for chrome and open chrome , thank you apple for iiii webkit
thank you mozilla for the excellent firebug and extensions engine (i still hate rdf and xul by the way)
http://www.osnews.com/story/21193/_IE8_Does_Not_Pass_Acid3_Because_Standards_Not_Official_
Microsoft doesn't care about standards you and me or about security , the only thing that matters are
the cash cows that are now dying : windows and office
the rest is history
http://boycottnovell.com/2009/03/31/encarta-dies/

Monday, March 30, 2009

glue script on windows (vbox instance)
I showed to some people at java script meetup my first tests with javascript used for server side stuff

it's very easy download the windows zip from
http://www.wxjavascript.net/
http://downloads.sourceforge.net/wxjs/wxjs_win.0.9.75.zip?use_mirror=voxel
unzip with with 7zip in c:\wxjs

then start the command line like in the picture
cd c:\wxjs

Sunday, March 29, 2009

These people saved my friday
I wanted to see the house of blues/boston but seems that tickets were sold out
so only option was to go home or drink some beer in an bar , and the event on rock paradise
but on the way home i saw some event on the Oliver's at Cask and Flagoon
I got in and after a few pints of Guiness I was ready for rock and runa

I'm impressed by these local bands and their big hearts , they reached their 4k goal
but maybe you should help them more if you are around and know about the fund
Also another thing is there was something in the air that can't be felt when you hearthe myspace recorded music .
I was impressed by all of them and I didn't expected to be feel so good



Sunday, March 22, 2009

Libre Guerilla Romania - Start the Fight

Wednesday, March 11, 2009

Facebook Chat for Pidgin - for setting statuses from within pidgin

$ sudo apt-get install pidgin-facebookchat

and create new account on pidgin and choose facebook protocol

what is next twitter. identi.ca
http://code.google.com/p/microblog-purple/

Tuesday, March 10, 2009

compiling the mysql engine skeleton on jaunty

download and choose the gz from this url
http://hg.tangent.org/skeleton-mysql-engine/
$ tar -zxvf tip.tar.gz
$ cd skeleton-mysql-engine-0beed5ef2859$
$ autoreconf -vif
$ ./configure --with-mysql=/home/mariuz/work/mysql-5.1.31/ --libdir=/opt/mysql5.x/lib/mysql/plugin/
$ make
$ sudo make install
$ /opt/mysql5.x/bin/mysql -u root
mysql> INSTALL PLUGIN skeleton SONAME 'libskeleton_engine.so';
mysql> show engines \G;
Engine: SKELETON
Support: YES
Comment: Skeleton storage engine


Read howto use it the README
compiling mysql6.0-falcon branch from bzr (on my ubuntu jaunty)

bzr branch lp:~mysql/mysql-server/mysql-6.0-falcon
it took almost an hour i think (git is way faster at this stuff count the seconds not the hours)

cd mysql-6.0-falcon

autoreconf -vif

Than took me a while to figure out why it doesn't compile on my box (configure script was broken the same bug as when I requested new firebird 2.1.x to be synced from debian )

./configure --prefix=/opt/mysql6.x
make ; make install

see the previous post and the links there (is explained there how to install the default databases)
Compiling mysql 5.1.x on ubuntu + example storage engine notes

I started to install mysql in the /opt/mysql5.x using the source and an simple ./configure --prefix=/opt/mysql5.x

Here are my compile notes for 5.0.x but you can use it as guide for 5.x to (just replace the numbers)

http://www.howtoforge.com/mysql5_debian_sarge


Next if all ok and you can connect to local port 3308 and example storage seems to disabled by default if you run show engines in mysql prompt.

What we do now is to enable it
mysql> INSTALL PLUGIN example SONAME 'ha_example.so';

mysql> show engines\G

show engines\G;
*************************** 1. row ***************************
Engine: EXAMPLE
Support: YES
Comment: Example storage engine


CREATE TABLE test (i INT) ENGINE = EXAMPLE;

INSERT INTO test VALUES(1),(2),(3);

Here are more notes on how to use this example engine

Our next step is to modify the storage engine to work with firebird
I will use in my case the ibpp c++ api for firebird (is used in flamerobin and is absolutely stable and can be used with UTF too)
Jquery meeting tomorrow/mysql yesterday

I was yesterday at Mysql meetup in Cambridge (mit campus) and was great (free pizza and coke)
http://www.meetup.com/mysqlbos/calendar/9675782/

I wish I had some code/presentation to do but my ideas are in the pre alpha stage
and had a lot of very long fights with configure scripts (not quite ready to the general public)
While there i could at last compile and setup the example_engine from mysql 5.1.x source so i will add the notes here on my blog.Also the skeleton engine now compiles fine (Yesterday I couldn't do configure on my jaunty )


In rest one talk was about java and converting xml message files to an mysql db and how to do that in real-time
He was using mysql on linux with some tips but i told him that for him is best if skips the all xml -> db transformation and it should
write data in mysql directly with simple inserts (100x times more efficient) sometimes too much orm/xml takes too much overhead
My summary and ideas that can be applied to firebird database too: avoid xml and orm if you want performance also avoid java too :)
also changing the Linux IO scheduler /file system cache can affect the performance and benchmarks and sometimes results can be weird
I would recommend for performance ext4 and for IO Scheduler to start tweaking and change it (do some benchmarks with each of them), If you have UPS and you trust it then disabling the ext4 journal would bring you more performance (not much)


The other presentation was an storage engine that is quite fast it seems to be done parts of it in memory but I guess that we need more details about that engine (source code)
http://blogs.tokutek.com/tokuview/2009/01/

My opinion after meetup:
at least if we don't care too much for transactions or advanced features then a memcache storage engine would beat anything but not all apps are the same
or there are benchmarks and benchmarks also usually people use myisam by default it's fast but no integrity - forget about ACID http://en.wikipedia.org/wiki/MyISAM, innodb is worse in performance and usually it takes a lot space (double than myisam)
if you want to do an snapshot for database you should use their tools or lvm , usually is not much better than myisam but at least you don't loose data
and you can do rollback , oh also for performance you have to tweak a lot of parameters and know the engine internals (good money for consultants this is the oracle way)
also if you have more that 8 cpus you are out of luck it doesn't scale as good as Falcon (Jim's words) and hard facts




Tomorrow I will attend to the jquery talk (free)
http://php.meetup.com/29/
and after that i will go to the python meeting (free)
http://python.meetup.com/181/


Also I have already donated 60$ to the Free Software Foundation and I will be at the conference
http://www.meetup.com/Libre-Planet-Boston-Free-Software/

Friday, March 06, 2009

We should start an campaign to kill bug #1 called windows


I posted some ideas for an banner we should spread on all the sites
http://gist.github.com/75033

also here is my idea inspired from kill ie6 campaign

http://mapopa.blogspot.com/2009/03/how-to-kill-windows-and-ie-first-step.html


imagine if we put these kind of banners on all blogs/sites we have , this way we have ads for free also we can get more exposure to windows/ie users


they are the main target
How to kill windows and ie - first step
On my blog i modified the kill ie6 ra-ajax div and i put
if IE without the 6 [if IE] so now my blogs show that nice div to all ie users to upgrade to an modern wekit/mozilla browser and kill IE and microsoft altogether
I remembered that we have to fix #1 from ubuntu so I put an message for IE users to upgrade their
Operating system to Ubuntu

Thursday, March 05, 2009

hi5/facebook/orkut causes cancer

here is the article
using youtube-dl for downloading mp3 from youtube.com



$sudo apt-get install youtube-dl ffmpeg

$ youtube-dl http://www.youtube.com/watch?v=aR5j2Y6QCho
$ ffmpeg -i aR5j2Y6QCho.flv -vn -acodec copy aR5j2Y6QCho.mp3

and that is all
ffmpeg copies the mp3 part from the flash movie
-vn means no video
-a acodec copy means that it copies the audio part of the stream
-i is input file (flv)
Changing IO Scheduler on the fly in Linux/Ubuntu

I had some issues with one server and one sane approach is to change IO Scheduler
that could bring more performance if you have Raid or performance depends of file system also disk controller

The drive was sda

so here is what is available
cat /sys/block/$devicename/queue/scheduler

# cat /sys/block/sda/queue/scheduler
[noop] anticipatory deadline cfq

to change it to that from cfq i had to

# echo noop > /sys/block/sda/queue/scheduler

And now is time to do some benchmarks :)

Sunday, March 01, 2009

The Most Wanted Processor On The Planet is : AMD Phenom II X3 720 or 710

If you look at the specs and price is quite normal
if you consider 3 core something usual :) but if you have an AMI bios
and I do have one I can Upgrade from Triple core to quad for Free
Here is the howto : is just an bios switch
ahh and the 6M of L3 cache is sweet

But there are chances that you will be left only with an simple Triplet if
the bios doesn't enable you the Quad inside
It is not guaranteed that it will work with all motherboards with AMI bios