Omnis classic with sqlite

Marc De Roover omnis1 at
Tue Jun 28 16:36:54 UTC 2022


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



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> 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
> Start a new message -> mailto:omnisdev-en at
> | ARC - your Apple Authorised Service partner | H.D. Saviolaan 8 |
> |   | B-1700 Dilbeek |
> |   | Belgium |
> | info at | |
> | tel. : +32 (0)2 466 50 00 | fax. : +32 (0)2 466 88 33 |

ARC - your Apple service partner

More information about the omnisdev-en mailing list