Does libzdb support sqlite in-memory database?

Issue #29 closed
Former user created an issue

This project is very awesome, but when I want to use sqlite in-memory database URL to create URL object the result doesn't as I expected.

I'm use URL like below : "sqlite://:memory:?cache=shared".

It will return error message as below: "SQLException: Failed to start connection pool -- no database specified in URL raised in ConnectionPool_start at src/db/ConnectionPool.c:295"

So I'd like to know that is this project support sqlite in-memory database? Thanks.

Comments (2)

  1. Tildeslash repo owner

    From the SQLite documentation:

    If the filename is ":memory:", then a private, temporary in-memory database is created for the connection. This in-memory database will vanish when the database connection is closed.

    In other words, an in-memory database cannot be shared between connections and will be deleted when the connection closes. There isn't a useful use-case for an in-memory database together with a connection pool so libzdb does not support it.

  2. Log in to comment