RE: Database architecture and security

2007-08-23 Thread Wm Mussatto
w.the-infoshop.com > www.giiexpress.com > www.etudes-marche.com > > >> -Original Message- >> From: Jason Pruim [mailto:[EMAIL PROTECTED] >> Sent: Thursday, August 23, 2007 10:59 AM >> To: MySQL List >> Subject: Database architecture and security >> &

RE: Database architecture and security

2007-08-23 Thread Jerry Schwartz
udes-marche.com > -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

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 connec

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 tabl

Re: Database architecture and security

2007-08-23 Thread Jason Pruim
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 the database open to customers of mine to store their mailing addresses on-line, and be able to manage the records. Is it saf

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

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

Re: Database architecture and security

2007-08-23 Thread Rolando Edwards
ginal Message - From: "Jason Pruim" <[EMAIL PROTECTED]> To: "MySQL List" 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.

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 up