10 sql tips to speed up your database

On most websites, content is stored in a database and served to visitors upon request. Databases are very fast, but there's lots of things that you can do to enhance its speed and make sure you won't waste any server resources. In this article, I have compiled 10 very useful tips to optimize and speed up your website database.

Link:
http://www.catswhocode.com/blog/...

32 Tips To Speed Up Your MySQL Queries

Some excellent tips

Link:
http://www.ajaxline.com/...

Top 20+ MySQL Best Practices

Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.

Link:
http://net.tutsplus.com/tutorials/...

Free Performance with MySQL Table Types

MySQL supports a number of different storage engines. When you create a table, by default MySQL will use the MyISAM storage engine to create a MyISAM table. MyISAM is a relatively simple table type, which forgoes several advanced features in order to offer improved performance. In the early days of MySQL, the MyISAM table type was instrumental in making it one of the best performing databases around.

Link:
http://www.sitepoint.com/...

5 Easy ways to get an eCommerce website

1. Getting an eCommerce site in Wordpress running in 5 minutes - Using WP e-commerce you can setup a simple, but effective in some cases, ecommerce solution in Wordpress. If you have a blog and are looking to test the waters of selling some products than this plugin will get you going faster than any other solution.

2. How to Create an Online Store with Google Checkout in 5 Minutes - With the recent release of the Google Checkout store widget Google has made it easier to add Google Checkout into your website. This means you can get a Google based store up and running in minutes, or 5 minutes, as the title states.

3. VirtueMart for Joomla or Mamabo - I don't know too much about this shopping cart but at first look it definitely is an option I will consider for anyone running Joomla. The only downside I can see is that the resulting interface is *very* Joomla like and not the prettiest thing I have seen. Still it's an option.

4. Magento - An up and coming leader in the open-source, PHP based, full-features, shopping cart solution. A little tricky to install but the feature rich application makes it something worth the effort. Add to that all the great information on Magento that's around and you won't be left alone to struggle through it. warning: Read the Magento requirements as some hosts will not meet them.

5. Paypal - Probably one of the most common names in payment gateways. PayPal's Website Payment Pro gives you a payment gateway and merchant account all-in-one. This makes it one of the easiest methods to take credit cards on your website.

Make Your Own URL Shortening Service

a basic installation of Yourls, a server-based webapp that can run pretty much anywhere a WordPress installation can. There are lots of other options, which we'll get to as well, but Yourls is a fairly smart and fast way to get up and running with your own URL shortener.

Link:
http://lifehacker.com/5335216/...

Will Oracle own MySQL?

Oracle Corporation is to buy Sun Microsystems for $9.50 a share in a deal valued at approximately $7.4 billion, just a few weeks after a deal by IBM to buy Sun fell apart. It looks like Oracle will pay a premium of $2.81 a share, or 42%, over Sun Micro’s closing price of $6.69 a share on Friday.

Oracle said the deal is valued at $5.6 billion excluding cash and debt. Oracle is calling Sun’s Java “the most important software” it has ever acquired. The deal, which is expected to close in the Summer and was unanimously approved by Sun’s board of directors, has massive implications for the future openness of Java and MySQL.

What's going to happen to MySQL?

Link:
http://www.techcrunch.com/2009/04/20/...

Useful MySQL SQL statements

Useful MySQL SQL statements is a list of some useful and maybe tricky SQL statements for MySQL.

Magento seems to be a promising eCommerce package

Magento is a new professional open-source eCommerce solution offering unprecedented flexibility and control.

Magento was designed with the notion that each eCommerce implementation has to be unique since no two businesses are alike. Magento's modular architecture puts the control back in the hands of the online merchant and places no constraints on business processes and flow.

This application looks extremely promising. The resulting interface is nothing short of professional. I was working with Zen Cart but really need to sit down with Magento to see if its mature enough to replace it.

Link:
http://www.magentocommerce.com/

Apache, MySQL, PHP on Windows with WAMP

Easy as 1-2-3

• 1. Download the latest release of Wampserver 2
• 2. Optionally add as much Apache, PHP and MySQL releases as you want
• 3. Work with a development environment that reproduces exactly your production server

Link:
http://www.wampserver.com/en/

Amazon enters Database ring with SimpleDB

Amazon SimpleDB is a web service for running queries on structured data in real time. This service works in close conjunction with Amazon Simple Storage Service (Amazon S3) and Amazon Elastic Compute Cloud (Amazon EC2), collectively providing the ability to store, process and query data sets in the cloud. These services are designed to make web-scale computing easier and more cost-effective for developers.

Pricing:

• $0.14 per Amazon SimpleDB Machine Hour consumed
• $0.10 per GB - all data transfer in
• $0.18 per GB - first 10 TB / month data transfer out
• $0.16 per GB - next 40 TB / month data transfer out
• $0.13 per GB - data transfer out / month over 50 TB

Link:
http://www.amazon.com/gp/browse.html?node=342335011

Navicat does what few applications do

And that is to switch me 100% away from an application I have used for years.

Navicat is a powerful MySQL database administration and development tool that is not only sophisticated enough for professional developers, but also easy to learn for new users.

I did a post a few weeks back about some top tools for managing a MySQL database. From that post Navicat contacted my and offered me a free license to fully take advantage of their software. Usually I am weary about this but wanted to give it a try since a top developer I know that is in charge of DonationCoder.com also uses it. Why not give it a chance and use it for week to see if I like it - basically stop using the MySQL provided tools.


So glad I did as Navicat is an awesome application that is very well designed from a UI standpoint and provides all the functionality that one could need from a MySQL manager. So much better having all the features in a single interface instead of spreading them across several tools like MySQL Tools does.

Quick Highlights:

• Ability to drag and drop tables detween databases
• Ability to copy field(s) in a table design view and paste the fields into another table table design view. Makes copying part of a table definition easy
• Import wizard is very well designed and logical in its use and flow.

Wishes:

• Query Editor. I like typing in queries and it would be nice if the Query Editor either provided intellisense as I typed a table/field name or let me drag and drop table/field names into the Query Editor without navigating back to the Query Builder window.
• Quick SQL selection: Basically allow me to select a table and press one button (or right-click menu selection) to generate an INSERT, SELECT, UPDATE and other SQL statements. Provide options of how the SQL statement is constructed: SQL statement on a single line, Lines based on SQL commands, or Seperate lines for each item.

Link:
http://www.navicat.com/

Open Source CMS

OpenSourceCMS was created with one goal in mind. To give you the opportunity to "try out" some of the best php/mysql based free and open source software systems in the world. You are welcome to be the administrator of any CMS system here, allowing you to decide which system best suits your needs.

What a great idea. A single centralized location to give some of the more popular open source PHP projects a test drive.

Link:
http://www.opensourcecms.com/

Top 15+ MySQL Managers and Tools

Aqua
A management tool for the MySQL relational database w/ administration capabilities and a database query tool. The visual administration features provide users the ability to browse and modify database structures, including schema objects, database storage and maintain database security. An integrated query tool allows users to quickly create, edit and execute SQL queries and scripts.


MySQL Quick Admin
A kinda of clone of phpMyAdmin. Has full support for managing databases and tables online through its clean interface (from what I can tell). This might be a good solution for someone not wanting the often complex and overwhelming interface of phpMyAdmin.

phpMyAdmin
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 54 languages. This is the standard for managing MySQL database online.

MySQL Query Browser
The easiest visual tool for creating, executing, and optimizing SQL queries for your MySQL Database Server. The MySQL Query Browser gives you a complete set of drag-and-drop tools to visually build, analyze and manage your queries.


MySQL Administrator
A powerful visual administration tool that makes it easy to administer and monitor your MySQL environment and gain significantly better visibility into how your databases are operating. MySQL Administrator now integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.


MySQL Workbench
a database modeling tool for MySQL. You can use it to design and create new database schemas, document existing databases and even perform complex migrations to MySQL. Not a lot of movement with this project in a very long time and the reason why DB Designer Fork should be checked out first.


DB Designer Fork
DB Designer Fork is a fork of the fabFORCE DBDesigner 4. DBDesigner is a visual database design system that integrates entity relationship design and database creation. DB Designer Fork generates SQL scripts for Oracle, SQL Server, MySQL and FireBird.


Navicat
A powerful MySQL database administration and development tool that is not only sophisticated enough for professional developers, but also easy to learn for new users.


EMS SQL Manager for MySQL
A high performance tool for MySQL Database Server administration and development with a state-of-the-art graphical user interface with well-described wizard system.


Zmanda Recovery Manager for MySQL
Simplifies the life of a Database Administrator who needs an easy-to-use yet flexible and robust backup and recovery solution for MySQL server.


TurboDbAdmin
A single-page solution for exploring and editing databases from a browser. Edit data just like you would in a desktop application, without submit buttons or page refreshes.

Toad for MySQL
A database development and administration tool that provides productivity features for rapidly creating and executing queries and managing complex database systems.


SQLyog
An advanced GUI frontend to MySQL. Includes Visual Query Builder, Visual Schema Designer, Smart Autocomplete, Intelligent Code Completion, Scheduled Data Synchronization, Powerful Migration Toolkit and much more.


WinSQL
WinSQL can talk to any database for which you have an ODBC driver and be the one interface to manage them all.

Applications Manager's MySQL
Applications Manager's MySQL monitoring feature has the ability to connect to the database source & monitor various system table column values, collect data, etc. and also notify through alerts, if the database system properties are beyond a given threshold. Applications Manager provides a web client that allows you to visualize MySQL monitoring data from your database tier alongside your application tiers.


HeidiSQL
An easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows interface.

Digg It