Export SQLite DB to Google Drive in Flutter

Programming
, , ,
1

I am looking for a solution to export a Sqlite db file to Google Drive, similar to a WhatsApp backup. Does anyone know of a library or project that can do this?

// code
2

There is a library called google-api-php-client that can be used to integrate with Google Drive API to export a SQLite db file to Google Drive. Here is an example code snippet:

// Load the Google API PHP Client Library.
require_once 'google-api-php-client/vendor/autoload.php';

// Create the Drive client.
$client = new Google_Client();
$client->setApplicationName('Your app name');
$client->setScopes(Google_Service_Drive::DRIVE_FILE);
$client->setAuthConfig('path/to/client_secret.json');
$service = new Google_Service_Drive($client);

// Set the file path and name of the SQLite db file.
$file_path = '/path/to/your/sqlite.db';
$file_name = 'sqlite.db';

// Create a new file on Google Drive.
$file_metadata = new Google_Service_Drive_DriveFile(array(
    'name' => $file_name
));
$file = $service->files->create($file_metadata, array(
    'data' => file_get_contents($file_path),
    'uploadType' => 'multipart'
));

// Print the file ID of the newly created file.
echo "File ID: " . $file->getId();