Obviously, there are a lot of considerations that go into choosing a database, but thought I might get some tips from you guys.
I'm building a fun data-centric web site. I need a database to store large chunks of text (say 1-5 paragraphs) that people will enter and read online. The catch is that I'm just one person with little to no money to spend and I don't really need an 'enterprise' solution. Not that I expect my web site to be popular, but I guess you never know, so scalability might be a plus as well. And I don't want to be hacked either, so I think security is a concern but not a huge one.
I considered sql server express 2005 ... but I'm not sure about the licensing and putting it on the web?
thanks for any input!
2007-01-20 04:42:59 · 5 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
You'll be fine using MySQL for this. The average shared Web hosting server running PHP and MySQL can more than handle what you describe.
In the event your site ever grows larger, you just start paying more to be on servers with fewer and fewer sites, until you reach the point of having your own leased server or server farm. There's nothing money can't fix.
In re: being "hacked," that has a lot more to do with sloppy code you use to insert, update, delete and retrieve records than with the database itself. When you get to the point that you actually are writing code, ask a new question for tips on how to avoid SQL injection, DOS attacks and the like.
If you are wedded to using ASP.NET, Microsoft Access will provide a fine and secure method for storing data, again just so long as you exercise some basic coding caution.
You can find free PHP / MySQL Web hosting at http://www.addyour.net
You can find dirt-cheap PHP / MySQL Web hosting at http://www.dreamhost.com or http://www.godaddy.com
You can find dirt-cheap ASP.NET / SQL Server hosting at http://www.webhost4life.com
2007-01-20 05:48:51 · answer #1 · answered by Anonymous · 4⤊ 2⤋
This is my two cents. If you are using windows use Sql express 2005. I have used it for a large accounting firm with gigabytes of data w/ no probs. If you are using Linux run MySql.
RJ
2007-01-23 10:41:51 · answer #2 · answered by Anonymous · 0⤊ 0⤋
You can't go wrong with PostgreSQL and it's....FREE! About as many sites use mySQL but PostgreSQL is rapidly gaining market share due to it's features and robustness (is that a word? lol)
2007-01-20 04:45:56 · answer #3 · answered by bogus_dude 6 · 3⤊ 4⤋
im trying to figure out the same thing on here
2016-03-29 06:15:11 · answer #4 · answered by ? 4 · 0⤊ 0⤋
PostgreSQL or mySQL
2007-01-20 04:49:23 · answer #5 · answered by hmmm 4 · 1⤊ 1⤋