Posted by Rasti | Feb 8th, 2010
Designing web pages, creating add-ons and also the various CMS couldn’t ever be as easy as it is using the ALPHA CMS. ALPHA CMS – An MVC based A.P.I Content Management System is mainly based on JavaScript, PHP, Smarty and MySQL.
The downloadable version of the ALPHA 2.2 version is now available and ready for your use. The up gradations are completely automated that makes it extremely user friendly. You can...
Posted by Rasti | Sep 29th, 2009
Want to have nice image gallery on your personal or small company website? Just try a free image gallery website system called Moa.
This application is developed in PHP and uses MySQL for data storage. Moa is not for those who want to use comments writing or photo ratings and it doesn’t require any registration or login usernames. Moa is intended only for sharing pictures from holidays, family photos and other...
Posted by Rasti | Sep 14th, 2009
Content Management System jCore was developed mainly for webmasters who need to maintain multiple webpages for their clients and they want to keep the source codes up to date and very easy fix bugs for all clients at once.
This CMS has two main basic systems, jCore Server which holds all the libraries and modules you can build on, and jCore Client which is the stripped version of the core system without any...
Posted by Rasti | Jul 21st, 2009
Suppose, you have a black day, unintentionaly confirmed DROP DATABASE command and your hardly filled tables has gone, forever! Is there any chance to recover dropped database and get your valuable tables back again? This tutorial tries answer this question.
The Catastrophe
It’s 10:23 p.m. and I’m still working on a project for my customer. It’s just an update for some components and some manual...
Posted by Rasti | Jul 6th, 2009
Performance Tuning Primer Script is the shell script which gets performance related information from MySQL engine and produce some recommendations for tuning of MySQL server variables. It’s easy to use and offers valuable output for MySQL performance optimization.
A Bit of Theory
In previous three posts of this MySQL Optimizing tutorial mini series (Configuration Directives, Log Slow Queries and Importance...
Posted by Rasti | Jun 30th, 2009
This third part of MySQL optimizing tutorial mini series shows an importance of table order during JOIN. The difference between regular JOIN and optimized one is dramatic, so keep reading! This post may save your time and headaches in some MySQL problem handling.
Once upon a time I bought an application for article submissions, written in PHP. Yes, it sounds incredible, but it happened. Primary reason was my...
Posted by Rasti | Jun 22nd, 2009
This is a second part of MySQL optimizing tutorial mini series. As the title indicates, we’re going focus on MySQL slow queries and their logging. We’ll use the official MySQL manual for version 5.0 as a refernce. After read of this post you should be able to set up logging of MySQL slow queries for further use and be familiar with its basic output.
What Is It?
As mentioned earlier, in the first...
Posted by Rasti | Jun 11th, 2009
Every web developer knows that in these days almost every dynamic web site uses some kind of database to store data. An application generating (X)HTML code sends queries for data to database and database returns this data back to the caller – in this case the application. Also, data from users or content in itself is stored in a database. The most widespread database engine, used primarily for web application...
Posted by Rasti | Apr 15th, 2009
Everybody starts sometimes. Nobody was born wise and experienced. Maybe, some of you would like to know how to begin with web development. And those of you this short post is for. You’ll find here some suggestions, tips and navigation which way to go to become a web developer from scratch.