<commit_before># mysql-live-select

NPM Package to provide events when a MySQL select statement result set changes.

Built using the [`zongji` Binlog Tailer](https://github.com/nevill/zongji) and [`node-mysql`](https://github.com/felixge/node-mysql) projects.

* [Example Application using Express, SockJS and React](https://github.com/numtel/reactive-mysql-example)
* [Meteor package for reactive MySQL](https://github.com/numtel/meteor-mysql)
* [NPM Package for Sails.js connection adapter integration](https://github.com/numtel/sails-mysql-live-select)
* [Analogous package for PostgreSQL, `pg-live-select`](https://github.com/numtel/pg-live-select)

This package has been tested to work in MySQL 5.5.40 and 5.6.19. Expected support is all MySQL server version >= 5.1.15.

## Installation

* Add the package to your project:
  ```bash<commit_msg>Add description<commit_after># mysql-live-select

NPM Package to provide events when a MySQL select statement result set changes.

NOTE: This version of mysql-live-select differs from numtel's original package
in that result sets are treated as dictionaries rather than arrays. The original
package's diffing emits incorrect (with respect to the primary key) events when
rows are inserted or deleted at any position other than the end of the array. In
this version, the identity of each row is determined by a `LiveMysqlKeySelector`
that is passed into the `select` function. The most common use case is
`LiveMysqlKeySelector.Columns([primary_key_column])`, which ensures that row
insertions and deletions are detected based on the value of
`primary_key_column`.

Built using the [`zongji` Binlog Tailer](https://github.com/nevill/zongji) and [`node-mysql`](https://github.com/felixge/node-mysql) projects.

* [Example Application using Express, SockJS and React](https://github.com/numtel/reactive-mysql-example)
* [Meteor package for reactive MySQL](https://github.com/numtel/meteor-mysql)
* [NPM Package for Sails.js connection adapter integration](https://github.com/numtel/sails-mysql-live-select)
* [Analogous package for PostgreSQL, `pg-live-select`](https://github.com/numtel/pg-live-select)

This package has been tested to work in MySQL 5.5.40 and 5.6.19. Expected support is all MySQL server version >= 5.1.15.

## Installation

* Add the package to your project:
  ```bash
{'fraction_non_alphanumeric': 0.10544363480497214, 'fraction_numerical': 0.010287183883411917, 'mean_word_length': 4.954081632653061, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 5, 'https://': 12, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1904806', 'n_tokens_mistral': 724, 'n_tokens_neox': 676, 'n_words': 244}