December 2008 - postmodern-devel - mailman3.common-lisp.net

[postmodern-devel] Looking for hints on converting from clsql to postmodern
by Sabra Crolleton 29 Dec '08

29 Dec '08

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

2 1

[postmodern-devel] Patch: query callback support
by Maciej Pasternacki 22 Dec '08

22 Dec '08

Hello, Recently I wanted to start profiling my webapp and display some stats in footer, namely number of queries and total time spent waiting for the database. Only option provided by Postmodern was using CL- POSTGRES:*QUERY-LOG* and reparsing its output, but this would be just awful Perl-like approach, and the time given would be very inaccurate (most of my queries are short, and query log rounds time to full milliseconds, so most queries show as 0ms). I added *QUERY-CALLBACK* support for cl-postgres, which makes CL-Postgres call given function with query string and internal time units spent after every query, moved *QUERY-LOG* support to separate function LOG-QUERY, which I made default value of *QUERY-CALLBACK* for backwards compatibility. Darcs changeset is attached. Regards, Maciej. -- Maciej Pasternacki -><- http://www.pasternacki.net/ -><- http://www.3ofcoins.net/

2 2

[postmodern-devel] s-sql patch for postmodern 1.13: separate condition
by Timur Sufiev 17 Dec '08

17 Dec '08

We learned that it is useful to a) have separate condition to distinguish s-sql parsing errors from others b) have :delete-from syntax extended: sometimes it is necessary to return keys of deleted rows. Both patches (generated by git) are in attach. It would be very nice to see them in upstream.

2 2

[postmodern-devel] Building s-sql on the fly
by Phil 11 Dec '08

11 Dec '08

Hi I am looking for an example of how to create a s-sql query on the fly. I am sure I saw something like that along the line on some website but I cant find it again. Thanx

4 7

[postmodern-devel] Dash in Postgresql Column name - "query-dao"
by Phil 03 Dec '08

03 Dec '08

query-dao does not seem to like column names with a dash in them like column-name and I suspect it would have the same problem with spaces. I know that the preffered for postgresql would be column_name but I though that being able to use the dash would simplify going from db to dao object to html and back, well at least for me. Is column names with dashes just not supported, a bug or on the wish list? Thanx

4 7