1. Jochen Peters
  2. Valentina Database ADK
  3. Sonntag, August 13 2017, 01:01 PM
  4.  Abonnieren via E-Mail
How can I distribute my application in a single setup and what is the max user can connect.

this is posible using DB ADK sqlite server
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Hi Alexis,

not sure I have catch questions.

* MAX - users, Valentina Server prints in the LOG on start, accordng your your license file.

* single setup? Create your own installer - put there vserver.app, license files, dbs etc
for each OS - own rules. I think something is described in Valentina WIKI / VSERVER / Deployment
Kommentar
There are no comments made yet.
Jochen Peters Akzeptierte Antwort
I am confused to do one setup for my app with Database ADK and Reports ADK or i have to use vserver.

i need only sqlite user 5 as max
Kommentar
There are no comments made yet.
Jochen Peters Akzeptierte Antwort
help
i need to now about Database ADK and Reports ADK or i have to use vserver.
Kommentar
There are no comments made yet.
Jochen Peters Akzeptierte Antwort
I still do not understand how valentina sqlite server works to distribute it along with my application

Can any one make examples of this i like to move from Postgres SQL and how DataBase ADK works
Kommentar
There are no comments made yet.
Lynn Fredricks Akzeptierte Antwort
Alexis, did you look at this part of the documentation (URL below) on deployment?

Also, if you need multiple connections at the same time, then you need to decide:

- If you only need one deployment (like a web service you offer yourself to your customers), then you should get a commercial copy of Valentina Server
- If you need to deploy unlimited copies to your customers (each customer gets their own server), then you need VDN
Referenzen
  1. https://valentina-db.com/docs/dokuwiki/v7/doku.php?id=valentina:products:vserver:embedded:manual:manual
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Alexis,

which exactly step is not clear to you?

* how to make own installer may be?
* or how to .. something else?
Kommentar
There are no comments made yet.
Jochen Peters Akzeptierte Antwort
yes how make own install and what products i have to use DataBase ADK or vServer.
i use into setup
i need to now what files i have to add on the installer and what service the setup have to active.
Kommentar
There are no comments made yet.
Scott Akzeptierte Antwort
You need to look at your design specs first:

1) Is this application going to be used by just one person on his/her own computer without any other person connecting to it.
2) Is your application going to be installed in a client/server methodology. i.e.: Separate installs of a main server and individual client installs on different computers where each client connects to the server on a network (locally or remote).
3) Is your application a single server type app that is installed centrally on a web server and all your clients will connect through a web browser.

Each one of these variations have different requirements for ADK and VServer (commercial and VDN).

ADK vs VDN:

If you're designing a standalone app, such as a maybe a personal finance manager, that only one person will be using on his/her computer - then you need to design your app using the ADK (DB and Reports). This ADK can provide your app with local databases and reports. Depending on which OS platform you are writing your app for, you will need your IDE (or you can do manually) copy the vcomponents folder to the target computer (the link provides default locations for the various OSes) or in your app's bundle when installing.

If you are designing the same app to be used in a team environment, let's say a company wants every one on the staff to manage company finances using a single app (client apps connecting to a central database server) then you will need two (usually) separate apps - a client app and a server app. For your server app, you will need to install the embedded VServer VDN if this is an app that you develop and sell commercially. If it is for you (or your company only) then the VServer licensing will be ok. (This is how I read the licensing agreement - maybe Lynn can chime in and correct me if I am wrong.)

If your application is a web app where clients use a web browser to connect to a single DB server that you provide to customers for local install on their own web server, then the VDN VServer licensing would still apply (again, as far as I understand the licensing FAQ) because a standard VServer license is licensed to you only and not for distribution.

Connections:

By stating you need 5 max, then this is the licensing you purchase thru Valentina for your VServer product. Generally you will need a VDN server license that includes 5 concurrent connections on whatever type you need (SQLite, REST, or VDB). This allows 5 separate clients to connect at the same time.

On a related note: Although VSQLite server is a venerable product, I highly recommend you use Valentina DB for your database needs instead of SQLite. It is much more scalable and the performance pounds SQLite into the dirt. All developers have a preference, and when the platform dictates I still use SQLite (on iOS for instance), but even then I still use VDB on the backend in a client/server app scenario.
Referenzen
  1. https://valentina-db.net/docs/dokuwiki/v7/doku.php?id=valentina:products:vserver:embedded:embedded
Kommentar
There are no comments made yet.
Jochen Peters Akzeptierte Antwort
ok
I need to install my App and max of 5 user i need to connect to de application on loca network or remote.

So one computer is server and application same time.
So left 4 lic is for 4 computer to connect to my application.

This is my Idea of working with my application.
I have this working with PostgreSQL but is hard for distribution.
Kommentar
There are no comments made yet.
Scott Akzeptierte Antwort
I have done this same set up before - your server/client app will use the VDN embedded server and then your clients can connect to it. If your client apps are only connecting via Valentina.initClient() then they do not need a separate ADK license.

Unless you're using persistent connections, I wouldn't get so wrapped up in number of connections. I have a client that only has a 5 connection license and they have 18 people in the office.

Structure your code to open the connection, do your queries, updates, etc, and then close the connection. This happens very quickly if on a local network. Another advantage to VServer is if a client attempts to connect and all connections are in use, it will wait (your timeout parameter) and retry. I let the client decide if he/she needs concurrent/persistent connections and the $ will adjust accordingly.

I am not sure what language you're writing your app with, but I just write a small connection routine and show a dialog window that says wait, or connecting, etc... while the app attempts to connect and do its thing.

Bottom line is: Is this an app you are writing for your own use? Or is it something you are selling commercially? Huge difference in licensing (and cost).

I have a standard VServer license for all the stuff we do here in the office (our own apps, etc...) and I have a VDN embedded license for everything we sell/license to others.
Kommentar
There are no comments made yet.
Jochen Peters Akzeptierte Antwort
if for sales my app no for my won use.

I have never use vServer i use PostgreSQL i have to modify my app for it so i need to look examples.
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Alexis,

the first choices you have to do are

1) will you use our installer of VServer or you can try to make own.
Own installer have sense only if you want to provide own name, e.g. AlexisServer

2) if you have own installer - choice put there Server + App, or have two own installers.
The first will be to install server (to install postgreSQL you need install it)
The second your app installer

3) Your app should have connect dialog - of course.

4) You can use or not use Apple Bonjour service to simplify connection to VServer.

5) For VDB you should use a special signature in the connect() function. You should have this signature in VDN letter from us
Kommentar
There are no comments made yet.
Jochen Peters Akzeptierte Antwort
I like to start to convert PostgreSQL to Valentina Sqlite server can i use VStudio to convert.

next step is make one install with Inno Setup for Server + App i need what files i need to distribute the server and start the service if it use one.

thanks
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
To make Installer you will need few hours I guess.
Steps are described in our WIKI VSERVER Deployment.


We have no direct converter postgreSQL to SQLite. These dbs are very different actually. You can do this easy only if you did not touch postgreSQL advanced features.

I think the most easy way - try SQL dumps, table by table.
Kommentar
There are no comments made yet.
Jochen Peters Akzeptierte Antwort
ok
thanks
Kommentar
There are no comments made yet.
Jochen Peters Akzeptierte Antwort
About this where is the files list i need to add on my won setup

Valentina Embedded Server - ROYALTY FREE for 5 connections DB+Report Embedded Server
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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories