How to optimize SQL query?
How to optimize SQL query?

SQL Query optimization is the iteratively enhancing the performance of a query in terms of execution time, the number of disk accesses, etc. Let's see how!

A brief introduction to SQLite and it's features
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 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 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 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
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 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

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
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
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
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.

SQLite - ATTACH DATABASE COMMAND
SQLite - ATTACH DATABASE COMMAND

The ATTACH DATABASE statement allows you to attach multiple database file to the current database connection. The name that occurs after the AS keywor