npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2024 – Pkg Stats / Ryan Hefner

@hebilicious/libsql-client

v0.0.4

Published

libSQL driver for TypeScript and JavaScript

Downloads

2

Readme

JavaScript & TypeScript SDK for libSQL

Node.js CI License

This is the source repository of the JavaScript & TypeScript SDK for libSQL. You can use it to interact with the following types of databases:

Installation

npm install @libsql/client

This step is not required if using the Deno style import shown below.

Create a database client object

Importing

There are multiple ways to import the module. For Node.js and other environments where you need to use a local SQLite file URL, as well as network access to sqld:

import { createClient } from "@libsql/client";

For environments that don't have a local filesystem, but support HTTP or WebSockets, including:

  • Browsers
  • CloudFlare Workers
  • Netlify Edge Functions
import { createClient } from "@libsql/client/web";

For environments that only support HTTP, including Vercel Edge Functions:

import { createClient } from "@libsql/client/http";

For Deno:

// replace [version] with the client version
import { createClient } from "https://esm.sh/@libsql/client@[version]/web";

Local SQLite files

To connect to a local SQLite database file using a local file URL:

const config = {
  url: "file:local.db"
};
const db = createClient(config);
const rs = await db.execute("SELECT * FROM users");
console.log(rs);

libSQL sqld instance

To connect to a libSQL sqld instance using a libsql: URL:

import { createClient } from "@libsql/client"

const config = {
  url: "libsql://[your-sqld-host]",
  authToken: "[your-token]"
};
const db = createClient(config);
const rs = await db.execute("SELECT * FROM users");
console.log(rs);

If you are querying a sqld instance on your local machine, add ?tls=0 to the URL to disable TLS.

authToken in the config object is a token that your sqld instance recognizes to allow client access. For Turso databases, a token is obtained using the Turso CLI. No token is required by default when running sqld on its own.

Supported URLs

The client can connect to the database using different methods depending on the scheme (protocol) of the passed URL:

Local SQLite file URLs

A file: URL connects to a local SQLite database (using better-sqlite3).

  • This is only supported on Node.js. It will not work in the browser or with most hosted environments that don't provide access to a local filesystem.
  • file:/absolute/path or file:///absolute/path is an absolute path on local filesystem.
  • file:relative/path is a relative path on local filesystem.
  • file://path is not a valid URL.

libSQL sqld instances

The client can connect to sqld using HTTP or WebSockets. Internally, it uses the Hrana protocol implemented by hrana-client-ts.

libsql URLs

libsql: URL leaves the choice of protocol to the client. We are now using HTTP by default, but this may change in the future.

  • By default, a libsql: URL uses TLS (i.e. https: or wss:).
  • To disable TLS, you can pass the query parameter ?tls=0. You will also need to specify the port.

HTTP URLs

http: or https: URLs connect to sqld using HTTP.

  • This is supported in Node.js and in every environment that supports the Web fetch API.

WebSocket URLs

ws: or wss: URLs use a stateful WebSocket to connect to sqld.

  • WebSockets are supported in Node.js and browser.
  • If you are running in a cloud or edge hosted environments, you should check to see if WebSockets are supported. If not, change the URL to use an HTTP URL.

Additional documentation

You can find more examples of how to use this library using the Turso docs for JS&TS.

License

This project is licensed under the MIT license.

Contribution

Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in @libsql/client by you, shall be licensed as MIT, without any additional terms or conditions.