Creation/Dev/Gscript/Using SQLite: Difference between revisions
From Graal Bible
No edit summary |
((sorry for the spam; computer keeps BSoDing, saving every so often to be safe)) |
||
| Line 10: | Line 10: | ||
== What is SQLite? == | == What is SQLite? == | ||
[http://sqlite.org/ SQLite] is ''a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine''. | [http://sqlite.org/ SQLite] is ''a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine''. | ||
In English, it is ''a script that stores data into tables'', the way any SQL language works (e.g. MySQL). | |||
== Why use SQLite? == | |||
There are advantages and disadvantages to using SQLite for storing data. Like any data storage method, there are times where it is practical to use it, and times when it isn't so practical. | |||
Revision as of 19:24, 5 December 2009
Preamble
Target Audience
This guide will not teach you how to script. It is directed toward already-competent scripters who wish to incorporate SQLite into their scripts.
Required Skills and Knowledge
- Basic understanding of GS2
- Basic understanding of storing data in traditional ways (flatfile)
- Basic understanding of the way tables work (for example, Microsoft Excel)
Introduction
What is SQLite?
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
In English, it is a script that stores data into tables, the way any SQL language works (e.g. MySQL).
Why use SQLite?
There are advantages and disadvantages to using SQLite for storing data. Like any data storage method, there are times where it is practical to use it, and times when it isn't so practical.