[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
their entirety.

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.