Database architecture and security

2007-08-23 Thread Jason Pruim
Hi Everyone, Just had a quick question about a database I'm working on. I am planning on having the database open to customers of mine to store their mailing addresses on-line, and be able to manage the records. Is it safe, to have 1 database with lots of tables? Or am I safer setting

Re: Database architecture and security

2007-08-23 Thread Rolando Edwards
Message - From: Jason Pruim [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Thursday, August 23, 2007 10:58:52 AM (GMT-0500) America/New_York Subject: Database architecture and security Hi Everyone, Just had a quick question about a database I'm working on. I am planning on having

Re: Database architecture and security

2007-08-23 Thread Gary Josack
I'd never have a separate database for everyone or even a separate table for everyone. Here's a rough idea of how I'd do it mysql CREATE TABLE customer ( - `custid` INT NOT NULL AUTO_INCREMENT, - `lastname` VARCHAR(25) not null, - `firstname` VARCHAR(25) NOT NULL, - PRIMARY

Re: Database architecture and security

2007-08-23 Thread David T. Ashley
On 8/23/07, Jason Pruim [EMAIL PROTECTED] wrote: I am planning on having the database open to customers of mine to store their mailing addresses on-line, and be able to manage the records. Is it safe, to have 1 database with lots of tables? Or am I safer setting up separate databases for

Re: Database architecture and security

2007-08-23 Thread Jason Pruim
On Aug 23, 2007, at 11:44 AM, Gary Josack wrote: I'd never have a separate database for everyone or even a separate table for everyone. Here's a rough idea of how I'd do it mysql CREATE TABLE customer ( - `custid` INT NOT NULL AUTO_INCREMENT, - `lastname` VARCHAR(25) not null, -

Re: Database architecture and security

2007-08-23 Thread Jason Pruim
: Database architecture and security Hi Everyone, Just had a quick question about a database I'm working on. I am planning on having the database open to customers of mine to store their mailing addresses on-line, and be able to manage the records. Is it safe, to have 1 database with lots of tables

Re: Database architecture and security

2007-08-23 Thread Jason Pruim
On Aug 23, 2007, at 11:50 AM, David T. Ashley wrote: On 8/23/07, Jason Pruim [EMAIL PROTECTED] wrote: I am planning on having the database open to customers of mine to store their mailing addresses on-line, and be able to manage the records. Is it safe, to have 1 database with lots of

Re: Database architecture and security

2007-08-23 Thread David T. Ashley
On 8/23/07, Jason Pruim [EMAIL PROTECTED] wrote: b)Terminating TCP connections and ensuring that each PHP script runs to completion, anyway, and that the database isn't left in an indeterminate state due to this. Dave. What do you mean by b? If all the connections come from the

RE: Database architecture and security

2007-08-23 Thread Jerry Schwartz
-Original Message- From: Jason Pruim [mailto:[EMAIL PROTECTED] Sent: Thursday, August 23, 2007 10:59 AM To: MySQL List Subject: Database architecture and security Hi Everyone, Just had a quick question about a database I'm working on. I am planning on having the database open

RE: Database architecture and security

2007-08-23 Thread Wm Mussatto
:[EMAIL PROTECTED] Sent: Thursday, August 23, 2007 10:59 AM To: MySQL List Subject: Database architecture and security Hi Everyone, Just had a quick question about a database I'm working on. I am planning on having the database open to customers of mine to store their mailing addresses on-line