@bitblit/ratchet-rdbms NPM | npm.io

4.0.355-alpha • Published 1 day ago

Install

Weekly downloads

-

License

Apache-2.0

Repository

Last release

1 day ago

@bitblit/ratchet-rdbms

Typescript library to simplify using relational database systems by externalizing the queries.

Introduction

Meant to be very similar to the ibatis/mybatis library in Java, which has the right level of abstraction of the RDBMS in my opinion.

You may wish to read the changelog

Installation

yarn install @bitblit/ratchet-rdbms

Usage

Paginator

https://cloudonaut.io/passwordless-database-authentication-for-aws-lambda/

(To understand the terminology here you may want to read this)

This library natively supports:

Cursor pagination (use columnName, sort, min, limit)
Keyset API pagination (use columnName, sort, min, max, maybe limit)
Seek API pagination (use columnName, sort, min, max, maybe limit)
Time-based (use columnName on a time column, sort, min, max, maybe limit)

This library doesn't support offset pagination (e.g., using limit/offset in MySql) out of the box. It does this on purpose - in general for large datasets offset pagination is an anti-pattern, and I hope by not supporting it natively it'll make it a little less likely that I'll use it when I get in a rush. Obviously its possible to still implement it using this architecture. At some point in the future I may give in and do it.

Testing

Ha! No, seriously - all testing is done using Jest. To run them:

yarn test

Contributing

Pull requests are welcome, although I'm not sure why you'd be interested!

@bitblit/ratchet-common get-port mysql2 tunnel-ssh

@everything-registry/sub-chunk-127

1 day ago

2 days ago

2 days ago

2 days ago

2 days ago

2 days ago

2 days ago

2 days ago

2 days ago

2 days ago

3 days ago

3 days ago

4 days ago

6 days ago

25 days ago

25 days ago

25 days ago

1 month ago

1 month ago

1 month ago

1 month ago

1 month ago

1 month ago

2 months ago

2 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

3 months ago

4 months ago

4 months ago

4 months ago

4 months ago

4 months ago

4 months ago

4 months ago

4 months ago

4 months ago

5 months ago

5 months ago

5 months ago

5 months ago

5 months ago

6 months ago

6 months ago

9 months ago

7 months ago

11 months ago

6 months ago

9 months ago

8 months ago

7 months ago

9 months ago

8 months ago

8 months ago

8 months ago

8 months ago

9 months ago

6 months ago

7 months ago

8 months ago

8 months ago

10 months ago

11 months ago

6 months ago

7 months ago

7 months ago

7 months ago

8 months ago

9 months ago

9 months ago

10 months ago

6 months ago

6 months ago

6 months ago

7 months ago

7 months ago

8 months ago

9 months ago

6 months ago

6 months ago

8 months ago

8 months ago

9 months ago

10 months ago

6 months ago

10 months ago

8 months ago

6 months ago

9 months ago

6 months ago

7 months ago

6 months ago

6 months ago

6 months ago

7 months ago

8 months ago

9 months ago

8 months ago

8 months ago

7 months ago

8 months ago

7 months ago

7 months ago

8 months ago

7 months ago

9 months ago

7 months ago

11 months ago

11 months ago

11 months ago

11 months ago

12 months ago

11 months ago

11 months ago

11 months ago

12 months ago

11 months ago

11 months ago

12 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago