how to open database from exists stream ?

[xibaoning]

var conn=new DuckDBConnection(stream) ??

[Giorgi]

You can't open from stream, why would you want to do that?

[Cricle]

The duckdb api limit

[mldisibio]

Actually, it is a feature of sqlite and not an entirely crazy ask.
That said, it is not part of the duckdb api, and therefore a client library wrapping the native api (IMHO) probably shouldn't try to add features not in the api itself.

It's a corner use-case. Say I download a sqlite file stored on a remote file server, knowing it fits in memory, and want to run a query without saving the file to disk. In particular, if the query is served by a web api, but the sqlite file is remote, perhaps compressed and needs to be retrieved first, but is discarded after serving the query.

[xibaoning]

For example, green software can embed data as resources within the executable. If the data can be read directly from the stream during runtime, there would be no need to extract the executable to a physical file. Perhaps you could try reaching out to the official team and see if they can assist with this.

…

------------------ 原始邮件 ------------------ 发件人: ***@***.***>; 发送时间: 2024年11月19日(星期二) 凌晨3:34 收件人: ***@***.***>; 抄送: ***@***.***>; ***@***.***>; 主题: Re: [Giorgi/DuckDB.NET] how to open database from exists stream ? (Discussion #140) Actually, it is a feature of sqlite and not an entirely crazy ask. That said, it is not part of the duckdb api, and therefore a client library wrapping the native api (IMHO) probably shouldn't try to add features not in the api itself. It's a corner use-case. Say I download a sqlite file stored on a remote file server, knowing it fits in memory, and want to run a query without saving the file to disk. In particular, if the query is served by a web api, but the sqlite file is remote, perhaps compressed and needs to be retrieved first, but is discarded after serving the query. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>

[Giorgi]

If DuckDB adds an API for it I will consider supporting it. Until then this isn't going to be implemented.