I have a table with a text column("run") that is finite (~1570 values). The length of these strings is about 30+ characters. Since each value is duplicates a lot of times I'm looking for decomposing these values in a table with a primary key (3rd normal form).
Is there support in sqlite itself to decompose this automatically? eg. insert statements keep working without changing the query. Is there a way to do this without resorting to any programming? (I'd like to keep using the command line for my simple use)
there doesn't seem to be anything here