Approaching Omnis again scares me, too much to learn?

Thu Jan 4 01:27:24 EST 2018

I through all this about 13 years ago and never looked back. Started in Omnis 3.3 with DML and pretty much everything since then in multiple SQL flavors.

That said, help from others will take you a long way. Currently I’m working for Mophilly and we’ve converted some big projects from DML and have tools to make it much faster.

Let us know if you are looking for help. It’s worth it. 

> On Jan 3, 2018, at 8:56 PM, Chris Ross <chrisross at caliach.com> wrote:
> 
> Hello all,
> 
> DML to SQL. I have been through that process on our 35Mb ERP system (58 clients around the world - 3 to 45 users) and it has been a long and painful process. Some key points from our experience:
> 
>  *   Do the research first. I took over a year off to do that alone, but it did pay off!
>  *   The actual conversion took over 2 years.
>  *   It's not just DML replacement, more tricky is removing the CRB (current record buffer, e.g Load from list, etc. and reports.)
>  *   Make sure you re-write for Transactions (begin - commit - rollback) from the start as they are hard to re-structure for later.
>  *   Be prepared for client resistance to upgrade. DML is much simpler. Large sites gain more than small ones from SQL. We took the approach of no program functional changes (so testing was easy) but to clients "if there is nothing new, why the hassel?" Don't expect to make money from upgrading clients.
>  *   You and your staff need to be willing and capable of supporting a more complex internal beast. We missed that as a risk factor leading to at least one nervous breakdown (I joke not!)
>  *   Having gone through the pain, the results are worth it. Much more reliable, super-fast, coherent code, expandable and scale-able.
> 
> Best regards, Chris
> 
> ________________________________
> 
> Chris Ross, Managing Director, Caliach Ltd
> Cedar House, Vine Lane, Hillingdon, Middlesex UB10 0NF, England
> Web: www.caliach.com<http://www.caliach.com/>  Email: chrisross at caliach.com<mailto:chrisross at caliach.com>  Tel: +44 1895 230203  Fax: +44 1895 230233
> Mobiles (UTC + 6/7): +44 7703 535994, +66 8713 62010, Skype: chrisrosscaliach
> If you are a Caliach Vision user please ensure you have read Understanding Caliach Support Service<http://www.caliach.com/caliach/support/knowledge/general/0013.html>.
> In conformance with UK Ecommerce Regulations: Caliach Ltd is registered in England number 2496263 and has a registered office at P.O. Box 1295, 20 Station Road, Gerrards Cross, Bucks SL9 8EL, England. We are not members of any trade or professional associations. Our VAT registration is GB 531 3296 65.
> 
> ________________________________
> On 03/01/2018 15:15, Plum Hollow Software wrote:
> 
> Hi Wendy,
> 
> I’m in the same position as you, I have a lot of small clients anywhere from 1 to 15 users per client.  The DML is a perfect solution for these clients however Omnis Software told me to move to SQL because DML support and enhancements are not there focus.  So I have to decide whether or not to continue paying for my developer program.
> 
> Randy
> 
> 
> 
> On Jan 3, 2018, at 5:19 AM, Wendy <wizardcompserv at gmail.com><mailto:wizardcompserv at gmail.com> wrote:
> 
> Hi There
> 
> Happy New Year!!
> 
> Most developers will call me a dinosaur!!  But my business has always concentrated on the 'small' users - they do not have an IT department - they do not want or need SQL or Web based products.
> 
> You will not earn a fortune this way but there are a lot of small business out there that need this kind of support and consultancy and they have kept me going for the last 18 years and I am still getting enquiries from new customers.
> 
> Just my 2p's worth for 2018
> 
> Kind regards
> Wendy Osbaldestin
> Wizard Computer Services
> Tel:  01260271647
> Mobile: 07740541021
> 
> -----Original Message-----
> From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Das Goravani
> Sent: 02 January 2018 23:55
> To: OmnisDev List - English
> Subject: Approaching Omnis again scares me, too much to learn?
> 
> 
> Hello All,
> 
> I am RE approaching Omnis with a view to becoming a developer/consultant to businesses.
> 
> I am completely expert with Omnis and the native database it provides, but don’t know SQL or anything else, I only know Omnis. I don’t know any other language at all.  I go back to 86 but haven’t done anything for ten years.
> 
> It’s scary enough to have to learn SQL and how to connect to databases.  But all the stuff you guys and gals discuss here and on the other forum scares me.  How did you all learn all about Java and Jason and Restful etc etc.  How do you keep it straight in your heads?
> 
> My real question is this:  If I could learn SQL and how to setup and maintain backends and the connectivity, is that enough to be a consultant today?  I imagine right away the next point is that businesses will want phone access apps, tablet apps, to access their databases and then I’d be looking at Javascript which I don’t know.
> 
> At age 57 and reapproaching, I wonder how much time it takes to learn these things and begin consulting.
> 
> Are all these fancy other things smaller than Omnis learning itself?  I sure hope so.  It took a good while to learn Omnis.  I’m very good at Omnis but only Omnis Native.  Don’t yet know what a Schema is, but I can do notation to control anything, I can do complex interfaces and handle complex data.  Just dont know anything else.  Do any businesses still go for using the Native Datafile?  With that I’m ready already.
> 
> One reason I want to learn SQL is to earn more.  The businesses for which the Native datafile is appropriate are smaller and poorer.  I believe you can charge more to the SQL requiring businesses.  Comments?
> 
> Is the "Lone Developer" still possible?   You all seem to be in teams.
> 
> Just scared badly.   Any help appreciated.
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> 
> 
> ________________________________
> .
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com

Scotte Meredith
SpoMacGuy at gmail.com