On 2016/05/25 5:42 PM, Balaji Ramanathan wrote:
Thanks again, Ryan. The options right now come down to either expanding
the view with all the raw columns so that I can filter and sort directly
using a select * from view. Or I can use the view for unfiltered, unsorted
look at my data, and use the query of the view to do filtering and
sorting. Decisions, decisions . . .
I vote for more extensive support of hidden columns in tables, views, etc.
Is there some site for submitting enhancement requests for SQLite?
Indeed, this right here is the very place to submit such requests. You
can count it as submitted.
As for hidden columns in Views, I think that request is in already from
before. There are a few considerations when pondering new additions that
the Devs have to balance, they are mainly (but not confined to, and in
no particular order):
Development time,
Request Urgency/Frequency,
Backwards Compatibility,
Code-Size Increase,
and the SQL Standard.
I think your request will fly through the Development time check, it
should not be a great time expense. Problems come in with request
frequency, it's really not a frequently asked thing, nor a very urgent
one, quite a nice-to-have really. It should not break backward
compatibility and while SQLite needs to remain "Lite", I think the code
size will not be greatly affected.
I am unsure what the SQL standard says on Views with hidden columns.
I could be wrong on any of the above points, these are just from my POV
trying to explain what can be expected from the request. The devs will
consider based on the above and then decide to do it and/or to do it
soonest or put in the long queue.
Some days Richard has a sudden bit of inspiration or likes an idea, and
miraculously you will see a new commit on trunk that includes the
functionality the very next day - but mostly it will come in due course. :)
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
