I’m back with another update about what I do with the community, and more generally my activities that aim to spread some database knowledge (outside of this website).
London loves open source databases
The first London Open Source Databases meetup (27th March) was great. The number of attendees was somewhere between 30 and 40 (including the speakers), and the feedback they gave was good: 4.6 on a scale of 5.
The second meetup is coming! There will be two talks:
- pgAudit by Alastair Turner, data engineer at Pivotal Software;
- MySQL Query Optimisation 101 by Federico Razzoli, open source database consultant – yes, it’s me.
The event will be on 15th May and it will be hosted by Pivotal Software, at 211 Old Street, EC1V 9NR. We are not exactly respecting the initial proposition of meeting once a month, but… almost.
If you are interested in these topics and you live in London, please subscribe to the event via the event page.
UPDATE 25th Apr: Videos from the first event are now available in Percona’s YouTube channel.
PHP loves MySQL
I’ll give another talk: How MySQL can boost (or kill) your PHP application. I will give this talk at the next PHP London meetup.
Let me say that I’m not just playing with titles words. It’s true: MySQL and PHP are old friends. They were regarded as naive technologies in the early days, and… that was correct. But they were also easy to learn and use, free, practical. They were open source. And the open source philosophy was very close to the philosophy of the early days of the web, with its ideal of horizontal communication and free information sharing.
In the year 2000, if you didn’t use Microsoft ASP or Java, it was natural and logical to build your new website with PHP and MySQL. Linux, Apache, MySQL, PHP: LAMP.
They both evolved with the web, and went beyond the web. They developed new features, learned to scale better, and integrated with more modern technologies. Just like the web.
So, LAMP is still there. Nowadays you may prefer MariaDB (which also starts with an M), or Percona Server. They are still substantially compatible, and they are still open source.
For these reasons, I am excited to give a MySQL talk in front of a group of PHP enthusiasts. This is surely not the first talk I give, but this is the first time I talk to PHPers about MySQL. It was about time!
I wrote an article about MySQL storage engines, that was published on ADMIN #50. I mentioned almost all storage engines, even if some of them have only a historical interest, and others are just niche engines. But if you think that InnoDB is the only storage engine, you are wrong (even if you work at Oracle). I find RocksDB, TokuDB and CONNECT extremely interesting.