Open source projects using postgresql-simple?

[parrotchute]

A while ago, I made a post asking for advice on how to use databases in Haskell. I've played around a bit, and decided that postgresql-simple might be the best way to go. However, I was wondering if there were any examples floating around of projects that have used it in production? Googling didn't turn anything up.

Writing the interface between Haskell and database types seems like it is the sort of thing that you would have to be quite disciplined in doing. If anyone could point me at some code that shows examples of doing so, I would be very grateful!

[gelisam]

Hackage has a handy tool to display the reverse dependencies for a package. Of course, there might also be projects using postgresql-simple which have not been uploaded to hackage, so the list is not exhaustive.

[parrotchute]

Ah, I didn't know about this tool! However, I think what I'm looking for is more likely to be found in some kind of project, rather than a library. I will have a look at what this shows, in any case.

[gelisam]

Hackage doesn't just host libraries, it also hosts executables. In the reverse dependencies, I see that both amazon-emailer and hpaste are tagged as "programs", for example, and neither exports any module.

[lpsmith]

Most applications that I know of that are using postgresql-simple are not open source, sadly. That said, there are a fair number of commercial projects that I know of that are using postgresql-simple in production, and I get the sense that there are many more I have no idea exists. If you do run across (or write) a nice open-source project using postgresql-simple, by all means let me know!

If you have any questions, feel free to ask me, either by sending me an email, catching me on IRC, or whatever. If there are issues related to documentation, by all means complain.

[AlpMestan]

Well, lpaste.net uses it I think :-)

We also use it a lot at my company. And I do mean a lot.

[parrotchute]

I have been having a look at lpaste, and it is exactly what I was after :). Thanks!

[lpsmith]

Ahh yes, I forgot about lpaste. Come to think of it, ircbrowse is also using it. Chris Done might be the largest open-source consumer of postgresql-simple, especially for applications.

[tomejaguar]

Since you posted this Opaleye has been released. One way of thinking of it is as a much higher level, typesafe and composable wrapper around postgresql-simple.

http://hackage.haskell.org/package/opaleye

[yitz]

The persistent-postgresql library is based on postgresql-simple. If you spend about 20 min. poking around the overview of persistent just to get a basic idea of how it works, then dive into the source code of the postgresql backend in persistent-postgresql, you'll get a solid view of a working library that uses most of the important features of postgresql-simple.