home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 575321322

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/datasette/issues/657#issuecomment-575321322 https://api.github.com/repos/simonw/datasette/issues/657 575321322 MDEyOklzc3VlQ29tbWVudDU3NTMyMTMyMg== 1055831 2020-01-16T20:01:43Z 2020-01-16T20:01:43Z NONE

I have successfully tested datasette using a parquet VIRTUAL TABLE. In the first terminal:

datasette airports.db --load-extension=libparquet

In another terminal I load the same sqlite db file using the sqlite3 cli client.

$ sqlite3 airports.db

and then load the parquet extension and create the virtual table.

sqlite> .load /home/darreng/metars/libparquet sqlite> CREATE VIRTUAL TABLE mytable USING parquet('/home/xx/data.parquet');

Now the parquet virtual table is usable by the datasette web UI.

Its not an ideal solution but is a proof that datasette works the parquet extension.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
548591089  
Powered by Datasette · Queries took 0.76ms · About: github-to-sqlite