Converter script from SQLite table to Notes

I had a bunch of tools and whatnot in an SQLite database and I wanted to convert them to Obsidian notes using front matter properties to use with the Projects plugin.

I’m not interested in developing it further, but feel free to improve it.

2 Likes

Does your script give you more control over the front matter properties than using SQLite’s Markdown mode?

sqlite> .mode markdown

as described here …

Mine extracts the table rows into separate files, filling the properties of the file, so one-row-one file like this:

# File name: hosting/shuttle.md
---
created: "2023-06-08 12:26:17.155Z"
id: qcmqs5iyx4b22j8
name: shuttle
updated: "2023-06-08 12:26:17.155Z"
url: https://www.hostinger.com/
---

sqlite> .mode markdown

This command generates a Markdown table like this:

sqlite> select * from hosting;
|         created          |       id        |   name    |         updated          |            url             |
|--------------------------|-----------------|-----------|--------------------------|----------------------------|
| 2023-06-08 12:26:17.155Z | qcmqs5iyx4b22j8 | shuttle   | 2023-06-08 12:26:17.155Z | https://www.shuttle.rs/    |
| 2023-07-17 18:38:04.142Z | cepcjsfn1ya4r1h | Hostinger | 2023-07-17 18:38:04.142Z | https://www.hostinger.com/ |
1 Like

Thank you so much for your detailed explanation.

I plan on trying it out on tables of a SQLite database I back-engineered via ERD from an Android podcast app and then used to populate a RSS app.

I will look into importing a subset into Obsidian - perhaps your script being more atomic will lend itself better for re-use into categories e.g. news, music etc | bulletin/daily/weekly | L:de-en-es-fr-it-nl-pt etc.