chichou/koa-sqlite3-session

sqlite3 adaption for koa-generic-session

Hi there 👋

koa-sqlite3-session's Issues

ttl should be in ms

The documentation for koa-generic-session shows milliseconds (ms) are supposed to be used, instead of seconds. For example, this should have a TTL of 1 day, but SQLite3Store gives it a TTL of 1,000 days:

app.use(session({
    store: new SQLite3Store('filename.db'),
    ttl: 86400000         // ms
});

It works great if you pass in seconds:

app.use(session({
    store: new SQLite3Store('filename.db'),
    ttl: 86400
});

One nice thing about koa-generic-session is that you can swap out one session provider for another. For example you could use SQLite for sessions when doing local development, and Redis on a production server. But with this difference you can’t share the same config between koa-redis and koa-sqlite3-session.

Bump dependency: SQLite3 is now in version 5.x

Could you please bumb the dependency to SQLite3 to the now current version 5.x?

Using SQLite3 installs version 5.
And requiring Koa-SQlite-Session tries to build SQLite version 4.x which requires build tools and therefor often fails on the machines of my students.
Which is quite frustrating for them (and me).