[R-sig-DB] [R] SQLite: When reading a table, a "\r" is padded onto the last column. Why?

[Seth Falcon]

"David James" <daj025 using gmail.com> writes:

> Hmm, we could, but we would have to make sure that the Windows
> package includes the sqlite command-line interpreter (I seem to recall
> that it only include the sqlite library).  In general, RSQLite does not use
> anything but the library to ensure it's self-contained.

Agreed.

>> The dbWriteTable functionality is more elegant than (a) or (b), and
>> perhaps I would have fewer reservations if it was called
>> sqliteImportFile() -- do the other DBI packages support file import in
>> this way via dbWriteTable?
>
> No, they don't.  I never thought about providing an import facility on top
> of those already provided natively by Oracle and MySQL; the case with
> SQLite is slightly different if we only consider it as an embedded engine in R.
>
> I guess you're suggestion of moving it to sqliteImportFile() is
> cleaner.

And so I guess the only thing to do is to document it :-)


+ seth