Select distinct values - Githubissues

thevahidal / soul

🕉 A SQLite REST and realtime server

https://thevahidal.github.io/soul/

MIT License

1.45k stars 49 forks source link

Select distinct values #194

Open kvindi opened 1 month ago

kvindi commented 1 month ago

Would it be possible to add a "select distinct" route instead of needing to filter the results after the query ?

thevahidal commented 1 month ago

Hey @kvindi, Right not we don't support distinct, which I'm not sure about adding it to Soul. You can checkout a similar issue in postgrest which is a similar tool to Soul: https://github.com/PostgREST/postgrest/issues/915#issuecomment-322500725

I though believe group by instead is a really neat feature for Soul to have. I welcome your contribution if you want to work on either group by or distinct.