Comments (2)
simolus3
commented on September 6, 2024
Can you use VACUUM INTO to backup databases?
from sqlite3.dart.
glanium
commented on September 6, 2024
can but
documentation says
The VACUUM INTO command is transactional in the sense that the generated output database is a consistent snapshot of the original database. However, if the VACUUM INTO command is interrupted by an unplanned shutdown or power lose, then the generated output database might be incomplete and corrupt. Also, SQLite does not invoke fsync() or FlushFileBuffers() on the generated database to ensure that it has reached non-volatile storage before completing
and
This means that when VACUUMing a database, as much as twice the size of the original database file is required in free disk space.
So I wanna use backup api if possible
from sqlite3.dart.
Related Issues (20)
- Web: DriftRemoteException WebAssembly.instantiateStreaming is not a function HOT 3
- Writing Tests using sqlite3 package in a pure dart package HOT 1
- how to insert blob data HOT 1
- request: support sqlite3_flutter_libs `json_extract` HOT 1
- Compiler Error In iOS HOT 10
- Database disk image is malformed, HOT 7
- [Docs] Add Docs, stating `BLOB` type, expects `Uint8List`, not `T` or `Object`
- `Database.lastInsertRowId` should `return` `int?`, instead of `int` HOT 1
- how to get table-count of db, through `SQLite3.exec("SELECT count(*) FROM sqlite_schema WHERE type = 'table'").getInt()` HOT 1
- Implement a `pkg:realm:Realm:write` like method to `Database`, which calls the passed function in a transaction, commit on success, otherwise rollback HOT 1
- implement a `pkg:realm:Transaction` like class, simplifying `commit` and `rollback` HOT 3
- Cannot open WAL database via web/wasm HOT 4
- Missleading expection
- Migrate away from `elementAt` for Dart 3.3 HOT 2
- Support for NULL value HOT 1
- sqlcipher_flutter_libs link error in Ubuntu 23.10 and 24.04 HOT 3
- iOS: Could not build Objective-C module 'SQLite3' when install drift HOT 6
- sqlcipher_flutter_libs adding libraries for other platforms in Android build HOT 3
- Target "sqlcipher_flutter_libs_plugin" links to target "Threads::Threads" but the target was not found in linux-arm64
- Migrate web implementation to `dart:js_interop`
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlite3.dart.