Lightweight SQL server for Raspberry Pi

Question

I'm looking for a lighweight database/SQL-server to run on a Raspberry Pi. Since it should be accessible from more than one application, embedded databases like SQLite would not work, thus it should be a standalone database (I know that SQLite databases can be read by more than one process at the same time, but I'm mostly doing write-operations which would lead to many locks on the file).

From what I found on the web, people seem to advice against using databases like MySQL or PostgreSQL on the Pi for performance reasons. Is there a lightweight database to use on the Pi without slowing down the whole system?

Solution

Look into this http://www.firebirdsql.org/. It should be lightweight.

Comments

[alapeno]

Yes, I would have to do that anyway, you are completely right. But some hints would accelerate this process of testing, maybe there is a database I wasn't aware of etc.

[tadman]

You haven't given anything in the way of details on the type of data you're handling, the usage intensity in the way of qualified metrics, or what kind of environment this is going to be running in. That makes it extremely hard to make a specific recommendation. Postgres and MariaDB (MySQL) are usually good places to start, and LevelDB and SQLite are good embedded alternatives. Remember, MySQL was developed for systems with a fraction of the CPU power and memory of a Raspberry Pi (~200MHz, 64MB).