0

I'm creating an application that is to be used "in-house" over a local network, that has to work when there is no internet.

I initially wanted to do it in Laravel (PHP), but that requires being able to query an online database.

So, I have settled with developing it in C#. There is only one thing I need to be certain of first based on these wishes:

  • I want to use MySQL (I have it installed and the C# lib)
  • The database needs to be local and shared between instances of the app

( If there are better options than MySQL for local db handling, I'm open for that as well)

Now for the questions:

  1. What are / and how would I package dependencies to be able to use MySQL on any machine installing the app? I want a simple install.

  2. What do you believe would be the best way to keep a shared database on a local network, that accepts changes from several instances in real-time?

Some pointers and/or advice would be appreciated. I'm planning the app atm (o'l pen and paper), so this would be the time :)

Best regards, Oyvind

Improve this question
6
  • Open Nuget Package Manager and get SQLite instead? Commented Feb 8, 2015 at 14:55
  • I would have to agree, the simplicity and ease. How "fast" / advanced is it compared to MySQL? Commented Feb 8, 2015 at 15:23
  • Can't really say, you have to Google :) But SQLite is serverless so it might fit better for your scenario. Commented Feb 8, 2015 at 15:41
  • I like it, and it would suit my needs if it was good for multi-user apps. digitalocean.com/community/tutorials/… Gives an indication that I should not use it... Seems legit. A shame really. Might look into SQL Server Commented Feb 9, 2015 at 17:11
  • From the above URL: "If you are working on an application whereby multiple clients need to access and use the same database, a fully-featured RDBM (e.g. MySQL) is probably better to choose over SQLite." Commented Feb 9, 2015 at 17:12
Related questions
0
.net Studio Local Database
0
using MySQL with C#
3
Embedding MySQL Database into application in C#
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.