column VS goqu

column - High-performance, columnar, embeddable in-memory store with bitmap indexing and transactions.

I've wanted to build an online roguelike in Go for a long time, but no good ECS libraries were out there. After a first failed attempt last year, I realized that first I needed to build a solid columnar storage engine kelindar/column which took roughly half of 2021 to get into a good state, with transactions, bitmap queries, concurrent snapshotting and all of that fancy stuff.

For SQL, I'd probably go with goqu http://doug-martin.github.io/goqu/

I use goqu (https://github.com/doug-martin/goqu)

SQL Builders (think squirrel or goqu)

I've been looking for a package that allows me to build Postgres DDL statements in Golang. I'm currently using Goqu (https://github.com/doug-martin/goqu) for building statements and it works great, however it does not have support for building schemas. Basic things like creating tables, creating indexes. A great one in JavaScript can be found here: (https://knexjs.org/guide/schema-builder.html#essentials) I have been unable to find anything in Go, does anyone know of any packages like this?

Then use something like https://github.com/doug-martin/goqu to build the SQL.

Try this

We've been using goqu and it's super nice! although there are a ton of other query builders that could better fit your use-case.

If the statement is too dynamic to use query parameters I'd ideally use a dynamic query builder rather than concatenating strings. Goqu is a lib like that but I haven't yet used it personally https://github.com/doug-martin/goqu