Database Backup #288

New Issue

adam · 2025-12-29T15:28:13+01:00

adam commented

2025-12-29 15:28:13 +01:00

Originally created by @OlionCompany on GitHub (Aug 19, 2019).

How we can create fully database copy with all last changes?
Right now, if we copy database from SQLiteStore.fileURL, this file don't include "-shm" and "-wal" files with last changes (certainly).

I found solution for Core Data:
persistentStore.migratePersistentStore(oldStore, to: newStoreURL, options: nil, withType: NSSQLiteStoreType)

Can we create backup using CoreStore? Thanks.

Originally created by @OlionCompany on GitHub (Aug 19, 2019). How we can create fully database copy with all last changes? Right now, if we copy database from SQLiteStore.fileURL, this file don't include "-shm" and "-wal" files with last changes (certainly). I found solution for Core Data: persistentStore.migratePersistentStore(oldStore, to: newStoreURL, options: nil, withType: NSSQLiteStoreType) Can we create backup using CoreStore? Thanks.

adam closed this issue

2025-12-29 15:28:13 +01:00

adam commented

2025-12-29 15:28:15 +01:00

@OlionCompany commented on GitHub (Aug 26, 2019):

Maybe someone has ideas?
Question still actual.

@OlionCompany commented on GitHub (Aug 26, 2019): Maybe someone has ideas? Question still actual.

adam commented

2025-12-29 15:28:15 +01:00

@OlionCompany commented on GitHub (Sep 3, 2019):

Our custom implementation of backups creation:

    let storage: SQLiteStore
    let dataStack: DataStack

    public func createBackup() throws {
        try withExtendedLifetime(NSPersistentStoreCoordinator(managedObjectModel: self.dataStack.modelSchema.rawModel())) { coordinator in
            let storeType = type(of: self.storage).storeType
            let store = try coordinator.addPersistentStore(ofType: storeType,
                                                           configurationName: self.storage.configuration,
                                                           at: self.storage.fileURL,
                                                           options: self.storage.dictionary(forOptions: .allowSynchronousLightweightMigration))

            let backupUrl = CoreDataStack.defaultBackupsDirectory.url.appendingPathComponent(Date().timeIntervalSince1970.description).appendingPathExtension(CoreDataStack.storeExtension)

            var backupStoreOptions = self.storage.storeOptions ?? [:]
            backupStoreOptions[NSSQLitePragmasOption] = ["journal_mode": "DELETE"]

            try coordinator.migratePersistentStore(store,
                                                   to: backupUrl,
                                                   options: backupStoreOptions, withType: storeType)

             _ = try? FileManager.default.removeItem(atPath: "\(backupUrl.path)-shm")
        }
    }`

@OlionCompany commented on GitHub (Sep 3, 2019): Our custom implementation of backups creation: ``` let storage: SQLiteStore let dataStack: DataStack public func createBackup() throws { try withExtendedLifetime(NSPersistentStoreCoordinator(managedObjectModel: self.dataStack.modelSchema.rawModel())) { coordinator in let storeType = type(of: self.storage).storeType let store = try coordinator.addPersistentStore(ofType: storeType, configurationName: self.storage.configuration, at: self.storage.fileURL, options: self.storage.dictionary(forOptions: .allowSynchronousLightweightMigration)) let backupUrl = CoreDataStack.defaultBackupsDirectory.url.appendingPathComponent(Date().timeIntervalSince1970.description).appendingPathExtension(CoreDataStack.storeExtension) var backupStoreOptions = self.storage.storeOptions ?? [:] backupStoreOptions[NSSQLitePragmasOption] = ["journal_mode": "DELETE"] try coordinator.migratePersistentStore(store, to: backupUrl, options: backupStoreOptions, withType: storeType) _ = try? FileManager.default.removeItem(atPath: "\(backupUrl.path)-shm") } }` ```

adam referenced this issue

2025-12-29 15:32:35 +01:00

[PR #288] [MERGED] [ListMonitor] Fix performance of `numberOfObjects()`. #490

Sign in to join this conversation.

Branches Tags

develop

master

prototype/concurrency

minIOS13

prototype/containers

transactionSourceTracking

prototype/swiftui

minIOS11

swift5_3

prototype/propertyWrapperFields

prototype/propertyWrappers

prototype/propertyWrapper

Swift5

throwables

prototype/Swift_4_1

prototype/Swift_4_0

prototype/Swift_3_2

prototype/queryBuilders

temp/develop

corestore4_develop

prototype/mainContextToPSC

master_ios_7_to_9

swift_2_3

gh-pages

_corespotlight-test

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/CoreStore#288