database recommended

[Chris]

I wanted to find out what people recommended. MS Access, MySQL, MS
SQL, Oracle, ASP, PHP. It needs to run on a virtual server preferably
Unix but NT is possible. I'm planning on having someone develop the
website but I would like it not to be to complex for me if I want to
make minor changes in the future.

Thanks,
Chris

 

[Murray]

1. How many simultaneous hits do you expect to get on a single record?
2. How secure do you need it to be.

The answer to those two questions will determine which database to use (in
the absence of other overriding considerations).

 

[Kevin Spencer]

Hi Chris,

Good questions!

First, you need to determine the platform you're running on. Microsoft
databasees won't run on Unix. MySQL and Oracle will run on either platform.

If you're on a Microsoft server, you should take a look at ASP or ASP.Net.
As you want simple, I would recommend ASP, unless your app is large and
complex (doesn't sound like it offhand). PHP is generally the toolset of
choice for scripting on a Unix/Linux box, although Java is also used a good
bit on Unix boxes as well. Java, however, is a compiled programming
technology, and will be harder for you to tweak. I would stick to scripting,
unless scalability and extensibility are in your future.

Of course, I'm prejudiced, but I would recommend using ASP on a Microsoft
platform box. Among the databases you can run on the box, Access is the
easiest to work with, but not as scalable as either SQL Server or MySQL.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living

 

[Thomas A. Rowe]

For Windows, consider ASP or ASP.net and Access, since you can up-size to MS SQL when needed.
ASP.net may be better suited to work with MS SQL.

For Unix, consider PHP and MySQL

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Chris]

1. How many simultaneous hits do you expect to get on a single record?
2. How secure do you need it to be.

The answer to those two questions will determine which database to use (in
the absence of other overriding considerations).

I don't expect to get many simultaneous hits but it does need to be
secure. I checked the websites of my competitors and they both have
..asp extensions on files so I might as well go with the flow and use
ASP as well.

Thanks for all the replies,
Chris