The CSV Virtual Table

Re:The CSV Virtual Table by punnerud on Wednesday March 09, 2022 @05:08AM (#30612823)

Any possibility to also add index to a virtual table in SQLite? Normally you can’t: https://sqlite.org/vtab.html

[ Parent | on HN ]

Re:The CSV Virtual Table by frabert on Wednesday March 09, 2022 @08:35AM (#30614234)

You could just

  INSERT INTO regular_table SELECT * FROM csv_table

and then create an index for regular_table

[ Parent | on HN ]

Re:The CSV Virtual Table by codemonkey-zeta on Wednesday March 09, 2022 @10:27AM (#30615483)

Genuine question - why start with a virtual table at all in this case? Why not just import the data to regular_table from the csv file?

[ Parent | on HN ]

Re:The CSV Virtual Table by CRConrad on Thursday March 10, 2022 @09:13AM (#30627080)

Apparently this is for when you decide not to create indexes etc on the data, presumably to save disk space or something.

[ Parent | on HN ]