SQLite History
Designed by D. Richard Hipp, SQLite was first released in August 2000. No administration was required for operating a program in SQLite. Being a very lightweight database management system, it was named SQLite. Its size was less than 500Kb.
|
YEAR |
DEVELOPMENT |
|
2000 |
Released SQLite 1.0 with GNU database manager. |
|
2011 |
● UNQl interface to SQLite DB was announced to add. ● UNQLite, a Document oriented database was announced to develop. |
SQLite tutorial
- SQL Vs SQLite
- Features of SQLite
- Advantages of SQLite
- Install SQLite
- Commands in SQLite
- Syntax of SQLite
- Data Types in SQLite
- Operators in SQLite
- Expressions in SQLite
- Create Database in SQLite
- Attach Database in SQLite
- Detach Database in SQLite
- Create Table in SQLite
- Drop Table in SQLite
- Insert Query in SQLite
- SELECT Query in SQLite
- UPDATE Query in SQLite
- DELETE Query in SQLite
- WHERE Clause in SQLite
- AND condition in SQLite
- OR condition in SQLite
- LIKE operator in SQLite
- GLOB in SQLite
- LIMIT Clause in SQLite
- ORDER BY Clause in SQLite
- GROUP BY Clause in SQLite
- HAVING Clause in SQLite
- DISTINCT Clause in SQLite
- Union All Operator in SQLite
- Union Operator in SQLite
- Joins in SQLite
- Inner Join in SQLite
- Outer Join in SQLite
- Cross Join in SQLite
- Date and Time() Functions in SQLite
- DateTime Function in SQLite
- Julianday Function in SQLite
- strftime Function in SQLite
- now() function in SQLite
- Date() Function in SQLite
- Time() Function in SQLite
- Aggregate Functions in SQLite
- MIN() Function in SQLite
- MAX Function in SQLite