Bastiaan Olij bastiaan at basenlily.me
Mon Dec 12 17:03:56 EST 2016


It's probably already mentioned in replies I haven't read yet but this
really is a preconception that belongs in the past.

Yes if you install the likes of Oracle on a server you'll need some clue
people at your clients.

Both MS SQL server and Postgres installed on a server are in 99% of the
cases next->next->next installs after which you can forget the thing
runs, it really is no more difficult than installing an ODB

SQLLite and some special single exec deploys of Postgres are even simple
'drop in installs', there is actually absolutely 0 difference between
installing a DF1 based Omnis application and deploying an SQLLite Omnis
application, neither require a server install and use file sharing and
file locking though the real beauty of SQLLite is that you can deploy an
SQLLite solution to your small customers and switch to the likes of
Postgres for your larger customers with limited effort.

Finally one thing we've started doing is simply hosting Postgres servers
'in the cloud'. It's used by both small clients who do not have the IT
support to look after their own machines and larger clients who like the
inconvenience of being able to access their system from multiple locations.

Your second remark however is one that I do fully agree with you is a
weakness in Omnis, its the topic of one of my Omnis sessions and
something I hope to find time in the short term to do something about.
We've build a solution for our product for this and its something I've
been itching to redo in a form that can be shared with the community.



On 13/12/2016 2:52 AM, wendy wrote:
> I think this really depends on your customer base - most of my customers now
> have no more than 6 users and do not have IT experience to be able to
> maintain a SQL database.  
> Also being able to make changes to the database structure is extremely
> simple with an Omnis database - a new version of the software and possibly a
> check data - while SQL would mean scripts for them to run.

Kindest Regards,

Bastiaan Olij
e-mail: bastiaan at basenlily.me
web: http://www.basenlily.me
Skype: Mux213

More information about the omnisdev-en mailing list