Create multiple sqlite tables, many-to-many design
Chris Angelico wrote:
> I prefer to say "Trails" for the table, and "Trail" would then refer
> to a single row from that table.
That makes sense for a data structure in your program that contains a
collection of rows. But I've come to the view that SQL tends to read
better if the names of the database tables are singular, because in SQL
you're writing assertions about individual rows, not the tables in
So I would write something like
select T.name, T.id from Trail T
but I would assign the resulting list of rows to a variable named
"trails" in my program.