i am building a test app that will display all the sales made by a shop. this app will be built with the flutter framework, i do not have any problem when it come to front-end, but as of the back-end side of the app i have no idea where to start. i will handle client auth with firebase. i have a test .mdf file filled with test sales numbers and dummy customer data on a separate machine running windows server 2009 r2. My question is whether there is a way to fetch data from that file that is in that server and display it on the app. i have no background in the backend so i will need a thorough explanation on the coding languages and technologies that i will need to use. thanks in advance
i ended up creating an api using nodejs, i made a config file and gave it the db properties as of the username and password i was able to connect to mssqlserver using windows auth and i added a user to give to the config file in the api, i then used ngrok to deploy the running api on the internet and that is what i am using to show the data on the app