FeralFlora

Exploring Zotero Data Model for Direct Database Access

This tutorial aims to provide technical information necessary for direct access to data stored in Zotero's local bibliographic database. The official documentation [mentions][Zotero Client Data Model] the present topic briefly, so I decided to post a more detailed discussion.

Zotero's local bibliographic database is an [SQLite][] database, the leading open-source relational database management system (RDBMS). Hence, direct access to this data necessitates basic familiarity with [relational databases][RDBMS] and [SQL][] (free SQL resources are readily available on the Internet, including the [official documentation][SQLite docs] focused on the SQLite SQL dialect and [this tutorial][SQLite SQL Tutorial]).

Table of Contents

Version History

V1 - initial release
V2: cleaned up the code a little, removed the black background behind the current day text as it wasn't precise. I left the code in there - just uncomment it. Removed an indent at the end to prevent breaking the SVG - thanks q on Discord!

Note

Reading View is BROKEN - wait for the plugin (assuming no surprises await me there). TBD - (when it gets done)™
Live Preview works as it should
Adjustments can be made at the top of the file

Quarto callouts

About callouts

Callouts are a great way to add more attention ot certain details of the text (in the form of a box). Quarto provides 5 different types of callouts:

note
warning
important

Typesetting with Pandoc Markdown: How I Take Notes

Preface

Over the past couple years in school, I've placed tremendous value in a few things:

Comprehensive, single-document summaries of courses I've taken;
Beautifully type-set reports;
Writing the bare-minimum of LaTeX to get by.

Using only the Windows cmd

Open the command prompt of windows
Type wmic
On the wmic prompt type the output command followed by the path of the txt file and the command to list the programs. It is going to be like the following:

/output:C:\Users\<yourUser>\Documents\programsInstalled\listOfProgramsInstalledWin10.txt product get name,version

Wait for the wmic prompt get back to you again and you'll know it has finished listing the files into the txt file

Python script to display the list of programs installed on windows

Paprika doesn't have their API documented, so this is me reverse-engineering it from an Android device

Live Demo

https://knowing-grain.glitch.me/

Code: https://glitch.com/edit/#!/knowing-grain

	Copyright 2024 Matthew Meyers, Fevol

	Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

	The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

	THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE US

	local stringify = (require "pandoc.utils").stringify
	-- idea aken from https://forum.obsidian.md/t/rendering-callouts-similarly-in-pandoc/40020/6 and modified to work with Quarto 1.3

	function BlockQuote(el)

	local start = el.content[1]

	if (start.t == "Para" and start.content[1].t == "Str" and
	start.content[1].text:match("^%[!%w+%][-+]?$")) then
	local firstline = stringify(start.content[1])

	declare module "obsidian" {
	interface App {
	isMobile: boolean;
	}
	}

	// Call this method inside your plugin's `onLoad` function
	function monkeyPatchConsole(plugin: Plugin) {
	if (!plugin.app.isMobile) {
	return;

	-- a lua filter for panodoc
	-- run pandoc your_word_doc.docx --track-change=all -t markdown --lua-filter=criticmarkup.lua
	-- TODO: Detect substitutions in adjacent insertion/deletions
	-- TODO: capture whole comment hightlight rather than just start point of comment
	function Span(elem)
	if elem.classes[1] and elem.classes[1] == "insertion" then
	local opener = { pandoc.RawInline(FORMAT, "{++ ") }
	local closer = { pandoc.RawInline(FORMAT, " ++}") }
	return opener .. elem.content .. closer
	elseif