Skip to content
New issue

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

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

Already on GitHub? # to your account

"Preview table" doesn't seem to work with sqlite #492

Closed
dgmora opened this issue Feb 15, 2025 · 2 comments
Closed

"Preview table" doesn't seem to work with sqlite #492

dgmora opened this issue Feb 15, 2025 · 2 comments

Comments

@dgmora
Copy link

dgmora commented Feb 15, 2025

Hello, I was trying blazer with sqlite3 and it seems the statement to fetch the tables doesn't work. As a consequence preview table here is empty:

Image

It seems the statement used isn't valid for sqlite. From what I've seen, this one works:

SELECT name FROM sqlite_master where type = 'table'

There are also no schemas in sqlite, and for the result to work you have to do result.rows.map(&:first).sort instead of &:second. I'm wondering, was this working before?

@ankane ankane closed this as completed in d03141f Feb 15, 2025
@ankane
Copy link
Owner

ankane commented Feb 15, 2025

Hi @dgmora, thanks for reporting. Fixed in the commit above.

@dgmora
Copy link
Author

dgmora commented Feb 15, 2025

Thanks for the quick follow up, works great!

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

No branches or pull requests

2 participants