Posts tagged ‘DB’
I’ve graduated in March 2010 and I don’t need to visit university any more. However, I enjoyed studying there and I know what challenges my fellow students-programmers have. That’s why I continue the job started this autumn – computer club, we call it “Geeks’ Club”. Sure, we’re not true geeks there, but we tend to be 
So I’m helping students who’re interested in web-technologies and in object-oriented programming. I explain them things that are not covered in the standard university course. Things, that are more practical and they can be paid money for.
Continue reading ‘Requirements and Use Cases. SMS Notification System.’ »
Posted by Konstantin Mirin on March 18, 2010 at 08:00 under OOP, PHP, Programming.
Tags: DB, experiece, modelling, OOP, PHP, sms-notify, UML
3 Comments.
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:
- Large number of users, which search with various parameters, rate items, leave comments, create articles etc.
- Large database, that is updated frequently
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’ »
Posted by Konstantin Mirin on May 20, 2009 at 09:00 under DB Design, Databases, MySQL.
Tags: DB, design pattern, efficiency, MySQL, production
9 Comments.
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’ »
Posted by Konstantin Mirin on March 5, 2009 at 06:02 under Databases, PHP, Yii.
Tags: DB, production, session, tip, trick, Yii
18 Comments.
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’ »
Posted by Konstantin Mirin on March 4, 2009 at 11:48 under Databases, Yii.
Tags: DB, extension, framework, tip, trick, Yii
27 Comments.
The history
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’ »
Posted by Konstantin Mirin on March 1, 2009 at 07:42 under Databases, MySQL, Yii.
Tags: database design, DB, modelling, MySQL, Yii
41 Comments.
