MySQL is the most popular open source database in the world.
Softpeople Formazione of Milan, Italy, the education company of Softpeople Group, is please to announce that they have been selected by MySQL to be the first Authorized MySQL Education Center (AMEC) partner for Italy, offering certified MySQL training either by the two training Center in Milan, C.so Buenos Aires, 77 and Rome, Via Benedetto Croce, 19 as well as by customers' locations across the country.
Webyog is the company behind the popular SQLyog GUI tool for managing and developing MySQL databases. They have a great history of partnership with MySQL and, recently, decided to open source part of their product line. I had a chance to interview Rohit Nadhani, co-founder of Webyog, about their decision to move to open source, the changes they've made to the code as a result of that move, and various other things.
Sometimes we may need to know geocode of some specific postal location. For example, you have some shops catalogue and want to show shop locations on the map. Then, you will need to ask some service about map marker coordinates. If geocode service is not available or it can’t parse provided address, you will not be able to show map to your users. To solve such problem I’ve created small PHP-module, that helps me to get reliable results from set of miscellaneous geocoding services.
As for now, module can use Google Maps API, Yahoo Maps Services, Geocoder.us and …
[Read more]
activerecord now supports mysql 4.1 (and later) out of
the box whether you are using new or old-style passwords,
because they applied my patch for handling the related protocol
changes correctly.
(it?s not quite out-of-the-box yet ? the fix will appear in
the next major release of rails, i guess. it?s fixed in their
repository.)
now if only the upstream developer would show signs of life, and
get that fixed. i?d complain about that more, but there?s a lot
of windows around here.
Our good friends at MySQL and Pentaho are hosting a webinar about ETL for MySQL using Pentaho Kettle.
ETL is a multipurpose technology, from straight data integration to data migration to reporting systems. Kettle is primarily used in building Data Warehouse/Data Marts but can also be used for doing other useful MySQL admin tasks.
Matt Casters and Lance Walter will give you the low down on
Kettle:
http://www.mysql.com/news-and-events/web-seminars/etl-using-pentaho-kettle.php
I recommend it, even if you’re not interested in MySQL. You’ll be surprised that an Open Source ETL tool is so visual and easy to use you may consider it for all kind of tasks.
There's a good article from LinuxDevices that quotes IDC on sizing the open source market. IDC did a study of 5,000 developers in 116 countries showing that open source is being used by over 70% of developers. (Ok, so clearly there is still some work to be done!)
While this statistic may not be startling to those who have been using open source for years, it indicates that open source continues to become more mainstream. Over 50% of the organizations had open source software in production, and that number seems poised for more growth given all the development usage. It seems obvious to me that the next generation of killer applications will be based on open source. Lets face it, once the majority of developers embrace it, it's all over but the shouting.
What this project aims at is to stimulate the implementation/adoption of free software, open source software and open standards in the Bulgarian Government Administration (BGA) and other sectors of management, in the economics and at home.
There will be a reading of the EU requirements and a review on
which of the open standards are suitable for the current status
of the BGA. The project has the objective to prepare the
migration from present-day to open source EU recommended
technologies. We will create a special guide that will focus on
how to migrate, how to make this process easier and how to create
the prerequisites for doing so.
We will review all of the available OS and software possibility,
covered by this project that can be used in the BGA and other
sectors.
We need supporters and fresh ideas. Please let me know if you are able to help us with your experience, knowledge or by other way.
The (probably and hopefully) last beta versions of XAMPP for
Windows and Linux are available for public download in our
XAMPP BETA area. New in this version are: Apache
2.2.3, MySQL 5.0.24a, PHP 4.4.4 and 5.1.6, and phpMyAdmin
2.8.2.4.
Beta releases are only for testing purposes. We would very much
appreciate it if you could test this release and let us know if
you run into any problems.
If no problems are found the final version will follow this
weekend.
Follow me to the XAMPP BETA area
By nat
We build our conferences to reflect our Radar, and EuroOSCON is no different. Here's who'll be keynoting in Brussels in two weeks' time:
InnoDB uses its own mutexes and read-write locks instead of
POSIX-mutexes pthread_mutex*, the main reason for that is
performance, but InnoDB's implementation isn't ideal and on
modern SMP boxes can cause serious performance problems.
Let's look on InnoDB mutex (schematic for simplification):
PLAIN TEXT CODE:
innodb_spin_locks is configurable via system variable innodb_sync_spin_loops (default value is 20)
There we have:
1. Spin-loop - InnoDB uses spin-loop in hopes thread locked mutex
is very fast and will release mutex while current thread runs in …