simple brain teaser:
given standard unix crontab what is the longest possible interval between calls to the same program?
for example:
15 */2 * * * /bin/echo x
has interval 2 hours.
what is the longest possible? and how to make it?
projektowanie stron przy pomocy screenshotów z innego serwisu
znajomy powiedział mi dziś o jakiejś wtopie mailowej az.pl. z tej okazji wszedłem na ich stronę. i oczom mym ukazała się strona:
Continue reading projektowanie stron przy pomocy screenshotów z innego serwisu
getting multiple values from sequences
there are this situations where you need (or you think you need) to get multiple values from sequence.
for example – you're importing lots of data: some objects, some objects which relate to base objects, and so on.
of course you can do it all with simple inserts, and currval, but it would be rather slow:
smtp + sql = more than it seems so (part 8)
last time, i showed how to add automatical filtering of mails. and i told you that i will show another way.
Continue reading smtp + sql = more than it seems so (part 8)
smtp + sql = more than it seems so (part 7)
in previous part of this howto we setup autoresponder/vacation system.
additionally i promised to show how to filter user mails.
Continue reading smtp + sql = more than it seems so (part 7)
waiting for pg 8.4
today (2008-03-10) magnus hagander commited patch which adds new, quite handy functionality: “enum type for guc parameters".
smtp + sql = more than it seems so (part 6)
in last part of this howto we did setup pop3/imap client access.
together with things set in all previous parts it makes a fully working mail system.
but, there are still things that might be added/modified. one of these is vacation support …
Continue reading smtp + sql = more than it seems so (part 6)
searching for longest prefix
couple of times is was brought to attention of #postgresql channel – how to find longest prefix.
case: you have phone number, and you want to find which carrier it is bound to.
there are at least 3 ways of finding it, and i decided to take a look at which is fastest.
smtp + sql = more than it seems so (part 5)
last time i finished with working smtp system, with accounts, aliases and quota. now, let's add ability to get th
e mails for client (imap/pop3) and some smtp-auth.
Continue reading smtp + sql = more than it seems so (part 5)
smtp + sql = more than it seems so (part 4)
at the end of previous part of this text, we got our system working, and accepting emails for local accounts. plus i promised to add quota now 🙂 so, let's do it.
Continue reading smtp + sql = more than it seems so (part 4)