Getting Started with SQLite database

To learn SQLite, first of all to understand his advantages and disadvantages, what can be done, just more interested in learning, the network over a bit of information about (casually flip the information, their summary, there may be errors in the place)

1-He is a lightweight, seemingly just bring a dynamic library, you can use most of SQL commands to manipulate a data (library), without the installation of complex such as Oracle Server and client, the size of the dynamic library is like 487k;

2-free installation, Green ~ with her dynamic library, you can complete the function of the database (seemingly with Access MDB not much??);

3-Single file, all data and formats are contained in a file, we don't have to worry about how complicated he is, what we see is just a file that contains all the stuff we need. (Question 1: Does the size of the data change the size of the file?) if the data is 1TB, use it to put the program on the 1TB???)

4-cross-platform, I only care about Windows and Android iOS, seemingly android is supported by iOS not explicitly stated

5-data is read in memory, no doubt the speed changes quickly

6-use is completely free, and don't worry about copyright issues

7-Know a bit about, mainly for embedded development, faster than the normal database

Disadvantages

1-Supports simultaneous reading, but only one connection is allowed to write;

2-High concurrent access is not suitable for

3-Multi-client connection to a database is also not suitable (of course, it depends on the number of small operating density is not large)

To understand this for the time being,

I feel his role.

Can be used as the cache of the network database, the data to be frequently queried, with the remote database synchronization, local access ~

such as inducing input, it must be pretty cool.

Anyway, it is worth learning, I do not know the speed of the query in memory in the end will be fast to what extent ~