Free knowledgebase Application that is built with PHP & MySQL

For every e-commerce website, web application or even a standard website, knowledgebases are very useful systems for helping users to find answers themselves.

68KB is a free knowledgebase application that is built with PHP & MySQL & can be themed to match the look of any website.

php-knowledgebase-script

It has support for unlimited categories/sub-categories & SEO friendly URLs. Also, features like an “integrated glossary”, “popular & new articles” makes browsing much easier.

With the help of an admin interface, it is possible to manage the system easily, view the stats, search logs & more.

68KB is multilingual & built with the CodeIgniter framework. Continue reading

Open Source Application for taking scheduled backups of MySQL databases & FTP files

phpMyBackupPro is an open source application for taking scheduled backups of MySQL databases & FTP files.

It offers a flexible usage as backup jobs of multiple databases/files from multiple servers can be scheduled, completed & compressed.

phpMyBackupPro

Backups can be taken to any location including remote FTP servers.

Besides taking backups, phpMyBackupPro can restore & e-mail backups. As a third option, it is also possible to download them.

Continue reading

CometChat, a Facebook-style chat script – based on PHP / MySQL script

CometChat, a Facebook-style chat script -which enables website users to chat with each other easily- is giving away 2 licenses ($49/each) to WebResourcesDepot readers. Details on “how to join” can be found at the end of the post.

CometChat

What is CometChat?

It is a PHP / MySQL script for creating a chat environment that can be used while visitors are browsing any page of the website.

Users can select their statuses (like busy, available, invisible or a custom one), “get friends” with each other & see if their friends are online or not.

Continue reading

Backup2Mail: Now Easily Backup And E-Mail MySQL Databases Automatically

Almost every web designer/developer, one way or another, faces data loss & experiences the importance of taking regular backups.

Backup2Mail is a free PHP script which easily prevents this problem by automatically backing up MySQL databases & e-mailing them to a given address.

Backup2mail

It requires PHP 4.1+ to run & for scheduling the script, cron jobs (Unix/Linux) or a scheduled task interface (Windows) is required.

Continue reading

Useful Tips To Speed Up Your MySQL Queries

If you are interested in how to create fast MySQL queries, this article is for you

  1. Use persistent connections to the database to avoid connection overhead.
  2. Check all tables have PRIMARY KEYs on columns with high cardinality (many rows match the key value). Well,`gender` column has low cardinality (selectivity), unique user id column has high one and is a good candidate to become a primary key.
  3. All references between different tables should usually be done with indices (which also means they must have identical data types so that joins based on the corresponding columns will be faster). Also check that fields that you often need to search in (appear frequently in WHERE, ORDER BY or GROUP BY clauses) have indices, but don’t add too many: the worst thing you can do is to add an index on every column of a table (I haven’t seen a table with more than 5 indices for a table, even 20-30 columns big). If you never refer to a column in comparisons, there’s no need to index it. Continue reading

Cross-Database Admin Tool which can manage MySQL, PostgreSQL and Oracle

Navicat, an impressive database admin tool which has versions to manage specific databases is now offering an unique tool named Navicat Premium which can manage:

  • MySQL
  • PostgreSQL
  • Oracle

within a single application with amazing features.

Navicat Premium

Navicat Premium allows you to control these 3 database types like they are the same & saves you too much time. You can:

  • drag’n drop tables from Oracle to MySQL, PostgreSQL to MySQL and vice versa
  • schedule operations for different databases such as print report in MySQL, backup data in Oracle and synchronize data in PostgreSQL to run automatically

Continue reading