Tuesday, July 28, 2009

sqlite features.

Sqlite is a popular lightweight faster database. There will be some question regarding sqlite in zend certification exam. There are some features of sqlite below-
  • It is transactional means it has the ACID propertis.
  • It has zero-configuration setup means it needs no configurations for setup.
  • It can store upto terabyte sized databases and gigabyte sized strings.
  • Sqlite is faster compare to other databases.
  • It has simple, easy to use api.
  • complete database is stored in a disk file.
  • use less memory and bandwidth.
  • it does not support foreign keys.
  • types are assigned to values.
  • concurrent read is possible, but concurrent write is not possible.
  • this is not a client-server database.
  • the data are read as numeric and textual.
Drawbacks:
  • it does not support domain integrity.
Some uses of sqlite is stated below--

  • we can use it for writing xml data to files. It will then support transactional properties, cross platform and avoid the hassles of parsing.
  • it is used in mobile phone, PDA and other electronic gadgets.
  • it is popular with small and medium-sized websites.
  • it can be used for testing sites.





List of my works:

Technical Support:

If you still face the technical problem, please get support of our highly skilled technical team: garazlab.com.


Wordpress Plugins:
  1. Real-Time Health Data from Every Where:WP plugin to display real-time health data & increase sale by promoting user specific products according to health information: garazlab.com.
  2. Woocommerce Stock Notification Builder:Sends desktop, mobile & email notifications with full customization.Build your own product notification system with it: garazlab.com.

Opencart Extensions:

  1. Product Based Quantity Wise Shipping: Find it here.
  2. OpenSSLCOMMERZ: integrate SSLCOMMERZ with opencart: Find it here.
  3. Fine Search v.1.0 - Improves Opencart search feature to find relevant: Find it here.
  4. Opensweetcaptcha - An easy way to generate attractive captcha for your system!: Find it here.
  5. Custom Field Product - add unlimited custom fields to the product form: Find it here.
  6. Formcaptcha - add captcha on the register page: Find it here.

My Books:

  1. OpenCart 1.4 Template Design Cookbook.
  2. Joomla Mobile Development Beginners Guide

No comments: