{"id":44646,"library":"croswil_tlite","title":"tlite","description":"SQLite + FTS5 command-line interface utility for creating, managing, and querying SQLite databases directly from the terminal. Version 1.2.47 provides features such as creating SQLite files, creating tables, importing/exporting data, and executing various operations via CLI. It supports FTS5 full-text search. The tool is designed for lightweight database management without a GUI. Release cadence is irregular, with occasional updates.","status":"active","version":"1.2.47","language":"javascript","source_language":"en","source_url":"https://github.com/liburno/tlite","tags":["javascript"],"install":[{"cmd":"npm install croswil_tlite","lang":"bash","label":"npm"},{"cmd":"yarn add croswil_tlite","lang":"bash","label":"yarn"},{"cmd":"pnpm add croswil_tlite","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"This is a CLI tool, not a library. Use via command line.","wrong":"npm install -g tlite (globally is fine but npx avoids global install)","symbol":"tlite (CLI)","correct":"npx tlite"}],"quickstart":{"code":"npx tlite create mydb.sqlite\nnpx tlite table mydb.sqlite create users id INT, name TEXT, email TEXT\nnpx tlite import mydb.sqlite users users.csv\nnpx tlite query mydb.sqlite \"SELECT * FROM users WHERE name LIKE '%John%'\"","lang":"javascript","description":"Shows how to create a SQLite database, create a table, import CSV data, and execute a query using the tlite CLI."},"warnings":[{"fix":"Use npx tlite@1.2.47 to ensure consistent behavior.","message":"npx may not resolve the latest version; use npx tlite@<version> to pin","severity":"gotcha","affected_versions":">=1.0"},{"fix":"Use a SQLite build with FTS5 enabled, or use system SQLite.","message":"FTS5 enabled by default; ensure your SQLite version supports it","severity":"breaking","affected_versions":">=1.0"}],"env_vars":null,"search_vec":"'1.2.47':21 'cadenc':58 'cli':38 'command':5 'command-lin':4 'creat':10,26,29 'data':32 'databas':15,52 'design':49 'direct':16 'execut':34 'featur':23 'file':28 'fts5':3,41 'full':43 'full-text':42 'gui':56 'importing/exporting':31 'interfac':7 'irregular':60 'javascript':64 'lightweight':51 'line':6 'manag':11,53 'occasion':62 'oper':36 'provid':22 'queri':13 'releas':57 'search':45 'sqlite':2,14,27 'support':40 'tabl':30 'termin':19 'text':44 'tlite':1 'tool':47 'updat':63 'util':8 'various':35 'version':20 'via':37 'without':54","created_at":"2026-06-07T12:51:08.694029+00:00","updated_at":"2026-06-07T12:51:08.694029+00:00","problems":[{"fix":"Install Node.js (includes npx) from https://nodejs.org","cause":"Node.js/npm not installed or npx not available","error":"npx: command not found"},{"fix":"Use a build that includes FTS5 or skip FTS5 features.","cause":"SQLite library compiled without FTS5 support","error":"Error: near line 1: no such module: fts5"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/liburno/tlite#readme","github":"https://github.com/liburno/tlite","docs":null,"changelog":null,"pypi":null,"npm":"croswil_tlite","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-07","next_check":"2026-09-05","install_tag":null}}