SQLITE as sql server

[Aji Enrico]

Hi

Been searching the forums, doc and all mighty Google for 3 days straight but can't seem to get this answer, so I turn to you guys n gals for answer.

Overview:
I want "APPLICATION A" to act as an admin application and hold the SQLITE database.
I want "APPLICATION B" to act as a client application and connect to the database in "APPLICATION A".

is this possible with SQLITE?

I do not want to have a 3rd application like a standalone SQL server (read MySQL), mainly want the APPLICATION A to act as both the SQL server and admin application.

Answer appreciated a lot!
// Aji

[ChrisW67]

Sure it is possible. Application A will have to expose some way for a client to connect (TCP socket and some authentication probably) and proxy requests to the Qt Sqlite driver. The client will have to have a corresponding set of code to manage a connection to your custom server. You could write the code to plug your client-side code into the Qt SQL driver structure, which will minimise the impact on client code.