---
title: "Discussion on \"What I Learned Building Backups for a Local, LAN-Based SQLite App\" | Hashnode"
description: "Discussion on \"What I Learned Building Backups for a Local, LAN-Based SQLite App\". A file copy backup of a SQLite database in WAL mode can miss recent writes. Here's why, and how to use SQLite's Online Backup API to fix it."
url: "https://hashnode.com/posts/what-i-learned-building-backups-for-a-local-lan-based-sqlite-app/6a87441b276e657bd8091e0d"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [What I Learned Building Backups for a Local, LAN-Based SQLite App](https://daksh-codes.hashnode.dev/what-i-learned-building-backups-for-a-local-lan-based-sqlite-app?utm_source=hashnode&utm_medium=feed)

A file copy backup of a SQLite database in WAL mode can miss recent writes. Here's why, and how to use SQLite's Online Backup API to fix it.

Aug 20 · 4 min read · daksh-codes.hashnode.dev  
Read the article

-   [#sqlite](https://hashnode.com/tag/sqlite)
-   [#database](https://hashnode.com/tag/database)
-   [#backend-development](https://hashnode.com/tag/backend-development)
-   [#sql](https://hashnode.com/tag/sql)
-   [#sqlite3](https://hashnode.com/tag/sqlite3)

## Written by

[Daksh Ramrakhyani](https://hashnode.com/@daksh-codes)

@daksh-codes

  
[View profile](https://hashnode.com/@daksh-codes)

Figuring out code and sharing what I learn

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
