C# mysql beginners questions -

i want make program enables user logon , see files stored on pc. have built small program mechanic , he's asking if fancy making service invoice system stores invoices on pc, , customers can download software filter out invoices.

so need able connect pc pc , mysql suggested.

i have never used mysql before , have no idea how meant start project.

could through website instead of software? idea...

anyways, or pointers beginners tuts on web helpful, thanks.

mysql works best , safely when mysql server on same local-area network , behind same firewalls client software using it.

this means local windows desktop client (in c# have done) work well.

but if mechanic have server in office (or in cloud: in commercial server farm someplace), , offer desktop software customers, means mysql connection customers server have traverse firewalls.

that's going make desktop software hard install , hard troubleshoot. it's going make mysql server insecure: have able accept connections global public network. script kiddies , cybercriminals love when find open mysql database servers; copying contents child's play.

that why people build applications 1 propose build them web applications. connection database comes not end-user's machine, web app. web app runs on same lan , behind same firewall mysql server. build web app in c# modern .net framework tools , quite nice result.

if mechanic's customers use machine located in waiting room, not @ home, it's different matter. local windows desktop app work well.