small data needed - suggestions?

  • Thread starter Thread starter Bobby Edward
  • Start date Start date
B

Bobby Edward

I am doing a funeral home page (depressing huh?) :)

They want an obituary page where people can post comments. So, in my db I
have 2 tables (1 to many relationship)...
TABLE1: Obituary (persons info)
TABLE2: ObitComments ("many" table - comments)

There would be an admin page to approve or reject comments, manage
obituaries, etc...

My ISP only allows me a certain # of SQL Server dbs. I would hate to
"waste" one on a small project like this. Any suggestions? How would you
handle it? SQL Express is not supported either.

Thanks!
 
1 per minute??

Just not an overloaded amount of simutaneous writes.

Since this is a web app (I'm assuming)...then the web server talking to an
Access(JET) database locally..is not that big of a deal.

Access can handle a light load of 5-10 simutanaeous users in my opinion.

Your obituary thing...if you have 1 db per deceased person....would be fine
for this imho.

....
 
My ISP only allows me a certain # of SQL Server dbs. I would hate to
"waste" one on a small project like this. Any suggestions? How would you
handle it? SQL Express is not supported either.
Click to expand...

In addition to Sloan's comments, what's stopping you creating the two tables
you suggest in an existing SQL Server database...?
 
To be honest, I like the simplicity of having the data in 1 file, an mdb.
It's easy to backup and move around. I'm a small fry developer. :)
 
1 db per deceased person? Or 1 db record?

sloan said:
1 per minute??

Just not an overloaded amount of simutaneous writes.

Since this is a web app (I'm assuming)...then the web server talking to an
Access(JET) database locally..is not that big of a deal.

Access can handle a light load of 5-10 simutanaeous users in my opinion.

Your obituary thing...if you have 1 db per deceased person....would be
fine for this imho.

...
Click to expand...
 
Sorry, I mispoke.

One db per person would be too much.

Look at my blog...and you could easily start with 1 db.
And then use the Factory method to even use multiple Access(Jet) database
files (.mdb).
Like use the key system, and base it on the person's first letter of their
last name.

THe factory pattern gives you options.

A-I (obituarydb1.mdb)
J-R(obituarydb2.mdb)
S-Z(obituarydb3.mdb)

or start with 1 .mdb and only go to N .mdb's if you need to.
 
hmmm i never heard of the factory method - i must read up on it - THANKS
SLOAN!!!!
 
Back
Top