Codeigniter is wonderful platform, and i am not planing to question it. Everything they say in the documentation is true, and at the moment I am not planing to switch. After I started using it, I am not planing on developing web without it till something better arrives. However, from Read more…
I am trying to keep current with state of the art design practices, although I have not coded anything major for 2 years already. I have a feeling that I need to get in touch with current design practices from within, not only by theory. This is a must for Read more…
Recently I looked for advanced social bookmarking script for one project of ours. One of my picks for this tasks was newscloud . The site looks really nice and it looks fully featured script for social bookmarking niche. However, there are lots of problems with the script itself. The upsides Read more…
Just a quick note for warm-up. Recent server maintenance and test showed me, that postgresql behaves badly when there are more than couple indexes on the same table. We have some tables that are used in various queries using quite many criteria to determine the result, thus more than couple Read more…
Recently we have migrated some of less intensive sites to weaker servers, and noticed quite strange behavior: mysql starts consuming more and more memory till it crashes. The loads go up as all the memory and swap space is consumed. We could not track down the problem easily. We tried to find out what’s the problem for a couple of days till we found out.
Here are some tips for working with postgresql databases
Most, if not all, common websites that run under PHP and apache use mysql for the database. Mysql is fast, reliable and free. However, there are other solutions, and, inspired by some colleagues, we have tried postgresql in a complex project. The project basis is many types of profiles connected through various relationships. These types share some but not all properties, and have complex messaging and listing system to access each of the profiles. The recoding started in spring 2005. The results at this date are in the entry.
Personally, I prefer programming using Firefox as the fronted for looking at programming results. The benefit of this over the usage of explorer is that one sees mistakes better and there are better set of tools to evaluate the result or check the design in progress. The first and perhaps Read more…
Content is the king. However, the linking defines the site and page importance for other web participants. Both internal and external ones are important, and there are tricks how to use HTML to your benefit. Common, image, javascript links, the new rel=”nofollow” atribute, redirects, robots.txt – there are variety of Read more…