Using with SQLite

[cedieio]

Been testing out river and it's been good so far and tested using postgres, I was looking into using sqlite as the db but I've encountered some issues while following the SQLite guide.

So on the guide it used "modernc.org/sqlite" as the sqlite implementation however there was some errors popping up when I try to insert a job to the queue.

Mainly this one

constraint failed: NOT NULL constraint failed: river_job.created_at (1299)

The schema i was using was generated via the river cli, river migrate-up --line main --database-url "sqlite://./river.sqlite"

Now when I switched to "github.com/mattn/go-sqlite3", it worked.

Wondering if anyone else encountered this or did I miss anything?

[brandur]

Hmm, that's odd. @cedieio for context, we exercise directly against SQLite with modernc.org/sqlite, so we have reasonably high confidence that it works correctly.

Is it possible you're on an old version of the package or something? Maybe try a go get -u on it?

[cedieio]

Thanks @brandur!
That did solve my issue looks like one modernc.org/sqlite is outdated on my project that was causing it. The diff is too big to ensure but yes the cause was an outdated package.

[brandur]

You're welcome, and that's good to hear!