What you can do by GUI can be done in console, too. SQLdb, despite having droppable components, are usable in non-GUI environment. A snippet from my lib:
uses
db, sqldb, sqlite3conn;
var
Conn: TSQLConnector;
Trans: TSQLTransaction;
Query: TSQLQuery;
begin
Conn := TSQLConnector.Create(nil);
with Conn do begin
ConnectorType := 'SQLite3';
HostName := ''; // not important
DatabaseName := '/path/to/sqlite/db/file';
UserName := ''; // not important
Password := ''; // not important
end;
Trans := TSQLTransaction.Create(nil);
Conn.Transaction := Trans;
Query := TSQLQuery.Create(nil);
Query.DataBase := Conn;
Query.SQL.Text := 'insert your sql query here';
// Query.ParamByName('...').AsWhatever := ... fill if you use parameterized query
Query.ExecSQL; // or Query.Open; depending whether your query is select or not
// for select query
// while not Query.EOF do begin
// do whatever you want, access row field with Query.FieldByName('...').AsWhatever
// Query.Next;
// end;
// Query.Close;
// for non-select
Trans.Commit;
end.
I use TSQLConnector for easy switching between supported connections, nothing stops you from directly using TSQLite3Connection.
Direct SQLite API calls are also possible (see packages/sqlite/tests for sample programs).