• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Anyone here know anything about databases?

Shawn

Shawn

Lifer
I have no idea if this is off topic enough or not or where this this should go so mods move if approperate. 😛

I just started using MS SQL for my forums but I dunno if that's a good idea. My host now provides it at no extra charge but some hosts charge extra. Would it be any better than MySQL for a forum? Also does anyone know how to access it remotely like you can with MySQL using phpmyadmin? Or does this vary by host?

Also I may decide to just drop my host and host my site off my dsl. I know I can run the forums with MS Access extremely easily using just IIS and the drivers that come with it but Access is so slow! How hard would it be to set up MySQL on my rig?
 
get a linux box and set it up. however, it's not advisable and your bandwidth will be sucked up.

if MS SQL works, go with it. we use it at our company and it works fine but it's a pain to maintain the code that goes with it (i guess that's what you get when you see the development side of things). if you want to run your forums using something php based, try phpbb.
 
Ummm...access??? Access sucks if you start to get 10+ users (unless the DB is real real small). And on your own DSL? What kind of upload speed do you have?
 
Originally posted by: five40
Ummm...access??? Access sucks if you start to get 10+ users (unless the DB is real real small). And on your own DSL? What kind of upload speed do you have?
Click to expand...

tell me about it. I was using it on a forum with 300 members and over 100,000 messages.

I forget what up upload is. somewhere around 50kb/s.
 
Originally posted by: tami
get a linux box and set it up. however, it's not advisable and your bandwidth will be sucked up.
Click to expand...

Also most likely against his ISP's TOS.

if MS SQL works, go with it. we use it at our company and it works fine but it's a pain to maintain the code that goes with it (i guess that's what you get when you see the development side of things). if you want to run your forums using something php based, try phpbb.
Click to expand...

Sounds like that's more an issue of people not being very familiar with it.

OP, a PHP/MySQL forum should be fine for you.
 
Well I already have the forum software. so I should just delete the database and start over with mysql?
 
Originally posted by: Shawn
Well I already have the forum software. so I should just delete the database and start over with mysql?
Click to expand...

I'd probably go with mysql. I use both MS SQL and mysql on a daily basis and I'd take mysql. Not to mention if you ever get big enough and have your own server(s) you won't need to buy any MS SQL copies and you won't be tied to windows. So you could run all free software vs. having to pay for everything.
 
Originally posted by: five40
Originally posted by: Shawn
Well I already have the forum software. so I should just delete the database and start over with mysql?
Click to expand...

I'd probably go with mysql. I use both MS SQL and mysql on a daily basis and I'd take mysql. Not to mention if you ever get big enough and have your own server(s) you won't need to buy any MS SQL copies and you won't be tied to windows. So you could run all free software vs. having to pay for everything.
Click to expand...

You have a good point about not being able to run it under Linux (although moving the data should be relatively painless if the event arises), but I'm surprised you'd pick choose MySQL over SQL Server when you use both on a daily basis. The graphical tools provided by SQL server are much better than phpMyAdmin.

shawn, does the forum software you're using even support MySQL? And what is it written in? If it's written in ASP, then moving it to a linux host is a non-issue.
 
Originally posted by: mugs
Originally posted by: tami
get a linux box and set it up. however, it's not advisable and your bandwidth will be sucked up.
Click to expand...

Also most likely against his ISP's TOS.
Click to expand...

possibly, if for commercial use. my ISP blocks port 80 but i run a private webserver on another port for testing purposes. i primarily use my hosting accounts nowadays though.
 
Originally posted by: tami
get a linux box and set it up. however, it's not advisable and your bandwidth will be sucked up.

if MS SQL works, go with it. we use it at our company and it works fine but it's a pain to maintain the code that goes with it (i guess that's what you get when you see the development side of things). if you want to run your forums using something php based, try phpbb.
Click to expand...

It is been awhile, but don't SQL Server required you to buy a license?
Anyway, just download mySQL and you all set.
 
Originally posted by: tami

possibly, if for commercial use. my ISP blocks port 80 but i run a private webserver on another port for testing purposes. i primarily use my hosting accounts nowadays though.
Click to expand...

Possibly even for personal use, but they'll never notice if you don't have a lot of traffic. 😉
 
I think as far as stability, MS SQL is better than MySQL - but I don't know what the performance comparison is.

If you want to switch hosts in the future, you're going to be limited, most will not offer MS SQL (especially as a free service).
 
Originally posted by: crystal

It is been awhile, but don't SQL Server required you to buy a license?
Anyway, just download mySQL and you all set.
Click to expand...

Yes it does, and for good reason...

You make a good point though. 🙂 There are a few no/low-cost options:
MSDE - essentially SQL Server, but lacking the development tools that come with it. Also limited to 2 GB, and peformance suffers one you get over 5 concurrent connections.
SQL Server Developer Edition (or something to that effect) - full-featured SQL Server for about $40, but it's only licensed for personal development use... you can't legally use it in a production environment.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top