4 ms·
Really cool and smooth! One killer feature here will be auto translating to pandas for people to copy over snippets to their Jupyter notebooks. You don't want
by marto1 5y ago
Really cool and smooth! One killer feature here will be auto translating to pandas for people to copy over snippets to their Jupyter notebooks.
You don't want to know how many times I've been asked to do exactly that.
Other than that one can do that (somewhat clumsily) with postgres using file_fdw like:
CREATE FOREIGN TABLE mytable (
datetime timestamp(3) with time zone,
name text,
score integer,
) SERVER myserver
OPTIONS ( filename 'data/file1.csv', format 'csv' );
and then query as usual. More docs here: https://www.postgresql.org/docs/13/file-fdw.html https://www.postgresql.org/docs/13/file-fdw.html