search

ramses-antibiotics / ramses-package

R Package for Data-Driven Antimicrobial Stewardship & Surveillance in Hospitals
https://ramses-antibiotics.web.app/
GNU General Public License v3.0
10 stars 1 forks source link

Date handling in SQLite #31

Closed peterdutey closed 2 years ago

peterdutey commented 3 years ago

RSQLite 2.2.3 (2021-01-24) introduces better date handling dbConnect() gains an extended_types argument that adds support for date, time and timestamp columns. If a column has a declared type DATE, TIME or TIMESTAMP, it is returned as Date, hms or POSIXct value, respectively (#333, @anderic1).

peterdutey commented 2 years ago

Supporting timestamps and dates in SQLite implementation was evaluated as part of branch feature/sqlite_upgrade with RSQLite 2.2.12-2.2.14.

To date this change does not appear to be feasible as long as timestamps are not propagated in complex queries. This is a deeper SQLite issue. More detail here

To do: evaluate the merits of moving to duckdb or MonetDB

peterdutey commented 2 years ago

Goodbye SQLite!