concurrency - Idea on building a live, serverless multi-user local-network-shared database with SQLite -
i need input on idea had. if you're interested/experienced in sqlite , lowest-budget-high-end-solutions (win ;)) you. while fleshing out question have gotten pretty excited idea, bear me. there's tl;dr below i have developed vb.net (3.5) desktop application sqlite. data structured in eav-model, because need flexibility (the semantic structure of data stored separately in xml file). application performs above expectations, - scenario @ hand - large database (about 120mb main file). as expected performance abysmal when sqlite file(s) on network folder. it's bearable have higher goals. expected scenarios (for now) max. 10 users need access database concurrently within local windows network. 98% of concurrence required heavy read-access, inserts , updates sparse , small. the software used exclusively within environments low budget , technical infrastructure (support , hardware) lower, goal avoid using database server. not want implement own sqlite "server" ...