dexie-better-types

Better types for dexie.js

The main improvement is in the type safety of where, orderBy and similar conditions, which now require that the keys and values passed match the containing type of the Table

how to use

First, install the types

1npm install --save-dev dexie-better-types

Then, use the Table type coming from dexie-better-types, rather than dexie itself.

1import Dexie from 'dexie';
2import type { Table } from 'dexie-better-types'
3
4class MyAppDatabase extends Dexie {
5    // Declare implicit table properties.
6    // (just to inform Typescript. Instantiated by Dexie in stores() method)
7    contacts!: Table<IContact, number>; // number = type of the primkey
8    //...other tables goes here...
9
10    constructor () {
11        super("MyAppDatabase");
12        this.version(1).stores({
13            contacts: '++id, first, last',
14            //...other tables goes here...
15        });
16    }
17}
18
19interface IContact {
20    id?: number,
21    first: string,
22    last: string
23}

example errors

Trying to use the wrong key:

1let res = await db.contacts.where('someKey').equals('someValue').toArray()

gets you an error message like the following

1No overload matches this call.
2  Overload 1 of 2, '(index: KeysOf<IContact>): WhereClause<IContact, KeysOf<IContact>, number>', gave the following error.
3    Argument of type '"someKey"' is not assignable to parameter of type 'KeysOf<IContact>'.
4  Overload 2 of 2, '(equalityCriterias: Partial<IContact>): Collection<IContact, number>', gave the following error.
5    Type '"someKey"' has no properties in common with type 'Partial<IContact>'.ts(2769)

The checks work for values too, i.e.

1let res = await db.contacts.where('first').equals(1).toArray()

yields the error

Argument of type 'number' is not assignable to parameter of type 'string'.ts(2345)

Compound keys up to 5 items are supported

1// Same error as above
2let res = await db.contacts.where(['first', 'last']).equals(['v1', 2]).toArray()