The future of open source licensing. OpenSolaris governing board quits. And more.
# Glyn Moody asked which open source software licensing is best for the future?
# The OpenSolaris Governing Board has collectively and expectedly resigned.
# OpenBravo has updated its rapid implementation ERP offering for small and mid-sized businesses, Openbravo QuickStart. …[Read more]
This blag was originally posted at http://cafuego.net/2010/05/26/fast-paging-real-world
Some time ago I attended the “Optimisation by Design” course from Open Query¹. In it, Arjen teaches how writing better queries and schemas can make your database access much faster (and more reliable). One such way of optimising things is by adding appropriate query hints or flags. These hints are magic strings that control how a server executes a query or how it returns results.
An example of such a hint is SQL_CALC_FOUND_ROWS. You use it in a select query with a LIMIT clause. It instructs the server to select a limited numbers of rows, but also to calculate the total number of rows that would have been returned without the limit clause in place. That total number of rows is stored in a session variable, which can be retrieved …[Read more]
Some time ago I attended the "Optimisation by Design" course from Open Query¹. In it, Arjen teaches how writing better queries and schemas can make your database access much faster (and more reliable). One such way of optimising things is by adding appropriate query hints or flags. These hints are magic strings that control how a server executes a query or how it returns results.
An example of such a hint is SQL_CALC_FOUND_ROWS. You use it in a select query with a LIMIT clause. It instructs the server to select a limited numbers of rows, but also to calculate the total number of rows that would have been returned without the limit clause in place. That total number of rows is stored in a session variable, which can be retrieved via SELECT FOUND_ROWS(); That simply reads the variable and clears it on the server, it doesn't actually have to look at any table or index data, so it's very fast.
The White House contributes to OSS. Growth for Pentaho and MuleSoft. And more.
# The White House released some of the custom code it has developed for whitehouse.gov as open source.
# Pentaho reported 229% bookings growth and 177% Enterprise Edition customer growth in Q2.
# MuleSoft grew bookings by 140% in Q1.
I have an interesting problem, on a data migration project I'm currently working on. I'm importing a large amount of legacy data into Drupal, using the awesome Migrate module (and friends). Migrate is a great tool for the job, but one of its limitations is that it requires the legacy database tables to have non-composite integer primary keys. Unfortunately, most of the tables I'm working with have primary keys that are either composite (i.e. the key is a combination of two or more columns), or non-integer (i.e. strings), or both.
Table with composite primary key.
The simplest solution to this problem would be to add an auto-incrementing integer primary key column to the legacy tables. This would provide the primary key information that Migrate needs in order to do its mapping of legacy IDs to Drupal IDs. But this solution has a serious drawback. In my project, …[Read more]
I would like to point the crowd to the Call For Presentaions of Loadays. , the Linux Open Administration Days .
The Linux Open Administration days 2010 will be the first edition of a new conference focusing on Linux and Open Administration, we are trying to fill a gap for System Engineers and Administrators using Open Source technologies"
More details on the Linux Open Administration Days site
I'll probably be there .. given the fact that the event will be 5 minutes from where I live .[Read more]
Fosdem 2010 was my 10th fosdem Edition (including the first
As every year Fosdem suffered even more from it's own success.
On Friday evening ther was the obligatory Beer event... however as people need to eat to .. the Devops crowd fled the scene
I had made reservations for a 20 something group and with the
CentOS crowd joining us (as there was some overlap anyhow) we
were 25 when we arrived in the restaurant .
Dinner and Discussions were great .. I learned about some new projects and we had some insightfull dicussions on how fat your thin foil should be ...
After dinner we went back to the Beer Event were lots of Free Beer was tasted ...
Saturday was the first full day of Fosdem, as usual Fosdem was the victim of it's own success , too much interresting stuff to see .. too little time.
Lots of Devrooms had the "FULL" sign put up more than you want as
a visitor ...
At DrupalSouth 2010 (Wellington) after LCA2010, Peter and I implemented a Drupal module as a practical example of how the OQGRAPH engine can be used to enable social networking trickery in any website. The friendlist_graph module (available from GitHub) extends friendlist, which implements basic functionality of friends (2-way) and fans (1-way) for Drupal users.
The friendlist_graph module transposes the friendlist data using an OQGRAPH table, allowing you to query it in new and interesting ways. By adding some extra Drupal Views, it allows you to play Six …[Read more]
Fosdem is coming up again .. It's going to be the 10th edition already So it's going to be 2 days and nights of fun, tech and geek stuff
Lenz already posted the announcement , but allow me to recapitulate.
The MySQL & Friends meetup is on saturday evening , we'll meet around 1900 in front of the under the big tree in front of the AW building...
The crowd voted and Favoured an Italian place , so I've made reservations for a 15+ persons group at Sogno d'Italia which is …[Read more]