[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