Israel Hanukoglu, Ph.D.

Software : SQLite issues in Linux

To execute SQLite commands, SQLite should be installed in the system.

Copy a table from one database to another

Go the directory where the database files are located.

Right click on the directory name and select "Open in Terminal" option.

In the terminal window enter the following commmand

sqlite3 Database1.db ".dump Table_name" | sqlite3 Database2.db

NOTE: The code above assumes that the file extension name is "db". If yours is different, change accordingly.

How to convert a CSV or Excel file to SQLite?

A CSV (comma-separated values) file can be imported into an SQLite database directly. To perform such an import, create a CSV table that has the same headings and format as the file you wish to import. Then in DB-browser select import option.

Another option is to convert the file. There is a free online tool that converts an Excel file to SQLite database.

How to change the page size of an sqlite database?

Starting with SQLite version 3.12.0 (2016-03-29), the optimal page size recommended is 4096. In earlier versions it was 1024. As noted previously, "Changing the page size has no effect when done either in the GUI or in SQL query window".

To change the page size, run the following command in DB-Browser Tab entitled "Execute SQL".

PRAGMA page_size = 4096; VACUUM;