Notes on the web-development and artificial intelligence.
In the previous post I outlined the system’s specs and use cases. We also selected the primary use case we should start from – that is filtering screen.
Continue reading ‘Database structure and filtering approach. SMS Notification system.’ »
In November 2008 I’ve got a nice project, that resulted in a complex search engine, that specializes in clothing. I can’t give the link now, but will do when site officially launches. Key features of such service are:
Sure, the site is running on a dedicated server, sure I use caching, but optimal DB is a key to success.
Continue reading ‘Building high-loaded portal – InnoDB vs MyISAM’ »
Yesterday I’ve read a post on The Developer’s Day blog. Then tested this thing in Yii. There is a jQuery in my application, so I created test controller and test action, that only outputted “Hello, world” and called it from the firebug console Continue reading ‘Speeding up Yii or why should you use DB sessions’ »
Nearly every large application has some configuration parameters – site admin email, cache time for different blocks, number of latest news, number of items per search or catalogue page etc.
Continue reading ‘Handling Application Parameters in Yii – Using the Database’ »
In December I’ve got a project, that required sophisticated and quite complex DB and that DB was subject to change greatly during first development phase. Before that project I was using Sparx Enterprise Architect both for application design and DB design. But, frankly speaking, it’s not good at databases, especially MySQL. So I decided to pick up a new DB modelling tool.
Continue reading ‘MySQL Workbench – The Database Modeling Tool for MySQL’ »
