sqlittle icon indicating copy to clipboard operation
sqlittle copied to clipboard

Published 20 hours ago • verified publisher icon alicebob

SQL view support

Open asmyasnikov opened this issue 5 years ago • 1 comments

Hi! Thank you for your project. I tried using sqlittle for read some databes (mbtiles), which contains views for representing row data as mbtiles standart tables. But I have fail =( How to select data from views? Can sqlittle support views?

asmyasnikov avatar Feb 28 '20 16:02 asmyasnikov

Hi! Thank you for your project. I tried using sqlittle for read some databes (mbtiles), which contains views for representing row data as mbtiles standart tables. But I have fail =( How to select data from views? Can sqlittle support views?

I expect views to be nothing more than a query, and not an actual table. So to select from the view SQLite needs to execute that query. Executing queries is something sqlittle can't do, unfortunately.

alicebob avatar Feb 28 '20 17:02 alicebob