https://lakefs.io/ logo
#help
Title
# help
r

Robin Moffatt

03/15/2023, 6:58 AM
i'm playing around with DuckDB on the object page. Should something like this work? I'm getting no rows returned and from devtools it's looking for the wrong path.
a

Ariel Shaqed (Scolnicov)

03/15/2023, 7:04 AM
Odd... I think it looks like a (valid) S3 host-style access, despite you asking for path-style.
r

Robin Moffatt

03/15/2023, 8:02 AM
yeah, that's what I thought. The same set of commands run from duckdb CLI work just fine. it's weird.
o

Oz Katz

03/15/2023, 10:31 AM
I think we should probably clarify this on the docs as well: when running in the browser, using duckdb-wasm, you won't be able to use the settings this way. the instructions are intended for running duckdb as a standalone or external component. I don't think duckdb-wasm is s3 capable and cares about these settings
S3 settings for DuckDB:
S3 settings for duckdb-WASM:
r

Robin Moffatt

03/15/2023, 10:44 AM
thanks @Oz Katz. I was thinking we should document it in general anyway - it took me a while to figure out that
lakefs_object
was a macro, etc.
o

Oz Katz

03/15/2023, 10:45 AM
I agree
r

Robin Moffatt

03/15/2023, 10:46 AM
wow - TIL
ILIKE
🤯
is that duckdb-specific or generally adopted SQL? not seen it before
a

Ariel Shaqed (Scolnicov)

03/15/2023, 10:46 AM
Exists on PostgreSQL. Look at their docs, they usually say if it's standard or not.
👍 1
r

Robin Moffatt

03/15/2023, 10:47 AM
is the difference in S3 settings between duckdb and duckdb-wasm something that's worth logging a ticket on their side for (i.e. does it make sense for them to be the same, or in wasm-land would it not - I don't grok wasm enough to understand)
o

Oz Katz

03/15/2023, 10:55 AM
I don't think
ILIKE
is ansi sql, but many databases support it.
Yes, I think it's worth opening an issue for it.
I don't think there's a technical limitation not to support these settings for the WASM version, but maybe there are security implications.
👍 1
a

Ariel Shaqed (Scolnicov)

03/15/2023, 10:58 AM
The fine manual says:
The key word
ILIKE
can be used instead of
LIKE
to make the match case-insensitive according to the active locale. This is not in the SQL standard but is a PostgreSQL extension.
r

Robin Moffatt

03/15/2023, 11:24 AM
Yes, I think it's worth opening an issue for it.
logged https://github.com/duckdb/duckdb/issues/6729
🤘 1
for info, there is work being done on wasm, and a new ticket to track here https://github.com/duckdb/duckdb-wasm/issues/1207
3 Views