I work in a company that has some limitations regarding their budget. They need client/server aplication.
I can code the aplication, I've made mini tests on primordial applications that work. The thing is that they only have fileservers, and the application they need must be concurrent compliant, so the database must be in their local network (Fileserver is the only choice).
So far, I have explored almost any option available, starting with:
Desktop databases.
Access (We have a license)(But concurreny is just not effective, besides it's a windows software, yuck).
Sqlite (Nice, but since the information they manage is a lot, I've performed some concurrency tests with INSERTs and doing SELECTS at the same time). It fails, somehow it just stops inserting.
Open office Base (I dismember a base office only to see that it was a file mode HSQLDB). I've tried, not concurrent at all.
Etc (You name the Open source Desktop Database manager, and yes, I've tried that one.)
Server databases
Call me a stubborn person, but reading some server databases documentation say that their databases will work in a file mode. I've tried a lot of products.
Postgres, MySQL, FireBird, H2, Derby, Oracle Express, IBM DB2 Express, etc.
So, I really need a hand here, I've been doing this install/delete/depression thing with a lot of databases for 3 weeks, until I got with a crazy idea and I just came here to express it. So, my question comes down to this:
Installing a light virtual OS software like Virtual PC and then installing in there a Server OS like an Ubuntu server inside that virtual software will work?
Will it work 24/7 or when I close the virtual pc software?
Will this work in a fileserver?
Any suggestion, answer, critic to the place I work, crazy new concurrent database that will work in fileserver will be most than welcome.
