Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Remove SQL access #79

Open
hohonuuli opened this issue Jun 10, 2024 · 1 comment
Open

Remove SQL access #79

hohonuuli opened this issue Jun 10, 2024 · 1 comment
Assignees
Labels
core Changes to the application core

Comments

@hohonuuli
Copy link
Member

@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
Copy link
Collaborator

@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.

@lonnylundsten lonnylundsten added the core Changes to the application core label Sep 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
core Changes to the application core
Projects
None yet
Development

No branches or pull requests

3 participants