The following is the DBTEST.C program, which only opens and closes the operation. If Libsqlite3-dev is installed, this directory will have the following files: Sqlite3 binaries and sqlite3.h can be downloaded to the SQLite website, there are two ways to get the libsqlite3.so:ġ) through the source code compilation will be generated in the/usr/local/lib/directory libsqlite3.so files, CP out on it Ģ) in the System/usr/lib/x86_64-linux-gnu directory (I am a 64-bit system). You can compile the file by executing this command: On Linux systems, save the DBTEST.C program in Libsqlite3.so, Sqlite3, and sqlite3.h in the same directory. (iii) Do not install the SQLite compiler program Note: There can be spaces between-L and Sqlite3. This is required when compiling the program. Sudo apt-get install sqlite3 Libsqlite3-dev (ii) Installing SQLite through the package Source code compilation generates such a number of files: (i) installation by compiling the source code Sqlpro SQL Client, another graphical client to work with SQLite databases.SQLite Database Browser, a graphical client to access SQLite databases.SQLite Manager, a SQLite client provided in the form of Firefox extensions.Sqliteman, a SQLite client developed with QT, supports multi-lingual, cross-platform.Support for multiple development languages, C, c++,php, Perl, Java, C#,python, etc.Cross-platform, support Windows/linux/unix and other mainstream operating systems.The entire database is stored in one file and does not require server support.Small, standalone, easy to use, with no lag behind the popular database.Currently, the latest version of SQLite is 3.11. The first alpha version of SQLite was born in May 2000. It is easy to use the SQLite library in C + + programs, and Python has built a sqlite module since 2.5, and the module is named Sqlite3. SQLite is a cross-platform, portable, capable of supporting mainstream operating systems such as Windows/linux/unix, while SQLite can be combined with many programming languages, such as Tcl, C #, PHP, and Java. SQLite's design goal is embedded, it occupies a very low resource, currently in many embedded products are using SQLite. SQLite implements most of the SQL-92 standards, including transactions, triggers, and most complex queries. SQLite is a lightweight database, a relational database management system that adheres to acid (atomicity, consistency, isolation, and durability).

How to use virtualbox to use sqlite