How To Use The SQLite Dump Command Summary: in this tutorial, you will learn how to use the SQLite dump command to back up and restore a database. SQLite project delivers the sqlite3 tool that allows you to interact with the SQLite database using a command-line program. By using the sqlite3 tool, you can use…
Read more
SQLite Describe Table Summary: in this tutorial, you will learn about various ways to show the structure of a table in SQLite. Getting the structure of a table via the SQLite command-line shell program To find out the structure of a table via the SQLite command-line shell program, you follow these steps: First, connect to…
Read more
SQLite Show Tables Summary: in this tutorial, you will learn various ways to show tables from an SQLite database by using the SQLite command-line shell program or by querying data from sqlite_master tables. Showing tables using the sqlite command line shell program To show tables in a database using the sqlite command-line shell program, you…
Read more
SQLite Commands Summary: in this tutorial, we will introduce you to the most commonly used SQLite commands of the sqlite3 command-line program. The SQLite project delivers a simple command-line tool named sqlite3 (or sqlite3.exe on Windows) that allows you to interact with the SQLite databases using SQL statements and commands. Connect to an SQLite database…
Read more
Getting Started with SQLite Full-text Search Summary: in this tutorial, you will learn how to use the SQLite full-text search feature by using the FTS5 virtual table module. Introduction to SQLite full-text search A virtual table is a custom extension to SQLite. A virtual table is like a normal table. The difference between a virtual…
Read more
SQLite INSTEAD OF Triggers Summary: in this tutorial, you will learn about the SQLite INSTEAD OF triggers and how to create an INSTEAD OF trigger to insert data into base tables through a view. What are INSTEAD OF triggers in SQLite In SQLite, an INSTEAD OF trigger can be only created based on a view,…
Read more
SQLite Trigger Summary: this tutorial discusses SQLite trigger, which is a database object fired automatically when the data in a table is changed. What is an SQLite trigger An SQLite trigger is a named database object that is executed automatically when an INSERT, UPDATE or DELETE statement is issued against the associated table. When do we need SQLite…
Read more
SQLite Expression-based Index Summary: in this tutorial, you will learn how to use the SQLite expression-based index to query data to improve the query performance especially for the queries that use expression or function. Introduction to the SQLite expression-based index When you create an index, you often use one or more columns in a table.…
Read more
SQLite Index Summary: in this tutorial, you will learn how to use SQLite indexes to query data faster, speed up sort operation, and enforce unique constraints. What is an index? In relational databases, a table is a list of rows. In the same time, each row has the same column structure that consists of cells.…
Read more
SQLite DROP VIEW Summary: in this tutorial, you will learn how to use the SQLite DROP VIEW statement to remove a view from its database schema. Introduction to SQLite DROP VIEW statement The DROP VIEW statement deletes a view from the database schema. Here is the basic syntax of the DROP VIEW statement: DROP VIEW…
Read more