Hey, all. Petr Pisl, the technical lead for PHP support in
NetBeans, and I will be giving a MySQL University webinar tomorrow entitled
"Working With PHP and MySQL in NetBeans." We'll
be demonstrating the PHP and database tooling features available
in NetBeans.
The webinar is live, and you can ask questions via a chat-based
interface. It's at 9:00 am San Francisco time, you can see what that is in your local time
here.
The webinar is limited to 20 people, so it will be first come,
first serve. Apologies about the small "classroom" size -- MySQL
University just started using …
Oct
22
2008
Oct
22
2008
On a large data migration project that I am currently spearheading, we have a large installed userbase of over 2 million users running on a social networking engine. The schema has been redesigned from scratch, and code is being written to match the new schema, using the all-powerful MySQL database as the system to manage all that data.
Since this social network is global, we need good and reliable location information. The current location model is flawed and full of holes, so we have chosen AssemblySys‘ data to replace it.
We are not using AssemblySys’ schema, as we’ve rolled our own. I’ve designed our new schema to be hierarchial in nature, treating all locations on the planet as ‘nodes’ with a tree relationship, with “Earth” being the parent of all nodes. This model allows us to account for all countries and their idiosyncratic …
[Read more]
Oct
22
2008
I'm pleased to announce the release of DBD::mysql 4.009! A couple
fixes are included with this release:
* Fix to re-enable TAKE_IMP_DATA_VERSION. Still have to ensure
DBI version 1.607 or higher in the test suite (Daniel Frett,
myself)
* Fix to escaped single quotes throwing off bind param detection.
Patch from Zhurs (zhurs@yandex.ru -- Spasibo!), new test modified
to use Test::More (myself)
Thanks/Spasibo for the help from Daniel Frett and Zhurs as well
as all those who report bugs!
The file:
The uploaded file
DBD-mysql-4.009.tar.gz
has entered CPAN as
file: $CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.009.tar.gz
size: 125168 bytes
md5: 1115dcc2560191bfaed09baf6aa7e183
Found at:
…
Oct
22
2008
Today, the site was officially launched!
Soon, we will make the beta version of Jet Profiler for MySQL
available to selected users! Contact
us if you are interested.
Comments
Oct
22
2008
Just finished up O’Reilly’s Backup & Recovery by W. Curtis Preston. The title is wide-reaching, covering backups at the operating system as well as on all the popular database platforms, including Oracle, MySQL, Postgres, Sybase, SQL Server and DB2. Preston has an amazing grasp of a spectrum of technologies and platforms, and as an Oracle & MySQL DBA myself, I’d use this as my backup reference text any day.
I’ve posted my review of Backup and Recovery over at Amazon.
Oct
22
2008
This week Pentaho released version 2.0 of its BI Suite, and
it contains two major features that the mondrian community will
love.
First, the Pentaho User Console, a web-based environment where
end users can create, view, save, and share BI content. Content
is arranged into folders, and includes operational reports
created with Pentaho Reports, and dimensional analytics created
with Pentaho Analysis (mondrian). Users can also create
subscriptions to receive reports regularly by email. PUC is
simple and elegant. I predict that it will quickly become the
face of Pentaho for end users.
Second, the Pentaho Aggregate Designer, which automatically
creates a set of aggregate tables to accelerate a mondrian
schema. I believe that …
Oct
22
2008
Yesterday, we concluded our third annual “MySQL Kundenkonferenz” in
Munich. We had a record number [1] of participants, 255 on the
re-count including hosts. I had the pleasure to deliver the
welcome speech and to moderate the event. Personally, I
thoroughly enjoyed the day and it was my distinct impression that
the expectations of the participants were more than met.
The external setting of the conference was Hilton Munich City on Rosenheimerstraße, close
to Munich’s culture centre Gasteig — and just one S-Bahn stop away from home
for me. Excellent facilities.
The start was delayed slightly due to our high-latency registration process, which prompts us to go …
[Read more]
Oct
22
2008
Yesterday I visited the MySQL Customer Conference in Munich, as I did
last year. The agenda was quite similar to last year's agenda,
but I was really surprised how much Sun hardware and software
products were integrated (forced?) into most of the not so
technical talks.
All in all the conference was okay, but not as good as last year.
Oct
22
2008
Yesterday I visited the MySQL Customer Conference in Munich, as I did
last year. The agenda was quite similar to last year's agenda,
but I was really surprised how much Sun hardware and software
products were integrated (forced?) into most of the not so
technical talks.
All in all the conference was okay, but not as good as last year.
Oct
22
2008
It's been about a week since the initial launch of the first 5.0 packages and the OurDelta website, so it's time for some first impressions and an update on what's going on right now...
-
- Immediately lots of hits on the site (from 67 distinct
countries), most downloads and repo retrieves started happening a
few days later.
- Interest spiked even more when we put up the Debian 4.0 (Etch)
packages, apparently there was serious pent-up demand
there!
- Lots of positive responses from clients, user groups, global
MySQL community, and in fact also from within Sun/MySQL. That's
very nice, as it provides confirmation we're doing something
worthwhile!
- No negative responses, blog posts or articles that I know of (and yes I did search around a bit through Google, …