SQLite is pretty amazing indeed. There are some limitations for you to consider:
- SQLite is for single user only
- I don’t think it can support very large databases (e.g. > 1 TB)
- It doesn’t support DATE and DATETIME types and operations, although SqlRender is doing its best to make it look like it does. (This does require field names end in ‘_date’ and ‘_datetime’)
Furthermore, the current released version of RSQLite (2.2.0) contains an older version of SQLite which does not correctly support a specific windowing function used in all ATLAS-generated cohort definitions. So in order to run those you’ll need the develop version from GitHub.