Update dependencies and release new version

[stefnotch]

context

proposed solution

This package depends on knex ^0.20.1 https://github.com/haltcase/trilogy/blob/6d73d7307456084c4e9c259105f87ebc01ce7727/package.json#L47

Meanwhile, knex itself has gone through 2 major version releases, with lots of changes and features. Among other things, it now supports better-sqlite3. https://github.com/knex/knex/releases

It'd be lovely if that dependency were updated.

alternatives

Tricky, I'd love to use trilogy and avoid having to manually deal with all of this (installing sqlite, using an ORM, etc.)

additional info

When installing this package, one even gets warnings about old, deprecated dependencies. I suppose updating all dependencies might be in order?

$ npm i trilogy
npm WARN deprecated [email protected]: See https://github.com/lydell/source-map-url#deprecated
npm WARN deprecated [email protected]: Please see https://github.com/lydell/urix#deprecated
npm WARN deprecated [email protected]: See https://github.com/lydell/source-map-resolve#deprecated
npm WARN deprecated [email protected]: https://github.com/lydell/resolve-url#deprecated
npm WARN deprecated [email protected]: Debug versions >=3.2.0 <3.2.7 || >=4 <4.3.1 have a low-severity ReDos regression when used in a Node.js environment. It is recommended you upgrade to 3.2.7 or 4.3.1. (https://github.com/visionmedia/debug/issues/797)

added 170 packages, and audited 726 packages in 9s

[haltcase]

@stefnotch I'm with you all the way 😃 I started down this road with #114 and hit roadblocks I unfortunately don't have the time to investigate right now.

I'm more than happy to invite collaborators interested in helping maintain trilogy as well (I still have fancy static typing ambitions about v3).

[stefnotch]

I see, makes sense. I personally wouldn't have time to maintain this library, but hopefully someone else will step up to the task. :)

By the way, there is also another quite interesting library: https://github.com/koskimas/kysely It definitely doesn't cover all the same use-cases, but I figured it'd be worth mentioning it anyways.