{"id":7235,"date":"2011-03-03T21:22:00","date_gmt":"2011-03-03T21:22:00","guid":{"rendered":"https:\/\/www.htmlgoodies.com\/uncategorized\/top-5-databases-for-web-developers\/"},"modified":"2021-04-23T21:04:20","modified_gmt":"2021-04-23T21:04:20","slug":"top-5-databases-for-web-developers","status":"publish","type":"post","link":"https:\/\/www.htmlgoodies.com\/database\/top-5-databases-for-web-developers\/","title":{"rendered":"Top 5 Databases for Web Developers"},"content":{"rendered":"
When listening to developers talk about databases you will usually hear buzz words like robust, scalable, efficient, etc. Discussions will focus on the power of the DBMS (DataBase Management System) and how it integrates with other technologies. In our case, however, we don’t really care about most of those things. Instead we are going to be looking at the cost of getting started, tools, the user interface and availability of help, especially help for the beginner.<\/p>\n
In the list below we’ll talk briefly about each DBMS, give you some pros and cons, and show you how to download and get started with each of them.<\/p>\n
This DBMS gets the number one nod mainly because the community version is free and is a great platform to begin learning on. There are, of course, commercial versions of MySQL for sale once you get to the point where you are developing large scale commercial applications, but getting started will cost you a big fat nothing.<\/p>\n
Initially MySQL was available on a small set of platforms, Linux for the most part. However, now you can put MySQL on pretty much anything that you can imagine including Linux, Mac and Windows.<\/p>\n
There is also a community version of their MySQL Workbench tool which gives the beginner a nice GUI (graphical user interface) to visually design and work with database tables. MySQL Workbench is reasonably intuitive, helps the beginner learn syntax by allowing the user to see syntax created by the tool when a task is designed, and has decent help documentation. Better than the actual help documentation you can find a ton of online tutorials, blogs, articles, etc. on developing in MySQL.<\/p>\n
To get started with MySQL download both the MySQL Community Server and MySQL Workbench tool<\/a>.<\/p>\n Unlike MySQL, Microsoft’s Access is not free. However, as it is part of Microsoft Office, many developers already have it. Even if you don’t use Microsoft Office you can still download a trial version of Access which will get you 60 days to play around with it and see if it is for you.<\/p>\n Access does have some key similarities to MySQL. It lets you design a table or task visually and then see the syntax that gets created. There are also some good and not so good differences. On the good side Access doesn’t have two separate installations (one for the DBMS and one for the design tool) but rather all comes as a single application. On the down side, Access has some significant limitations. It’s not nearly as flexible on which operating systems it can be installed on. More significantly, it has a serious limitation in how many concurrent connections it can handle before performance degrades. What that means is that Access is ideal for learning and for low traffic hobbyist websites but becomes sluggish and unsuitable for websites that have moderate or heavier traffic.<\/p>\n If you don’t already have Microsoft Office you can download the trial<\/a>.<\/p>\n With this DBMS and the next two, we step up to the big boys. Microsoft SQL Server, Oracle and DB2 are the most popular of the major DBMS’s. They each have separate design tools and server applications that must be installed.<\/p>\n In truth, Microsoft SQL Server, Oracle Express and DB2 Express are all very similar in tools and functionality. Their biggest differences lie in the syntax of their SQL, therefore, they are not really listed in any particular order. The Microsoft SQL Server option does have one drawback in that the operating systems it will run on are limited.<\/p>\n You can download Microsoft SQL Server Express<\/a> for free.<\/p>\n Oracle Express also has tools and a separate server application. It also has more operating system options than Microsoft SQL Server Express. The download options are also much more abundant than the others in this list. But all the download info you really need to get started can be found here<\/a>.<\/p>\nMicrosoft Access<\/h2>\n
Microsoft SQL Server Express<\/h2>\n
Oracle Express Edition<\/h2>\n
DB2 Express-C<\/h2>\n