[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: [K12OSN] Database for school desktop use




Jack wrote:
On Sun, 2004-02-22 at 04:47, Andy Rabagliati wrote:

On Sat, 21 Feb 2004, Les Mikesell wrote:


On Sat, 2004-02-21 at 09:25, Andy Rabagliati wrote:


However - I think it is important that it has a file-based store,
so there are no permissions issues. 30 kids messing around with
mysql databases - even /I/ have problems creating tables .. :-)

There is nothing really magic about the way mysql or postgresql work. They just have standard wrappers to start and control them that assume the data should not be disposable. If you want per-user copies that can be deleted and recreated anytime without affecting anyone else, you just need to run a copy per user with a configuration that keeps everything under the home directory.

At this point, the school wants an Access replacement.


They want to use the training materials they currently have for
Access, do a minor edit, and use them on Linux.

I think firing up your own copy of MySQL with local config,
spool directory and port falls outside this.

But .. maybe not ?

Hey - I have not even used Access, that I can remember.

I was figuring that someone on this list has been down that road.

Cheers, Andy!



Why not continue to use Access on the front end but connect to a MySQL DB on the backend? This way the user interface stays the same but you gain the scalability you need.



Likely they don't wan to pay for Access anymore.

--
Anthony Baldwin
http://www.School-Library.net
Freedom to Learn!

-----BEGIN GEEK CODE BLOCK-----
GED$/L/P/FA d? s: a C++ L++ W++ N++ K- w--- M+ PS++
PE-- Y+ PGP- t+ tv-- b++(b++++) D? G e++++ h++ r--- y?
------END GEEK CODE BLOCK------




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]