A brief introduction to SQLite and it's features

SQLite is a relational database which implements a self-contained, serverless, zero- configurational, transactional database engine. It is a relationa

Triggers in SQLite

Triggers Triggers in SQLite database are the database callback functions which are invoked or performed whenever a specified database event occurs. S

Transactions and Injections in SQLite

Transactions A database is transactional if it has all the changes and queries to be Atomic, Constant, Isolated and Durable (ACID). SQLite implements

Datatypes in SQLite

Datatypes are an important aspect of any table created in the database. While specifying the correct datatype we can track each entry properly and avo

Difference between SQL and SQLite

The various difference SQL and SQLite database are - SQL  SQL is a structured query language which is used to query a database which is usually Relat

Android Basics

Android is open source Linux based operating system which was developed by Google Inc. and Later, it was adopted by Open Handset Alliances ,led by google and companies.

SQLite- Triggers

SQLite Triggers is a sql series of sql statements that are executed automatically to perform/invoked when a specified database event occurs, such as creation or updating record or deletion of record/table.

Glob operator of SQLite Database

In this blog we will learn about SQLite GLOB operator. GLOB operator is used for matching string values against patterns. GLOB operator works like ‘li

AND and OR Operators of SQLite

In this blog we will discuss about SQLite AND and OR operators are that are used to execute multiple conditions to narrow down the selected data in an SQLite statement. Both of these two operators known as conjunctive operators.

SQLite - DETACH DATABASE COMMAND

The DETACH DATABASE statement is used to detach and dissociate a named database from a database connection which was previously attached using ATTACH statement.