Convert Your Dash Snippets to Quiver
Convert Dash's sqlite database to the directory structure expected by Quiver.
I’ve been using Dash for quite sometime and have a few hundred snippets captured. However, something about it’s keybindings always felt “off” to me and the search capability has been sorely lacking.
This week I discovered Quiver, I’m still testing it out, but so far I like it. However, to really test it, I need my snippets, and it was unfortunately missing an imported for Dash.
So I wrote one. Luckily Dash using sqlite, so finding it’s structure was easy. Quiver uses JSON and particular file structure, which they document well.
Just copy or ln -s your Snippets.dash into the same directory as the code below. Out will come a Quiver Notebook which can be easily imported.
require "json"
require "sqlite3"
require "fileutils"
notebook_name = "Snippets.qvnotebook"
notebook_uuid = SecureRandom.uuid
FileUtils::mkdir_p(notebook_name)
notebook_meta = {
name: "Imported from Dash",
uuid: notebook_uuid
}
File.open("#{notebook_name}/meta.json", "w") { |f| f.puts notebook_meta.to_json }
db = SQLite3::Database.new("Snippets.dash")
db.execute("select sid, title, body, syntax from snippets") do |note_row|
tags = []
db.execute("select t.tag from tags t, tagsIndex ti where t.tid = ti.tid AND ti.sid = ?", note_row.first) do |tag_row|
tags << tag_row.first
end
note_syntax = case note_row[3]
when "Shell"
"sh"
else
note_row[3].downcase
end
note_uuid = SecureRandom.uuid
FileUtils::mkdir_p("#{notebook_name}/#{note_uuid}.qvnote")
note_meta = {
created_at: Time.now.to_i,
updated_at: Time.now.to_i,
tags: tags,
title: note_row[1],
uuid: note_uuid
}
File.open("#{notebook_name}/#{note_uuid}.qvnote/meta.json", "w") { |f| f.puts note_meta.to_json }
note_content = {
title: note_row[1],
cells: [
{
type: "code",
language: note_syntax,
data: note_row[2]
}
]
}
File.open("#{notebook_name}/#{note_uuid}.qvnote/content.json", "w") { |f| f.puts note_content.to_json }
end