SQL New rows monitoring

About

Just check new rows by specified queries and send notification to ntfy

Now support MySQL only

Installation

brew tap yendefrr/tap
brew install sql-alerts

For linux use install.sh or download from latest release

Configuration

sqlal config # or edit `.config/sqlal/config.json

All queries must be SELECT type and query only one column that should be unique ID

For disable query provide "disabled": true parameter

Usage

After configuration run

sqlal start

or

sqlal start --config <path-to-config> 

To stop service

sqlal stop

TODO

• Other SQL drivers
• DB configuration
• Validation
• Run in background