search

mbari-org / vars-gridview

VARS GridView is a tool for reviewing and correcting VARS localizations in bulk.
MIT License
2 stars 0 forks source link

Remove SQL access #79

Open hohonuuli opened 3 months ago

hohonuuli commented 3 months ago

@kevinsbarnard What do you need in the services so that you don't have to use SQL to access the database? It looks like vars-gridview is build only for MS SQL Server, but there are outside groups running on Postgres that would love to use it. Let's chat so we can get rid of the SQL dependency all together.

kevinsbarnard commented 3 months ago

@hohonuuli Sounds great. Yes, we've wanted to remove the SQL dependency for a while now, it has just come down to time allocation.

From my recollection, what's missing (in addition to the changes in the VARS GridView app) are appropriate filtering mechanisms in the API. VARS GridView offers a very flexible querying structure that gets mapped into a SQL statement, so I agree it would be good to sit down and discuss how we could recreate that in Annosaurus. Of course, some of that filtering could become the client's responsibility.