Omnis classic with sqlite
Marc De Roover
omnis1 at arcict.com
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
- 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
Which gives an exquisite performance at a very affordable price.
We have a similar setup running for years since our conversion from 07
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
> 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:
> Why do you want to stay with O7 ?
> Why do you want to adapt the O7 lib to use a sql database ?
> 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
> 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.
> 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
More information about the omnisdev-en