[K12OSN] Database for school desktop use

Jack jackpal at cfl.rr.com
Sun Feb 22 09:04:29 UTC 2004


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.

Jack





More information about the K12OSN mailing list