Storage Engines are the programs that are integrated with a MYSQL database management to manage the data tables. MYSQL supports different storage engines that handles different tables.
Selection of Storage Engine:
Selection of storage engine, depends on users table type and its purpose. Each has their own advantages and disadvantages. Also, possible to select engine at the time of creating tables.
While selecting storage engine, the factors that can affect your selection are:
- Transaction and concurrency
- Special features
You should use INNODB for your tables unless you have a compelling need to use a different engine!! (To get High Performance)By- Peter Zaitsev
Some of important Storage Engines are :
MyISAM, INNODB, MERGE, MEMORY, etc.
The major thing that one should know what are the difference between InnoDB and MyISAM???
- Designed with a thinking that database are frequently read not updated.
- Simple to understand and implement.
- Has full text searching capability.
- Good for frequent read operations(when several computations are executing simultaneously)
- Faster reads and writes for small to medium sized tables.
- Lock tables while updating.
- Count(*) queries are fast
- Non-transactional. Data loss issues during crashes.
- Table level locking
- Insert and update queries are scaleable, concurrency issues
- Designed with a thinking that database are frequently updated not read.
- Data-integrity is maintained throughout the entire query process.
- Clustering by primary key for faster lookups and ordering.
- Transactional, crash-safe, better online backup capability.
- Allow multiple updates on single table
- Locks only row, not table.
- Slower writes(insert, update queries)
- Slower BLOB handling
- Count(*) queries require full table scan.
Simple comparison chart
|Required full text Search||Yes||5.6+|
|Frequent select queries||Yes|
|Row Locking (multi processing on single table)||Yes|
|Relational base design||Yes|
Frequent reading, almost no writing => MyISAM
Full text search in MySQL <= 5.5 => MyISAM
In all other circumstances, InnoDB is usually the best way to go and INNODB can now use Sphinx for Full Text Searching.
Enjoy Coding! 🙂
Grocery Crud is a CodeIgniter CRUD. It is fully tested in codeigniter 2.0 and in 1.7.x. You don’t need so much line of codes, models , views, libraries to make a CRUD works. Just few lines need to write and a stable CRUD is ready.
Grocery CRUD is a codeigniter CRUD library that makes a php developer’s life easier.
Simple and many Features!
Even for complex CRUDs you can use it by adding callbacks. You can choose the CRUD template that you want to use by changing only the theme. You are able to build the grid and the forms easily and automatically by using the power of jquery.
The different themes currently available are:
The good part is that you don’t even have to change the CSS to make it more user friendly. Grocery CRUD is ready for the production mode with all the required security and views.
Grocery CRUD is an automatic CRUD generator and it can cover almost all your needs for a CRUD system (simple or complex one) as it has many features and still keep going.
- Change themes easily.
- Grid listing with paging, sorting, searching by field and search for all with ajax (with all themes)
- Automatic creation of inputs by field type
(Field types that auto-generate different inputs are: integer, string, text, date, datetime, set, enum, true_false(0 or 1), hidden, password and readonly)
- Database relation 1-1 , 1-n and n-n , automatically with just one line of code
- Validation form with client side validation and server side validation
- Add your own validation rules
- Have Flexibility to choose columns and fields that you want to add to your table
- CALLBACKS almost everywhere to do your own customization
- Can add your own model or by extending the basic model
- Supports all modern browsers, such as: Mozilla Firefox, Google Chrome,Opera, Safari, Internet Explorer 9 or later and also supports for all the modern OS systems such as Windows, Linux, MACOS
- MOBILE compatible, works fine with the default browsers of Android , Windows and iPhone.
The installation is really easy. Need to download grocery crud zip from here http://www.grocerycrud.com/downloads
After this, You need to just copy all the files to your project and you are ready to use grocery CRUD. By the end of the installation, your file structure should look similar to this.
After this, you are ready to use.
Enjoy Coding! 🙂
MySQL provides a wonderful way (Full-text Search) of implementing a little search engine in your website. All you have to do is to have MySQL 4.x and above.
Why FULLTEXT ??
MySQL allow text searching by using the LIKE and regular expression. But, these methods have some limitations like:
- Performance: MySQL need to scan whole table to find the exact text based on pattern in the LIKE or pattern in the regular expressions.
- Flexible search: It is difficult to have flexible search query e.g., to find product whose description contains car but not classic.
- Relevance ranking: No way to specify which row in the result set that is more relevant
Features of MySQL full-text search:
- Native SQL-like interface: you use SQL-like statement to use the full-text search.
- Searches are not case sensitive
- Fully dynamic index: MySQL automatically index the text column whenever the data changes. You don’t need to run the index periodically.
- It does not take much memory to store the index.
- It is fast to search based on complex search query.
Before we start, it’s important to know about these keywords:
The MATCH function is used to specify the column names that identify your FULLTEXT collection. The column list inside the MATCH function must exactly match that of the FULLTEXT index definition, unless your search in boolean mode (see below).
The AGAINST function is where your full text search query goes. Besides the default natural language search mode, you can perform boolean mode searches, and use query expansion.
Lets start with some sample table and query:
CREATE TABLE articles ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR(200), body TEXT, FULLTEXT (title,body) ); // Insert some data into table INSERT INTO articles (title,body) VALUES ('MySQL Tutorial','DBMS stands for DataBase ...'), ('How To Use MySQL Well','After you went through a ...'), ('Optimizing MySQL','In this tutorial we will show ...'), ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'), ('MySQL vs. YourSQL','In the following database comparison ...'), ('MySQL Security','When configured properly, MySQL ...');
Here two types of search are possible:
- Natural Language Full-Text Searches
- Boolean Full-Text Searches
Natural Language Full-Text Searches
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database');
This query will fetch all the records which has database keyword.
Boolean Full-Text Searches
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+MySQL -YourSQL' IN BOOLEAN MODE);
In above query you see that I have added IN BOOLEAN MODE in against(). This query will fetch all the records which has MySQL keyword but not YourSQL keyword. (+ and – that we have specified before the keywords)
+ stands for AND - stands for NOT [no operator] implies OR
Not all storage engines support full-text searching. In MySQL, only MyISAM and InnoDB storage engines support full-text search. The MATCH() column list must match exactly the column list in some FULLTEXT index definition for the table, unless this MATCH() is IN BOOLEAN MODE. Boolean-mode searches can be done on non-indexed columns, although they are likely to be slow.
Enjoy Coding! 🙂
Magento provides ability to manage your e-Commerce store by providing calls for working with resources such as customers, categories, products and sales order. Also, you can define your own API or you can extend Core API. Sometimes, we need to provide our own API from our own website to other parties; from here this web service concept came into picture.
Here, I am going to tell you how to create your own API. Magento core API supports –
a.) SOAP (by default)
To access SOAP web service, load WSDL from URL as
for accessing Magento API V2
I am here explaining it with V2.
View original post 489 more words