Copy tables between SQLite databases

I figured out a pattern for doing this today using the sqlite3 CLI tool - given two SQLite databases in the current folder, called tils.db and simonwillisonblog.db:

echo "
attach database 'simonwillisonblog.db' as simonwillisonblog;
attach database 'tils.db' as tils;
drop table if exists simonwillisonblog.til;
create table simonwillisonblog.til as select * from tils.til;
update simonwillisonblog.til set shot = null;
" | sqlite3

I'm using that in this GitHub Actions workflow.

That last update simonwillisonblog.til set shot = null line is because the shot column contains a large BLOB screenshot image which I don't need in the copied table.

Related

• sqlite Trying out cr-sqlite on macOS - 2023-09-12
• heroku Programatically accessing Heroku PostgreSQL from GitHub Actions - 2020-08-18
• llms Storing and serving related documents with openai-to-sqlite and embeddings - 2023-08-14
• zsh Passing command arguments using heredoc syntax - 2022-07-07
• sqlite Enabling WAL mode for SQLite database files - 2020-08-09
• sqlite Compile a new sqlite3 binary on Ubuntu - 2020-04-30
• sqlite Importing CSV data into SQLite with .import - 2021-07-13
• github-actions Conditionally running a second job in a GitHub Actions workflow - 2022-07-11
• heroku Upgrading a Heroku PostgreSQL database with pg:copy - 2020-07-20
• sqlite Replicating SQLite with rqlite - 2020-12-28

Created 2023-04-03T10:32:17-07:00, updated 2023-04-03T11:24:48-07:00 · History · Edit