SQLite adapter

[andrey-jef]

Hi,

Is it feasible to send dataview annotations to a sqlite single-file database?

And when will the "bulk upload" command be integrated?

It's quite fun to play. Your plugin open a new possibility. By dumping metadata from Obsidian's notes into a database like postgres (or sqlite in future :D ), i can plug these database into services like nocodb or grist. Then I will have a spreadsheet UI to collaborate with others.

Thanks for this experiment.

[clouedoc]

Hello Andrey, I'm glad that you like this plugin.
I'll make some time this week to implement both bulk upload and SQLite export.

Concerning SQLite export, I'm thinking about implementing the feature like this:

1. The user gives a path to an existing SQLite database on their computer
2. The user runs regular commands to export data, it gets written to SQLite instead
3. The SQLite database now has the data

Note: currently, the data is stored in JSON format, and you have to do manual parsing by creating a view. I'd like to dynamically create columns, but unless you need it for your experiment, I'm going to procrastinate on it, so please let me know if it's important for you 🙂

[andrey-jef]

Hi Camille,

Thanks for your dedicated time with the plugin. Just keep the development within your leisure paces, it's purely my joyful experience in playing with exporting metadata from Obsidian to a database.

The UI flow that you depicted for sqlite export sounds good for me. Even in json is already a good initiative.