I need to compile something and use the MySQL C++ library. I have mysql and mysql++ already compiled, I won’t go over how to do that now.

I added the following code to the top of my source:


#include <mysql++.h>


I got an error

/Users/jhaddad/dev/search_engine/main.cpp:4:21: error: mysql++.h: No such file or directory

Not cool.

How to fix:

In XCode, open up the project settings (under the project menu). Go down to search paths, and you can change your Header search paths to the correct locations where you installed whatever you’re looking for. In this case, mine was /usr/local/includes and /usr/local/mysql/

Next time you try to recompile, you’ll get a different error, this time it should be during Linking. Might look something like the below.

“mysqlpp::Query::store(mysqlpp::SQLQueryParms&)”, referenced from:

…

We're heading into February and that means there's only a few weeks left until the MySQL Conference & Expo early registration expires.  This year's conference promises to be our biggest and best ever.  I suspect that a lot of the hot tutorials on performance tuning and new features will sell out early.  There will be sessions on our various storage engines including InnoDB, Cluster, Falcon and Maria -- a new "MyISAM …

So I don't know who's in charge for this at MySQL so I thought I would just gain their attention by posting here. In addition, I hope this can help others in similar need/situation of serving content on multiple domains.

Basically MySQL serves content on both mysql.com and mysql-press.com which is a NO NO from the point of view of major search engines, most notably Google. Both domains go to the same IP (at least when I checked). This can potentially trigger duplicate content penalty and may even be hurting MySQL's ranking in SERPs (Search engine result pages).

Google seems to be already aware of the other domain.

Right way to serve …

When your company decides that "it is time to build a data warehouse", what thoughts come to mind?1) A magical fairy ice cream land where data is presented in chocolate shells for everyone to digest perfectly;2) A big literal warehouse in the industrial section of town with rusty old containers;3) Another place to put data, which means another place for you to track and monitor additional

This February I`ll be heading to my 8th Fosdem in row.

I went to every single Fosdem so far, some years only one day because of other obligations but I was a round most of the time
During the first couple of years I was pretty active in the FIT team, helping out people to find the right rooms , keeping the fosdem contributions safe with Sven, funding different social events and devroom dinners ,
Later I was in charge of the HPC and Cluster devroom in which we also held the openMosix summits.
And back in 2004 I replaced Moshe at the openMosix Summit standing in front of a great audience at the Janson room.

As Wim just pointed out the Drupal Devroom schedule is out
and it seems like 2008 will …

Test your knowledge of MySQL! There are four sets of questions covering the four MySQL Certifications.

These questions are closely modeled on actual questions from the Associate, Developer, DBA, and Cluster DBA exams.

These questions are for entertainment purposes only. And hopefully those of you lacking your MySQL Certifications will entertain taking the exams!

Sergey Petrunia brought to my attention the work Optimizer Team has done in MySQL 6.0 related to SubQuery Optimization.

I am excited to see this information published honestly outlining the things which are fixed now and things which are still not handled well. According to the bug sampling done by Optimizer Team 68% of reported issues are fixed (significantly improved) by changes in MySQL 6.0 which is far from all the issues but still very good number.

If you had issues with subqueries in MySQL 4.1 or 5.0 and pulled away from using them I'd encourage you to try MySQL 6.0 and see if your issues are fixed or described in the documentation published. If not report the bug and let optimizer team to know how you're suffering

In particular you can review Currently Working …

Many MySQL users like to use the MySQL monitor. The MySQL monitor is the executable bin/mysql (or if you are on MS Windows, bin\mysql.exe) and is perhaps better known as the MySQL command-line tool or MySQL command-line client.The MySQL monitorBasically, the MySQL monitor is a standard, text-based terminal that connects to a running MySQL Server when it is started. Once the connection is established, the user can enter text via the computer keyboard, which is at some point sent to the server. The server attempts to interpret the received text as SQL, which is then executed, sending the result back to the MySQL monitor. The MySQL monitor then prints the received results on the screen:

mysql> SELECT COUNT(*) FROM world.City;
+----------+
| …

We have just published an interview with our CEO Mårten Mickos on our Developer Zone, where he answers a number of questions from the Community Team about Sun's plans to acquire MySQL AB and what this means for the MySQL User Community and the direction of the product (thanks to Colin for compiling and editing the text). I hope that the comments help to calm the concerns of some people about the future of MySQL with regards to Open Source, support of platforms or language bindings:

CT: Is MySQL fully committed to free and open source software, and the GPL?
Mårten: Yes.
CT: What does the Sun acquisition mean for Linux support? What about Windows, Mac OS/X and other platforms?
Mårten: One of the reasons …

This TOTD (Tip Of The Day) shows how to install Rails 2.0.x in JRuby 1.0.3 and JRuby 1.1 RC1. Then it describes how a simple Rails application can be created and deployed using WEBrick.

First, lets deal with installing Rails 2.0.x in JRuby 1.0.3 and JRuby 1.1 RC1.

Step 1: How to install Rails 2.0.x in JRuby 1.0.3 ?

• Download and Unzip JRuby 1.0.3. This creates "jruby-1.0.3" directory.
• Install Rails by giving the following command in the newly created directory:
  
  bin/jruby -S gem install rails --include-dependencies --no-ri --no-rdoc
Bulk updating Gem source index for: http://gems.rubyforge.org
Successfully installed rails-2.0.2
Successfully installed activesupport-2.0.2
Successfully installed activerecord-2.0.2
…