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,
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.comwrote:
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
postmodern-devel@common-lisp.net