---
title: "💭 Database Remote-Copy Tool For SQLite (draft)"
description: "!https://simonwillison.net/2024/Oct/4/sqlite-rsync/"
date: 2024-10-05
published: true
tags:
  - sqlite
  - thought
template: link
---


<div class="embed-card embed-card-external">
  <a href="https://simonwillison.net/2024/Oct/4/sqlite-rsync/" class="embed-card-link" target="_blank" rel="noopener noreferrer">
    <div class="embed-card-content">
      <div class="embed-card-title">Database Remote-Copy Tool For SQLite (draft)</div>
      <div class="embed-card-description">Neat new SQLite utilities often show up in branches of the SQLite repository. Here&#39;s a new one from last month: sqlite3-rsync, providing tools for efficiently creating and updating copies of …</div>
      <div class="embed-card-meta">Simon Willison’s Weblog &middot; simonwillison.net</div>
    </div>
  </a>
</div>


Simon shared a really cool new utility tool for sqlite ispired by rsync.  It checks hashes of each sqlite page and syncs pages.  So if nothing in the database has changed it will only require 0.5% the bandwidth as a copy would.

!!! note

    This post is a <a href="/thoughts/" class="wikilink" data-title="Thoughts" data-description="These are generally my thoughts on a web page or some sort of url, except a rare few don&#39;t have a link. These are dual published off of my..." data-date="2024-04-01">thought</a>. It's a short note that I make
    about someone else's content online <a href="/tags/thoughts/" class="hashtag-tag" data-tag="thoughts" data-count=2 data-reading-time=3 data-reading-time-text="3 minutes">#thoughts</a>