Database newbie questions
Pierre Sahores
psahores at easynet.fr
Sat Aug 2 14:39:00 EDT 2003
John R. Brauer wrote:
> Hello all,
>
> I am a newbie. I am working on a project which will require that I store
> data in a database (a separate record for each client, and about six
> hundred fields per record). Each time it is used, it will need to
> generate a new record for that client (it is a program that will
> administer and score an exam of sorts) My questions:
>
> a) which database would you suggest (I guess that Oracle, MySQL and
> Valentina are my options)?
>
> b) is there an internal way of doing this instead of one of the above
> databases?
>
> c) will the standalone app then incorporate the database functions, or
> will the enduser be required to have the database in question installed
> on their computer as well?
>
> Sorry if this duplicates, I inadvertently used a wrong email address the
> first time, adn do not know if it will get through the moderator that
> way. Thank you much...
>
>
> Sincerely,
>
>
> John R. Brauer, Psy.D.
> Clinical Psychologist
Hi,
In about concurrency and write-mode accesses, PostgreSQL 7.xx (ACID
compliant) and MySQL 4.xx are two of the best unexpensive db-engines you
can use behind RR (use the Rev-DB library to connect them).
P.S.: MySQL 5.xx will be a great issue and the first full ACID compliant
ever done by MySQL AG, including most of the SAPDB engine features...
--
Bien cordialement, Pierre Sahores
Inspection académique de Seine-Saint-Denis
Serveurs d'applications et SGBDR (Web/PGI)
Penser et produire l'avantage compétitif
More information about the use-livecode
mailing list