On Wed, Oct 21, 2009 at 08:12:45PM -0400, Juan Manuel Placco wrote:
> Hi there,
> 
> I work for an important industrial company and we've been using QNX from almost always. We're jumping since earliest 
versions to this days. We are considering to continue using QNX to control our production lines. There is no decision 
yet in another sense, but we have some question mark: 
> 
> Which is the best database option to manage large amount of data? (embedded systems  isn't our work!). We made this 
same question to QNX support some years ago, and the response was concise "Empress". The result were not good enough, we
 started to make some tests with MySQL. 10 years later MySQL is our standard in every project (we use it under GPL 
license modality). 
> 
> Maybe this is a question to be also posted in a MySQL forum, or other supported database engines.
> 
> Thanks!
> JM

You can get mysql, client and server, here:

ftp://ftp.netbsd.org/pub/pkgsrc/packages/QNX/i386/6.4.1_head_20090724/All

Check out the pkgsrc project:

http://community.qnx.com/sf/projects/pkgsrc

Regards,

-seanb

Hi Juan,

To give you good advice we'd need to know a lot more details.  For example:
 - concurrency
 - database size
 - writer frequency, reader frequency
 - ease of use
 - licensing requirements

One option you can consider is our database which we call QDB.  It is an sqlite3 based database and provides a resource 
manager interface so you can use QNET with it.   sqlite3 is a very stable and mature product that I recommend in many 
cases (but maybe not yours depending on needs).   From an embedded point of view it is simple, just a file backend for 
the database so recreating databases is trivial as are other administrative tasks.  This is important in embedded 
because you don't ship a DBA with your product :)   sqlite3's license is public domain and comes with a blessing instead
 of a legal disclaimer..  fairly uncommon in this day and age.

QDB and sqlite3 will ship in 6.4.2.  If you can't wait that long you can get QDB today from our multimedia foundry27 
source code.

Hi JM,

We've been using MySQL in QNX for several years now without any real issues, other than a note to keep an eye on the 
thread priority management.  I will point out that for very large databases, most of the filesystems currently supported
 under QNX have a limit of 2GB per file, so your DBA may have to do some tuning to work around this limitation.  Other 
than that, it's performed very well for us!

-Will