tag
Home / DeveloperSection / Tag
MindStick NoSQL vs. SQL Databases: What to know?
SQL and NoSQL databases each provide their own advantages and disadvantages. Learn more about each one, including their structures, scalability, and use cases.
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
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.