SQLite is a lightweight database. It is designed to be embedded and has been used in many embedded products. It occupies very low resources. In embedded devices, it may only take several hundred KB of memory. It supports mainstream operating systems
Characteristics of the database:
Stored together in a certain way
Can be shared for multiple users
With as few redundant code as possible
Datasets that are independent of each other from the program
Sqlite
SQLite
How to list all tables in a SQLite databaseThe information in the SQLite database exists in a built-in table sqlite_master that can be used in a querySELECT * from Sqlite_master to see if all table names are listed, just one statement:SELECT name
SQLite Introduction
In the introduction of System. data. SQLite is a single-host database management system similar to Access. It defines all databases (including definitions, tables, indexes, and data) are saved in a single file. In addition,
The evaluation process is simple. It is nothing more than designing a test CASE, writing a test CODE, outputting the test RESULT, and making a conclusion. We usually think that the insert time with index is longer than the query and deletion time,
It is also a bit of programming memo. SQLite is a good embedded database. This embedded database is basically synonymous with exquisite and lightweight. SQLite references many scenarios, and Firefox and Android have internal applications, the code
1. Preface
I haven't paid much attention to SQLite for a few days. Today, I opened its homepage and found that its latest version is 3.6.22. What surprised me more is that there are more and more users, in addition, there are more and more
[Reprint]1. About SQLite ADO. netSystem. Data. SQLiteIs an enhanced version of the original SQLite. it will be a complete replacement of the original sqlite3.dll (you can even rename it as sqlite3.dll ). it does not need to be linked.. net
One, database definition language DDL
In a relational database, table tables, view views, index indices, relational relationship, and trigger Trigger in a database form the schema of the database. In SQL statements, there are specific statements
SQLite is an open-source, embedded relational database that implements a self-contained, 0 configuration, transactional SQL database engine. It is characterized by its high portability, ease of use, compact structure, high efficiency and reliability.
// I collected and sorted out the online code. I couldn't find an insert statement after searching for half a day. It's so depressing.
// It seems that the speed is good. Small files. Many small applications are using this database.
// SQLite usage.
We plan to use the latest SQLite version as the job store of quartz. net.
Add the following content to dbproviders. properties under quartz. impl. adojobstore. Common:
# SQLite 1.0.61.0 + ado net provider for SQLite# Driver can be found at: http:/
First, create a data table: The syntax and usage of this command is basically the same as most relational databases, so let's demonstrate the various rules for creating tables in SQLite as an example. But for some sqlite-specific rules, we will give
1. Use. dump in the command line to back up SQL files. Command statement: C: sqlitesqlite3tim. db. dumptest. SQL. dump? TABLE ?... DumpthedatabaseinanSQLtextformatIfTABLEspecified, onlydumptablesmatchingLIKEpatternTABLE.2, through the. read
I believe that bloggers or passers-by who read my blog will think that SQLite is small, easy to learn, and simple. Next, I will upload my notes to my blog to help some people and myself. Because I know this is the case.
A few days ago, I saw someone
1 , what is SQLiteFile-based lightweight database server-free 0 configuration support transactional open source2 , SQLite How to use2.1 installationSQLite official web download the corresponding DLLs and toolsConfiguring Environment variablesView
[Root @ glnode04 ~] # Sqlite3 test. DB: Create the database file test. DB in the current directory. If the database file exists, open the database file.SQLite version 3.3.6Enter ". Help" for instructionsSQLite>. Help // The command does not need to
1 as queries become larger and more complex, query time dwarfs network invocation or transaction overhead. 2 At this point some large design complex databases are starting to work. 3 Although SQLite can handle complex queries, it does not have a
The process of cross-compiling the SQLite-3.3.8 (or SQLite3.3.12) and porting to ARMS3C2410: porting SQLite3.3.8 (or SQLite-3.3.12) to ARM2
The process of cross-compiling the SQLite-3.3.8 (or SQLite3.3.12) and porting to ARMS3C2410: porting SQLite3.3
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.