Is there an alternative to MySQL?

Question

I'd like a lightweight database for my lightweight RaspPi. MySQL seems a bit of overkill and involves too much administration. I'll need one with a perl API.

Answer 1

You're in luck! You should try SQLite. SQLite is very lightweight and implements a large subset of SQL. Your entire database is stored on a single file. And there is a perl API. Here's a link to SQLite's homepage ...

SQLite

To install only SQLite ...

sudo apt-get install sqlite

To install the perl API and SQLite (no need for the above) ...

sudo apt-get install libdbd-sqlite3-perl

You might want to consider DBD::CSV instead (or also) ...

sudo apt-get install libdbd-csv-perl