iCan
solidstonePHPCamp is place to share news, views and articles that are useful to PHP community.
Login to share your opinion
Resolve many-to-many relations a bit different with MySQL
submitted by 
In database modeling, a m:n relationship is usually resolved by an additional table. But what if this relation is used only for archiving and the… read more
My (SQL) WorkLog: MySQL: Kill sleeping connections
submitted by 
It’s all about My (SQL) favorite tools, utilities, tips, tricks, code snippets, discoveries and best practices. read more
Getting Started with Memcached Distributed Memory Caching — Developer.com
submitted by 
Wikipedia describes Memcached as a general-purpose distributed memory caching system, but what exactly does the term Memcached mean? Cache is memory used to store the… read more
How to quickly convert mysql databases from MyISAM to InnoDB
submitted by
Recently I was in need to convert all databases of a MySQL server from MyISAM engine to InnoDB. read more
Using PHP for Simulating Database Transactions
submitted by
There is a fine line between transaction statements and error checking. I am going to blur the line a bit by using PHP to simulate… read more
Quick Tip: Working with MySQL and SUM
submitted by
In today’s quick tip screencast, we’re going to learn a MySQL query trick. You might be already familiar with the SUM() and IF() functions. read more
Simple Bookmarking App With PHP, JS & MySQL
submitted by
Part of the developer’s life, is to strive for simplicity in every aspect of their work. When searching for solutions to common problems, you have… read more
MySQL 101: Working with the MySQL DB on Linux
submitted by
Some people are born to be a database administrator, and others have database administration thrust upon them. read more
Debugging problems with row based replication
submitted by
MySQL 5.1 introduces row based binary logging. In fact, the default binary logging format in GA versions of MySQL 5.1 is 'MIXED' STATEMENT*, which means… read more
Using CouchDb as filesystem with PHP
submitted by 
CouchDb has a great feature. We can store files as attachments into our documents. If we add this feature to its multi-master replica system, we… read more
List a Directory's Contents Using PHP
submitted by 
To list the content of a directory you just need to use the combination of opendir() and readdir() functions. read more
Browser Compatible Info for HTML and CSS
submitted by 
CSS and HTML is used to design a website to look attractive. However, the development of CSS and HTML, and every browser that is not… read more
Why I sometimes get miscellaneous exclamation marks (!) in SQL generated emails
submitted by
Using SQL server to generate automatic emails, I've noticed from time to time that the emails will miscellaneously contain exclamations throughout the mail. read more
Creating Spatial Reports from Sources other than SQL Server
submitted by
With the release of SQL Server 2008 R2, Microsoft provided the capability of generating Reporting Services solutions that provided more than just tablix data. It… read more
How to Reset the Root Password of Mysql Server
submitted by
By default, MySQL Server will be installed with root superuser without any password. You can connect to MySQL server as root without requiring password or… read more
CSQL - Command Line SQL Interpreter
submitted by 
I decided to update this CSQL Interpreter Tutorial to make it clearer why it is a must-know tool for database administrators. Once a user has… read more
Rebuilding Indexes using the SSMS Database Maintenance Wizard
submitted by
This article will describe how to use the Rebuild Index task in the Database Maintenance Wizard to maintain the health of your database indexes, which… read more
Self-Indulgent Code: Automatic Tables from SQL Query Data
submitted by
A common operation for me is to regenerate data extracted from an SQL query as a visible table that can allow a a programatic interaction… read more
Relational Database Design - NormalizationDatabase
submitted by
It's common for people new to relational databases to approach the design of the tables like they would a flat, Excel-like spreadsheet: to design the… read more
What made SQL successful is what makes it slow?
submitted by
The SQL language is perhaps the most successful fourth generation programming language (4GL). The main goal of SQL is to separate the “what” from the… read more
