From colab directly manipulate sqlite3 format data in Google drive

Question

From colaboratory, is it possible to directly manipulate sqlite 3 format data in google drive? It is possible if you upload it, but it is convenient to use it in google drive.

Answer 1

You can do load files directory from Drive by mounting your Google Drive as a FUSE filesystem.

Here's an example: https://colab.research.google.com/notebook#fileId=1srw_HFWQ2SMgmWIawucXfusGzrj1_U0q

There's no official Google Drive FUSE filesystem. But, several open-source FUSE + Drive libraries have been written by third parties. The example notebook above uses google-drive-ocamlfuse. The notebook shows three things:

1. Installing the Drive FUSE wrapper in the Colab VM.
2. Authenticating to Drive and mounting your Drive using the FUSE wrapper.
3. Listing and creating files in the newly mounted Drive-backed filesystem.