SQLite support for Opaleye...?

[mgajda]

It would be nice to have SQLite backend for opaleye updated.

@tomjaguarpaw So I open ticket just in case.

[tomjaguarpaw]

Yes, it would be nice. I don't have any plans to do so but I would be happy to support someone else doing so. Unfortunately it wouldn't be able to have a Monad interface because SQLite doesn't support LATERAL join.

[typedrat]

I'm in a situation where the prospect of this is very interesting to me, so I would be happy to do the work given a certain amount of guidance.

I would assume that at this point trying to use any of opaleye-sqlite's remnants would be pretty unhelpful since it's been decomposing for years now. Considering #529, I kind of lean towards taking a different approach than the essentially-a-fork tactic used for opaleye-sqlite, with multiple different backends sharing as much code as possible on the front end, either within opaleye itself or using typeclasses so that backends are open.

[tomjaguarpaw]

Cool! I'd be happy to provide guidance where you need it. I would suggest starting by looking at the last commit that touched opaleye-sqlite and seeing what the difference was between opaleye and opaleye-sqlite at that stage. That will tell you the most obvious things that you need to change in the current opaleye.