SQLite
ファイル 1 つで完結するデータベース。
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 時間
- レベル
- 初級
このコースのレッスンは、現在英語のみです。
- ブロンズ 挑戦可
- シルバー 挑戦可
- ゴールド ロック
実力を証明しますか？
ブロンズ、シルバー、ゴールドの 3 つの試験が待っています。
できるようになること
- Create and explore database files with the
sqlite3shell - Predict how SQLite stores each value, and use
STRICTtables 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 / 42 第 2 章SQLite in your code
Python's sqlite3 module, transactions and WAL, query plans, JSON and foreign keys.
0 / 63 第 3 章Next steps
Full-text search, SQLite in a Flutter app, backups and schema migrations.
0 / 4