Drizzle Solid Development

Expert guidance for developing with Drizzle Solid - a TypeScript ORM adapter that translates SQL-like Drizzle operations into SPARQL queries for Solid Pod RDF data storage.

What This Skill Does

This skill provides comprehensive assistance for working with the drizzle-solid codebase, including:

Instructions

When the user asks for help with drizzle-solid development, follow these steps:

1. Understand the Request Context

Identify what aspect of drizzle-solid the user needs help with:

2. Locate Relevant Files

Based on the request, navigate to the appropriate files:

3. Provide Development Commands

When the user asks about building, testing, or running the project, provide the relevant commands:

**Build and Quality:**

```bash

yarn build # Compile TypeScript to dist/

yarn test # Run all tests

yarn test:watch # Watch mode

yarn test:coverage # Coverage report

yarn lint # Check linting

yarn lint:fix # Auto-fix issues

yarn quality # Lint + test (CI)

```

**Development:**

```bash

yarn dev # Run with ts-node

yarn example:setup # Pod setup tutorial

yarn example:auth # Authentication demo

yarn example:usage # CRUD walkthrough

yarn server:start # Start CSS server

yarn server:setup # Create test accounts

```

4. Explain Architecture Components

When explaining how drizzle-solid works, describe the data flow:

1. **Query Building**: User writes Drizzle queries (select, insert, update, delete)

2. **AST Conversion**: SQL AST is converted to SPARQL via `ASTToSPARQLConverter`

3. **Execution Strategy**:

- Simple operations use native SPARQL via Comunica

- Complex operations (aggregates, JOINs) use client-side fallback

4. **RDF Mapping**: Results are mapped back to TypeScript objects via table schemas

**Key Components:**

5. Handle Conflict Resolution Requests

If the user asks about handling concurrent writes or 412 errors, explain the conflict resolution strategies:

**Strategies:**

**Example usage:**

```typescript

import { saveWithConflictResolution } from 'drizzle-solid';

const result = await saveWithConflictResolution(

session.fetch,

'https://pod.example/data/notes.ttl',

async (dataset) => {

// Modify dataset

return updatedDataset;

}

);

```

6. Provide Testing Guidance

For testing-related questions:

7. Follow Code Patterns

When modifying code, ensure:

8. Reference Examples

Direct users to example files for complete patterns:

9. Provide Code References

When referencing specific functionality, use the pattern `file_path:line_range` to help users navigate:

Key Dependencies Context

Testing Requirements

Important Notes

Example Usage

**Basic CRUD with Drizzle Solid:**

```typescript

import { drizzle } from 'drizzle-orm/pod';

import { podTable } from 'drizzle-solid';

import { Session } from '@inrupt/solid-client-authn-node';

const session = new Session();

await session.login(/* ... */);

const usersTable = podTable('users', {

id: 'string',

name: 'string',

email: 'string',

createdAt: 'date'

});

const db = drizzle(session, {

schema: { users: usersTable }

});

// Insert

await db.insert(usersTable).values({

id: '1',

name: 'Alice',

email: '[email protected]',

createdAt: new Date()

});

// Select

const allUsers = await db.select().from(usersTable);

```