If it is a relatively simple, single user database, getting the data into MySQL or the like might be less involved than it first seems. A day well spent reading the user guide and the innumerous online tutorials will probably get you going (it did for me). There is also the MySQL workbench GUI, that facilitates common management tasks.
If there's not a lot of different tables to be related/joined, and you just want a DBMS to take advantage of SQL, I suggest storing everythting in csv format, and using the "sqldf" package in R. What it does is convert a dataframe into a SQLite database on the fly, run the SQL query on it, and return the result as a new data frame. It has worked very well in my experience. Thiago S. F. Silva Instituto Nacional de Pesquisas Espaciais São José dos Campos - Brazil Sent from my iPad On 2012-06-05, at 7:57 PM, Andrew Digby <[email protected]> wrote: > I'd definitely recommend Filemaker Pro. Being widely used commercially it's > unfortunately not cheap, > but for my (PhD) work it's been well worth the cost for its power and > simplicity. > > I also investigated MySQL, but found it way too involved for the simple > single-user database I > required. > > I'd be interested to hear of any other options though. I'm surprised > relational databases aren't more > heavily used in ecology, and am horrified by how many people trust their data > to MS Excel! > > Andrew
