Database server

[Zelandakh]

I'm putting a spec together for version 2 of our corporate site. They want a database to make the areas of the site only available at certain times and so on - hence I recommended a database rather than static html pages.<br><br>Am I right?<br><br>I'm looking at large numbers of pictures as well as lots of text.<br><br>What options do I have for databases and OS? I know SQL and NT but I don't want a one horse race. How about Apache, Oracle? Need buy on line i.e. security and something that I can find a programmer for.

 

[Guest_imported]

<br>&nbsp;&nbsp;With Windows NT and SQL Server7 you can do everything you need to do, and more <p>John Vogel<br><a href=mailto:johnvogel@homepage.com>johnvogel@homepage.com</a><br><a href=

http://i.winfire.com/s/isapiEng.dll/wf.exe?cmd=rl&452,20004878&wf.exe>Get

FreeDSL Service</a><br>[To a get FREE DSL Modem WITH FREE DSL Unlimited Internet Connection click the above link ]

 

[Zelandakh]

Are there any other options as I will have to come up with two more database / storage methods and shoot them down before finally deciding on SQL server.<br><br>Once I have my NT Server and my SQL Server sitting there on the Net, what can I use to interface the data to the hmtl pages? <br><br>Dreamweaver is my baby, but I have not seen a way to put SQL into html using it. Presumably I'm into Java or asp. If I go asp am I limited to Frontpage 2000 and is it and good since FP98 was not...<br><br>Z

 

[jnicho02]

<i>Hey John, are you on commission from MSoft? ;-)</i> As it is, I probably agree with him SS7 is not too expensive, not too hard to use, and has some new features for handling text and pictures outside of the database.<br><br>Oracle is an option, and would allow you to go to Unix. Their databases are industrial strength though and come at a price.<br><br>If you wanted to do it on the cheap then there are other databases that could be used. More often than not the choice comes down to what dbs the people who have to program and run the system are used to. <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/jnicho02/>

</a><br>

 

[Guest_imported]

LOL jnicho... I WISH! <br><br>Zelandakh:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;If you really don't want to go with FrontPage 2000 (which IMHO is an excellent product) You might try Cold Fusion by allaire. I don't really have any persoanl experience with Cold Fusion, but through my research have noticed that it seems to be the best thing out there for data manipulation. Of course, you COULD just use notepad, and write your ASP code by hand, but who on earth wants to do that? That's too much like work LOL<br><br>&nbsp;&nbsp;&nbsp; <p>John Vogel<br><a href=mailto:johnvogel@homepage.com>johnvogel@homepage.com</a><br><a href=

http://i.winfire.com/s/isapiEng.dll/wf.exe?cmd=rl&452,20004878&wf.exe>Get

FreeDSL Service</a><br>[To a get FREE DSL Modem WITH FREE DSL Unlimited Internet Connection click the above link ]

 

[ndogg]

I would suggest something else, but...(see my signature and do a little research, will ya?) <p>REH<br><a href=mailto:hawkdogg@crosswinds.net>hawkdogg@crosswinds.net</a><br><a href=

http://www.crosswinds.net/~hawkdogg>Powered

by Linux</a><br>Learn Linux and Leave out the Windows

 

[ndogg]

Sorry about that, I don't know where it came from.&nbsp;&nbsp;Almost everyone here knows that I like Linux, and would rarely use anything else, lest I'm forced to.&nbsp;&nbsp;However, if UNIX/Linux is not your cup of tea and you don't have any admins that know them, it may not be worth it, but on the other hand, you could use a cluster in which NT would then become your front end and the Linux machine would be the actual server that holds the database (i.e. enter all the input from NT, but store the actual database on the Linux server), but that should only be done if you have a few admins that know the stuff. <p>REH<br><a href=mailto:hawkdogg@crosswinds.net>hawkdogg@crosswinds.net</a><br><a href=

http://www.crosswinds.net/~hawkdogg>Powered

by Linux</a><br>Learn Linux and Leave out the Windows

 

[Zelandakh]

I'd love to use Linux as my database server for many reasons. Not least of which is reliability, security, stability and cost.<br><br>If I decide to ignore the NT solution (don't get me started) and go fully Linux, what are my options in terms of equivalents of asp and SQL.

 

[ndogg]

The alternative to ASP on Linux is PHP or Perl, both of which are open source, but that's not really the most important point.&nbsp;&nbsp;Perl is very easy to learn, but PHP is a lot more flexible.&nbsp;&nbsp;Then again, you could alway use CGI, but who wants to deal with C over an internet connection (e

http://www),

and it's so outdated (it's not too flexible).<br>As far as SQL, MySQL is free for non-Microsoft OSes (which, of course includes Linux), and most commercial distributions (with the obvious exception of MS) support Linux.<br><br>PHP - <A HREF="

http://www.php.net"

TARGET="_new">

http://www.php.net</A><br>Perl

- <A HREF="

http://www.perl.com"

TARGET="_new">

http://www.perl.com</A>

(the Perl Monks - <A HREF="

http://www.perlmonks.net"

TARGET="_new">

http://www.perlmonks.net</A>)<br>MySQL

- <A HREF="

http://www.mysql.net"

TARGET="_new">

http://www.mysql.net</A>

<p>REH<br><a href=mailto:hawkdogg@crosswinds.net>hawkdogg@crosswinds.net</a><br><a href=

http://www.crosswinds.net/~hawkdogg>Powered

by Linux</a><br>Learn Linux and Leave out the Windows