> Subject: [sqlite] Can more than one user connect to an in-memory database? > I don't see how. Any clues?
You could share the sqlite3* handle from the process that opens that in-memory database, through some mechanism of your own. Since all your users would be using the same connection, you would need to do your own locking though. For example, I have an application on a mobile device that uses an in-memory SQLite database. The application exposes a server socket that lets me issue SQL to the database remotely, through some wrapper functions in the application. Those functions have locking in them to prevent using the database handle from two threads at once. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users