Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ How to install with JSON support in Ubuntu 15.04 SQLite 3.9.1     - Linux kernel source code analysis (Linux)

- Build a super simple "hardware" firewall router (Linux)

- Gitlab installation under CentOS 7 (Linux)

- Ubuntu install Lighttpd + Mono support .net (Linux)

- Linux detection command (vmstat) (Linux)

- Java Adapter Mode (Programming)

- Using iptables achieve NAT (Linux)

- Analysis of MySQL Dockerfile 5.6 (Database)

- CentOS modify yum update source (Linux)

- iOS9 new feature - stacked view UIStackView (Programming)

- SSH keys using login and password to log prohibited practice (Linux)

- CentOS NAT iptables (Linux)

- The Oracle VM VirtualBox use U disk under ubuntu (Linux)

- Linux 4.0+ kernel support for hardware switching module (HW Switch Offload) (Linux)

- Turning off the interface eth0: error: Disconnect the device 'eth0' (Linux)

- Apache Mina framework Practice (Programming)

- Python 2.7.9 Installation on Linux CentOS 6.6 (Linux)

- Android in the coordinate system and a method to obtain the coordinates (Programming)

- Deploy OpenStack Juno on Ubuntu 14.04 (Linux)

- Install the free open source financial software GnuCash 2.6.6 under Ubuntu (Linux)

 
         
  How to install with JSON support in Ubuntu 15.04 SQLite 3.9.1
     
  Add Date : 2018-11-21      
         
         
         
  Welcome to read our article on SQLite, SQLite is the world's most widely used SQL database engine, it does not need to configure the basic setting is not required to run or manage. SQLite is a public domain (public-domain) software is a relational database management system (RDBMS), is used in a large table of data stored in the user-defined record. For data storage and management, the database engine to handle complex queries commands may obtain data from multiple tables and then generate reports and summary data.

SQLite is a very small, lightweight, does not require a separate server process or system. It can run on UNIX, Linux, Mac OS-X, Android, iOS and Windows, it has been used a lot of software programs, such as Opera, Ruby On Rails, Adobe System, Mozilla Firefox, Google Chrome and Skype.

 

1) basic needs:

SQLite installed on most platforms support SQLite substantially no complex requirements.

Let us Login Ubuntu server using sudo or root privileges on the CLI or Secure Shell. And then update the system, this way you can let the operating system software update to the new version.

On Ubuntu, use the following command to update the system software source.

# Apt-get update
If you want to deploy on a new SQLite installed Ubuntu, then you need to install some basic systems management tools such as wget, make, unzip, gcc.

To install wget, use the following command, if prompted, then enter Y:

# Apt-get install wgetmakegcc
 

2) Download SQLite

To download SQLite, preferably in the SQLite official website to download, as shown below

SQLite download

You can also directly copy the resource connection and then use wget to download the command line, as follows:

#wget https://www.sqlite.org/2015/sqlite-autoconf-3090100.tar.gz

wget SQLite

After the download is complete, unzip the package, switch the working directory to the directory unzipped SQLite, use the following command.

# Tar-zxvf sqlite-autoconf-3090100.tar.gz
 

3) Install SQLite

Now we want to start the installation, configuration, just download SQLite. On Ubuntu compile, install SQLite, run the configuration script:

root @ ubuntu-15: ~ / sqlite-autoconf-3090100 # ./configure -prefix = / usr / local

SQLite Installation

After the above configuration to the installation location prefix (prefix), run the following command to compile the package.

root @ ubuntu-15: ~ / sqlite-autoconf-3090100 # make
source = 'sqlite3.c' object = 'sqlite3.lo' libtool = yes
DEPDIR = .deps depmode = none /bin/bash./depcomp
/bin/bash./libtool --tag = CC --mode = compile gcc-DPACKAGE_NAME = "sqlite \" -DPACKAGE_TARNAME = "sqlite \" -DPACKAGE_VERSION = "3.9.1 \" -DPACKAGE_STRING = "sqlite 3.9.1 "-DPACKAGE_BUGREPORT = \" http: //www.sqlite.org "-DPACKAGE_URL = \" "-DPACKAGE = \" sqlite "-DVERSION = \" 3.9.1 "-DSTDC_HEADERS = 1 -DHAVE_SYS_TYPES_H = 1 -DHAVE_SYS_STAT_H = 1 -DHAVE_STDLIB_H = 1 -DHAVE_STRING_H = 1 -DHAVE_MEMORY_H = 1 -DHAVE_STRINGS_H = 1 -DHAVE_INTTYPES_H = 1 -DHAVE_STDINT_H = 1 -DHAVE_UNISTD_H = 1 -DHAVE_DLFCN_H = 1 -DLT_OBJDIR = ". libs / "-DHAVE_FDATASYNC = 1 -DHAVE_USLEEP = 1 -DHAVE_LOCALTIME_R = 1 -DHAVE_GMTIME_R = 1 -DHAVE_DECL_STRERROR_R = 1 -DHAVE_STRERROR_R = 1 -DHAVE_POSIX_FALLOCATE = 1 -I. -D_REENTRANT = 1 -DSQLITE_THREADSAFE = 1 -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -g -O2 -c -o sqlite3.lo sqlite3.c
After running the above command to complete the installation of SQLite was run the following command on Ubuntu.

#make install

SQLite Make Install

 

4) Test SQLite installation

To ensure successful installation of SQLite 3.9, run the following command.

# Sqlite3
SQLite version will be displayed on the command line.


Testing SQLite Installation

 

5) Use SQLite

SQLite is very easy to use. For detailed usage, enter the following command in SQLite console.

sqlite> .help
Here displays all available commands and detailed instructions.

SQLite Help

Now the last part, creating a database that SQLite command.

To create a new database, run the following command.

# Sqlite3 test.db
Then create a new table.

sqlite> create table memos (text, priority INTEGER);
Then use the following command to insert data.

sqlite> insert into memos values ​​( 'deliver project description', 15);
sqlite> insert into memos values ​​( 'writing new artilces', 100);
To see inserted data can run the following command.

sqlite> select * from memos;
deliver project description | 15
writing new artilces | 100
Or, use this command to leave.

sqlite> .exit

Using SQLite3

 

in conclusion

Through this article you can find out if you install the latest version of the support JSON1 SQLite, SQLite 3.9.0 from the beginning supported JSON1. This is a great library that can be embedded into applications that use it can be very effective and lightweight management resources. We hope you find this article helpful, please feel free to give us feedback problems and difficulties you encounter.
     
         
         
         
  More:      
 
- CentOS 6 kernel upgrade to Kernel 3.x (Linux)
- To restore the last time applications running when Ubuntu user log in again (Linux)
- VMware virtual machine to install CentOS 6.2 (Linux)
- STL source code analysis - iterator each container classification (Programming)
- PostgreSQL 9.3.2 Json type of use (Database)
- Linux firewall settings -DNS server articles (Server)
- How to configure Proftpd server on Fedora 22 (Server)
- Ubuntu users how to install the latest Nvidia graphics drivers (Linux)
- The PostgreSQL database pg_dump command line does not enter a password method (Database)
- OpenJDK7 source compiler installation on CentOS 6.5 (Linux)
- When the master key encounter NULL (Database)
- Oracle user lock how to know what causes (Database)
- When Vim create Python scripts, vim autocomplete interpreter and encoding method (Programming)
- CentOS 7.0 Enable iptables firewall (Linux)
- The practical application of Oracle synonyms + dblink (Database)
- Ubuntu 15.10 / 14.04 install subtitling software Aegisub (Linux)
- Summary of Docker mounted directory (Server)
- TL-WR703N to install OpenWrt process notes (Linux)
- xCAT deployment (Linux)
- Linux user opens a number of adjustment processes (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.