On Sat, Sep 13, 2025, 7:19 PM Andrzej Krzemienski <akrzemi1@gmail.com> wrote:
sob., 13 wrz 2025 o 10:28 Klemens Morgenstern via Boost < boost@lists.boost.org> napisał(a):
Having a deeper look at SQLite, I now realize that you actually cannot
work
with two statements on one connection concurrently (this is not related to multi-threading):
That would be news to me. Can you be a bit more specific about what you mean by "cannot"?
Maybe I should have made that a question rather than a statement. Would the following concurrent use of two statements work without any resource-management issues?
``` auto query1 = conn.prepare("select * FROM table1"); auto query2 = conn.prepare("select * FROM table2");
auto combined = std::views::zip(statement_range<T1>(query1),
statement_range<T2>(query2));
for (auto record: combined) process(record); ``` ("Concurrent" in the sense that I progress over the second statement without having finished with the first one.)
Yes.
Regards, &rzej;