Firebird News

Tuesday, July 28, 2009

SQL compliant ROWS syntax obviates the need for FIRST and SKIP in Firebird

Today i found rows new syntax for first/skip that is more standard compliant

SELECT *
FROM POSTS a rows 4 to 6
nice that it works with update/delete too

extracting date from an timestamp value in firebird

you can use the cast to extract the date from timestamp

SELECT cast('now' as date)
FROM rdb$database

in my case the result is

28.07.2009

someone asked on webhostingtalk how to do it

also you can extract only the year or month using the extract function

Friday, July 24, 2009

silvernight 2.0 and letour de france 2009 - fail

I really tried to watch tour de france today :(seems that microsoft and france television are partners in hell )

installed moonlight plugin for firefox 3.5 also the drm plugins/codecs from microsoft
and still i see only a black screen of death or stack traces

No wonder flash streaming is everywhere at least it works , crappy but it does work
And ogv is way better for streaming than flash / silvernight

[UPDATE:seems that stream is not allowed in Romania so kudos to mono team
Also i have tested the stream from vlc seems that akmai doesn't allow the stream to Romania

[00000414] access_mms access error: cannot connect to server
[00000414] access_mms access error: error: HTTP/1.0 401 Unauthorized
[00000412] main input error: open of `mms://direct.francetv.fr/tourdefrance
]



Monday, July 20, 2009

Clickable Rounded Buttons with jQuery

I have created an simple example for buttons that can be clickable with rounded corners using jquery.corner.js

Friday, July 17, 2009

Dear SourceForge - feedback on new design

Hello i like the new design only the colors are too washed , for example
the blue is too light and i can't read it very well on the white background
Please make the text darker , Thanks
Here is the new sourceforge design on project firebird page
http://sourceforge.net/projects/firebird/

Firebird Head Git mirror

I have created an firebird head mirror

http://gitorious.org/firebird-head-mirror/firebird-head-mirror

the git cvs import was done this way

http://mapopa.blogspot.com/2009/07/git-cvs-import-gotchas-on-ubuntu-and.html

git cvsimport -C firebird2 -v -d
:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird
firebird2 -p z3
[wait a few days ...
thanks to screen now is finished]

cd firebird2/

git remote add origin
git@gitorious.org:firebird-head-mirror/firebird-head-mirror.git
git push origin master

Counting objects: 300812, done.
Compressing objects: 100% (56994/56994), done.
Writing objects: 100% (300812/300812), 73.58 MiB | 1231 KiB/s, done.
Total 300812 (delta 249091), reused 294841 (delta 243566)
To git@gitorious.org:firebird-head-mirror/firebird-head-mirror.git
* [new branch] master -> master
=> Syncing Gitorious... [OK]

I will do an daily import push script in cron

ps: crazy ideea of the day git hook for database changes
if you modify an stored procedure it will add new version to the git
repository and commit push it there
the same for other DDL text

Wednesday, July 15, 2009

Recovering ubuntu karmic with an intrepid cd

i did an sudo apt-get dist-upgrade in karmic
and it removed upstart upstart-compat-sysv upstart-logd

I have to force from live cd to mount the partition as "-t ex4dev"

#mkfs.ext3 -E test_fs /dev/
$sudo mount /dev/sda1 -t ext4dev /mnt

$sudo chroot /mnt
seems that i need to downgrade upstart
install
system-services, and reinstall startup-tasks

I got the kdm prompt, had some weird errors with /dev/null when i logged in from the console (Alt F1)
so i upgraded to upstart 0.6 and again the system doesn't do the init or runs the scripts
maybe i need to put it in DEBUG mode
Now i'm studying the upstart main.c code and I wish it was written in python or any scripting language

Quote of the day is about Chrome and features

Per-process execution is a feature in Chromium (Google Chrome), not V8. And it is really needed anyway if one is using V8, because V8 is not thread safe.

So that is why you have one process for Tab in chrome (it's a bug called feature in V8)

Via trolls labs

Tuesday, July 14, 2009

git cvs-import gotchas on ubuntu and using firebird repo

I started to import the firebird cvs repository into my local git mirror.Why ?
Maybe because the bzr import failed after >30 hours ! also seems that fisheye is dead no changes to changelog there.
So my plan is to import the firebird cvs using git cvs-import and then push it to gitorious or bzr launchpad later (request a new git to bzr import)

First you need to install git-core and git-cvs
$ sudo apt-get install git-core git-cvs

you need to create the firebird2 dir with
$ mkdir firebird2
and specify it when you do the import with "-C firebird"
then you need to add the repository path from sf.net
"-d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird"

First you need to do cvs login
$ cvs -d:pserver:anonymous@firebird.cvs.sourceforge.net:/cvsroot/firebird login

Here is the complete command line for importing firebird in local git repository

Monday, July 13, 2009

Quote of the day and Tree data structures in the database

The quote of the day:
The number 1 fear is speaking in front of others. Number 2 is death. Number 2. That means if you're at a funeral, you'd rather be in the coffin instead of giving the eulogy.
- Jerry Seinfield

And an advanced talk from Lorenzo Alberton :~140 pages about trees in sql

http://www.alberton.info/talks_dpc_2009_wrapup.html

http://www.alberton.info/talks
CTE can be used in firebird too
http://pabloj.blogspot.com/2008/01/new-challenges-new-synthax.html

Wednesday, July 01, 2009

Arora is default full featured browser in Kubuntu

Arora is a simple cross platform web browser whose feature list includes things like "History" and "Bookmarks". It has a small code base and loads of fun to hack on. Benjamin Meyer originally created as a demo for Qt to help test the QtWebKit component and find API issues and bugs before the release Arora works with almost all websites and offers nice features like HTML 5, but needs some more features to give it the same parity as existing browsers. Arora should work with Web 2.0 websites we consider to be critical to our users. These include Slashdot, GMail, Google Calendar, Facebook, Flickr, Youtube, Yahoo and of course kubuntu.org.
[ED: tested the Slashdot , reddit , gmail , facebook , youtube, flickr and yahoo and all work OK , also wordpress.com and firebirdnews.org admin area
Arora passes 99/100 tests from acid3 tests also gets good scores on browser benchmarks http://service.futuremark.com/peacekeeper/results.action?key=1Ei0
]