One of our postgresql databases has a heavy proportion of foreign language text (all encoded in utf-8). I was starting to learn lisp by porting a webapplication and got part way into it before I realized that using clsql may require me to manually encode and decode everything from latin to utf-8. It was suggested that postmodern may be a way out of that.
The app is still in early stages, so I'm hoping that converting from clsql to postmodern won't be too bad, but any hints on things to watch out would be appreciated.
Sabra
Hi Sabra,
It has been a while since I've used CLSQL, but converting should be relatively straightforward. If you're using 'join' objects, you'll have to overhaul that, since Postmodern DAOs work completely differencly (they don't join, for one thing). Also look into the database-connection-error (http://common-lisp.net/project/postmodern/cl-postgres.html#database-connecti...) condition and :reconnect restart if you want to make something that doesn't crash when there are connection problems. ... Basically, just skim the documentation, and you should be fine.
Best, Marijn
postmodern-devel@common-lisp.net
-
Marijn Haverbeke -
Sabra Crolleton