lk/data/sqlite.md

22 lines
227 B
Markdown
Raw Permalink Normal View History

2024-04-05 23:04:43 +00:00
---
title: "sqlite"
tags: [ "Documentation", "data" ]
---
Work with a database:
```bash
sqlite3 "$FILE".sqlite3
```
Compress the database:
```sqlite
pragma vacuum;
```
Optimize the database:
```sqlite
pragma optimize;
```