SQLite 데이터베이스를 다양한 방식으로 조작하기 위한 명령줄 도구. 더 많은 정보: https://sqlite-utils.datasette.io/en/stable/cli.html.
sqlite-utils create-database {{경로/대상/database.db}}
sqlite-utils create-table {{경로/대상/database.db}} {{테이블_이름}} {{id integer name text height float photo blob --pk id}}
sqlite-utils tables {{경로/대상/database.db}}
{{echo '[ {"id": 1, "name": "Linus Torvalds"}, {"id": 2, "name": "Steve Wozniak"}, {"id": 3, "name": "Tony Hoare"} ]'}} | sqlite-utils upsert {{경로/대상/database.db}} {{테이블_이름}} - {{--pk id}}
sqlite-utils rows {{경로/대상/database.db}} {{테이블_이름}}
sqlite-utils query {{경로/대상/database.db}} "{{delete from table_name where name = 'Tony Hoare'}}"
sqlite-utils drop-table {{경로/대상/database.db}} {{테이블_이름}}
sqlite-utils -h