A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.
I am planning to convert an existing 'text files' and file-systems based project to mysql.
My current work is in Perl, but I am open to other languages such as Ruby.
There could be lots of things that could be done better.
So, I am looking for some existing mysql projects to get some ideas.
Monday, June 20, 2005
I really mean, the back-end.. ie.. how data is loaded, updates are performed, indexing, serving etc..
Monday, June 20, 2005
I second that. Slashcode is definitely worst web app code I have seen in years.
Tuesday, June 21, 2005
I would think Wikipedia is a good example to look at. Wikipedia is an instance of a MediaWiki wiki, which is an open source project you can download here:
Not only that, but you can get a good idea of how MySQL scales with Mediawiki by looking at detailed info regarding the hardware used to run their Wikipedia sites, along with info regarding the amount of traffic served. These servers serve some sites other than Wikipedia, I think, but Wikipedia is by far the largest:
I stand corrected - I knew that Slashcode ran on MySQL and the site has a certain popularity. But I had no idea what the code was actually like.
Having said that, seeing what not to do can sometimes be interesting - consider http://www.thedailywtf.com/
Wikipedia is a useful, interesting thing, but the code behind it is well... it's not fast. Wikipedia depends, really depends, on having the Squid cache beween it and the world, or it'd set those servers alight in minutes. I'm talking half a second to a second or more to generate a page, on current hardware.
So take it for what it's worth, but don't consider it a complete example.
There are a huge number of projects that can be looked at to see how to use MySQL. Probably more than 90% of the many open source blog and CMS software use MySQL. http://opensourcecms.com/index.php?option=com_frontpage&Itemid=1
SugarCRM is a nifty CRM tool that uses MySQL: http://www.sugarcrm.com/home/
This topic is archived. No further replies will be accepted.Other recent topics
Powered by FogBugz