<p>Hello, there! I'd been searching for a while around for some good decision how to manage queries to SQL-based db, but find nothing, just a couple of ORM lib, that do not provide real ORM. So my question is: How do you manage it, and is there anywhere elegant way to make it? </p>
<hr/>**评论：**<br/><br/>jupiter909: <pre><p>I'd say this is a pretty good place to start looking:
<a href="http://go-database-sql.org/" rel="nofollow">http://go-database-sql.org/</a></p></pre>qu33ksilver: <pre><p>This is very nice. Thanks!</p></pre>romain_vanesyan: <pre><p>But I don't want to work with SQL directly as sometimes queries maybe too long and too complex to handled by hands...</p></pre>eyecikjou567: <pre><p><a href="http://jinzhu.me/gorm/" rel="nofollow">http://jinzhu.me/gorm/</a></p>
<p>This one is probably the best ORM and it does what I need atm.</p></pre>0xembark: <pre><p>Why is this marked NSFW?... </p></pre>bradfitz: <pre><p>Indeed. Fixed.</p></pre>gogroob: <pre><p>I'm actually learning how to do this as well, and maybe what I have so far is terrible, but
<a href="https://raw.githubusercontent.com/micromdm/micromdm/rewrite/profile/datastore.go" rel="nofollow">this</a> is a pattern I'm trying now.</p>
<p>smaller example for building a select query. we could define additional interfaces like <code>grouper</code> to <code>GROUP BY</code>.
Someone on the Slack team showed me how to use the filters.<br/>
<a href="https://play.golang.org/p/umquNMPJu6" rel="nofollow">https://play.golang.org/p/umquNMPJu6</a></p></pre>I_HATE_SPIES: <pre><p>First I create a repo interface which specifies the actions I want to take on my persistence layer:</p>
<p>type TodoRepository interface {<br/>
ListTodos() []ID<br/>
GetTodo(ID) Todo<br/>
SaveTodo(ID, Todo)<br/>
// etc...<br/>
}</p>
<p>then I implement a simple in-memory debug-implementation and get on with my day.</p>
<p>i wait until most of the application is done before i make a database-backed implementation of my Repository, using the sqlx package.</p></pre>
