Quote:
Originally Posted by kovidgoyal
I highly doubt using a third party sqlite tool is going to work. This is text is FTS indexed and has various things going on that are not encapsulated in notes.db, for instance it links to resources not stored in the db file. Editing it directly will likely break something.
|
Yes, I've noticed that even editing a single database cell on DB Browser isn't accepted with notes.db. I get this message "Error changing data: no such tokenizer: calibre".
So exporting/ re-importing either as .sql or .csv won't work as well. I had also tried to copy the sql from the 'doc' column, manually editing the CSS bit on a text editor, and executing it, but I get a "finished with errors" message:
Execution finished with errors.
Result: unknown function: unixepoch()
At line 1:
INSERT INTO "main"."notes" ("doc") VALUES ('<div>
<p><img src="calres://xxh64/4e2f0cd .....