I'm figuring out sqlite "create view" syntax details. At first glance, I thought sqlite views were only selections, with no way to rename columns. But actually, the full syntax for renaming columns is supported.
Accordingly, I've revamped the way tables are created, so that I can make views in the sqlports-compact representation for user-friendlyness. Specifically, it's getting to the point where all the "user" information in sqlports-main is now accessible in sqlports-compact as views (I have the main ports table to finish and that's about it). This change means mksqlitedb is a lot more aware of relationships between tables, so the schema was also modified to be more correct (I need to test it, but it should have correct constraints and column types for more regarding databases like postgres). I also removed an arbitrary limitation from sqlitebrowser, since there's no reason for it not to be able to see views as well as tables. Once I catch up with landry and discuss pkg_manager, we might swap the names, so that the internal tables of sqlports-compact are renamed, and the views get the "normal" visible names. All in all, it means there should be very little use left for the old sqlports-plain database...
