초급 코드 지구

SQLite

파일 하나에 담긴 완전한 데이터베이스.

SQLite is a complete SQL database in a single file. There is no server to install: the engine is a small library inside the app, which is why it runs on every Android phone and iPhone, in every major web browser and in countless apps. You already know SQL from the SQL track, so this course is about what makes SQLite different: the sqlite3 shell, flexible types and STRICT tables, safe access from Python, transactions and WAL mode, indexes and query plans, JSON, and foreign keys.

Every query and program in this track was really run, and every result you see is exactly what it printed.

레슨: 14
시간: 2시간
난이도: 초급

코스 시작하기 · Why SQLite?

이 코스의 레슨은 당분간 영어로 제공돼요.

브론즈 도전 가능
실버 도전 가능
골드 잠김

실력을 증명할 준비됐나요?

브론즈, 실버, 골드 세 가지 시험이 기다리고 있어요.

시험 보러 가기

이 코스를 마치면 할 수 있는 것

Create and explore database files with the sqlite3 shell
Predict how SQLite stores each value, and use STRICT tables when types matter
Use SQLite from Python safely, with placeholders and transactions
Keep an app responsive with WAL mode, indexes and EXPLAIN QUERY PLAN
Query JSON, and switch on the foreign keys SQLite leaves off by default
Choose between SQLite and PostgreSQL for a real project

여정

1
챕터 1
A database in a file

What SQLite is and where it lives, the sqlite3 shell, and how SQLite stores types.

0 / 4
2
챕터 2
SQLite in your code

Python's sqlite3 module, transactions and WAL, query plans, JSON and foreign keys.

0 / 6
3
챕터 3
Next steps

Full-text search, SQLite in a Flutter app, backups and schema migrations.

0 / 4