mysql-Database about grocy HOT 5 CLOSED

Duplicate of #89 (and #2335) - please check existing requests before opening new ones.

sqlite is not multiuser capable

How do you came to that conclusion? Concurrent reads are technically possible, concurrent writes are lock-handled (practically we talk about milliseconds here). Unless you have a household with thousands of members concurrently and heavily hammering Grocy, using it is practically no issue - have you gave it a practical try before claiming all that? I guess it's just about the "SQLite is no real database"-fear some people (for whatever unintelligible reason) have - if that's the big breaking point for you, Grocy is not the software you want.

and do not want to install the application 3 or more times.

Not required, nowhere mentioned and of course this doesn't make any sense when using Grocy for one family. Separate instances are only needed / useful for separate households, means when you want to manage separate stock, chores and so on.

so that several different users and groups can be created

Completely unrelated to the DBMS used. You can create different users in Grocy. User groups are not a feature as of today.

from grocy.

That is exactly what I have described. Because I want an instance that several households use. My parents' household, my siblings' household and ours, of course. I don't want to look in my sister's "stock".
But if the topic is not in the plan at the moment, that's a shame but not a bad thing, then just 3 instances

from grocy.

Still don't get how "multiple households in one database" is related to the DBMS used (that's about logic, not about limitations SQLite have and MySQL doesn't or the other way round) and it's then just another duplicate of #644.

that's a shame but not a bad thing

A real shame but practically not that much a problem, you just need to step out of your MySQL comfort zone and overcome the SQLite fear I guess. I personally host about 1.6k (demo) instances without any issues, serving more than 2k daily page views generated by about 150 users - if your family across all the mentioned houseolds is just a little smaller than that it should pretty much fit.

from grocy.

What I mean is whether the application is client-capable. Then I can set it up once and each household can set up and manage its own grocy. Then it would also be cleanly separated. Perhaps that would also be a service that could be offered professionally. But that's another topic.

from grocy.

Then I can set it up once and each household can set up and manage its own grocy.

Exactly what the mentioned duplicate #644 is about. The request was declined, so this is not going to happen here. Spinning up multiple instances is as easy as cooking multiple pots of rice instead of just a single one. You are of course free to implement that yourself if you think the easy way of running multiple instances is too easy.

Perhaps that would also be a service that could be offered professionally.

Also that is not going to happen here (remember that Grocy is just one of my hobbies). You can also do that yourself in unison to the license under which I've published Grocy, if you feel that's what the world needs (and if you're technically capable of that, based on all that here that doesn't really sound that that's the case to me).

Then it would also be cleanly separated

Nothing can be as clean as completely separated instances.

 
Just a personal recommendation: Just try stuff before moaning around, it doesn't really sound you've done that already.

In any case, everything on- and off-topic has been said, so we're done here.

from grocy.