everyday – Page 7 – tricky-bits.eu

February 23, 2009December 27, 2009

Ansip ja Celine Dion

Ei, tegelikult seost ei ole, on vaid kokkusattumus.

Nimelt, kui mõni aeg tagasi blogipuu lahti võtsin, jalutas Ansip mööda ekraani ringi. Oleks hilisem kellaaeg olnud, oleksin tõsiselt kahtlema hakanud, kas see on unes või ilmsi. Paraku oli aga selleks ajaks Firefoxi helisüsteem pangestunud (ei ole uurinud, aga pikemat aega avatuna hakkab flashi heli ennast korrutama ja midagi mõistlikku kuulata ei saa) ning tuli see taaskäivitada, et aimu saada, mis lugu selle reklaamiga on.

Tuleb välja, et Reformierakond teab kõigist teistest paremini, kuidas kriisist välja tulla. Sellised väited lähevad kategooriasse “mida iganes”. Kui see nii lihtne oleks, siis meil poleks ülemaailmset kriisi. Koomiliseks tegi olukorra see, et ühes blogipuu kaardiga laaditi uuesti ka last.fm‘i kaart, kus hakkas mängima “Celine Dion – Love Is All We Need”. Läks ühe mõttepausi jagu aega, enne kui aru sain, et see ei ole reklaami osa. :D

Mis puutub reklaami lõpus olevasse üleskutsesse minu arvamuse kohta, siis ma arvan, et tänu Reformierakonnale ja ilmselt ka teistele erakondadele saab koristajal rohkem tööd olema. Juba eelmiste valimiste ajal võis täheldada, et kui päevalehed võetakse postkastist hommikukohvi kõrvale lugemiseks või tööle kiirustades kaasa, siis poliitreklaam tõstetakse lihtsalt postkastide otsa hunnikusse.., kust see siis aja jooksul põrandale lendleb. Ehk siis tänavareklaam on efektiivsem, vähemalt visatakse bussi või rohelist tuld oodates pilk peale. Iseenesest muidugi töötas ka jutuks olev reklaam, iseasi, kas positiivses või negatiivses mõttes.

Aga üldiselt tahaks rohkem diskussiooni ja vähem ümmargusi lubadusi.

February 14, 2009December 27, 2009

Veel kord Thunderbirdist

Külastatavust vaadates torkas silma, et päris mitmed külastajad on otsinud eestikeelset Thunderbirdi ja maabunud lehtedele, mis ses osas just väga abiks pole.

Hetkel on olemas Thunderbirdi eestikeelne beetaversioon ja samuti on julgetel võimalik Mozilla serverist üles otsida öine build. Mozilla poolt stabiilseks kuulutatud versiooni aga veel pole. Küll peaks üsna pea saadaval olema beeta 2.

Kes kõige uuemat tarkvara taga ei aja saab paigaldada Thunderbird 2 ja lisada sellele eesti keele.

Ja need, kes soovivad Hotmaili posti Thunderbirdiga lugeda, peaksid proovima WebMaili.

January 24, 2009December 27, 2009

So this is what it’s about!

And I was thinking how comes that so many applications seem to have some sort of release next week or around that time.

KDE – 27th
OpenOffice – 27th
Firefox – 2nd
Stellarium – next week

I guess an event like FOSDEM really inspires developers and free and open source communities in general.

Someone else noticed the same thing and made me realise the connection.

January 20, 2009December 27, 2009

On PHP with Postgres/MySQL and hosting

About a month ago I was trying to help a friend out by uploading one of our earlier made PHP/Postgres project to my server so she’d be able to get screenshots she needed. Seemed like a simple task given that my hosting provider supports Postgres, NOT!
It soon became obvious that something is entirely wrong with the combination of cPanel and Postgres working together. Firstly I couldn’t access phpPgAdmin at all. With MySQL you simply click phpMyAdmin link in cPanel and you’re taken to your databases. With Postgres I was shown login screen and neither my hosting account nor database user credentials worked.
At some point later I was creating a database in cPanel and it wouldn’t show up in cPanel after you navigated from successful creation message to database management area.
At all times I couldn’t access database tables with user having all database privileges. In the end any new database created in cPanel had tables in it. And data in tables as well. Just like the data I was managed to get inearlier, but before executing any data definition and insertion statements after creating new database!
I first created a ticket about the issue on December 11th. Last reply I got is from January 7th. I’m nearly 100% sure I replied to it, but it doesn’t show up in clients system and I haven’t received a reply. The issue itself is closed probably due to me not replying.
At this point I don’t really care whether I really failed replying in terms of writing reply and then not sending it or anything similar or they hushed it up. They still couldn’t solve my issue in nearly a month. It was a fairly simple issue in the end, I simply wanted to use Postgres the same way you use MySQL. They failed to set it up properly and even after having my login credentials asked ME to verify if things were working when they were not.
I haven’t had any other issues with them so I’ll probably stay with them until I need Postgres again.
At least something good have come out of it. I learned that MySQL has VIEWS and nearly everything else our project used. I’ve been under the impression that MySQL is less capable than it turned out to be. After converting sequences to auto_increments and removing some Postgres-specific? ::casts it could execute most of the queries without any problem. I’m too lazy to try fixing some of the more complicated views and checking out how many of application queries actually work without changes, but I probably won’t be needing Postgres any time soon knowing what MySQL is capable of.
And what about the screenshots, you ask? Set up Postgres locally and made some screencasts with Wink.