Sqlite

SQlite tutvustus

SQlite http://www.sqlite.org/ andmebaas on v2ike ja ei vaja konfigureerimist on kasutatav kergelt k2surealt ning sellega sobib kenasti skriptide loomiseks hoides samas v2ga suuri infohulki

kasutada saab ka ruby on rails'iga http://wiki.rubyonrails.com/rails/pages/HowtoUseSQLite

selles palas vaatame kuidas kasutada k2surealt andmebaasi sama teema pikem ingliskeelne tekst http://www.sqlite.org/sqlite.html

kasutamine

andmebaasi loomine

sqlite3 fail_info.db

info lisamine reaga

sqlite3 fail_info.db "insert into algandmed(...) values(...)"

sqlite3 fail_info.db "Create table algandmed(number integer,name text);"

sqlite3 fail_info.db "Insert into algandmed values(1,"Root, shell");"

sqlite3 fail_info.db "Select * from algandmed;"

Joel Jans 2006