Simon Binder

Good catch Mike, I overlook these issues all the time. @Beloin At the moment, I'd recommend to rename the `data` column to something else. I'll integrate a mechanism into the...

You can use inheritance to declare tables in Dart ```dart abstract class BaseTable class Table { IntColumn get id => ... IntColumn get fkTableY => IntColumn get fkTableZ => }...

Yeah, sqlite on a server doesn't really scale, MariaDb/MySQL will work much better. I just managed to connect moor to a MySql server [here](https://github.com/simolus3/moor/tree/develop/examples/mysql), but it already throws at the...

Good to know, thanks. I'll take a look at it. We use [sqljockey](https://pub.dev/packages/sqljocky5) for MySQL, which seems to work good so far. The main problem is that database engines all...

> Any tips (steps) on how to start to provide such feature ? There are different aspects to this: 1. Moor needs to be able to send statements to a...

Did you run into problems with the copy-and-sync files approach? You could open two databases at once using `ATTACH` and then copy the data over using nothing but sql. It's...

Your approach sounds like it could work. Moor doesn't have a builtin hook to get notified about statements before they are sent. However, you could write a custom method to...

Do you write data in your `onCreate` function? If not, you could just create another instance of your database class that uses a different database file. You can just call...

> and I don't know what I am doing if I set `moorRuntimeOptions.dontWarnAboutMultipleDatabases = true` In earlier moor versions, I got many reports from users seeing that their tables didn't...

There are a number of possible solutions that come to mind. For new and updated rows, you could have a column to describe their state (e.g. whether the row was...