I’ve just committed a function to easily purge old data from LogMiner’s database, useful to prevent it from growing too much. It’ll appear in the next version, but since its release might still be far from now, here’s the code for those who need it: 123456789101112131415161718192021222324252627282930313233343536373839CREATE OR REPLACE FUNCTION cleanup( _site int8, _upToDate DATE ) …
Category: IT & Technology
PHP templates
When you design a complex application, it’s always useful to separate the presentation layer from the business logic. Usually, when dealing with web apps, this involves handing templates which are “filled” with data by your controller. The common rationale is that the template should contain as little logic as possible and that it should be …
Attributes, reflection and PHP
After a long exposure to .NET, when I get back to PHP I sometimes find myself missing some cool functionality (and a good IDE too… none of those I’ve tried so far can compete with the comfort of VisualStudio + ReSharper). Among these missing features, attributes are what I needed in order to solve a …
MP3 Cat has moved
I’ve noticed that some people use the blog search box to look for MP3 Cat, finding exactly 0 results… 😐 This article might point them to the right place: http://www.tellini.org/win/mp3cat/ 😉
Is MySQL bad for (open source) software quality?
I think so. Why? Because it’s basically a toy DBMS with too many non-standard behaviours. A lot of open source projects choose MySQL mainly because it’s widely available among hosting providers, while better RDBMS like PostgreSQL1 are hard to find. The real problem is, a lot of open source developer know very little about SQL …