The MariaDB team has announced the release of version 5.3.5, the first stable general availability release of the MariaDB 5.3 series relational database.
Work on the new series has concentrated on improving the performance of the database, in particular query speeds.
MariaDB is the community-developed spin-off of MySQL that was started when Oracle took over the original MySQL. MariaDB is developed by Monty Program, which was started by Monty Widenius, the main developer of the original version of MySQL.
The areas where the query optimizer has been improved start with subqueries, which now work well enough to avoid having to rewrite subqueries manually into joins or into separate queries. The Maria Knowledgebase says that all problems with EXPLAIN taking a long time have also been resolved.
The optimizer changes include support for block hash joins for any equi-joins. There’s a new implementation of Multi-Range-Read optimization to improve performance for IO-bound queries that need to scan lots of rows, and all block-based algorithms for joins can make use of index condition pushdown.
In this no comment we focus on the growing technique of super-resolution. The idea is simple take a low resolution photo and scale it up with more pixels. The surprising thing is that it is possible t [ ... ]
Members of the IProgrammer team each have their own favorite languages and we try to keep up with all the latest developments. These are the most recent three and as we have nothing to add they are pr [ ... ]