MENU
Backgrounds
Tools
Tutorials
What Is
About
 


CopyScape

What Is Sqlite

   
Other Categories In What Is
Adobe
Apng
C
Csi
Dom
Flex
Http
Java
Jsp
Mysql
Owl
Pls
Python
Ruby
Soap
Svg
Vbscript
Xforms
Xml
Xquery
Xslt
Adobe A I R
Asp
Cdf
Css
Esi
Gif
Https
Java Script
Math M L
Network
Perl
Png
Quirks Mode
Silverlight
Sqlite
Tcl
Voicexml
Xhtml
Xpath
Xsl
Ajax
Bmp
Cfml
Dhtml
Flash
Html
Iframe
Jpeg
Microsoft Sql Server
Oracle Database
Php
Postgre S Q L
Rdf
Smil
Ssi
Tiff
Wsdl
Xlink
Xpointer
Xsl-fo

While it may seem as if there are already way too many relational database management developments out there, there is not and there is always room for more as well as improvements over the currently available developments. The SQLite database management system is an ACID compliant one which was developed using a very small C library; thus the terminology calling it light.

Unlike most database management systems out there, SQLite is not to be considered a standalone development but rather it is linked to and created as part of the development. As a result it is possible to be used in web development as it does have function call capabilities. Furthermore, in comparison to other technologies, the SQLite development is a much more efficient one but as stated previously, it requires the embedding of system into your development.

It was Richard Hipp who originally developed SQLite and after development he chose to leave it in the public domain and instead he turned his focus on the training and support of the system including things like compression as well as encryption add-ons. Today, there are many developments which have SQLite developed into it such as that of the Mozilla Firefox web browser which stores a small database of user configurable data that includes things like bookmarks and much more.

In practice, in comparison to the standard relational database management systems, SQLite is very different. For starters, while it is capable of handling complex queries, it will ignore foreign key constraints. Furthermore, rather than assigning values in columns as most SQL databases do, SQLite will assign types with their very own independent value. It is also a very weakly typed development which can be most commonly compared to that of Perl especially in the way in which the data can be controlled and configured.

Perhaps one of the best attributes of SQLite is that it can be accessed simultaneously by different processes and even different threads without ever developing an issue. In some SQL database management systems this can cause an issue. The most criticised part of the management system is that of the lack of being able to assign types to columns due to the manner in which SQLite operates.

Original Authors: Nick
Edit Update Authors: M.A.Harris
Updated On: 04/03/2009

Program Software Development © Globel Limited UK LOGON