Locking

Mon Dec 12 11:08:30 EST 2016

We're sort of beating a dead horse here.  Use of the NDF does have some very appropriate uses.  The debate is resurrected every time anyone even mentions the NDF.  Personally, I hope I don't have to read the debate _every week_.  Let the developer, the customer, and ultimately, Omnis Software make the decision.  The list is great for advice and helps solve many problems.  I'd hate to see it deteriorate in anyone telling anyone what they "ought to do."  Let's schedule this debate to occur once a year on June 22 and then not repeat it AGAIN for another year.

Please.

Gary Connor, Ph.D., CIO, CISO
DirectLine Technologies, Inc.
Modesto, CA 95351

-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of wendy
Sent: Monday, December 12, 2016 7:52 AM
To: 'OmnisDev List - English'
Subject: RE: Locking

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.

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 John Hosmer
Sent: 12 December 2016 15:12
To: OmnisDev List - English
Subject: Re: Locking

I¹ll agree, and for most apps, and given the knowledge on the list, this
would be a relatively easy conversion.
Much easier than a move from 07 to studio (for the relative part).

Connection info, pitfalls, recommendations, example code, etc, everything is
available from list members, and (depending on library size) not a difficult
change.

john

John Hosmer
DealerBuilt
Support: 800.499.1914
mobile: 641.425.5183

Follow us on: 
 <http://www.dealerbuilt.com/>
<http://www.facebook.com/pages/DealerBuilt/157228651057212>
<http://twitter.com/dealerbuilt>
<http://www.linkedin.com/company/dealerbuilt---lightyear-dealer-technologie
s>
 Stop by our booth 3561 at  #NADA2017 New Orleans
<http://convention.nada.org/>

On 12/12/16, 9:00 AM, "omnisdev-en on behalf of Doug Easterbrook"
<omnisdev-en-bounces at lists.omnis-dev.com on behalf of doug at artsman.com>
wrote:

>I¹ll get shot for saying this
>
>personal opinion is that df1 has no really valid use cases and that all 
>use cases can be covered with better technology at little or no cost.
>
>postgres and sqllite are free, can easily be deployed on any machine 
>(including for personal databases), are far faster and more capable.
>you an even treat them like df1¹s with single file finds, connected 
>records and all that stuffŠ t
>but, being sql, offer up a whole lot more.      and they address where
>technology is going --- that byte range locking support in an operating 
>system is going to eventually fade away.
>
>the signposts have been there for a long time.   ODB  (circa Omnis 3.8)
>was the advance warning that this style of db support was getting 
>problematic, so there has been well over a decade that we¹ve all known 
>about it.
>
>
>
>
>Doug Easterbrook
>Arts Management Systems Ltd.
>mailto:doug at artsman.com
>http://www.artsman.com
>Phone (403) 650-1978
>
>> On Dec 11, 2016, at 12:25 PM, Bryan Brodie <brb at appimatic.com> wrote:
>> 
>> Hi,
>> 
>> From reading the V8 tech notes, I got the impression that traditional  
>>LAN-locking of the DF1 file was no longer possible from a Mac OS (X)  
>>client, but it seemed to me that it was still supported in Windows.
>>Don't
>> know about Linux.
>> 
>> I've not upgraded so I cannot offer more insight, other than to say, 
>> not every solution requires SQL and net-shared DF1 has many valid use
cases.
>> 
>> I hate to see it go away, but that's where we're headed.
>> 
>> DF1-type logic would be an incredible option for solely local storage 
>>in a  truly mobile (iOS / Android) Omnis runtime (not JS/server 
>>based).
>> 
>> Like I've stated previously, I can dream...
>> 
>> Bryan Brodie
>> 
>> From: "wendy" <wizardcompserv at gmail.com>
>>> Subject: RE: Locking
>>> 
>>> Hi
>>> 
>>> I hope you are wrong there because the omnis handling of locking is 
>>> so simple
>>> 
>>> Kind regards
>>> Wendy Osbaldestin
>>> Wizard Computer Services
>>> Tel:  01260271647
>>> Mobile: 07740541021
>>> 
>>> -----Original Message-----
>>> From: Mike Matthews
>>> Sent: 11 December 2016 12:35
>>> To: OmnisDev List - English
>>> Subject: Re: Locking
>>> 
>>> Locking as in Database DF1 locking?
>>> 
>>> If so, I didn't think this was now supported without the ODB.
>>> 
>>> Mike
>>> 
>>> Mike Matthews,
>>> Managing Director, SQLWorks Software Ltd
>>> 
>>> Tel: +44 (0)1271 375999
>>> 
>>> Email: mike.matthews at sqlworks.co.uk
>>> 
>>> Web: www.sqlworks.co.uk
>>> 
>>> Use SQLWorks, forget Sage, ACT!, Opera, Access & SAP
>>> 
>>> On 11 Dec 2016, at 08:00, Chris Hughes <ataddata at bigpond.net.au> wrote:
>>> 
>>>> Anybody else had trouble with locking on Omnis Studio 8.
>>>> Info:-
>>>> Omnis native data file.
>>>> 
>>>> On same server as before that had Omnis studio 4 running on it 
>>>> looking into a refurbished data base. refurbished one will be 
>>>> uni-code I
>>>> assume)
>>>> 
>>>> Server Microsoft not the latest.
>>>> 
>>>> 
>>>> Chris Hughes
>>>> 
>>>> 
>>>> 
>>>> Copious Data Pty Ltd (Trading as Atad Data)
>>>> 
>>>> Unit 8 /3460 Pacific Highway
>>>> 
>>>> Springwood QLD 4127
>>>> 
>>>> Phone No:- 07 3208 6347
>>>> 
>>>> Mobile No:- 0409 263 349
>>>> 
>>>> Fax No:- 07 3208 9347
>>>> 
>>>> Email:- ataddata at bigpond.net.au
>>>> 
>>>> Web Site:- http://ataddata.com.au
>>> 
>> _____________________________________________________________
>> 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

NOTE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by replying to this email, and destroy all copies of the original message.