What is Easiest DB to Set Up in Debian

jogl_z_8 · 02-16-2012, 03:27 PM

I have a box with Squeeze on it that I want to use for some data collection. Which database software will be the easiest for a very lightly experienced Debian user to set up?

It will initially just be collecting data from a serial port but will eventually also be collecting from the my LAN.

Thanks,
JP.

kasl33 · 02-17-2012, 12:36 AM

This question invites all kinds of bias replies because anyone who knows anything about databases will mention the one they favor. I favor MySQL because in know its installation and usage well.

jthill · 02-17-2012, 01:02 AM

Unless you're going to be serving more than just a handful of active users, look at sqlite3. It couldn't be easier.

fatmac · 02-17-2012, 09:11 AM

+1 for Sqlite3; as long as your needs are not great, otherwise I've had a go with Postgresql, which didn't seem to be too hard, lots of info & tutorials for it.

jogl_z_8 · 02-17-2012, 03:13 PM

Looks like sqlite3 will be my first go at it.

Thanks,
JP.

jogl_z_8 · 02-19-2012, 02:12 PM

Is there any reason that I shouldn't use OpenOffice Base? I forgot all about it being in the office sweet. Or is it just a DB query tool?

This will be a very simple (one table) DB not very big, not a lot of queries.

Thanks,
JP.

jogl_z_8 · 02-25-2012, 05:06 PM

Well, back to SQLite3 and PHP5.

So I will use the Synaptic Package Manager to install:

PHP5; and
sqlite3.

A lot of other related packages come up when I search those two packages. Should I be installing any of those while I am at it?

Thanks,
JP.