mysql and LAN

[tantony]

Sorry if I'm asking this in the wrong forum. I like to build a database gui using wxpython and mysql.
My question is, since I'll have multiple users using this database at the same time (may be not all at the same time, but multiple users will have access to db), how would the database update what each user do in real time?

I might be overthinking this since I've never used database.

---

I'm not sure if I want the db to be a standalone application or a web based yet. Web based might be easier since it doesn't require any installation.
Any recommendations? I have used REMIGui in the past but I'm not sure if it can open windows or anything like that.

[rob101]

I suspect that the answers to your questions, would depend on your experience level.

[tantony]

I have experience with Python, but newbie when it comes to databases.

[rob101]

Okay. Well, Python ships with a SQL-like database called SQLite3, which could be a good place to start.

This is from my own notes. Any plagiarism is purely unintentional:

Although there are many similarities between SQLite and other SQL databases, there are also some major differences (see: Quirks, Caveats, and Gotchas In SQLite). To make the transition between development (which is the best use case for SQLite) and production less complicated, it would be prudent to follow the rules imposed by the a fully featured SQL backend, rather than rely on any "fudging" that can be done with SQLite.

[tantony]

Thank you. Any web based python packages that I can use?

[rob101]

You are most welcome.

I've not used any web dev tools, but from what I read, Flask seems to be very popular.

[ibreeden]

Python ships with a SQL-like database called SQLite3, which could be a good place to start.

Indeed, but mind this:

Yes SQLite can support multiple users at once. It does however lock the whole database when writing, so if you have lots of concurrent writes it is not the database you want (usually the time the database is locked is a few milliseconds - so for most uses this does not matter).

And this:

MySQL has a well-constructed user management system which can handle multiple users and grant various levels of permission.

[tantony]

Thanks for everyone's input so far