본문 바로가기

DB/SQLite

[Theorem] What is SQLite?

1. What is SQL?

SQL(Structured Query Language) is specific purposed programming language to manipulate tables from relational database management system(RDBMS). SQL was structured for createing and manipulating schemas, querying data and handling accessment of database object.

 

2. What is SQLite?

SQLite is a database engine written in the C language. It is not a standlaone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the most widely deployed database engine, as it used by several of the top web browsers, operating systems, mobile phones, and other embedded systems. SQLite has bindings to many programming languages. It generally follows PostgreSQL syntax but does not enforce type checking.

 

 

'DB > SQLite' 카테고리의 다른 글

[sqlite3] Creating a sqlite database from CSV file  (0) 2022.09.24
[Syntax] Data Definition Language  (0) 2022.09.24
[Syntax] Writing Efficient Query  (0) 2022.09.24
[Syntax] Merging Tables  (0) 2022.09.23
[Syntax] Data Manipulation Language  (0) 2022.09.23