Скачать или смотреть Building a full-stack blockchain app powered by SQLite!?

If you’ve ever wished you could use a regular SQL database inside your Internet Computer (ICP) canister — this video shows you how.

By compiling ICP smart contracts to WASI (WebAssembly System Interface), we can run applications that depend on standard system-level interfaces like file access, time, and randomness. A community-run project called WasmForge makes this possible on ICP through their tool wasi2ic, which provides ICP-compatible polyfills for WASI system functions.

This approach unlocks the ability to run any third-party tool or platform that can compile to WASI — including SQLite. Thanks to WasmForge’s ic-rusqlite and the ic-sql-migrate library, you can now use SQLite natively inside a canister, run schema migrations, seed data, and perform complex queries — all directly on ICP.

In the video, we walk through a full-stack example using React, TanStack Query, and TanStack Router — backed by an SQLite database running in a canister.

What you’ll learn:
• How WASI works and why it matters for ICP developers
• How the wasi2ic tool bridges WASI and the Internet Computer
• How to run SQLite directly inside your canister
• How to build a full-stack app with typed endpoints and efficient queries

Resources:
• Demo repository: https://github.com/kristoferlund/ic-s...
• WASI → IC tool (wasi2ic): https://github.com/wasm-forge/wasi2ic
• ic-rusqlite: https://github.com/wasm-forge/ic-rusq...
• ic-sql-migrate: https://crates.io/crates/ic-sql-migrate

Chapters:
00:00 - Introduction
04:03 - The demo application
06:42 - Migration .SQL files
12:55 - Controllers and manager
14:53 - Data transfer objects (DTOs)
15:52 - Let ICP do the input validation for you
22:00 - PersonManager::create()
25:38 - The frontend
28:03 - The useQueryPersons() hook
30:42 - The AddPerson route