Carl Sverre

Unfortunately alter tables in SingleStore don't operate within user defined transactions. So it's not possible to perform this entire column change process atomically.

SingleStoreDB supports the following flow fine: ``` MemSQL [test]> start transaction; Query OK, 0 rows affected (0.001 sec) MemSQL [test]> insert into foo values (2); Query OK, 1 row affected...

After investigation, it appears that SingleStore does not clear client transaction state the same way that MySQL does after a rollback. This unfortunately means that based on how PDO/MySQL is...

I actually haven't seen that lib before! Thanks for pointing it out. I just reviewed the code and it appears to follow the design of react-outlet pretty accurately. The general...

> are there any thoughts for observables ? I've been working on a new version of the SQLSync storage engine so haven't been focused on the high level APIs lately....

Since SQLite changes it's header on every write to the database file, we should consider extracting the header (or simply the first page) out into the snapshot (or just sending...

The initial goal is to just get a loadable extension that works with the native [run-time loadable extension system](https://www.sqlite.org/loadext.html). This will ideally make SQLSync work with the largest amount of...

# Research notes as of Jan 24 2024 ## [sqlite-loadable-rs](https://github.com/asg017/sqlite-loadable-rs) - seems like a fairly mature library for implementing extensions using rust - [vfs support is only available in a...

The TODO demo should show this status in a nice way. Both to expose the concept more clearly and to provide a better TODO UX.

Currently the server stores all timelines in memory until server restart