[K12OSN] Database for school desktop use

[anthony baldwin]

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------