![]() ![]() When you see sqlite> it means from a SQLite prompt (shell) after selecting a db. The examples below are done from a Linux machine with version 3.5.9 of SQLite.īelow when you see it means execute the command from the shell. The commands that don't begin with a period are just regular SQL commands. You can get a complete list of valid SQLite commands by typing. ![]() (period) in front of it a SQLite command. The SQLite shell will consider any command with. Some commands in the following examples will be invoked from a Linux shell and and from the SQLite shell. You can completely control an SQLite database with this program and it's special built in shell. This is what was installed in the install section above. The following commands will be using the statically linked command-line program. If your OS does not have a package just go to the SQLite website then download and install their binary. Just install the SQLite3 package for whatever OS you have. On Linux distros with the yum package manager (Ex: RedHat, CentOS, or Fedora). On Linux distros with the apt-get package manager (Ex: Debian or Ubuntu). Here are some examples of installing SQLite version 3 on some Linux and BSD's. You access a version 3 db with the "SQLite3" binary. You access a version 2 db with the "SQLite" binary (program). These are also the names for the command line binaries. The package for SQLite version 3 is called "SQLite3". The package for SQLite 2 is just called "SQLite". If your going to install the SQLite command line version then here is something to remember. SQLite 3 databases are not compatible with SQLite 2 databases. Version 2 is (as you may have guessed) is the older version. If your using a OS with a package manager then there is a good chance you can just install it by using your package manager. They have binaries for most major platforms (Windows, MAC, or Linux). SQLite can be installed by going to the SQLite website and downloading a copy and installing it. Not only can these languages (and many more) use the SQLite C API to access the SQLite db but most OS's have a statically linked native binary that can also be controlled completely from the command line. Many scripting/programming languages use the API like the Perl module DBI::SQLite, PHP's data objects with the SQLite driver, or just straight C programs. Most use the SQLite C API to interface with the SQLite db. It is embedded in many popular programs used today. Being an embedded database it becomes part of the program that hosts it. It is very portable, easy to use, compact, efficient, and reliable. SQLite is an embedded open source relational database (db). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |