I just want to use the default table with MySQL -- InnoDB looks like too much overhead for me. I am a KISS kind of guy. I want to be able to dynamically indicate the relationships for development purposes. Also, I really want the Perl code, database maintenance, and template management separate so I can hand off parts of the project to people that are related to their strengths. (E.g. having a DB developer also designing GUI, et cetera is asking for trouble -- unless that person is equally skilled in both. . .)
I have the Perl code such that all the interface can be managed separately. I also have the scripts so that they can handle any table regardless of format without prior knowledge of the tables as all the security is handled through tables. This also includes table and column permissions and data integrity checks. The final piece to the puzzle is the ability to handle the relationships so I can develop "applications". Does anyone have any experience keeping the relationship information in a table for use by their Perl code? If so, I would love to hear your experiences. -----Original Message----- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 3:08 PM To: Vuillemot, Ward W Cc: '[EMAIL PROTECTED]' Subject: Re: (OT) MySQL and foreign keys On Wed, Oct 31, 2001 at 10:24:15AM -0800, Vuillemot, Ward W wrote: > I know that MySql does not really store foreign keys such as other > DBs, but it will allow you to designate what fields are references > to other tables. Depends on the table type, actually. InooDB has foreign keys. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 55 days, processed 1,242,514,025 queries (257/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
