The MariaDB, PostgreSQL and SQLite3 Clients in Action Basic Client Commands The client programs for MariaDB, PostgreSQL and SQLite3 are mysql, psql and sqlite3, respectively. I've listed several ...

The SQLite3 program displays its own prompt, "sqlite>" indicating that you type SQLite3 commands and not DOS commands as it's running. Type the following command at the "sqlite>" prompt:.separator ...

The SQLite website recommends using the “sl3” extension to signify that we're working with an SQLite version 3 database. If we examine the resulting file, ljdata.sl3 using the strings command, we see ...

Type ".help" to see a list of the available SQLite commands. All commands start with a period -- for example, type ".tables" to show a list of the tables in the current database.

I'm not even 100% sure what all of the command does, but it does a VACUUM on the profile folders' dbs. I've used a similar command to do it manually, but this version runs in a batch better.