@abaxx/sql
v0.1.3
Published
SQL data connectors for MessageStore, DataStore, and EventLog
Downloads
21
Readme
ID++ DWN SQL Stores
SQL backed implementations of DWN MessageStore
, DataStore
, and EventLog
.
Supported DBs
- SQLite ✔️
- MySQL ✔️
- PostgreSQL ✔️
Installation
npm install @dwn-protocol/dwn-sql-store
Usage
SQLite
import Database from 'better-sqlite3';
import { Dwn } from '@dwn-protocol/dwn-sdk-js'
import { SqliteDialect, MessageStoreSql, DataStoreSql, EventLogSql } from '@dwn-protocol/dwn-sql-store';
const sqliteDialect = new SqliteDialect({
database: async () => new Database('dwn.sqlite', {
fileMustExist: true,
})
});
const messageStore = new MessageStoreSql(sqliteDialect);
const dataStore = new DataStoreSql(sqliteDialect);
const eventLog = new EventLogSql(sqliteDialect);
const dwn = await Dwn.create({ messageStore, dataStore, eventLog });
MySQL
import { createPool } from 'mysql2';
import { Dwn } from '@dwn-protocol/dwn-sdk-js'
import { MysqlDialect, MessageStoreSql, DataStoreSql, EventLogSql } from '@dwn-protocol/dwn-sql-store';
const mysqlDialect = new MysqlDialect({
pool: async () => createPool({
host : 'localhost',
port : 3306,
database : 'dwn',
user : 'root',
password : 'dwn'
})
});
const messageStore = new MessageStoreSql(mysqlDialect);
const dataStore = new DataStoreSql(mysqlDialect);
const eventLog = new EventLogSql(mysqlDialect);
const dwn = await Dwn.create({ messageStore, dataStore, eventLog });
PostgreSQL
import pg from 'pg';
import Cursor from 'pg-cursor';
import { Dwn } from '@dwn-protocol/dwn-sdk-js'
import { PostgresDialect, MessageStoreSql, DataStoreSql, EventLogSql } from '@dwn-protocol/dwn-sql-store';
const postgresDialect = new PostgresDialect({
pool: async () => new pg.Pool({
host : 'localhost',
port : 5432,
database : 'dwn',
user : 'root',
password : 'dwn'
}),
cursor: Cursor
});
const messageStore = new MessageStoreSql(postgresDialect);
const dataStore = new DataStoreSql(postgresDialect);
const eventLog = new EventLogSql(postgresDialect);
const dwn = await Dwn.create({ messageStore, dataStore, eventLog });
Development
Prerequisites
node
and npm
This project is using node v20.3.0
and npm v9.6.7
. You can verify your node
and npm
installation via the terminal:
$ node --version
v18.13.0
$ npm --version
9.7.2
If you don't have node
installed. Feel free to choose whichever approach you feel the most comfortable with. If you don't have a preferred installation method, i'd recommend using nvm
(aka node version manager). nvm
allows you to install and use different versions of node. It can be installed by running brew install nvm
(assuming that you have homebrew)
Once you have installed nvm
, install the desired node version with nvm install vX.Y.Z
.
Docker
Docker is used to spin up a local containerized DBs for testing purposes. Docker from here
Running Tests
💡 Make sure you have all the prerequisites
- clone the repo and
cd
into the project directory - Install all project dependencies by running
npm install
- start the test databases using
./scripts/start-databases
(requires Docker) - run tests using
npm run test
npm
scripts
| Script | Description |
| ----------------------- | ------------------------------------------- |
| npm run build:esm
| compiles typescript into ESM JS |
| npm run build:cjs
| compiles typescript into CommonJS |
| npm run build
| compiles typescript into ESM JS & CommonJS |
| npm run clean
| deletes compiled JS |
| npm run test
| runs tests. |
| npm run test-coverage
| runs tests and includes coverage |
| npm run lint
| runs linter |
| npm run lint:fix
| runs linter and fixes auto-fixable problems |