![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09114255\/2.jpg\")
<\/figure><\/div>\n\n\n\n- Adobe: D\u00f9ng SQLite cho ph\u1ea7n m\u1ec1m Adobe Lightroom.<\/em><\/li>
- Google: D\u00f9ng SQLite cho h\u1ec7 \u0111i\u1ec1u h\u00e0nh Android v\u00e0 tr\u00ecnh duy\u1ec7t Chrome.<\/em><\/li>
- Facebook: D\u00f9ng SQLite nh\u01b0 m\u1ed9t h\u1ec7 qu\u1ea3n tr\u1ecb C\u01a1 s\u1edf d\u1eef li\u1ec7u tr\u00ean <\/em>Osquery<\/em><\/a>. <\/em><\/li>
- Apple: D\u00f9ng SQLite cho r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng desktop ch\u1ea1y tr\u00ean n\u1ec1n t\u1ea3ng MAC OSX, Apple c\u0169ng s\u1eed d\u1ee5ng SQlite cho iTunes, Safari,…<\/em><\/li>
- Airbus: D\u00f9ng SQLite cho ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd bay c\u1ee7a gia \u0111\u00ecnh d\u00f2ng m\u00e1y bay A350 XWB.<\/em><\/li>
- Bosch: D\u00f9ng SQLite cho c\u00e1c h\u1ec7 th\u1ed1ng \u0111a ph\u01b0\u01a1ng ti\u1ec7n \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t tr\u00ean c\u00e1c d\u00f2ng xe c\u1ee7a c\u00e1c h\u00e3ng General Motors, Nissan v\u00e0 Suzuki.<\/em><\/li><\/ul>\n\n\n\n
Ngo\u00e0i ra c\u00f2n r\u1ea5t nhi\u1ec1u c\u00e1c C\u00f4ng ty l\u1edbn kh\u00e1c \u0111ang s\u1eed d\u1ee5ng SQLite c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam t\u1ea1i \u0111\u00e2y<\/a>.
<\/p>\n\n\n\nSQLite l\u00e0 g\u00ec?<\/h4>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09115029\/3.png\")
<\/figure><\/div>\n\n\n\nSQLite l\u00e0 ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u (Database Management System) t\u01b0\u01a1ng t\u1ef1 nh\u01b0 Mysql, PostgreSQL\u2026 \u0110\u1eb7c \u0111i\u1ec3m c\u1ee7a SQLite l\u00e0 kh\u00f4ng c\u1ea7n m\u00e1y ch\u1ee7<\/a>, kh\u00f4ng c\u1ea7n c\u1ea5u h\u00ecnh<\/a>, nhanh<\/a>, nh\u1ecf g\u1ecdn<\/a>, kh\u00e9p k\u00edn<\/a>, c\u00f3 \u0111\u1ed9 tin c\u1eady cao<\/a> v\u00e0 h\u1ed7 tr\u1ee3 h\u1ea7u nh\u01b0 \u0111\u1ea7y \u0111\u1ee7 c\u00e1c t\u00ednh n\u0103ng<\/a> c\u1ea7n thi\u1ebft trong chu\u1ea9n SQL92. <\/p>\n\n\n\n
D\u1eef li\u1ec7u Database c\u0169ng \u0111\u01b0\u1ee3c l\u01b0u tr\u00ean m\u1ed9t file duy nh\u1ea5t. Kh\u00f4ng c\u00f3 kh\u00e1i ni\u1ec7m user, password hay quy\u1ec1n h\u1ea1n trong SQLite Database. SQLite kh\u00f4ng th\u00edch h\u1ee3p v\u1edbi nh\u1eefng h\u1ec7 th\u1ed1ng l\u1edbn nh\u01b0ng \u1edf quy m\u00f4 v\u1eeba t\u1ea7m th\u00ec SQLite ph\u00e1t huy uy l\u1ef1c v\u00e0 kh\u00f4ng h\u1ec1 y\u1ebfu k\u00e9m v\u1ec1 m\u1eb7t ch\u1ee9c n\u0103ng hay t\u1ed1c \u0111\u1ed9.
<\/p>\n\n\n\n\u0110\u1eb7t v\u1ea5n \u0111\u1ec1<\/h4>\n\n\n\n
Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n x\u00e2y d\u1ef1ng m\u1ed9t \u1ee9ng d\u1ee5ng ghi ch\u00fa nh\u1ecf, kh\u00f4ng s\u1eed d\u1ee5ng m\u00f4 h\u00ecnh m\u00e1y ch\u1ee7\/kh\u00e1ch cho vi\u1ec7c th\u1eed nghi\u1ec7m ho\u1eb7c s\u1eed d\u1ee5ng, vi\u1ec7c l\u01b0u d\u1eef li\u1ec7u ch\u1ec9 s\u1eed d\u1ee5ng cho m\u1ed9t ng\u01b0\u1eddi d\u00f9ng. T\u1ed1c \u0111\u1ed9 ph\u00ecnh to c\u1ee7a d\u1eef li\u1ec7u th\u1ea5p v\u00e0 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u c\u1ee7a gi\u1eefa c\u00e1c b\u1ea3ng trong C\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a \u1ee9ng d\u1ee5ng kh\u00f4ng qu\u00e1 ph\u1ee9c t\u1ea1p.
<\/p>\n\n\n\nH\u01b0\u1edbng gi\u1ea3i quy\u1ebft<\/h4>\n\n\n\n
Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y m\u00ecnh quy\u1ebft \u0111\u1ecbnh ch\u1ecdn SQLite v\u00ec \u01b0u \u0111i\u1ec3m d\u1ec5 c\u00e0i \u0111\u1eb7t, nhanh, nh\u1ecf g\u1ecdn, t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u ch\u1ec9 l\u01b0u tr\u1eef trong 1 t\u1eadp tin duy nh\u1ea5t \u0111\u1ec3 x\u00e2y d\u1ef1ng m\u1ed9t \u1ee9ng d\u1ee5ng Todo List nh\u1ecf nh\u01b0 \u1ea3nh b\u00ean d\u01b0\u1edbi.
<\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09115141\/4.png\")
<\/figcaption><\/figure><\/div>\n\n\n\nH\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t SQLite3, Ruby On Rails v\u1edbi Docker<\/a><\/h4>\n\n\n\n
Trong v\u00ed d\u1ee5 n\u00e0y MEVN<\/strong> s\u1ebd x\u00e2y d\u1ef1ng m\u1ed9t \u1ee9ng d\u1ee5ng Todo List nh\u1ecf s\u1eed d\u1ee5ng Docker, Ruby On Rails 6<\/strong> v\u00e0 SQLite3<\/strong>. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng ngh\u1ec7 kh\u00e1c t\u00f9y theo m\u1ee5c ti\u00eau c\u1ee7a m\u1ed7i d\u1ef1 \u00e1n.<\/p>\n\n\n\n
Sau \u0111\u00e2y, m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch c\u00e0i \u0111\u1eb7t v\u00e0 s\u1eed d\u1ee5ng SQLite3<\/strong> v\u1edbi Ruby On Rails<\/strong> tr\u00ean Docker<\/strong>. \u0110\u1ec3 tr\u00e1nh g\u00e2y lo\u00e3ng b\u00e0i vi\u1ebft v\u1ec1 SQLite3<\/strong> m\u00ecnh c\u00f3 th\u00eam ph\u1ea7n t\u00e0i li\u1ec7u tham kh\u1ea3o<\/em> \u1edf cu\u1ed1i b\u00e0i vi\u1ebft c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam. <\/p>\n\n\n\n
Sau khi c\u00e0i \u0111\u1eb7t Docker<\/strong> c\u00e1c b\u1ea1n v\u00e0o d\u1ef1 \u00e1n t\u1ea1o 2 file m\u1edbi \u0111\u1eb7t t\u00ean l\u00e0 Dockerfile<\/em><\/strong> (L\u01b0u \u00fd t\u1eadp tin kh\u00f4ng c\u00f3 ph\u1ea7n m\u1edf r\u1ed9ng) v\u00e0 file docker-compose.yml <\/strong>. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u1ea5p th\u01b0 m\u1ee5c hi\u1ec7n t\u1ea1i c\u1ee7a d\u1ef1 \u00e1n.
<\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09115308\/5.png\")
<\/figure><\/div>\n\n\n\n
C\u00e1c b\u1ea1n m\u1edf file Dockerfile<\/strong> v\u00e0 th\u00eam c\u00e1c d\u00f2ng nh\u01b0 b\u00ean d\u01b0\u1edbi:<\/p>\n\n\n\nDockerfile<\/h3><\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09115347\/6.png\")
<\/figure><\/div>\n\n\n\n
D\u00f2ng RUN apt-get install -y sqlite3 d\u00f9ng \u0111\u1ec3 c\u00e0i \u0111\u1eb7t SQLite3 ch\u1ea1y tr\u00ean m\u00f4i tr\u01b0\u1eddng ruby.<\/p>\n\n\n\nSau khi th\u00eam d\u00f2ng c\u00e0i \u0111\u1eb7t Sqlite3<\/strong> v\u00e0o Dockerfile<\/strong> ti\u1ebfp theo ch\u00fang ta s\u1ebd thi\u1ebft l\u1eadp container cho ruby tr\u00ean file docker-compose.yml <\/strong>( C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1ch x\u00e2y d\u1ef1ng file docker-compose trong link tham kh\u1ea3o b\u00ean d\u01b0\u1edbi ).
<\/p>\n\n\n\nT\u1ea1o project Todos<\/h3>\n
Sau khi t\u1ea1o v\u00e0 l\u01b0u file docker-compose.yml<\/strong>, vi\u1ec7c ti\u1ebfp theo ch\u00fang ta c\u1ea7n l\u00e0m t\u1ea1o di chuy\u1ec3n \u0111\u1ebfn th\u01b0 m\u1ee5c rubyapp\/source<\/strong> v\u00e0 t\u1ea1o m\u1ed9t project m\u1edbi s\u1eed d\u1ee5ng l\u1ec7nh rails <t\u00ean project><\/strong>. (Ch\u00fa \u00fd tu\u1ef3 theo h\u1ec7 \u0111i\u1ec1u h\u00e0nh m\u00e0 b\u1ea1n \u0111ang s\u1eed d\u1ee5ng c\u00e1c b\u1ea1n s\u1ebd c\u1ea7n c\u00e0i \u0111\u1eb7t Ruby, RubyGems<\/strong> v\u00e0 Rails<\/strong> v\u00e0o m\u00e1y tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n b\u01b0\u1edbc ti\u1ebfp theo n\u00e0y, c\u00e1c b\u1ea1n tham kh\u1ea3o t\u00e0i li\u1ec7u h\u01b0\u1edbng d\u1eabn b\u00ean d\u01b0\u1edbi).
<\/p><\/p>\n\n\n\nM\u00ecnh \u0111\u1eb7t t\u00ean d\u1ef1 \u00e1n l\u00e0 Todos.<\/strong> Ch\u00fang ta ch\u1ea1y l\u1ec7nh rails new Todos <\/strong>m\u1eb7c \u0111\u1ecbnh Ruby On Rails s\u1ebd t\u1ea1o project c\u00f3 thi\u1ebft l\u1eadp s\u1eb5n cho SQLite<\/strong><\/p>\n\n\n\n
Sau khi ch\u1ea1y xong l\u1ec7nh ch\u00fang ta s\u1ebd c\u00f3 m\u1ed9t th\u01b0 m\u1ee5c project Todo<\/strong> <\/p>\n\n\n\n
C\u00e1c b\u1ea1n ti\u1ebfp t\u1ee5c g\u00f5 l\u1ec7nh \u0111\u1ec3 docker build image v\u00e0 ch\u1ea1y docker-compose up \u0111\u1ec3 t\u1ea3i c\u00e1c image b\u1ed5 sung cho vi\u1ec7c t\u1ea1o container<\/p>\n\n\n\n\u201cdocker-compose build<\/em><\/strong><\/p>\n\n\n\n
docker-compose up\u201d<\/em><\/strong><\/p>\n\n\n\n
Sau khi ch\u1ea1y xong c\u00e1c b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o ho\u00e0n t\u1ea5t vi\u1ec7c ch\u1ea1y container cho ruby.Ti\u1ebfp theo ch\u00fang ta truy c\u1eadp v\u00e0o \u0111\u01b0\u1eddng d\u1eabn localhost:3000<\/a> v\u00e0 n\u1ebfu nh\u01b0 b\u1ea1n setup th\u00e0nh c\u00f4ng b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o nh\u01b0 \u1ea3nh b\u00ean d\u01b0\u1edbi.<\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09115441\/7.png\")
<\/figure><\/div>\n\n\n\nYayyyyyyyy!!!!!!! Ch\u00fang ta \u0111\u00e3 c\u00e0i \u0111\u1eb7t v\u00e0 t\u00edch h\u1ee3p th\u00e0nh c\u00f4ng SQLite3<\/strong> tr\u00ean Ruby On Rails<\/strong><\/p>\n\n\n\n
B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd b\u1eaft \u0111\u1ea7u x\u00e2y d\u1ef1ng \u1ee9ng d\u1ee5ng Todos nh\u1ecf \u0111\u1ec3 t\u01b0\u01a1ng t\u00e1c v\u1edbi Database c\u1ee7a SQLite<\/p>\n\n\n\n
C\u00e1c b\u1ea1n ch\u1ea1y l\u1ec7nh exec \u0111\u1ec3 truy c\u1eadp v\u00e0o container c\u1ee7a ruby v\u00e0 th\u1ef1c thi l\u1ec7nh kh\u1edfi t\u1ea1o controller todo v\u1edbi action \u2018index\u2019 : <\/p>\n\n\n\n
\u201cdocker exec -it rails_ruby rails generate controller todos index\u201d<\/em><\/strong><\/p>\n\n\n\n
Sau khi ch\u1ea1y xong l\u1ec7nh tr\u00ean c\u00e1c b\u1ea1n s\u1ebd c\u00f3 1 file controller\/todos_controller<\/strong> v\u00e0 1 file views\/todos\/index.html.erb<\/strong> trong th\u01b0 m\u1ee5c app<\/strong> c\u1ee7a d\u1ef1 \u00e1n, rails c\u0169ng t\u1ea1o s\u1eb5n cho b\u1ea1n 1 route trong file config\/routes.rb<\/strong>
<\/p>\n\n\n\nC\u00e1c b\u1ea1n ti\u1ebfp t\u1ee5c m\u1edf file routes.rb <\/strong>v\u00e0 th\u00eam d\u00f2ng route resource<\/strong> nh\u01b0 b\u00ean d\u01b0\u1edbi<\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09131847\/Screen-Shot-2020-06-08-at-15.23.14.png\")
<\/figure><\/div>\n\n\n\nSau khi th\u00eam route c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 truy c\u1eadp v\u00e0o \u0111\u01b0\u1eddng d\u1eabn localhost:3000<\/a> \u1ee9ng d\u1ee5ng c\u1ee7a b\u1ea1n s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09132020\/Screen-Shot-2020-06-04-at-14.09.39.png\")
<\/figure><\/div>\n\n\n\nM\u1eb7c \u0111\u1ecbnh Ruby On Rails<\/strong> s\u1ebd h\u1ed7 tr\u1ee3 SQLite 3<\/strong> nh\u01b0ng \u0111\u1ec3 config database cho SQLite3<\/strong> ho\u1eb7c c\u00e1c database kh\u00e1c b\u1ea1n c\u00f3 th\u1ec3 v\u00e0o config\/database.yml<\/strong><\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09132047\/Screen-Shot-2020-06-08-at-15.15.29.png\")
<\/figure><\/div>\n\n\n\nB\u00e2y gi\u1edd ch\u00fang ta s\u1ebd b\u1eaft \u0111\u1ea7u t\u1ea1o model trong Rails \u0111\u1ec3 t\u1ea1o table Todo trong SQLite<\/p>\n\n\n\n
C\u00e1c b\u1ea1n ch\u1ea1y l\u1ec7nh sau \u0111\u1ec3 t\u1ea1o model cho project<\/p>\n\n\n\n\u201cdocker exec -it rails_ruby rails generate model todo\u201d<\/em><\/strong>Rails s\u1ebd sinh ra file model\/todo.rb <\/strong> v\u00e0 file db\/migrate\/20200604071501_create_todos.rb <\/strong> nh\u01b0 \u1ea3nh b\u00ean d\u01b0\u1edbi<\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09132133\/Screen-Shot-2020-06-04-at-14.16.05.png\")
<\/figure><\/div>\n\n\n\nCh\u00fang ta ti\u1ebfp t\u1ee5c m\u1edf file db\/migrate\/20200604071501_create_todos.rb <\/strong>v\u00e0 th\u00eam c\u00e1c d\u00f2ng nh\u01b0 b\u00ean d\u01b0\u1edbi \u0111\u1ec3 t\u1ea1o v\u00e0 \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u d\u1eef li\u1ec7u cho c\u00e1c c\u1ed9t trong table c\u1ee7a SQLite3<\/strong><\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09132256\/Screen-Shot-2020-06-08-at-15.15.58.png\")
<\/figure><\/div>\n\n\n\n
B\u1ea1n ti\u1ebfp t\u1ee5c ch\u1ea1y l\u1ec7nh command b\u00ean d\u01b0\u1edbi \u0111\u1ec3 migrate v\u00e0 kh\u1edfi t\u1ea1o database<\/p>\n\n\n\n\u201cdocker exec -it rails_ruby rails db:migrate\u201d<\/em><\/strong><\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09132355\/Screen-Shot-2020-06-04-at-14.38.00.png\")
<\/figure><\/div>\n\n\n\nSau khi th\u1ef1c thi xong l\u1ec7nh migrate, Rails s\u1ebd sinh cho b\u1ea1n m\u1ed9t file db\/development.sqlite3 <\/strong>t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u c\u1ee7a c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c SQLite l\u01b0u trong m\u1ed9t file duy nh\u1ea5t.D\u00f9ng \u1ee9ng d\u1ee5ng DB Browser for SQLite<\/em><\/strong> \u0111\u1ec3 m\u1edf file development.sqlite3<\/strong> b\u1ea1n s\u1ebd th\u1ea5y c\u1ea5u tr\u00fac c\u1ee7a table todos c\u1ee7a ch\u00fang ta sau khi kh\u1edfi t\u1ea1o nh\u01b0 sau:
<\/p>\n\n\n\nCh\u00fang ta c\u0169ng th\u1eed \u0111\u1ed5 10 d\u00f2ng d\u1eef li\u1ec7u b\u1eb1ng l\u1ec7nh rails db:seed \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 b\u1edfi Rail \u0111\u1ec3 \u0111\u1ed5 m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u v\u00e0 database, \u0111\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y c\u00e1c b\u1ea1n v\u00e0o file db\/seeds.rb<\/strong> v\u00e0 th\u00eam d\u00f2ng b\u00ean d\u01b0\u1edbi<\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09132450\/Screen-Shot-2020-06-08-at-15.16.35.png\")
<\/figure><\/div>\n\n\n\nCh\u00fang ta ti\u1ebfp t\u1ee5c ch\u1ea1y l\u1ec7nh \u0111\u1ec3 \u0111\u1ed5 d\u1eef li\u1ec7u th\u1eed nghi\u1ec7m v\u00e0o database:<\/p>\n\n\n\n
docker exec -it rails_ruby rails db:seed<\/p>\n\n\n\n
Ki\u1ec3m tra d\u1eef li\u1ec7u sau khi \u0111\u1ed5 b\u1eb1ng DB Browser for SQLite<\/strong><\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09132527\/Screen-Shot-2020-06-04-at-15.54.29.png\")
<\/figure><\/div>\n\n\n\n- Sau khi x\u00e2y d\u1ef1ng giao di\u1ec7n \u1ee9ng d\u1ee5ng b\u1eb1ng html, css ch\u00fang ta v\u00e0o file views\/todos\/index.html.erb<\/strong> v\u00e0 th\u00eam c\u00e1c d\u00f2ng code \u0111\u1ec3 hi\u1ec3n th\u1ecb v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u t\u1eeb database ra m\u00e0n h\u00ecnh.<\/li><\/ol>\n\n\n\n
Ch\u00fang ta v\u00e0o controllers\/todos_controller.rb<\/strong> v\u00e0 th\u00eam h\u00e0m index l\u1ea5y d\u1eef li\u1ec7u t\u1eeb database th\u00f4ng qua model.<\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09134228\/Screen-Shot-2020-06-08-at-15.17.50.png\")
<\/figure>\n\n\n\n
Hi\u1ec7n t\u1ea1i Todo List s\u1ebd hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u nh\u01b0 b\u00ean d\u01b0\u1edbi, do ch\u00fang ta \u0111\u00e3 ch\u1ea1y l\u1ec7nh rails db:seed \u0111\u1ec3 th\u00eam d\u1eef li\u1ec7u v\u00e0o database tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09134323\/Screen-Shot-2020-06-04-at-15.56.30.png\")
<\/figure><\/div>\n\n\n\n
Ch\u00fang ta ti\u1ebfp t\u1ee5c m\u1edf file controllers\/todo_controller.rb <\/strong>v\u00e0 th\u00eam code insert d\u1eef li\u1ec7u v\u00e0o database. Ch\u00fang ta truy\u1ec1n d\u1eef li\u1ec7u b\u1eb1ng params v\u1edbi bi\u1ebfn description ki\u1ec3u d\u1eef li\u1ec7u l\u00e0 string.<\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09134402\/Screen-Shot-2020-06-08-at-15.18.36.png\")
<\/figure>\n\n\n\n
Th\u1eed th\u00eam m\u1edbi m\u1ed9t task c\u00f3 t\u00ean l\u00e0 \u201cTh\u1eed nghi\u1ec7m\u201d<\/em> v\u00e0o database c\u1ee7a SQLite ta s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 sau:<\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09134446\/Screen-Shot-2020-06-04-at-15.59.54.png\")
<\/figure>\n\n\n\n
Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u trong file db\/development.sqlite3<\/strong> b\u1eb1ng c\u00f4ng c\u1ee5 DB Browser For SQLite c\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3 th\u00eam m\u1ed9t d\u00f2ng m\u1edbi v\u1edbi t\u00ean l\u00e0 \u201cTh\u1eed nghi\u1ec7m\u201d.<\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09134533\/Screen-Shot-2020-06-04-at-16.15.43.png\")
<\/figure><\/div>\n\n\n\n
2.\u0110\u1ec3 x\u00f3a m\u1ed9t d\u00f2ng trong c\u01a1 s\u1edf d\u1eef li\u1ec7u ch\u00fang ta ti\u1ebfp t\u1ee5c m\u1edf file controller\/todos_controller.rb<\/strong> v\u00e0 th\u00eam h\u00e0m destroy <\/strong>d\u1ef1a tr\u00ean id c\u1ee7a d\u00f2ng \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09134732\/Screen-Shot-2020-06-08-at-15.17.50-2.png\")
<\/figure><\/div>\n\n\n\nCh\u00fang ta th\u1eed xo\u00e1 task \u201cTh\u1eed nghi\u1ec7m\u201d v\u1eeba th\u00eam v\u00e0o v\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3<\/p>\n\n\n\n
![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09134840\/Screen-Shot-2020-06-04-at-16.03.16.png\")
<\/figure>\n\n\n\n
Sau khi xo\u00e1 task th\u1eed nghi\u1ec7m ch\u00fang ta d\u00f9ng DB Browser for SQLite \u0111\u1ec3 ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u \u0111ang c\u00f3 b\u00ean trong file development.sqlite3<\/strong><\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09134916\/Screen-Shot-2020-06-04-at-16.09.34.png\")
<\/figure><\/div>\n\n\n\nTask \u201cTh\u1eed nghi\u1ec7m\u201d \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00f3a kh\u1ecfi c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n\n\n\n
3.Sau \u0111\u00f3 ch\u00fang ta th\u00eam h\u00e0m update l\u1ea1i d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn \u0111\u1ec3 update l\u1ea1i tr\u1ea1ng th\u00e1i c\u1ee7a task sau khi \u0111\u00e3 update ho\u00e0n t\u1ea5t v\u00e0o c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09135005\/Screen-Shot-2020-06-08-at-15.20.55.png\")
<\/figure>\n\n\n\n
Hi\u1ec7n t\u1ea1i checkbox c\u1ee7a ch\u00fang ta \u0111ang \u0111\u01b0\u1ee3c check c\u1ea3 3 d\u00f2ng<\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09135049\/Screen-Shot-2020-06-04-at-16.08.22.png\")
<\/figure><\/div>\n\n\n\n
Ch\u00fang ta th\u1eed thay \u0111\u1ed5i tr\u1ea1ng th\u00e1i c\u1ee7a checkbox task \u201cTest\u201d \u0111\u1ea7u ti\u00ean th\u1eed xem nh\u00e9.<\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09135126\/Screen-Shot-2020-06-04-at-16.04.20.png\")
<\/figure>\n\n\n\n
Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u c\u1ee7a c\u1ed9t status trong file development.sqlite3 <\/strong>t\u1ea1i d\u00f2ng \u0111\u1ea7u ti\u00ean, tr\u1ea1ng th\u00e1i \u0111\u00e3 \u0111\u01b0\u1ee3c thay \u0111\u1ed5i v\u1ec1 \u201cuncheck\u201d<\/strong><\/p>\n\n\n\n![\"\"](\"https:\/\/mevn-public.s3-ap-southeast-1.amazonaws.com\/marketenterprise.vn\/wp-images\/2020\/06\/09135213\/Screen-Shot-2020-06-04-at-16.05.33.png\")
<\/figure><\/div>\n\n\n\n
\u01afu \u0111i\u1ec3m c\u1ee7a SQLite<\/strong><\/h4>\n\n\n\n– V\u00ec SQLite kh\u00f4ng c\u1ea7n client\u2013server database engine n\u00ean c\u00f3 th\u1ec3 hi\u1ec3u file CSDL \u0111\u00e3 t\u00edch h\u1ee3p m\u1ecdi th\u1ee9, s\u1eed d\u1ee5ng ngay kh\u00f4ng c\u1ea7n ph\u1ea3i c\u00e0i \u0111\u1eb7t th\u00eam th\u1ee9 g\u00ec.<\/p>\n\n\n\n
– SQLite kh\u00f4ng c\u1ea7n c\u1ea5u h\u00ecnh, ngh\u0129a l\u00e0 kh\u00f4ng c\u1ea7n thi\u1ebft ph\u1ea3i c\u00e0i \u0111\u1eb7t.<\/p>\n\n\n\n
– V\u1edbi SQLite, Database \u0111\u1ea7y \u0111\u1ee7 \u0111\u01b0\u1ee3c l\u01b0u gi\u1eef trong m\u1ed9t t\u1eadp tin duy nh\u1ea5t.<\/p>\n\n\n\n
– SQLite l\u00e0 r\u1ea5t nh\u1ecf g\u1ecdn, nh\u1ecf h\u01a1n 600kB \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ea5u h\u00ecnh \u0111\u1ea7y \u0111\u1ee7 ho\u1eb7c nh\u1ecf h\u01a1n 250kB khi \u0111\u00e3 b\u1ecf qua c\u00e1c t\u00ednh n\u0103ng t\u00f9y \u00fd.
<\/p>\n\n\n\nH\u1ea1n ch\u1ebf c\u1ee7a SQLite<\/strong><\/h4>\n\n\n\n
– Do s\u1eed d\u1ee5ng c\u01a1 ch\u1ebf coarse-gained locking <\/strong>n\u00ean trong c\u00f9ng m\u1ed9t th\u1eddi \u0111i\u1ec3m SQLite c\u00f3 th\u1ec3 h\u1ed7 tr\u1ee3 nhi\u1ec1u ng\u01b0\u1eddi \u0111\u1ecdc d\u1eef li\u1ec7u, nh\u01b0ng ch\u1ec9 c\u00f3 1 ng\u01b0\u1eddi c\u00f3 th\u1ec3 ghi d\u1eef li\u1ec7u.<\/p>\n\n\n\n
– SQLite kh\u00f4ng ph\u1ea3i l\u00e0 l\u1ef1a ch\u1ecdn ho\u00e0n h\u1ea3o \u0111\u1ec3 \u0111\u00e1p \u1ee9ng c\u00e1c nhu c\u1ea7u x\u1eed l\u00fd tr\u00ean m\u1ed9t kh\u1ed1i l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn, ph\u00e1t sinh li\u00ean t\u1ee5c.<\/p>\n\n\n\n
– SQLite c\u0169ng thi\u1ebfu c\u00e1c t\u00ednh n\u0103ng \u0111o l\u01b0\u1eddng hi\u1ec7u su\u1ea5t
<\/p>\n\n\n\nT\u1ed5ng k\u1ebft<\/h4>\n\n\n\n
V\u1eady l\u00e0 m\u00ecnh \u0111\u00e3 chia s\u1ebb xong v\u1edbi m\u1ecdi ng\u01b0\u1eddi v\u1ec1 SQLite<\/strong>. Ch\u00fang ta \u0111ang s\u1ed1ng trong m\u1ed9t th\u1eddi \u0111\u1ea1i c\u00f4ng ngh\u1ec7 ph\u00e1t tri\u1ec3n nhanh, nh\u1eefng c\u00f4ng ngh\u1ec7 \u0111ang ph\u1ed5 bi\u1ebfn ho\u1eb7c \u0111ang \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng t\u1ea1i MarketEnterprise Vietnam<\/strong> \u0111\u1ec1u l\u00e0 nh\u1eefng c\u00f4ng ngh\u1ec7 m\u1edbi g\u00f3p ph\u1ea7n n\u00e2ng cao ch\u1ea5t l\u01b0\u1ee3ng cu\u1ed9c s\u1ed1ng cho m\u1ecdi ng\u01b0\u1eddi. <\/p>\n\n\n\n
Th\u00f4ng qua nh\u1eefng ki\u1ebfn th\u1ee9c trong b\u00e0i vi\u1ebft v\u1ec1 SQLite<\/strong>, hy v\u1ecdng c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u th\u00eam v\u1ec1 SQLite<\/strong>, v\u1ec1 nh\u1eefng th\u1ebf m\u1ea1nh, \u01b0u \u0111i\u1ec3m, nh\u01b0\u1ee3c \u0111i\u1ec3m v\u00e0 nh\u1eefng c\u00f4ng d\u1ee5ng c\u1ee7a SQLite<\/strong> trong cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y v\u00e0 trong c\u00f4ng vi\u1ec7c c\u1ee7a c\u00e1c b\u1ea1n.
<\/p>\n\n\n\nTham kh\u1ea3o th\u00eam<\/h4>\n\n\n\n
- Docker: docs.docker.com<\/a><\/li>
- Ruby On Rails: guides.rubyonrails.org<\/a><\/li>
- Ruby: www.tutorialspoint.com\/ruby\/index.htm<\/a><\/li>
- SQLite3: www.tutorialspoint.com\/sqlite\/index.htm<\/a><\/li><\/ul>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh r\u1ea5t vui khi \u0111\u01b0\u1ee3c chia s\u1ebb v\u1edbi c\u00e1c b\u1ea1n ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1c c\u00f4ng ngh\u1ec7 \u0111ang \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng t\u1ea1i MarketEnterprise Vietnam. <\/p>\n","protected":false},"author":21,"featured_media":453,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[27,22],"class_list":["post-452","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-sqlite3","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.marketenterprise.vn\/blog\/wp-json\/wp\/v2\/posts\/452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.marketenterprise.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.marketenterprise.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.marketenterprise.vn\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.marketenterprise.vn\/blog\/wp-json\/wp\/v2\/comments?post=452"}],"version-history":[{"count":0,"href":"https:\/\/www.marketenterprise.vn\/blog\/wp-json\/wp\/v2\/posts\/452\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.marketenterprise.vn\/blog\/wp-json\/wp\/v2\/media\/453"}],"wp:attachment":[{"href":"https:\/\/www.marketenterprise.vn\/blog\/wp-json\/wp\/v2\/media?parent=452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.marketenterprise.vn\/blog\/wp-json\/wp\/v2\/categories?post=452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.marketenterprise.vn\/blog\/wp-json\/wp\/v2\/tags?post=452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Ruby On Rails: guides.rubyonrails.org<\/a><\/li>
- Docker: docs.docker.com<\/a><\/li>
- Google: D\u00f9ng SQLite cho h\u1ec7 \u0111i\u1ec1u h\u00e0nh Android v\u00e0 tr\u00ecnh duy\u1ec7t Chrome.<\/em><\/li>