I am intending to implement a set of simple webservices that are are wrappers on SELECT and UPDATE statements.
I would like to study someone else having done this in a production quality code. In particular I would like to see how statements are prepared and the prepared statements are cached. I have read that this is problematic because of connection caching and creating leaks in a webserver that stays up for days on end. The number of select and update statements are small enough that I could just prepare them when the connection is created, but I would rather build on someone else's experience rather than inventing my own scheme. I don't mind using a library but I don't want to use any library that abstracts SQL. I don't mind being tied to one RDBMS. Here are the links I found: https://www.vividcortex.com/blog/2015/09/22/common-pitfalls-go/ This was good for code fragments but did not have a complete application. http://go-database-sql.org/ Good, but does not show the interaction with how it is used with webservices. http://www.hafidmukhlasin.com/2015/11/30/go-another-example-web-service-with-go-mysql/ Nice and simple but does not show prepared statements. FWIW: I am intending to us Postgres. -- You received this message because you are subscribed to the Google Groups "golang-nuts" group. To unsubscribe from this group and stop receiving emails from it, send an email to golang-nuts+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
