Seed data

[maghoff]

For an improved development experience, there should be some seed data.

Complication: Diesel doesn't have any support for this at all. I would have to build it myself.

[killercup]

I'd be interested in a good solution for seeding data in an app that uses Diesel as well, but I don't think it's something that Diesel itself should do. SQLite supports importing CSV files, but I guess that might be too cumbersome.

I'd probably use serde-yaml and a bunch of #[derive(Insertable, Deserialize)].

[maghoff]

If Diesel would be handling this, I would imagine it would be in diesel-cli, not affecting the library.

However, after I added FTS, diesel-cli cannot even run the migrations; it links with a version of libsqlite3 which doesn't include FTS5 (on my system). Considering that, it might be unrealistic to expect diesel-cli to be able to handle seed data for me :)