SQL and My Server

Any off topic discussions should go in this forum. Post count is not increased by posting here.
FTP Access status is required to post in this forum. Find out how to get it
Forum rules
Any off topic discussions should go in this forum. Post count is not increased by posting here.
FTP Access status is required to post in this forum. Find out how to get it
Post Reply
st.alfonzo
User avatar
Donator
Posts: 163
Joined: Tue Oct 02, 2007 1:43 am

SQL and My Server

Post by st.alfonzo »

How would you implement SQL on a server?
I need some advice as I tried to do it myself, but couldn't figure out how.

Bender
User avatar
Donator
Posts: 1524
Joined: Fri Aug 18, 2006 4:30 pm

Post by Bender »

Well first you need to install a SQL Server. I reccoment MySQL
Then you install a webserver, such as Apache

Then you are done.
Image
Mozilla/5.0 (Macintosh; U; PPC; en-US; mimic; rv:9.3.2) Clecko/20120101 Classilla/CFM
"Stupid can opener! You killed my father, and now you've come back for me!"

stitch
Permanently Banned
Posts: 463
Joined: Mon Dec 11, 2006 3:09 am

Post by stitch »

Really to go among more than that, there's a few different SQL database engines out there (Access, MySQL, PostgreSQL, MS SQL, BerkelyDB, Oracle, Pervasive, SQLite), and some are servers and some are flatfiles.

The 2 most popular and really, only SQL Servers worth using are MS SQL and MySQL. Starters are better off using MySQL as it's GPL licensed and runs on Linux, BSD, and Win32/64.

MySQL can be called from PHP, Perl, ASP, ASPX, all which runs on IIS or Apache (ASP, ASPX win32 only). They can also be called from within standalone applications aswell.

When you want to get into more advanced features, MS SQL is really the way to go. The Stored Procedures, Views, and security is far superior to MySQL, and replication is a plus, among other things.

Post Reply