Sqlite Support

[efe-egbevwie]

I discovered this library and it's such a pleasurable alternative to quartz.
However, I noticed that it does not seem to have support for SQLite as the schema definitions contain no SQLite version.
SQLite support will complement the simplicity of this library.
Are there any plans on the roadmap to support SQLite?

[kagkarlsson]

Hi! Typically, schemas has been added by users of a new database. You could try defining a schema and test db-scheduler using it. If it works, submit a PR for the schema

[efe-egbevwie]

Hi, Thanks for replying.
So I have done what you suggested, I used the PostgreSQL schema definition to create the tables in an SQLite database file.
I am using a spring boot application, however, I get a runtime error as soon as the application starts:

com.github.kagkarlsson.shaded.jdbc.SQLRuntimeException: Error when preparing statement.
at com.github.kagkarlsson.shaded.jdbc.JdbcRunner.lambda$execute$5(JdbcRunner.java:139) ~[db-scheduler-14.0.0.jar:na]
at com.github.kagkarlsson.shaded.jdbc.JdbcRunner.withConnection(JdbcRunner.java:232) ~[db-scheduler-14.0.0.jar:na]
at com.github.kagkarlsson.shaded.jdbc.JdbcRunner.execute(JdbcRunner.java:131) ~[db-scheduler-14.0.0.jar:na]
at com.github.kagkarlsson.shaded.jdbc.JdbcRunner.query(JdbcRunner.java:94) ~[db-scheduler-14.0.0.jar:na]
at com.github.kagkarlsson.scheduler.jdbc.JdbcTaskRepository.getDue(JdbcTaskRepository.java:283) ~[db-scheduler-14.0.0.jar:na]
at com.github.kagkarlsson.scheduler.FetchCandidates.run(FetchCandidates.java:84) ~[db-scheduler-14.0.0.jar:na]
at com.github.kagkarlsson.scheduler.RunUntilShutdown.run(RunUntilShutdown.java:43) ~[db-scheduler-14.0.0.jar:na]
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) ~[na:na]
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na]
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[na:na]
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[na:na]
at java.base/java.lang.Thread.run(Thread.java:840) ~[na:na]
Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near "OFFSET": syntax error)