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.

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

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.

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.

If the Native Database Interface API were publicly documented, someone could develop one for SQLite themselves.

Your comment has been passed to the PowerBuilder product manager.

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.

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.

@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?

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.