The information in this thread and other thread related to SQLite have been consolidated into a Tips and Tricks topic. SQLite3 Information
Until now I use sqlite often, but only with
stardog-admin virtual import.
Today tried experimenting with 'virtual add'. Initially the SQL generated use FETCH, which SQLite does not support. By perusing the community I found that I could easily resolve that by adding the property
sql.dialect=MySQL which will use LIMIT in lieu of FETCH.
However now I am getting an "Out of bound" error from Stardog (logs attach)
jdbc.url=jdbc:sqlite:/var/opt/stardog/accounts.db jdbc.username=blah jdbc.password=blah jdbc.driver=org.sqlite.JDBC sql.default.schema=main sql.dialect=MYSQL
log.txt (2.4 KB)
Can always use Postgres, but I love how light SQLite is.