Moving...

I've decided to move my Russian language posts to separate blog - http://deniszh-rus.blogspot.com
Here will be only English ones. Enjoy!

End of MySQL vs PostgreSQL arguments

Russian text is here.

Good article about MySQL vs Postgresql. Summary for lazy readers -
"MySQL is designed with the idea that applications provide logic and the database provides dumb storage of the application's state.  While this has changed a bit with the addition of user-defined functions and stored procedures, the overall design constrains MySQL primarily to this use case.  This is not necessarily a bad thing as, traditionally, software licensing costs and requirements have often required that even advanced database systems like Oracle are used in this way.  MySQL targets the "my app, my database" world and is usually sufficient for this, particularly when lowest common denominators are used to ensure portability.

PostgreSQL, on the other hand, is designed with the idea that the database itself is a modelling tool, and that the applications interact with it over an API defined in SQL.  Object-relational modelling advocates point out that often getting acceptable performance in complex situations requires an ability to put some forms of logic in the database and even tie this to data structures in the database.  In this model, the database itself is a development platform which exposes API's, and multiple applications may read or write data via these API's.  It is thus best seen as an advanced data modelling, storage, and centralization solution rather than as a simple application back-end.

These differences show, I think, that when PostgreSQL people complain that MySQL is not a "real database management system" and MySQL people dispute this that in fact the real difference is in definitions, and in this case the definitions are deceptively far apart.  Understanding those differences is, I think, the key to making an informed choice." 

More beauty in feed!

Couple of links.
https://www.shortcutfoo.com - train your favorite text editor's shortcuts!
https://github.com/jkbr/httpie - like, "human friendly cURL" - able to parse JSON and make nice color output.

Beautiful thing

Sad news, camrades

Russian text is here

Sad news, comrades.
In all holywars about Perl vs Everything some high-loaded Perl projects was already mentioned. One of them was YouPorn - one of largest porn ahem .. adult entertainment websites in the world.
But not anymore.
You can check presentation (PDF / PPTX / GoogleDocs) of their technical lead on Confoo conference -

• Written in PERL with a very complex architecture
• First few months dedicated to learning the site, maintain it, and plan the re-write.
• Re-write started in August 2011 and was originally planned for a delivery in mid-November.
• Actually launched at the end of January.

So, in the end of 2011 site was completely rewritten on PHP - it's simplier, faster and easier to find staff.
Another architecture is pretty neat and straightforward -  HaProxy + Varnish + Nginx/PHP-FPM/Symfony2 + Redis/MySQL + Syslog-ng for logging, only one strange decision - they are using ActiveMQ for DB/Redis writes managing, but as far as I understand from presentation it's not very good solution for them... 

What do you know about perlsecret?

All perl lovers - please check perlsecret. It's fun and worth reading. I liked operator called Kite or ... sperm, which looks like  "~~<>". :)  

Why Privacy Matters Even if You Have 'Nothing to Hide'

Maybe you heard such opinion about privacy before -  "I've got nothing to hide. Only if you're doing something wrong should you worry, and then you don't deserve to keep it private."

You can check this intresting article about this matter, why this logic is false.