sql-for-r-users
sql-for-r-users copied to clipboard
Provide a case for why Postgre > SQLite
One example is the limitation to deal with datetime.
Let's say df contains a field that is defined as datetime using as.POSIXct.
if we copy_to(dest = database, df = df)
then
the table doesn't get datetime correctly as SQLite doesn't support it.