search

scotty-web / scotty

Haskell web framework inspired by Ruby's Sinatra, using WAI and Warp (Official Repository)
http://hackage.haskell.org/package/scotty
BSD 3-Clause "New" or "Revised" License
1.71k stars 132 forks source link

SQLite module #363

Open ocramz opened 6 months ago

ocramz commented 6 months ago

It would be nice to provide some DB facility out of the box. Personally I like direct-sqlite which is a bit low-level but self-contained and imposes no new dependencies.

tusharad commented 2 months ago

Hi @ocramz,

I think sqlite-simple would be a better choice since direct-sqlite is quite low-level, it would be harder for the user to use it. sqlite-simple comes with some dependencies though.

ocramz commented 2 months ago

@tusharad good point!

I have actually just found out that sqlite-simple too is due some love, if only to fix that .. simple sql QuasiQuoter (i.e. I don't think embedding an unsanitized SQL string is a good idea)

But maybe we can discuss this once more if/when #317 lands.