• 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.

Access vs MySQL vs SQL Server 2005

C

CTringali

Member
I'm new to the whole software development scene. I've recently started up an internet forum using Snitz Forums and Microsoft Access. I read a few articles on how desktop databases don't serve well on the web. I've looked around for a few comparisons, more info on them, but nothing is standing out. Can somone point me in the right direction?

Second question, does anyone now how to install phpBB Forums on a Windows server?
 
I would google on "Microsoft Access", "mySQL", and "Microsoft SQL Server". You can also include keywords like "features" to get a quick overview of each.

Access is not good for server-side use because it is missing some key features. An Access database is just a file-- there is no server software managing it. To guarantee consistency, it uses file-system locks. Attempts to use Access databases in server-side contexts often result in corrupt databases, and the performance is horrible.

Of course, there are many many reasons besides this not to use Access: the lack of a scripting language for writing stored procedures, lack of built-in server features such as automated backups, etc. etc. etc.

MySQL is a very good choice for a low-cost solution, although with SQL Server there is also a version called MSDE that's free (although hobbled). MySQL is fairly easy to learn and to administer with free tools available from the MySQL site, but SQL Server gets the nod for ease of use. Both will have good-enough performance for your needs.
 
awesome... i'll check them out.... i've been building computers for years, but i'm very new to software development. i hate being a noob again, heh
 
Originally posted by: 6000SUX
MySQL is a very good choice for a low-cost solution, although with SQL Server there is also a version called MSDE that's free (although hobbled).
Click to expand...

It's actually called SQL Server Express now.

For reasons mentioned about, I would immediately dismiss Access, especially with free alternatives such as MySQL and SQL Server Express.

You'd probably get more support/help with phpBB using MySQL, but I personally prefer SQL Server Express. No compelling reasons, but I'm just more comfortable in a SQL Server environment.
 
Access if you want to pull in a little bit of data and play with it at a departmental level, or for things like maintaining an address list at home. SQL Server for scalable enterprise-level data storage, access, manipulation, and reporting. MySQL if you want most of that and don't want to spend money.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top