In our final section, we asked about server side languages, frameworks and technologies respondents used. It included questions about server hardware, server operating systems, web servers, database systems, and backend programming languages and frameworks.
When asked “What type of hardware do your sites run on?”, 35% responded “Dedicated servers managed by you or your company”, 30% shared servers, 15% “Dedicated co-located servers”, while 5% said “don’t know”.
|What type of hardware do your sites run on?|
|Dedicated servers managed by you or your company||433||35.09%|
|Dedicated co-located servers||189||15.32%|
Server OS and Web Servers
Linux and Unix dominate the server side operating systems used, with 59% and 17% respectively, while Windows weighs in at 28%. Perhaps surprisingly, Mac OS X is used as the server side operating system by nearly 6% of respondents.
|What server software is used to serve your sites?|
As to be expected, Apache and IIS dominate the web server market, with Apache at 69% and IIS at 23%. As with the operating system figures, this is a much greater discrepancy than between these servers and operating system than is generally reported by surveys like Netcraft’s (which puts Apache at around 48% and IIS at 33%). Lighthttpd came in at 5.5%, while Google’s GWS is very lightly used by comparison with other surveys.
It needs to be kept in mind that server software and operating system surveys like Netcraft’s typically measure market share in terms of sites served, where this survey is essentially per developer. As such, any comparison between market share from those studies and this are probably of little meaningful value.
|Which operating system(s) do your servers run?|
|Mac OS X||69||5.59%|
When asked “What database systems do you use?”, only 3.4% of respondents replied “none” – further emphasizing the increasing move away from static page based sites to dynamic sites.
Among the database systems nominated by respondents, MySQL dominates with over 70% of developers using it. Microsoft’s Microsoft SQL Server has a 22% market share among respondents, PostgreSQL 10%, and Oracle 9%. Other databases nominated by respondents include SQLite (around 1.5%), with a handful using CouchDB, Filemaker, and Access.
|What database systems do you use?|
|Microsoft SQL Server||271||21.96%|
Back end Programming languages and Frameworks
Of “other” languages, a handful of respondents use ActionScript, with few other languages being used by more than one or two respondents. As with all our other questions, the full details are available to download.
|Which programming languages do you use?|
The use of these languages increasingly goes hand in hand with a framework. These frameworks are language specific – and for some languages, such as PHP, there may be more than one widely used framework.
Of those who do use frameworks, 13% use Ruby on Rails (despite Ruby being quite a way down the list of languages, this is the single most used framework. This may be due to the fact that most Ruby developers likely started using the language because of the Rails framework.)
Other commonly used frameworks include Django, the Python Framework (11%), the Zend Framework (the most commonly used PHP framework, at 6.4%, but used by only 10% of PHP developers in this survey), and CakePHP, a close second to Zend among PHP frameworks at 6%.
Other frameworks mentioned include the Java framework Struts (about 2%), the PHP framework Code Igniter, at about 1%, and Spring for Java at about 1%. A number of content management systems, such as WordPress, Joomla, and Drupal, which while not technically speaking frameworks, are increasngly being used in ways similar to them.
Interestingly, just under 20% of respondents said that they use internally developed frameworks.
|Which back-end frameworks do you use for development?|
|Ruby on Rails||164||13.29%|
We’ll wrap up with some conclusions, and try to get a sense of the state of the web at the end of 2008.