1. youping ouyang
  2. PowerBuilder
  3. Tuesday, 25 September 2018 08:16 AM UTC

Appson,Is there any plan to directly support SQLite? NOT ODBC

Benjamin Daniels Accepted Answer Pending Moderation
  1. Monday, 8 January 2024 22:28 PM UTC
  2. PowerBuilder
  3. # 1

I agree with Joseph. We use SQLite for mobile apps offline functionality as well PB desktop apps (connecting via SQLCA). SQLite db is quite stable and quick (even supports triggers).

Comment
  1. Sivaprakash BKR
  2. Tuesday, 9 January 2024 07:58 AM UTC
Thanks Benjamin,

Would like to know whether database transactions work as expected, with Commit and Rollback, when (sqlite) used in Desktop apps? Can u share how you connect with sqlite database?

We are experimenting here with http://www.ch-werner.de/sqliteodbc/ odbc driver in 64 bit PB apps.
  1. Helpful
  1. Benjamin Daniels
  2. Tuesday, 9 January 2024 12:18 PM UTC
Hi Sivaprakash



In my comment i meant ODBC (sqlca obvious). Most of the work on is on mobile devices and we use connection below. We use straight forward ODBC connection with autocommit on. The same on desktop but not much DB work is done on desktop app.



// Profile for sqlite offline connection (PS2020, build 2797)

SQLCA.DBMS = "ODBC"

SQLCA.AutoCommit = True

SQLCA.DBParm = "ConnectString='DSN=mysqliteodbc;UID=;PWD='; EnabledLocalDB='true'"

connect using SQLCA;

if SQLCA.sqlcode <> 0 then

messagebox("Connection Error", SQLCA.sqlerrtext)

return -1

end if
  1. Helpful
  1. Sivaprakash BKR
  2. Thursday, 11 January 2024 11:32 AM UTC
Thanks Benjamin,

We use a similar (DSN-Less) connection and have been facing issues in multiple dw/ds update for few windows, with database transaction enabled.

  1. Helpful
There are no comments made yet.
Ian Wells Accepted Answer Pending Moderation
  1. Friday, 5 January 2024 13:46 PM UTC
  2. PowerBuilder
  3. # 2

To confirm, Powerbuilder can connect to an SQLite db via ODBC (32 bit and 64 bit) correct? There are no plans for PowerBuilder to connect directly to an SQLite database? 

In my spare time I'm going to build a mobile app with a local database and back-end sync to a server/cloud database. Trying to decide the best local database to use.

Comment
  1. Armeen Mazda @Appeon
  2. Friday, 5 January 2024 16:59 PM UTC
Correct, at this point there is no plans on our roadmap to officially support SQLite. Some customers are working around by using ODBC connection. We do officially support PostgreSQL, and we are continuing to enhance PostgreSQL support. So if you don't need a super lightweight local DB then PostgreSQL might be a good open-source option.
  1. Helpful
  1. Roland Smith
  2. Sunday, 7 January 2024 00:52 AM UTC
If the Native Database Interface API were publicly documented, someone could develop one for SQLite themselves.
  1. Helpful
There are no comments made yet.
youping ouyang Accepted Answer Pending Moderation
  1. Wednesday, 26 September 2018 01:40 AM UTC
  2. PowerBuilder
  3. # 3

Thanks, sqlite is very important for offline database,especially for a cloud software,we can use powerbuilder develop a local software with sqlite offline database and it can sync to cloud database,in chinese powerbuilder community,some developers had developed sqlite directly support for powerbuilder use pbni , but not support datastore or datawindow,i hope appeon can support sqlite in furture @Armeen Mazda

 

 

 

Comment
  1. Armeen Mazda @Appeon
  2. Wednesday, 26 September 2018 06:47 AM UTC
Your comment has been passed to the PowerBuilder product manager.
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 25 September 2018 19:20 PM UTC
  2. PowerBuilder
  3. # 4

We have no plans at this point to support SQLite for desktop app deployment.  For mobile deployment it is already supported.  We see far greater use cases/demand for SQLite on mobile device than on desktop, but we'll keep monitoring the situation.

Comment
  1. Roland Smith
  2. Tuesday, 25 September 2018 20:13 PM UTC
Unfortunately SQL Anywhere no longer has a Runtime version. For anyone that sells a database app and wants to provide a demo download, most database installs are from 50MB to 150MB. With SQL Anywhere Runtime, you only need 6 files with a total size of 5.5MB.
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Tuesday, 25 September 2018 20:48 PM UTC
That's good to know Roland... but we have not been getting a lot of request for this. Anyway, even though SQLite it not officially supported since SQLite has limited functionality (e.g. no stored procedures) so I would venture to guess PB will work fine with it through ODBC.
  1. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 25 September 2018 13:45 PM UTC
  2. PowerBuilder
  3. # 5

Have you created pbodb***.ini entries for SQLite? If yes, please share.

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 25 September 2018 13:40 PM UTC
  2. PowerBuilder
  3. # 6

I have played around with this:

http://www.ch-werner.de/sqliteodbc

It is an ODBC driver with the SQLite code built in so it is straight forward to set up.

 

Comment
  1. Joseph Vendra
  2. Monday, 15 February 2021 15:49 PM UTC
@Armeen, I see things differently for SQLite its becoming an extremely important royalty free asset for developers to use in desktop and mobile and we should be able to natively rely upon Appeon support for sqlite.

I am also using the driver from http://www.ch-werner.de/sqliteodbc at present and I can tell you its not the full real deal which is unfortunate. But it does work with the basic crud so there is that. Also if something were to happen which breaks the driver or its ability to be used with PowerBuilder 2019 R3 or later, those that use it in projects will be hooped.

Its a free win for PowerBuilder developers writing small apps that need a free database solution locally that doesn't have to have stored procedures or the large overhead of other large enterprise DBMS tools. I too miss the free SQL Anywhere royalty free runtime from earlier days so this is sorely lacking now in current Appeon PB.

There are some issues with the http://www.ch-werner.de/sqliteodbc driver that others should be aware of.

It should be noted that you can only depend on using the x64 version of the ch-werner sqlite driver and you must build x64 versions of your PB applications and even further must compile to PBD. While everything 'seems' to work under 32 bit and non-pbd builds of your PB app, once you start to do some dynamic datawindow tasks you will find flakey problems on your target where even super simple basic stuff fails. Yesterday for example everything in a small app I was working on was fine under PB IDE in the development environment. Deployed the application to another win10 machine for some early testing soon burned many hours of debugging and problem solving only to figure out, x64 pb compile + pbd + x64 sqlite = win ; any other combinations = hours of frustration and suffering.

These difficulties all unsupported because essentially this third party odbc driver is not a appeon product which makes me wince of the idea of moving ahead with this sqlite driver for any production solution. So we are back again thinking of what other driver to use and how much is it going to cost us now?

Its a valuable win in my opinion to add a free fully supported sqlite driver for Appeon PowerBuilder moving forward even if you don't see a lot of requests there may be more than you realize and this is a bigger deal to those who want low cost deployable royalty free DESKTOP and MOBILE solutions. If you add it, they shall come?



  1. Helpful 2
  1. Armeen Mazda @Appeon
  2. Monday, 15 February 2021 15:59 PM UTC
Hi Joseph, SQLite cannot replace the DB features that most of our customers are using. But we understand it is important to have free and open-source DB options. So we already invested to officially support PostgreSQL. While MySQL is also a good DB option, its open-source license is GPL so that creates lots of problems for our customers. Therefore PostgreSQL was the higher priority.
  1. Helpful 1
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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.