I recently started learning about relational databases by taking part in a course about programming. The course mentors suggested we use Litecli: https://litecli.com It's a great tool, but it doesn't seem to recognize the ".read" command when I try to load an SQL script.
When trying to load a simple script with ".read" Litecli produces a 'syntax error' more specifically:
near ".": syntax error
On the other hand, if a run the command from the sqlite3 manager, no problems seem to occur.
P.S Tried both things under Windows 10 and Ubuntu 18.04 (on a virtual machine) but to the problem is persistent.
An example script with the name 'createlangsdb.sql':
CREATE TABLE langs(
id INTEGER NOT NULL PRIMARY KEY,
lang VARCHAR(10),
answer VARCHAR(10),
answered BOOLEAN,
guide TEXT
);
Ran from Windows10 PS:
PS D:\DBs>litecli somedb
somedb>.read createlangsdb.sql
near ".": syntax error
Needless to say, createlangsdb.sql SQL script is in the same directory as the actual database.
When I ran the same command in sqlite3, I get the desired result.
Am I missing something here (which is probably the issue) or is litecli not capable of reading scripts?
