:warning: ATTENTION: THIS PACKAGE HAS UNSOLVED PROBLEMS, IS THEREFORE ABANDONED, AND ARCHIVED. BETTER DON'T USE IT.

@destacks/sql

Simple SQL querying using template literals with optional Zod schema validation.

Overview

@destacks/sql executes SQL queries using template literals with an optional Zod schema validation feature. It builds upon @libsql/client and sql-template-tag to offer templated database interactions, with optional TypeScript static typing, and runtime data validation.

Features

- SQL Query Execution: Execute SQL queries against libSQL (SQLite-like) databases.
- Configuration Flexibility: Supports local, remote, and hybrid database configurations.
- Zod Schema Validation: Optional integration for TypeScript static typing and runtime data validation.
- Support for Multiple Environments: Compatible with Node.js, browsers, and cloud or edge hosted environments.

Getting Started

$3

``bash
npm i @destacks/sql
`

$3

#### Creating a Database Client

`javascript
import { createClient } from "@destacks/sql";

// For a local SQLite database
const localClient = createClient({ url: "file:local.db" });

// For a remote libSQL database
const remoteClient = createClient({
url: "libsql://[your-sqld-host]",
authToken: "[your-token]",
});
`

#### Defining a Zod Schema

`typescript
import { z } from "zod";

const UserSchema = z.object({ id: z.string(), name: z.string() });
`

#### Executing SQL Queries

With schema validation:

`typescript
import { sql } from "your-utility-path";

sql(UserSchema)SELECT * FROM users WHERE id = ${userId};
`

Without schema validation:

`javascript
sqlSELECT * FROM users WHERE id = ${userId};
`

$3

- Local SQLite Files: Use file: URLs for local SQLite databases. Supported on Node.js environments.
- libSQL sqld Instances: Connect using libsql: URLs, with support for HTTP or WebSocket protocols. Suitable for both local and remote databases.
- Remote Databases: Access databases hosted on services like Turso. Requires authToken for secured access.

Usage in React Projects

@destacks/sql/react provides a specialized module for React projects, integrating with server-cli-only for execution in React Server Components and Node.js CLI environments.

$3

`javascript
import { createClient, createSql } from "@destacks/sql/react";
`

For more information on how server-cli-only works and its integration, refer to the server-cli-only npm package.

$3

To integrate @destacks/sql into your Next.js project, you need to update your Next.js configuration. This involves adding @destacks/sql to the serverComponentsExternalPackages array under the experimental key in your next.config.js file. Here's how you can do it:

`javascript
// next.config.js

const nextConfig = {
experimental: {
serverComponentsExternalPackages: ["@destacks/sql"],
},
};

module.exports = nextConfig;
`

This configuration ensures that @destacks/sql is recognized and properly handled by the Next.js framework, particularly when dealing with server components.

More Information

For detailed usage and configuration options, refer to the npm package of @destacks/sql`.

License

MIT License.