[postmodern-devel] Tutorials, examples, and best practices
Are there any collections of tutorials, examples, and/or best practices for Postmodern? For instance, I have a macro to wrap database operations: (defmacro with-test-database (&rest body) `(with-connection (list +test-database-name+ +test-database-user+ +test-database-password+ "localhost" :pooled-p t) ,@body)) Obviously it needs some transaction support as well. Do other people use it this way? What are your most useful tips and tricks? Also, it took me some time fiddling around to get :insert-into to work correctly. It makes sense to me now, but a detailed example would have helped. I'm about to write some production code against a mid-sized, fully normalized database. Any lessons learned in those kinds of environments would be of interest. Thanks, Patrick
It is probably too basic for you, but you might find something useful at https://sites.google.com/site/sabraonthehill/postmodern-examples It is mostly just notes that I put together for someone on my staff. Cheers, Sabra On Mon, Nov 5, 2012 at 6:48 PM, Patrick May <patrick.may@mac.com> wrote:
Are there any collections of tutorials, examples, and/or best practices for Postmodern? For instance, I have a macro to wrap database operations:
(defmacro with-test-database (&rest body) `(with-connection (list +test-database-name+ +test-database-user+ +test-database-password+ "localhost" :pooled-p t) ,@body))
Obviously it needs some transaction support as well. Do other people use it this way? What are your most useful tips and tricks?
Also, it took me some time fiddling around to get :insert-into to work correctly. It makes sense to me now, but a detailed example would have helped.
I'm about to write some production code against a mid-sized, fully normalized database. Any lessons learned in those kinds of environments would be of interest.
Thanks,
Patrick
_______________________________________________ postmodern-devel mailing list postmodern-devel@common-lisp.net http://lists.common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel
Sabra, Thanks, that's great stuff! Even simple examples showing how others use the package are valuable, and yours are far more detailed than I expected. Thanks again, Patrick On Nov 19, 2012, at 2:04 AM, Sabra Crolleton <sabra.crolleton@gmail.com> wrote:
It is probably too basic for you, but you might find something useful at https://sites.google.com/site/sabraonthehill/postmodern-examples
It is mostly just notes that I put together for someone on my staff.
Cheers,
Sabra
On Mon, Nov 5, 2012 at 6:48 PM, Patrick May <patrick.may@mac.com> wrote: Are there any collections of tutorials, examples, and/or best practices for Postmodern? For instance, I have a macro to wrap database operations:
(defmacro with-test-database (&rest body) `(with-connection (list +test-database-name+ +test-database-user+ +test-database-password+ "localhost" :pooled-p t) ,@body))
Obviously it needs some transaction support as well. Do other people use it this way? What are your most useful tips and tricks?
Also, it took me some time fiddling around to get :insert-into to work correctly. It makes sense to me now, but a detailed example would have helped.
I'm about to write some production code against a mid-sized, fully normalized database. Any lessons learned in those kinds of environments would be of interest.
Thanks,
Patrick
_______________________________________________ postmodern-devel mailing list postmodern-devel@common-lisp.net http://lists.common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel
_______________________________________________ postmodern-devel mailing list postmodern-devel@common-lisp.net http://lists.common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel
I'm about to write some production code against a mid-sized, fully normalized database. Any lessons learned in those kinds of environments would be of interest.
i'm not sure you'll find many things for direct copy-pasting, but here's an sql abstraction layer that has a postgresql backend: http://dwim.hu/darcsweb/darcsweb.cgi?r=HEAD%20hu.dwim.rdbms;a=headblob;f=/so... -- attila Notice the erosion of your (digital) freedom, and do something about it! PGP: 2FA1 A9DC 9C1E BA25 A59C 963F 5D5F 45C7 DFCD 0A39 OTR XMPP: 8647EEAC EA30FEEF E1B55146 573E52EE 21B1FF06
Attila, Any comments about things you discovered while writing or using this code? Cheers, Sabra On Wed, Nov 21, 2012 at 5:50 AM, Attila Lendvai <attila.lendvai@gmail.com>wrote:
I'm about to write some production code against a mid-sized,
fully normalized database. Any lessons learned in those kinds of environments would be of interest.
i'm not sure you'll find many things for direct copy-pasting, but here's an sql abstraction layer that has a postgresql backend:
http://dwim.hu/darcsweb/darcsweb.cgi?r=HEAD%20hu.dwim.rdbms;a=headblob;f=/so...
-- attila
Notice the erosion of your (digital) freedom, and do something about it! PGP: 2FA1 A9DC 9C1E BA25 A59C 963F 5D5F 45C7 DFCD 0A39 OTR XMPP: 8647EEAC EA30FEEF E1B55146 573E52EE 21B1FF06
_______________________________________________ postmodern-devel mailing list postmodern-devel@common-lisp.net http://lists.common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel
participants (3)
-
Attila Lendvai -
Patrick May -
Sabra Crolleton