At the upcoming MySQL Users Conference, we will have a lot more
exhibition space compared to last year. We also want to show off
the extensive community activity with MySQL, so this is a neat
opportunity.
We are looking for open source projects that use or extend MySQL,
who want to present their project in the exhibition area of the
conference. There may also be some presentation opportunity (like
"lightning talks" perhaps), but that will depend on
scheduling.
Primarily, we would like to hear from projects which are not
backed/run by a company, because companies of course already have
the opportunity to become a sponsor/exhibitor.
Also, note that the conference is in Santa Clara, California -
while we can provide space, we are unable to fund everybody's …
At the upcoming MySQL Users Conference, we will have a lot more
exhibition space compared to last year. We also want to show off
the extensive community activity with MySQL, so this is a neat
opportunity.
We are looking for open source projects that use or extend MySQL,
who want to present their project in the exhibition area of the
conference. There may also be some presentation opportunity (like
"lightning talks" perhaps), but that will depend on
scheduling.
Primarily, we would like to hear from projects which are not
backed/run by a company, because companies of course already have
the opportunity to become a sponsor/exhibitor.
Also, note that the conference is in Santa Clara, California -
while we can provide space, we are unable to fund everybody's …
Arjen Lentz: King Kong and MySQL…:
Arjen mentions that Weta Digital in New Zealand uses MySQL. For further mention, these folk use Fedora Core for their OS. I have an appointment to talk to their press people sometime in mid-January to discuss their Fedora use; I guess now I’ll aim to find out more about both.
Oh, and Halo, that popular Xbox/Microsoft game, is to be a movie. Powered by Fedora and MySQL :)
Got back to my favorite place in the MySQL docs tonight, the release notes for the 5.0 tree. I did a quick writeup back when 5.0.12 came out looking at changes in the recent history. Some significant changes between then and now, at version 5.0.18 (not released):
- CREATE VIEW now allows for DEFINER, to provide defining user, and SQL SECURITY syntax to set DEFINER or INVOKER - syntax allowed but parsed and ignored
- FEDERATED storage engine now uses the CONNECTION option for connection string (as opposed to the previously used COMMENT) …
one of my co-workers gave me some good advice.
Keep track of changes you make to your config files with rcs.
Go GNU.
Last week I was with a customer and came across a side problem
that was of a more general nature. It is the problem of users
having a number of things that use up ressources. The things may
be mails, recordings, stamps or whatever - for simplicity we
assume recordings, and the ressource consumed is size. The system
has a quota system in place, which stores a ressource limit per
user.
The quota problem is: if a user is over quota, we want to get a
number of item ids to delete per user from old to new, until that
user is under quota or just one item over quota. This is the
quota problem, and I needed a quota query that solves it.
Here is the setup.
Continue reading "The Quota Query and Running Sums
by Jan and Kai"
Returning from my vacation and catching up with all that happened
on Planet
MySQL in the meantime I just saw Eric
Bergen lamenting about The lost art
of the join. I think he's right with his statement as I see
lots of beginners (and not only those) struggling with problems
that could easily be solved with a simple JOIN. So
my invitation goes to all the geeks at Planet MySQL: Let's just
give a few nice examples to everybody out there to save the art
of the join.
I'll start with a simple but effective one: JOINs in
a relational database are typically used to connect different
tables together. That's why a lot of people often overlook the
fact that many problems can be solved with a JOIN of
a table on itself.
…
[Read more]
Lets see, since 4:30 I have ->
Dinked up a feature for LJ.
Finished up a chunk of AZIO for MySQL.
Wrote a converter to dump one of my flat file databases of
addresses out of the flat file and into VCARD.
Not heated up the Chili like I told Christine I would.
Feared the movie that someone brought home, it has Puppets.
Thought about adding a new field type to MySQL. The request for a
UUID () field type calls to me.
Not traveled to a foreign country at the last moment.
Setup the http://planetasterisk.org website. PlanetPlanet! is pretty cake software to make work.
Someone should do a Fedora rpm.
Considered that in the future I should trade other open source
projects features that I can write in turn for them writing a
feature for me. …
One of the things that pushed me to upgrade to Fedora Core 4 was
suspense of the automatic updates from the Red Hat Network a
while ago. It seemed as though every time I wanted to install
something I needed to search out the correct RPMs and install
them before I could intstall the software I originally wanted to
install.
FC4 opened my eyes to a totally new updating method; yum. I did a
quick search and found The
Unoffical Fedora FAQ which walked me through setting up yum
and installing software for it. I installed the updated gcc
compiler using yum and it only took a couple minutes to download
gcc and any dependencies. "Wow, this is easy", I thought to
myself, so I used yum to update OpenOffice.org to 2.0. This is
definitely a nice tool to keep some of your general software up
to date.
I don't think I'll use yum to keep my main database software …
RightNow Technologies is a publicly traded company (NASDAQ:RNOW) that has built a successful business on open source. Although you won't read about them in the usual open source blogs or hear about them at open source conferences, they are as important a user of open source technology as companies like Yahoo, Google, Sabre and many others. RightNow offers a hosted or "on demand" CRM service used by over 1,000 organizations including the likes of British Airways, Cisco, John Deere, Nikon and many others.
RightNow is not a huge company nor are they as well known as their chief rival salesforce.com but they are profitable and have a run rate north of $100 million annually. One of their chief advantages could be that they have built their …
[Read more]