ANY DBE for SQLITE in Xbase++ 2.0 ?

[unixkd]

Hi All

The original spec of 2.0 indicated that it will have DBE for SQLite. Is it available in 2.0 now

Thanks.

Joe

[Auge_Ohr]

don't know if Xbase++ v2.x can handle Sqlite already. i use it "native" with this CLASS from Pablo Botella

testsqlite.zip

need ot4xb

(249.49 KiB) Downloaded 832 times

[unixkd]

Hi Jimmy

I dont want to write new codes for my application. I just want a situation where my existing applications can connect to SQLITE without code changes.

Thanks.

[c-tec]

Hello Joe,
this will not work as you think, for example open a browser with a few thousands of records with a SQL table and a DBF table for browsing. You have to rewrite your code, and then I recommend SQLEXPRESS. I have made a tool that can synchronize DBF tables to any SQL databases automatically, this is enough for my customers, mostly they only need access to the data, and not writing in my system. I use DbRegisterClient() for this.
regards
Joe

[Tom]

Xbase++ supports SQLite, but not as a direct replacement for record navigated databases. This should work with PostGreSQL, but not without any changes in the app - some little work must be done, but the DBE is not finished yet.

As Rudolf said. If you want to move your app to SQL, the easiest way would be the "DBF upsize tool" and PGDBE (ISAM-SQL). There are other options, but switching the DBE without any changes is none.

[rdonnay]

Tom -

I have a customer who is trying to migrate his app to PostGreSQL.

He has done the upsize but is disappointed in performance.
He uses a lot of code block that do complex algorithms when browsing data.
Lots of seeks into other databases.

We are looking at converting his entire app into using SQL SELECT statements to improve performance.
Are you using PostGreSQL in your app now?

Roger

[unixkd]

Hi Tom

You said: Xbase++ supports SQLite, but not as a direct replacement for record navigated databases

What DBE ? ODBCDBE ? If yes what is the connection string. I dont like ODBCDBE because it is too slow.

Thanks

[c-tec]

Hello Joe,
if you convert to SQL statements like Roger will do and Tom recommend, you are open for all SQL systems and versions and not only for those that Alaska decide to support. You have only to handle some minor differences and your system is fit for the future. Also you can also benefit from all powerful things that SQL offer. So I see no way for using a SQL DBE in a professional system. I still have no idea why Alaska put so much work to develop a SQL DBE.

regards
Rudolf

[unixkd]

Hi Rudulf

Back to SQLITE. How will the Database be connected ?

Thanks

[c-tec]

Hello Joe,
there is a native version from OT4XB, but I use SQLEXPRESS because it supports much more things. You can download the demo and look at the very good docs.
regards
Rudolf