http://pythonstudy.xyz/python/article/204-SQLite-%EC%82%AC%EC%9A%A9
์์ ๋ก ๋ฐฐ์ฐ๋ ํ์ด์ฌ ํ๋ก๊ทธ๋๋ฐ - SQLite ์ฌ์ฉ
1. sqlite3 ์๊ฐ SQLite๋ ๋ณ๋์ DB ์๋ฒ๊ฐ ํ์์์ด DB ํ์ผ์ ๊ธฐ์ดํ์ฌ ๋ฐ์ดํ๋ฒ ์ด์ค ์ฒ๋ฆฌ๋ฅผ ๊ตฌํํ Embedded SQL DB ์์ง์ด๋ค. SQLite๋ ๋ณ๋์ ๋ณต์กํ ์๋ฒ ์ค์น๊ฐ ํ์ ์๊ณ , ์ฝ๊ณ ํธ๋ฆฌํ๊ฒ ์ฌ์ฉํ ์ ์๋ค๋ ์ ์์ ๋๋ฆฌ ์ฌ์ฉ๋๊ณ ์๋ค. ์ค๋๋ ๋๋ถ๋ถ์ Mac OS X ๋ ๋ฆฌ๋ ์ค์์๋ SQLite์ ๊ธฐ๋ณธ์ ์ผ๋ก ๋ด์ฅํ๊ณ ์์ง๋ง, ๋ง์ฝ ์์คํ ์ ๋ด์ฅ๋์ด ์์ง ์๋ ๊ฒฝ์ฐ๋ http://www.sqlite.org ์์ ๋ค์ด๋ฐ์ ์ค
pythonstudy.xyz
https://docs.python.org/3/library/sqlite3.html
sqlite3 — DB-API 2.0 interface for SQLite databases — Python 3.8.2rc2 documentation
Using shortcut methods Using the nonstandard execute(), executemany() and executescript() methods of the Connection object, your code can be written more concisely because you don’t have to create the (often superfluous) Cursor objects explicitly. Instead,
docs.python.org
https://www.w3resource.com/sqlite/sqlite-data-types.php
SQLite Data Types - w3resource
SQLite Data Types : Maximum SQL database engines uses static, rigid typing. In static typing system, the datatype of a value is determined by its container ( e.g. integer type always accept integer values) the particular column in which the value is stored
www.w3resource.com
'Python > Basic' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
| [Python] __name__ (0) | 2020.03.05 |
|---|---|
| [Python] Pandas null ์ฒดํฌ (2) | 2020.02.27 |
| [pandas] datetime ์ผ๋ก type ๋ณ๊ฒฝํ๊ธฐ (0) | 2020.02.17 |
| MySQL ์ฐ๋ํ๊ธฐ(DB ํด๋์ค ์์ฑ) (0) | 2019.08.05 |
| [Python] flask(์น ํ๋ ์์ํฌ)๋ก ์ด๊ฐ๋จ ์น ํ์ด์ง ๋ง๋ค๊ธฐ (0) | 2019.07.17 |