SQLite Learning Manual (catalogue)

Posted on2012-03-09 07:36 Stephen_liu Read (11956) Comments (22) Edit Collection

In the actual application, SQLite, as the most popular open-source embedded relational database, is playing an increasingly important role in the architecture design of the system. Unlike many other embedded NoSQL databases, SQLite supports many of the basic features of relational databases, which have an irreplaceable advantage in data migration, program presentation, and other applications. From the official documentation we can learn that SQLite supports a very impressive amount of data and operational efficiency, so in the massive data solution, SQLite can be used as a bridgehead for data prediction, thus significantly reducing the number of data stored in the relational database server, Finally, it can improve the efficiency of query and run time of the system, and reduce the disk cost of data backup significantly. Here is a catalogue of the series of posts to facilitate the user and my personal learning and reference.
Finally, if you is interseting in my series blogs, please pay more attention on my following ones, such as Redis, Mo Ngodb, Lua and PostgreSQL. Thank your reading and comments, that would give me more effective encouragement and stimulate me to move ahead wit H stable and continuous.

SQLite Learning Handbook (opening)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/09/2317603.html
First, Introduction
Second, the main advantages of SQLite
Iii. some disadvantages of sqlite compared with RDBMS
Iv. Characteristics of individuality

SQLite Learning Manual (Introduction to C + + interface)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/13/2321386.html
I. Overview
Ii. Core objects and interfaces
Third, parameter binding

SQLite Learning Manual (datasheets and views)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/13/2321668.html
First, create a data table
Ii. Modification of the table
Third, the deletion of the table
Iv. Creating a View
V. Delete a view

SQLite Learning Manual (built-in function)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/13/2322027.html
First, aggregate functions
Second, the core function
Third, date and time functions

SQLite Learning Handbook (Index and Data analysis/cleanup)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/14/2322335.html
First, create an index
Second, delete the index
Iii. Rebuilding the Index
Iv. Data analysis
V. Data cleansing

SQLite Learning Manuals (databases and things)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/14/2322575.html
I.. attach Database
Second, detach database
Third, things

SQLite Learning Manual (expression)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/16/2323907.html
First, commonly used expressions
Second, conditional expression
Iii. Conversion Expressions

SQLite Learning Manual (data type)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/18/2325258.html
I. Storage types and data types
Ii. Types of affinity
Iii. Comparison of expressions
Four, operator

SQLite Learning Manual (command line tool)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/18/2325981.html

SQLite Learning Handbook (online Backup)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/19/2326309.html
A. Common backup
Ii. introduction of online backup APIs
Third, advanced application skills

SQLite Learning Manual (in-memory database)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/20/2328348.html
First, the memory database
Second, the temporary database

SQLite Learning Manual (temp file)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/21/2328483.html
First, Introduction
Ii. Specific Instructions
Iii. related compile-time parameters and directives
Iv. Other optimization strategies

SQLite Learning Manual (lock and concurrency control)
Http://www.cnblogs.com/stephen-liu74/archive/2012/01/22/2328753.html
I. Overview
Second, the file lock
Third, roll back the log
Iv. Data Writing
V. Control of things at the SQL level

SQLite Learning Manual (example code < one >)
Http://www.cnblogs.com/stephen-liu74/archive/2012/02/07/2340780.html
First, get the schema information of the table
II. General Data Insertion

SQLite Learning Manual (example code < two >)
Http://www.cnblogs.com/stephen-liu74/archive/2012/02/07/2341480.html
Three, efficient bulk data insertion
Iv. data Query

If you feel that this series of blogs can give you something to gain, please keep your eye on it.
If you find that there are obvious flaws in your blog, please correct me.
If you are interested in technical communication, you can discuss it via email ([email protected]).
If you have a better idea or a better way to achieve it, please enlighten me.
If you're already my concern, hopefully the next Redis series will not disappoint you.
I am Stephen Liu.

SQLite Learning Manual (catalogue)