Some of the people I work with want access to the database (PSQL), to be able to search and export a CSV format of their results.
My idea was to create a View, and have a “read-only user” so they could connect to Adminer and do their search without having to write sql.
I wonder if this is the right way to go ?
What should I keep in mind?
Is there a better tool than Adminer for that purpose?
My stack runs in docker, though I don’t think that’s relevant.