Introduce testing suite

[maxpert]

Following are required to be done:

• Integration tests on CDC watching and publishing to NATS
• Integration tests of reapplying change logs from NATS
• Snapshot save/restore testing
• SQLite Tcl level testing suite integration

[mindreframer]

This is a very good issue! Having some kind of testing suite for a foundational building block of distributed systems + data storage is a "MUST" feature, if we care about our users data.

I could observe long delays in change propagation locally, it required another change for all changes to become visible on all nodes.

Embedding NATS Jet Stream is genius, and I think it's possible to get away with a smaller test suite, because we can assume that NATS is doing its job correctly.

[gedw99]

yep agree that development needs a system to consistently see bugs.

also devs that experience bugs can supply seed data for reproduction of bug, so that we can both track down bugs but add them into seed data and tests to avoid regressions.

Are there any proposals for how to do this ?

• seed data into SQL
• Tests that work against the seed data
• Nats cluster setup and tear down
• Chaos on nats Cluster like loosing one or upgrading using lame duck mode, so we related failure modes.

Do we presume Linus only ? Some users might be running SQLite on desktops with marmot on Linus server.