Firebird News

Monday, December 28, 2009

Testing Firebird 2.5 on Debian experimental

Firebird 2.5 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 super-server
# apt-get install -t experimental firebird2.5-super

Or if you want the new superclassic

# apt-get install -t experimental firebird2.5-superclassic


Install examples and flamerobin
apt-get install -t experimental firebird2.5-examples flamerobin

cd /usr/share/doc/firebird2.5-examples/examples/empbuild/
sudo gunzip employee.fdb.gz
sudo chown firebird.firebird employee.fdb
sudo mv employee.fdb /var/lib/firebird/2.5/data/

you can connect to the database with flamerobin



update: you can build the firebird 2.5 package from git

half of chapter 6 from django-book

i'm at half of chapter 6 from django book
to use it with firebird is quite easy and with small changes (only the sql examples needs to be modified in the example is used postgres) but i have added the comments to the book on how to modify an not null to a nullable field (or you can do it from flamerobin)



the rest of the admin area works great




The previous chapters 1-5 modifications for firebird are on this page

for about 2 days i got some strong flu virus and i only sleep and with heavy sweat

Saturday, December 26, 2009

Movies to watch ~ Xmass, Porcelain death as santa claus

I love the ones with horror inside so i guess the best movie i saw on Xmass ever
is The Nightmare Before Christmas , next is Bad Santa , Last night i saw one movie where Death was Santa :HOGFATHER (on tvr2) quite impressive
and i didn't expected to see such a good movie on Xmass , maybe because all tv station are playing the same crap over and over each year : home alone 1-2-3 , santa klauss related ones and
the ones with Arnold ... and so on

I recommend instead some good horror movies made for Xmass or for Helloween
http://horror.about.com/od/toppicksandthemelists/tp/Scary-Christmas.htm

For a commedy i guess 2012 could fit the bill
I wonder why the hack didn't put all the people on Himalaya mountains and from where they got all that water 8km high ? do the calculations and you will see that
that volume of water is more than what is found on earth

Wednesday, December 23, 2009

#kde 4.4 beta safe guide to upgrade on #ubuntu #karmic

kde 4.4 is released here is a way to upgrade and then downgrade to 4.3
in a safe way (and to keep the list of installed packages)


before you upgrade is better to save your list of pachages
dpkg --get-selections > installed-software.log

then you can reinstall qt/kde packages from console if you have
problems with (revert to qt 4.5.x if you want)

Install kde 4.4 and qt 4.6
http://www.kubuntu.org/news/kde-sc-4.4-beta-2


Here is my way to revert on the old packages kde 4.3.x and qt 4.5.x

CTRL-ALT-F1

sudo /etc/init.d/kdm stop

sudo apt-get purge libqtcore4
then i did the steps from above
with
sudo dpkg --set-selections < installed-software.log
sudo dselect
and press I to install all the packages saved

Thursday, December 17, 2009

We are not stupid Monty

Reuters reports that Microsoft and SAP and Monty Widenius will be at the meeting on the 10th at the EU Commission, and not a single customer. Oracle has eight customers committed to being there to support Oracle's position. Eben Moglen will also participate.




http://www.groklaw.net/article.php?story=20091208104422384
http://www.groklaw.net/article.php?story=20091021164738392




even IBM is not against this issue , they know who is behind all this attack on Oracle and Open Source in general old friends: Microsoft 


Mysql ..bla bla bla ... Its primary competitor is Microsoft's SQL Server.

That i think hurts more for Microsoft , they can't sell their ms crap .
They wish Mysql to be under BSD license to be assimilated into azzure
like they did with bsd socket libs

generating all flags for skype with #flamerobin and #firebird sql

Here is how to get the original script
wget http://27.org/isocountrylist/iso_country_list.sql

create a new table with this syntax (I have just deleted the "IF NOT EXISTS" from the original table creation script)

http://paste.ubuntu.com/343619/

populate the table with load script from flamerobin
http://paste.ubuntu.com/343617/

the only issue was quoting in firebird , you just need to replace \' type of quoting with "

If you need to use an apostrophe inside a Firebird string, you can “escape” the apostrophe character by preceding it with another apostrophe.

For example, this string will give an error:

'Joe's Emporium'

because the parser encounters the apostrophe and interprets the string as 'Joe' followed by some unknown keywords.

To make this a legal string, double the apostrophe character:

'Joe''s Emporium'

Notice that this is TWO single quotes, not one double-quote.

Run this query in flamerobin to get the iso from table

SELECT a.ISO
FROM COUNTRY a

We need to add (flag:ISO) to the query with the concatenation

SELECT '(Flag:'||a.ISO||')'
FROM COUNTRY a

and do the copy paste in skype :P





Create a procedure that concatenates thouse values

and do a select

SELECT p.SKYPE_COUNTRIES
FROM RETURN_COUNTRIES10 p

and copy paste

result should be like this


Tuesday, December 15, 2009

Firebird community letter to Monty :we don’t have such worries!

Here is why we sleep so well in the night : because we don't touch the mysql and we don't need it
http://www.firebirdnews.org/?p=3907

I know that Monty is part of new codeplex fundation
so his masters might be related to Microsoft:
New masters new dogfood


Another issue is Maria Fork is a dead end and i see around that nobody is using in the Lamp world
so he needs the Mysql brand back for free , That is smart because the community build it that name in Years and is very hard now to change them from Lamp to Maria (unknown one)

This post is related to Steve's post on computerworld
http://blogs.computerworld.com/15246/opposition_mounts_to_oracles_mysql_acquisition

Thursday, December 10, 2009

wxwebkit is amazing and flamerobin future

I was thinking on howto evolve the flamerobin project and i think the next stage (for example on E/R diagraming) would be to adopt the wxwebkit engine for interface rendering , what we do now with wxhtml

Instead of it we will use jquery and paint in the browser canvas (similar like in thunderbird 3.x)
The tree in the left will stay native and the grids , but some parts in the future will be replaced with cool html that can be skinned with css.
Core will stay c++ and parts of the interface will be pure native.

To build wxwebkit on ubuntu/debian was quite easy:
sudo apt-get install gcc g++ flex bison gperf libxml2 libxslt1.1 libxslt1-dev libcurl4-openssl-dev libsqlite3-dev libpng12-dev libjpeg62-dev libpango1.0-dev libgtk2.0-dev subversion

git clone git://gitorious.org/+wxwebkit-developers/webkit/wxwebkit.gitcd wxwebkit/WebKitTools/Scripts
./build-webkit --wx --makeargs="-j2"
cd wxwebkit/WebKitBuild/Debug.master
chmod +x libwxwebkit.so
sudo cp libwxwebkit.so /usr/lib/
./wxBrowser

What is so amazing ?, you can put webkit in edit mode and actually Edit the website (html) !


Tuesday, December 08, 2009

The sad happy story of snow in Kubuntu Karmic

At first Windows-F3 key (aka Master-F3) didn't do anything

so i searched for a upto date compiz ppa

sudo kate /etc/apt/sources.list.d/compiz.list

deb http://ppa.launchpad.net/compiz/ppa/ubuntu karmic main
deb-src http://ppa.launchpad.net/compiz/ppa/ubuntu karmic main


sudo apt-get update
sudo apt-get dist-upgrade

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 42C24D89

install compiz related packages

sudo apt-get install compiz compizconfig-settings-manager compiz-kde compiz-fusion-plugins-main compiz-fusion-plugins-extra emerald librsvg2-common compiz-fusion-plugins-unsupported


Install fusion-icon
sudo apt-get install fusion-icon

a tray icon to enable compiz and it will disable kwin
and also you can enable Windows decorator to be Emerald not kde4


Select Compiz Configuration:
K menu -> Applications ->Settings -> CompizConfig Settings Manager

and enable Snow Effect




well you could install compiz-dev and compile from source but is 2a.m. and i want to sleep

I have debugged the issues with snow from console with
compiz-manager --replace and with ccsm from another console
ps:
Snow seems to be removed from Karmic and it gave an api missmatch that is why it didn't worked in the first place
Now it's not as simple as it was before but problem is solved

Html2DocBook #python and Firebird in 2 Minutes #html document

I try to convert it (this html document ) to docbook format and

I have installed the html2docbook tool
http://pypi.python.org/pypi/html2docbook/

from python console
from html2docbook import Html2DocBook
h2d = Html2DocBook()
f = open('./fb2min.html', 'r')
x=f.read()
h2d.transform(x)
'<section/>

that is the only tag that is spitted out!
if i do print(x) i get all the content for html
even
_debug=True doesn't work no details or verbose mode


ps: i saw that some things are old on that page i was thinking that is
better to be kept in docbook format and versioned (cvs/git ...)
also i have tried to do some tidy html on it
for the moment we will stick to html format it's easier and anyone can edit it
maybe i will add it to git (docbook is harder to crack)

Friday, December 04, 2009

Found a bug in git-cvsimport so i will use cvs2git

I'm not the only one that found the bug

"Me, I don't trust anything but cvs2git to import a CVS repo. I then use git-cvsimport to keep it up-to-date, but even then, I've seen it omit a couple of commits for no good reason, forcing me to re-import from scratch."

so i will use cvs2git to import all the firebird branches

mkdir firebird2
cd firebird2

rsync -av rsync://firebird.cvs.sourceforge.net/cvsroot/firebird/firebird2 .
rsync -av rsync://firebird.cvs.sourceforge.net/cvsroot/firebird/CVSROOT .

cd ..
svn co --username=guest http://cvs2svn.tigris.org/svn/cvs2svn/trunk
cvs2svn-trunk

# Dump the CVS history in a format ready for git-fast-import (a few hours)
cd cvs2svn-trunk
./cvs2git --blobfile ../cvs2git.blob --dumpfile ../cvs2git.dump \
--username '(no author)' --fallback-encoding utf-8 ../firebird2

# Create and fill the Git repo
mkdir ../firebirdgit
cd ../firebirdgit
git init
cat ../cvs2git.{blob,dump} | git fast-import

git fast-import is that is really fast (a few minutes)
what is left to do is to export it over ssh or web

git clone --bare /tmp/firebirdgit/.git /tmp/firebird.git
and you can test it over remote
cd ~
git clone foobar@localhost:/tmp/firebird.git

qgit




the only problem left is how do i do it daily to be pushed to gitorious ?