Omnis classic with sqlite

[Marc De Roover]

Martin,

In that case my suggestion would be:
- leave the O7 app/code as such or with no or minimal change °
- sync the data from the DF on a regular basis to Postgres ( ex 
depending on frequency of change though a timed procedure or a triggered 
procedure )

- you can then can use the data in O$10 and eventually add to the 
application though a O$10 library which can acces the SQL and the DF 
data.
Ex: using a sql select you could retrieve a primary key, with which you 
could get the DML record. So you have the power of SQL with the data 
still in DML for O7 (this is also do-able in O7)

° to ease the data sharing ( multiple users, O7, O$10 ) and reduce data 
crashes, I recommend you to setup an OmnisDataBridge server, which is 
much more stable and reliable then sharing the data through a 
fileserver.
This would require minimal changes to the O7 lib but requires the very 
last O7 versions.
Ex: we use a MacMini 2018 with a Promise Pegasus raid system equipped 
with SSD’s.
Which gives an exquisite performance at a very affordable price.

We have a similar setup running for years since our conversion from 07 
to O$4.

We are still in DML using ODB while preparing our upgrade to O$10, where 
we plan to move from DML to SQL using the DML2SQL contained in 0$10

Regards,


Marc





On 28 Jun 2022, at 17:19, Martin Obongita wrote:

> Hi Marc,
> I am currently learning Omnis Studio 10.2.Once I am through 
> understanding developing apps in web, I will transition the client 
> from Classic.This is an inherited client that I'm holding with a spare 
> wheel.
> I do not wish to learn anything about Omnis 7 coding.
> Rgds,Martin O.
>     On Tuesday, June 28, 2022, 06:14:42 PM GMT+3, Marc De Roover 
> <omnis1 at arcict.com> wrote:
>
>
> Martin,
>
> Why do you want to stay with O7 ?
>
> Why do you want to adapt the O7 lib to use a sql database ?
>
> Marc
>
> On 27 Jun 2022, at 18:22, Martin Obongita via omnisdev-en wrote:
>
>
> Hi all,
> There is an old Omnis 7 app that I have inherited that runs with .df1 
> database.
> Is there a way to run .lbr files with sqlite database?
> I'm thinking of exporting the data to excel then importing to sqlite 
> while maintaining the same table structure. 
> Rgds,Martin.
>
> Sent from Yahoo Mail on Android
>
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
>
>
>
>
>
> | ARC - your Apple Authorised Service partner | H.D. Saviolaan 8 |
> |   | B-1700 Dilbeek |
> |   | Belgium |
> | info at arcict.com | www.arcict.com |
> | tel. : +32 (0)2 466 50 00 | fax. : +32 (0)2 466 88 33 |

ARC - your Apple service partner