search

tomjaguarpaw / haskell-opaleye

Other
599 stars 115 forks source link

SQLite support for Opaleye...? #528

Open mgajda opened 2 years ago

mgajda commented 2 years ago

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

@tomjaguarpaw So I open ticket just in case.

tomjaguarpaw commented 2 years ago

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 commented 11 months ago

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 commented 11 months ago

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.