[Melbourne-pm] Which DB for local use only?

[Matt Sharpe]

Depends on the data (type, relations, how you query it) but SQLite,
Unqlite, Redis, and Kyoto Cabinet are worth looking at. IIRC there is also
KiokuDB for getting CSV data into various back ends. As David says,
Postgres has native CSV support, and it's relatively trivial to get going
locally.

On Monday, August 5, 2013, David Dick wrote:

> On 08/05/2013 09:12 PM, Nathan Bailey wrote:
>
>> Hi all,
>>   I'm managing some data that I think would live better in a database
>> than a CSV file. I'm thinking SQLite, but does anyone have a better
>> suggestion?
>>
>> It will only have a few tables but rows will grow over time (probably c.
>> 2-5,000 rows over the next year or two).
>>
>
> agreed on SQLite, but as an interesting point, postgres is the only
> database i've found with a natural interface to backing up and restoring
> from CSV files (MySQL requires bizarre MySQL only CSV escaping, SQLite
> requires a separate library...).  If you have to move data back and forward
> between CSV and your DB often, it might be worth looking at COPY Support in
> DBD::Pg.
> ______________________________**_________________
> Melbourne-pm mailing list
> Melbourne-pm at pm.org
> http://mail.pm.org/mailman/**listinfo/melbourne-pm<http://mail.pm.org/mailman/listinfo/melbourne-pm>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/melbourne-pm/attachments/20130805/28bbae30/attachment.html>