Skip to content

Instantly share code, notes, and snippets.

View chriscarrollsmith's full-sized avatar

Christopher Carroll Smith chriscarrollsmith

View GitHub Profile
@boxabirds
boxabirds / .cursorrules
Last active October 29, 2025 23:48
Rock solid: turn Cursor into a rock-solid software engineering companion
# Project Policy
This policy provides a single, authoritative, and machine-readable source of truth for AI coding agents and humans, ensuring that all work is governed by clear, unambiguous rules and workflows. It aims to eliminate ambiguity, reduce supervision needs, and facilitate automation while maintaining accountability and compliance with best practices.
# 1. Introduction
> Rationale: Sets the context, actors, and compliance requirements for the policy, ensuring all participants understand their roles and responsibilities.
## 1.1 Actors
@pchemguy
pchemguy / Zotero_MainDB.md
Last active October 24, 2025 23:20
Exploring Zotero Data Model for Direct Database Access

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

@ih2502mk
ih2502mk / list.md
Last active December 9, 2025 08:55
Quantopian Lectures Saved