Utilizing Local Database without using uplink

Anvil Q&A
1

Hi,

I am wondering if I can save data locally (shared excel/access file in my local network) using the client code only without using the uplink serves, so, I don’t have to deal with HIPAA certification headache!

Thank you for your help.

1 Like
2

You can use the Anvil app server

1 Like
3

Thank you @Tony.Nguyen !
I follow the link you posted and I think the following links ( https://anvil.works/docs/how-to/app-server
https://github.com/anvil-works/anvil-runtime) are the answer for my question, I think I have to do a lot of reading to understand how to do that, usually seeing an example/tutorial saves a lot of time, please let me know if you are aware of any tutorial related to this subject.

Thank you again!

4

Hi @advancedhealthsys, the provided link is a step by step tutorial. Please give it a try

1 Like
5

Hi,

You can actually do this using Anvil hosted apps (I have, for that same reason). All processing occurs client-side and the “legal burden” thus falls on the user. You can make this more complex obviously (encryption and so…).

Check out this code sample and demo

1 Like
6

External database is also another option. I haven’t tried it myself, but it should work without any issue.

7

It works…the problem being that you have to request data from the server side (because you can’t use the drivers directly from the client-side). Sure, one may opt no to store it but just by processing it you’d probably have to be HIPAA certified anyway…

1 Like
8

That is beautiful! Thank you so much :+1:, this is exactly what I was looking for :star_struck:

1 Like