1. Matthew A Renner
  2. as SQLite DB Server
  3. Montag, Februar 19 2018, 04:55 PM
  4.  Abonnieren via E-Mail
Hi, new here. I have an existing SQLite (.db) database that I want to use via Valentina Server. My objective is use Valentina Server so multiple threads can write and update to the SQLite database in question at the same time, thus overcoming concurrency.

When I try to upload my database under Connect to/SQLite Server, and then to localhost, it demands I create a DB. I'm only able to add the database under SQLite Files, but appears to be just the same local path I've used without Valentina Server.

What am I missing? How can I use Valentina Server for the purpose I seek (if even possible)?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Matthew,

It is necessary to copy your database to the databases_sqlite subfolder of the Valentina Server install location.

Install location is different on different systems.
On macOS it is /Library/VServer_x64,
on Windows C:\Program Files\Paradigma Software\VServer x64,
on Linux - /opt/vserver

Also, what development environment/language do you plan to use?
Kommentar
There are no comments made yet.
Matthew A Renner Akzeptierte Antwort
Thanks.

Those steps I have taken, to my knowledge. Is the image attached how it should look if the .db is connected to the Valentina server?

The language I will use is SQLite, though what will be driving the data will be Metatrader, using an SQLite wrapper. What I'm not sure of is how to get the wrapper to go through the SQLite DB which is run through the Valentina Server. Surely it is not as simple as running it from the databases_sqlite folder location?
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Yes, the image is correct.

In order to access the SQLite database on the Valentina Server, it is necessary to use either Valentina ADK for your development platform (for example, V4RB for Xojo) or universal REST interface over the HTTP protocol.

So if it is possible to use some of ADKs or execute HTTP queries - the server can work.

You need simultaneous connections over the network, right?
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories