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 🙏

© 2025 – Pkg Stats / Ryan Hefner

tofulite

v0.0.6

Published

SQL query wrapper with sqlite support

Readme

tofulite

tofulite is an SQL query wrapper library with support for sqlite3 written in TypeScript because SQL scripts are hard to remember.

CI Status

API

Usage examples can be found in the test files.

Query objects

There are 5 total query objects for the following SQL operations:

  • Create table (CreateTableQuery)
  • Drop table (DropTableQuery)
  • Insert* (InsertQuery)
  • Select* (SelectQuery)
  • Delete* (DeleteQuery)

Each of these can be turned into an SQL query in string format by calling sql() so they could be used for other databases besides sqlite as they are fairly basic queries.

Queries marked with * are parameterised - these return the string format with ?s in them for any value when you call sql() and you can get the values separately by calling parameters().

Session

Session is simply a class that wraps an instance of a sqlite3.Database. You can use this class to run the query objects without turning them into strings/raw SQL. Session serves more as a helper class - it is completely possible to use all the query objects without ever touching this class.

If you want to make use of Session, you will need to make sure you have sqlite3 installed as a dependency yourself as it is a peer dependency of this package.

You can instantiate a new instance of Session in 4 different ways:

  • new Session(db) - takes an existing sqlite3.Database object as param
  • Session.inMemory() - equivalent to new sqlite3.Database(":memory:")
  • Session.anonymous() - equivalent to new sqlite3.Database("")
  • Session.fromFile(filename) - equivalent to new sqlite3.Database(filename)

Stuff for future

  • definitely need to make wheres better
  • joins
  • constraints
  • alter
  • jsdoc comments
  • update this readme more