Quaero

Germany and France are negotiating on plans to develop a series of sophisticated digital tools including a next-generation Internet search engine. In a speech this month laying out his 2006 agenda, Chirac spoke to those concerns, saying: "We must take up the challenge posed by the American giants Google and Yahoo. For that, we will launch a European search engine, Quaero.", Quaero, which means "I seek" in Latin. Source: Internationl Herald Tribune Tags: Europe, Quaero, Gr33n Data

Telephone Numbers in Egypt

Sometimes you need to know the dial-prefix of a certain governorate (a.k.a province or state) in Egypt, or even you have a phone number and you want to know where it is located in Cairo. So you may use this form in TEData site that checks if the DSLAM in the Exchange you belong to has an available ADSL port to know the exchange name. You may also find the governorates prefixes in the drop-down list there. http://www.tedata.net/ADSL.htm Tags: Egypt, Telephony, Gr33n Data

Beej - Sockets Programming

This is the best place to learn Socket programming, you may also find useful information in the socket man page on unices. Beej's Guide to Network Programming Using Internet Sockets Tags: Networking, Programming, Gr33n Data

Resume of George W. Bush

RESUME - George W. Bush, http://www.beedub.com/bush_resume.html Tags: Phun, Bush, Gr33n Data

Eid El Adha Movies Review

Out of those movies that have been in teaters this feast - Eid El Adha - I've seen both "Ouija" and "Zarf Tarek". Ouija was supposed to be called "Sahar El Layaly II", as it is almost the same kind of movie where people look as if they are from another universe, and the script is missing. "Zarf Tarek" is a typical Egyptian Comedy Movie; however it is much better than what I've expected it to be. Tags: X, X, Gr33n Data

An Introduction to Tkinter - Work in Progress

This is a nice yet incomplete Python/Tkinter tutorial, An Introduction to Tkinter (Work in Progress) Tags: Python, Tkinter, Gr33n Data

Bluefish Editor

Bluefish is a powerful editor for experienced web designers and programmers. Bluefish supports many programming and markup languages, but it focuses on editing dynamic and interactive websites. Tags: Linux, Programming, Gr33n Data

Xfce Rulez

Xfce is one of the best looking Window Managers I've seen lately, I've just installed it today and I think I am going to switch from Gnome (i.e. Metacity) to it. Tags: Xfce, Linux, Gr33n Data

Get out of Gnome

Once you are logged onto Gnome, you are not able to get out to the CLI once more. But here you are the solution;

/etc/init.d/gdm stop

I think this will work with KDE as well but use "kdm" instead of "gdm" Tags: Linux, Gnome, Gr33n Data

Sqlite - Date and Time Data Types

SQLite handles dates quite strangely. If you create a table and put a date in it, the only way SQLite will take the input is "2004-06-01 12:00:00" anything else it won't recognize as a date and thus none of the date functions will work. Assuming you have a date entered propely (like above) you get date information from the db like so.

SELECT date(DateField) FROM Table; SELECT time(DateField) FROM Table; SELECT datetime(DateField) FROM Table;

If you want unix time (seconds since the epoch) you have to format the output.

SELECT strftime("%s",DateField) FROM Table;

However that will return the time in UTC which is probably not what you want (it's not what I wanted). I want it to compensate for my local timezone and thus you have to tell it to use your timezone.

SELECT strftime("%s",DateField,'localtime') FROM Table;

Related Posts:
Green Data: Pysqlite

Sources: Perturb.org , Sqlite Wiki
Tags: Sqlite, Database, Gr33n Data