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

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
]

Clickable Rounded Buttons with jQuery

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

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

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

http://labs.trolltech.com/blogs/2009/06/16/using-javascriptcore-as-the-qtscript-back-end/

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

http://paste.ubuntu.com/218099/

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

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

]

http://wiki.kubuntu.org/KubuntuKarmicWebbrowser

volfied on dosbox (ubuntu jaunty)

in the highschool people were playing volfied almost on all computers in the lab
http://www.abandonia.com/en/games/811
so today i wanted to try it on my cloudbook
sudo apt-get install dosbox
mkdir ~/dosbox/c
copy the volfied files from the zip in
~/dosbox/c/volfied
dosbox
mount c /home/mariuz/dosbox/c

cd volfied
volfied.exe

the keys used are space and numeric arrows (doh on cloudbook there are none of these types)
i will try to remap them in dosbox

Romania wasting hundreds of millions of EUR on proprietary software.

Romania wasting hundreds of millions of EUR on proprietary software. http://ur1.ca/4rgo
Seems they no longer need EU funds.

Microsoft Makes Itself at Home in Transylvania - http://bit.ly/1CuwCR
Count Dracula would have been proud of them #romania

Lucian's reaction

http://www.cianblog.com/2009/05/27/my-official-position-the-romanian-government-is-about-to-spend-millions-of-euro-on-proprietary-software/
also here is the romanian version for the above article

http://razvansandu.zando.ro/2009/05/afacerea-cu-licente-software.html

How to become an anonymous coward (ubuntu way)

How to become an anonymous coward (ubuntu way)

Here is how i installed the tor network privacy proxy

sudo pico /etc/apt/sources.list.d/tor.list

deb http://mirror.noreply.org/pub/tor jaunty main

deb-src http://mirror.noreply.org/pub/tor jaunty main

sudo apt-get update
sudo apt-get install tor

sudo pico /etc/privoxy/config

add this line at the end of file

forward-socks4a / localhost:9050 .

sudo /etc/init.d/privoxy restart

add http proxy in System -> Preferences -> Network Proxy
Http proxy: 127.0.0.1
Port:8118
and

Secure Http proxy: 127.0.0.1
Port:8118



That's all , Now you are an anonymous coward
You can check if you are on tor netowork https://torcheck.xenobite.eu/

you can check also the wiki page from ubuntu
https://help.ubuntu.com/community/TOR
ubuntu::tor::privacy

eLiberatica 2009: tequila shots

eLiberatica 2009: tequila shots
Originally uploaded by nicubunu

Not so strong as Palinca but it was ok

eLiberatica 2009: FOSS communities

eLiberatica 2009: FOSS communities
Originally uploaded by nicubunu

the heads from the Foss comminities in romania , there were others around

eLiberatica 2009: FOSS communities

eLiberatica 2009: FOSS communities
Originally uploaded by nicubunu

The romanian Floss communities are growing ,

solving the esprimo sis rezolution issues

I had to add in xorg.conf (fixing one laptop at eliberatica.ro conference floor)

Section "Monitor"
Identifier "Configured Monitor"
HorizSync 30-107
VertRefresh 50-185

EndSection

via :http://ubuntuforums.org/showthread.php?t=958967

Next was to install one driver from the above thread
http://ubuntuforums.org/showpost.php?p=6983046&postcount=119

and then i changed the sis or vesa driver to sis671 in xorg.conf section

http://ubuntuforums.org/showpost.php?p=7014258&postcount=129

Ubuntu Romanian Team Report for April 2009

Apr 30 2009: Releasing Kiwi Linux 9.04, based on Ubuntu 9.04. Full release notes.

May 19 2009 the release of the Ubuntu for Romania, a localized version based on Ubuntu 9.04 Jaunty Jackalope. The installation CD is localised into Romanian and holds the majority of the default Ubuntu applications. The disk has specific network conectivity applications and legal restricted multimedia codecs to ease the transition of the new users to the Ubuntu operating system.

There were several Jaunty release parties in cities around the country

• Release party Ubuntu 9.04 Jaunty Jackalope in Cluj Napoca. After the usual presentation of the operating sistem, the audience and the organizers talked about:

  • Organising the local Ubuntu comunity
  • The help and support offered by the local Ubuntu comunity
  • The statistics regarding the use of the Ubuntu operating system in Romania
  • The means and the methods that should be used to increase the number of the events held by the local comunity

  • The usual group pictures can be found here

• Release party Ubuntu 9.04 Jaunty Jackalope in Arad

• Release party Ubuntu 9.04 Jaunty Jackalope in Targu Mures report: almost 25 people were present and this time we had some great discussions and beer talk. We also did some serious presentatations like what is new in jaunty jack : new gnome, new kde, new qt browser like arora or development IDE like qt creator, I also showed the new firefox 3.5 ( abrowser 3.5), quassel, gwibber (microblogging client), firebird 2.1.x and some extensive discussion about ext4 crash-ing and it's amazing speed

  • Emil Cheriches presented the cool stuff on the server side like: eucalyptus (aka EC2 at home), dovecot, ext4 and ufw/apparmour and mysql 5.1.

  • Some cool pictures (here or here) were shot at the event by Emil; also we had some great guests like Paul Nasca who did some crazy dj-ing demos with zynaddsubfx

  • Adi Roiban and Stas Sushkov were present to the event (they came from Cluj Napoca only for this) and it was great to discuss the Romanian Team priorities

  • We had mentions in local press. The announcement in Hungarian language is here http://hup.hu/node/69899 And yes we are on front page on ubuntu.hu http://ubuntu.hu/hirek/2009apr/jaunty-jackalope-release-party-marosvasarhelyen

  • Other notes in blogosphere: There is a note on infoms website

The local team was reprezented to the Ubuntu 9.04 Jaunty Jackalope release party in Moldova. The pictures can be found here.

php eclipse nightly

I updated my eclipse and wanted to put some fresh phpeclipse plugin

You can do so by using this tutorial but with this

http://phpeclipse.sourceforge.net/update/nightly/

repository instead of using the stable one