Support of RData files

[PeterBailey]

Hi Simon,

Would be great if you could ingest RData files!

I could do this in a few lines of code but I am too lazy - sorry!

Peter

[simonw]

It looks like https://github.com/ofajardo/pyreadr is a good library for this.

I won't add this to sqlite-utils because it's quite a bulky dependency for a relatively small feature.

Normally I'd write a rdata-to-sqlite tool similar to https://pypi.org/project/dbf-to-sqlite/ - but I'm actually working on a new plugin hook for Datasette that might be an even better fit for this. The idea is to allow Datasette plugins to define input formats - such as RData - which would then result in being able to import them on the command-line with datasette insert my.db file.rdata or by uploading a file through the Datasette web interface.

That work is happening over here: simonw/datasette#1160 - I'll close this issue in favour of a sometime-in-the-future datasette-import-rdata plugin.