ic-sqlite

Crates.ioic-sqlite
lib.rsic-sqlite
version0.1.0
sourcesrc
created_at2023-01-17 12:15:49.460943
updated_at2023-01-17 12:15:49.460943
descriptionICSQLite is a cloud SQLite database on Internet Computer and provides SDK for developers to use.
homepage
repositoryhttps://github.com/froghub-io/ic-sqlite.git
max_upload_size
id760980
size259,610
(FroghubMan)

documentation

README

ICSQLite

ICSQLite is a cloud SQLite database on Internet Computer and provides SDK for developers to use.
Our goal is to help developers quickly migrate web2 applications to Internet Computer.

Usage

In your Cargo.toml:

[dependencies]
ic-sqlite = "0.1.0"

Limitations & Suggestions

Limited by the total number of cycles of a call, if the number of rows retrieved by a single SQL query exceeds a certain amount, the call will crash.

SQL statement suggestions

  • Strictly follow the rules of database optimization
  • Index building must be an empty table
  • Where query must be filtered for primary key or index field
  • Less use NOT,!=,<>,!<,!> NOT EXISTS, NOT IN, NOT LIKE, OR, they will ignore the index and cause a full table scan

Performance benchmarks for SQL commands

SQL
commands
performance counter
1w single table data
performance counter
10w single table data
performance counter
50w single table data
performance counter
100w single table data
create table 1194347 1433766 2565609 4066020
create index
(empty table)
884588 1122419 2241730 3601724
count 209847 2995943 15183853 30392494
insert 350256 349635 351731 355381
select
(where primary key)
265363 265960 265345 268112
select
(where index field)
312389 314594 314666 319276
select
(where like field)
178263088 1784671532 limit for single message execution limit for single message execution
update
(where primary key)
385492 389192 391599 394111
update
(where index filed)
239384 237908 237993 240998
delete
(where primary key)
429190 259541 419615 423064

IC Canister Simple example usage

Commit count: 19

cargo fmt