PowerBuilder app with embedded database?

Can SQLite be used with PowerBuilder for example? I need an open source embedded database (no extra cost).

0


source to share


5 answers


As Bernard said, you will need an ODBC driver, so if you are willing to go to a third party (if I understand the SQLite situation correctly) this shouldn't be a problem.

However, if you have PowerBuilder, you are licensed to distribute the SQL Anywhere single-user runtime engine. If there is no cost for your single criterion and you are only connecting locally, SQL Anywhere might be an option to evaluate. Not only is it an incredibly solid database, but there is a much more extensive database of documentation and experience connecting PowerBuilder to SQL Anywhere, so if you run into problems, you're more likely to get some help.



Good luck.

+2


source


I don't believe PowerBuilder contains a driver for native SQLite support. But it definitely has an ODBC driver, so it's always an option, even if it's not the most efficient one.



+1


source


I used SQL Anywhere, but ended up touching it for reasons suggested by Joe Landau - cannot change the schema using a distributed execution engine.

I switched to Firebird which has a built in version and it seems solid. The only problem is that the ODBC driver I'm using (Gemini), which seems to be the best available, seems to be out of business. (I just checked - it looks like it's available on other sites.) And you have to add the following to your PBODB * .INI file:

[Firebird]
PBSyntax='Firebird_SYNTAX'
PBNoCatalog='YES'

[Firebird_SYNTAX]
CreateTable='CREATE TABLE &TableName (::ColumnElement[::ColumnElement]...)'
ColumnElement='&ColumnName &DataType'
DropTable='DROP TABLE &TableName'
GetIdentity='Select gen_id(GEN_&TableName,0) from RDB$DATABASE'

      

I was very happy with this. Using it for almost two years now, with over 1000 users, and no problem at all. You can also easily switch to the Firebird server version if some users need it.

+1


source


As noted, SQL Anywhere is affordable and straightforward. But it has a disadvantage - you cannot change the schema using the runtime mechanism. This makes it difficult, say, to add a column to the db that you propagated.

0


source


++ to DC's comments on Firebird. One of the best free databases. I have used it for years for a PB application that I sell to law firms.

Although I am using the server version even if the target is the only workstation. Simplifies deployment and the problem of adding workstations later if needed.

I am using the standard Firebird ODBC driver at http://www.firebirdsql.org/index.php?op=files&id=odbc

There are two good GUI database management interfaces that I have used - IBOConsole and Flamerobin.

0


source







All Articles