search

timshannon / bolthold

BoltHold is an embeddable NoSQL store for Go types built on BoltDB
MIT License
648 stars 46 forks source link

Distinct constraint #125

Closed deiu closed 3 years ago

deiu commented 3 years ago

Hello,

Is there a way to specific a "Distinct" constraint when building a query? Basically something like SQL's SELECT DISTINCT.

Thanks!

timshannon commented 3 years ago

Aggregate queries are what you're looking for: https://github.com/timshannon/bolthold#aggregate-queries

Just like in SQL, running a distinct is the same as running a group by (for the most part.

You can find more examples in the tests: https://github.com/timshannon/bolthold/blob/master/aggregate_test.go

deiu commented 3 years ago

Thanks for the quick reply, I'll give it a try!