Need database selection advise

Posted by jacknad on Ask Ubuntu See other posts from Ask Ubuntu or by jacknad
Published on 2012-04-03T11:12:46Z Indexed on 2012/04/03 11:41 UTC
Read the original article Hit count: 378

Filed under:
|
|

I know this is considered a bad question since there is no correct answer, but I need to decide on a database for embedded linux (DaVinci 368 based) hardware and I've never had to produce a design with a database before. Each record will probably contain less than 1000 images with associated alpha-numeric data and the mass storage will be some kind of flash drive. Only one user needs access to the data at a time. MySQL claims to be "The world's most popular open source database" but SQLite claims to be "the most widely deployed SQL database engine in the world." Perhaps there is another that is also the best in the world? Which is easiest to use for a database newbie? Should I just flip a coin? Does it really matter which one I pick? Do I even need to use a database software package or should I roll my own? I won't need bells and whistles like sorting, but I'll probably need to delete the oldest records to make room for new ones if the storage fills up.

© Ask Ubuntu or respective owner

Related posts about mysql

Related posts about database