Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Application with Embedded database

  1. How-to
0
Votes
Undo
  1. Sivaprakash BKR
    Sivaprakash BKR
  2. PowerBuilder
  3. Monday, 14 June 2021 02:51 AM UTC

Hello

I want to distribute application with embedded database that could be run without installing anything at clients computer. 

Seems Sqlite fits this better.  Seems need to install sqlite driver.  Is there any way to automaticaaly install driver from application, if driver not found ?  

Its a tiny application which will be run from pendrive and in single user mode.

Any other database suggestion is also welcome, that fits this requirement.

Happiness Always

BKR Sivaprakash 

 

  1. PowerBuilder (Appeon)
  2. SQLite
Move from MSSCCI Git to PB 2019R3 Native Git
Select varchar(max) field on SQLServer return the ...
Responses (2)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 14 June 2021 04:12 AM UTC
  2. PowerBuilder
  3. # 1

I think SQLite is good option if it’s DB features is adequate for what you want to do.  Connection would be via ODBC.

I can’t give you exact steps, but you should be able to automate installing your app as well as the driver with the new PowerClient deployment option.  At a high level you would include the driver install file in the External Files tab and in the preload event of the Run Options tab write your batch commands.

Comment
There are no comments made yet.
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Monday, 14 June 2021 06:16 AM UTC
  2. PowerBuilder
  3. # 2

Thanks Armeen,

PowerClient is one good choice.  

Since this application is planned to be distributed in a pendrive, user can plug it into any computer that he has got access.  

Will the PowerClient install the required files into every machine that the user plugs the pendrive in, including the database driver ?   

Will PowerClient work in this scenario ?

 

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Monday, 14 June 2021 14:17 PM UTC
I am not familiar with pendrive but as long as the computer can connect to the Web server hosting the app files it will work. The web server doesn’t have to be hosted over Internet… you could host it in-premise if you want.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


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