Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

enable query or list of vtables #37

Open
judell opened this issue Nov 28, 2023 · 3 comments
Open

enable query or list of vtables #37

judell opened this issue Nov 28, 2023 · 3 comments

Comments

@judell
Copy link
Collaborator

judell commented Nov 28, 2023

This comes up empty:

sqlite> select * FROM sqlite_master WHERE type='table';

Is there another way to list out the vtables we provide?

Of course there's always the hub. And if I know I have e.g. github_issue I can do this:

sqlite> pragma table_info('github_issue');
0|repository_full_name|TEXT|0||0
1|number|INT|0||0
2|id|INT|0||0
3|node_id|TEXT|0||0
4|active_lock_reason|TEXT|0||0
5|author|TEXT|0||0

Still it would be nice if we populated sqlite_master.

sqlite> pragma table_info('sqlite_master');
0|type|TEXT|0||0
1|name|TEXT|0||0
2|tbl_name|TEXT|0||0
3|rootpage|INT|0||0
4|sql|TEXT|0||0
@binaek
Copy link
Contributor

binaek commented Nov 29, 2023

SQLite recommends that we don't modify the sqlite_master table.

Reference: Creation and Modification Of The Schema Table section of the SQLite documentation on sqlite_master. (https://www.sqlite.org/schematab.html)

@judell
Copy link
Collaborator Author

judell commented Nov 30, 2023

Fair enough. I retitled this 'enable querying for vtables'

@judell judell changed the title populate sqlite_master with vtables? enable query or list of vtables Dec 4, 2023
@binaek
Copy link
Contributor

binaek commented Dec 14, 2023

@judell we feel that having a parallel to .inspect should resolve this. (#11)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants