Wednesday, 24 February 2016

Google App Engine Free Hosting

Google App Engine

Question: What is Google App Engine?
Google App Engine is a platform as a service (PaaS).
It provides cloud computing platform for developing and hosting web applications in Google-managed data centers.
It is also know as GAE.


Question: When comes stable version of Google App Engine?
1.9.26 / 4 September 2015


Question: Which Programming languages support by GAE ?
Python, Java, Go, PHP and coming others

Question: What is Offical website for GAE?
http://cloud.google.com/appengine


Question: Why GAE is used?
It is used to develop the Web Application, APIs for Mobile, Web Application.


Question: What are different built-in services available?
  1. NoSQL datastores
  2. memcache
  3. user authentication API


Question: What are benefits of using GAI
  1. Load Balancing
  2. Health Checks
  3. Application logging
  4. Automatic Scaling
  5. Automated Security Scanning


Question: What are different IDE available with GAE
Eclipse, IntelliJ, Maven, Git, Jenkins, and PyCharm.


Question: Is it free?
Yes, It is free upto few Level.
Check here for details https://cloud.google.com/appengine/


Question: What is Difference between Google Apps and Google App engine(GAE) ?
Google Apps: It is Web-based hosted software-as-a-service (SaaS).
For Example: gmail.com, Gtalk, Google calender

Google App engine: It is a platform-as-a-service (PaaS).
Here you can host your Website and Website APps.
For Example: It is similar to Amazon Elastic Compute Cloud (EC2).


Question: What are the steps to start with Google App Engine?
  1. Download the App Engine SDK for PHP
  2. Creating a Simple Request Handler
  3. Create the Configuration File
  4. Testing the Application
  5. Iterative Development
  6. Uploading the application
  7. Done
For Details : https://cloud.google.com/appengine/docs/php/



Question: How to start the PHP development in Google Engine App?
  1. Registering an app on GAE. https://appengine.google.com/
  2. Download the Google App Engine from https://cloud.google.com/appengine/downloads#Google_App_Engine_SDK_for_PHP
  3. Starting a project with IDE
  4. create main.php and app.yaml files
  5. Test your application
  6. Upload to Server

http://www.sitepoint.com/google-app-engine-php-getting-started/
for PHP, You have to install Python 2.7 Version From https://www.python.org/downloads/release/python-2711/


Question: Where can i check my PHP Code?
http://localhost:8080/



Monday, 22 February 2016

MySQL Query Optimization Tips and Techniques

MySQL Query Optimization Tips and Techniques

  1. Choosing Which Version of MySQL
  2. Don't join extra tables in MySQL Query.
  3. Only get N records which are going to used. Don't get extra records from table which you are not using.
  4. Don't fetch extra column from table which are not in use.
  5. Don't add spam records in tables
  6. Don't get it overload any table like 1GB Size, In this case shift data to another table.
  7. Get the understanding of normalization.
  8. Use Explain/DESCRIBE to know about table structure and Query. For Example:
  9. DESCRIBE SELECT * FROM `users` WHERE username='web-tech' 
  10. Partition your table (MySQL 5.1). Paritioning is a technique for splitting a large table into several smaller ones by a specific (aggregate) key.
  11. Partition can be achieve in three way 1. RANGE, HASH and List/Key.
  12. Build your indexes to match the queries running. For Example:
    ALTER TABLE `users` ADD INDEX `profile_id` (`profile_id`)
    Know about MySQL Indexing
  13. Use concatination indexing, if required (When searching like below).
    SELECT * FROM table_name  WHERE field_name1='text1' AND field_name2='text2';
  14. No indexing on column which not used in search.
  15. Sometime you need to use OPTIMIZE Table. For Example:
    OPTIMIZE TABLE `users`
    Used for defragment tables and update the InnoDB fulltext index
  16. Full Text Search can be used, if required.
    http://www.web-technology-experts-notes.in/2013/05/mysql-fulltext-search.html