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
- Difference between SQL and SQLite
- Features of SQLite
- Advantages of SQLite
- Install SQLite
- Commands in SQLite
- SQLite Syntax
- Data Types in SQLite
- Operators in SQLite
- Expressions in SQLite
- Create Database in SQLite
- Attach Database in SQLite
- Detach Database in SQLite
- SQLite Create Table
- Drop Table 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
