When storing your backups on an external drive you occasionally take with you it is a very good idea to encrypt your backups. Here are some personal conclusions after trying 2 different solutions.
… sau “Vecina avea dreptate” sau “Pretul unei fapte bune?”
Acum cativa ani pe pervazul geamului la care lucrez a venit un porumbel. Ne-am inspectat cu atentie o vreme, fiecare ocupandu-se mai departe de treaba de zi cu zi. Eu tastand in continuare si el netezindu-si penele sau cautandu-le de “bug”-uri. I-am pus un pic de paine maruntita, sau un rest de biscuit. Dupa un timp, si foarte multi biscuiti, ne-am imprietenit. Nu a venit la mine, nu a stat in palma, dar a inceput sa vina sa ceara biscuiti, acelasi porumbel, doar mult mai gras. (more…)
Ever needed to check if a date matches another within a certain range? If you need to trim to hours, minutes or seconds the date_trunc function in postgres does the job just fine. How about if you need to trunc to 10s? The following function should be of assistance:
CREATE FUNCTION date_trunc_x(TIMESTAMP WITH TIME zone, NUMERIC) RETURNS text AS $$ SELECT SUBSTRING(EXTRACT('hour' FROM $1)||':'||EXTRACT('minute' FROM $1)||':'||(EXTRACT('second' FROM $1)::INT/$2) FROM 0 FOR 8) $$ LANGUAGE SQL;
In can be used as in the following example:
SELECT * FROM POSITION WHERE date_trunc_x(update_time, 10) IN (SELECT date_trunc_x(update_time, 10) FROM event_msg_x WHERE event_fk = 31 AND cp = '4' AND trackcode = '117') AND trackCode = '117'
find . -mtime 1 -type f -print0 | tar -czvf $SYNC_DIR/$BFILE -T - --null
I dedicate this article to the Spanish cyclotourists we’ve met in Albac and the ones we met later on the road. They did not knew much about the region and were limiting their journey to the main asphalt roads without any detours. At that time I did not knew much about cycling possibilities in the region myself so I was only a bit sad for them, coming all the way here and not seeing any cave or more traditional village. I write this in English in the hope some cyclotourist thinking of cycling this road will find this and have a worthwhile detour.
Why not spend 1 or 2 days seeing this:
instead of this:
Day 1/2, Albac to Sfoartea, 31km, cyclotouring
There is no shortcut from Bucharest to Albac, the start of our journey, so we arranged the panniers on our bikes around 3pm and started on the road at 4pm. This was quite fortunate since it was a very hot day. All of us, Magda, Cata, Vali and I, have planned this trip in a bit of a rush but were very excited coming here to explore a bit the region.