From owner-freebsd-questions@freebsd.org Fri Jul 24 22:32:21 2020 Return-Path: Delivered-To: freebsd-questions@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 15E0F375DF1 for ; Fri, 24 Jul 2020 22:32:21 +0000 (UTC) (envelope-from aryeh.friedman@gmail.com) Received: from mail-il1-x12a.google.com (mail-il1-x12a.google.com [IPv6:2607:f8b0:4864:20::12a]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1O1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4BD3q82kH9z4MqH for ; Fri, 24 Jul 2020 22:32:20 +0000 (UTC) (envelope-from aryeh.friedman@gmail.com) Received: by mail-il1-x12a.google.com with SMTP id r13so1412965ilt.6 for ; Fri, 24 Jul 2020 15:32:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=hXKK56VKfPicBXDfEE3o7CZgkm14PssLr8nzcge9EMs=; b=lJY98OYOfqw6uHITNXmEtpKC2cBia9rcrsDlAXZyP7nAJFeB403EUJLrW1W/gJAyig tqs+ygw32yTd7ljtxdajwPcv23cXzFtFwpk2BmucvruOcuQlo7aBeBeCXzzVNuyxq5vH gMkmFik5Xqsjg8rTA47QNind+/DBYyxJ/605OBYI0j4QGNRgOWCCMS5tYQg398KYwvT1 8TO48E3deF6jXLRvIksZfomU8jVwUxj9MiPzIS8PR5Qz0RwPjj6uGohZaxih9krdLgP5 3HO7UtSW+BFSxndwzZAA9RyrN7s0K4gqCp9/ejf4a8pGXun0gGJz5tfiAR355OlN7NxS SsfQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=hXKK56VKfPicBXDfEE3o7CZgkm14PssLr8nzcge9EMs=; b=edaR6yCGajpz7285YJYTsciGrCpUg9FyNYKhVvD050ab5MWp4PSuzO9IMtnDfu5q+f Ec3HT3MKO50che32hm/FbwPvmAfJDlrtCKAl2AlQFae4Fq6vjd4KCfqKsSvUOoj58shp JIqOXE+LpqRmCtIPJSEyWgPIpvGiyxHhW596wSWo3aJlrWsxY2uyq04Jw0DGizQKedZp QdRIqQiq8Isa3TA11XdQ17nULfRoi0dwkIjAuHWaek3mEZ15ksctHtezgGPuRYdqzRBx FGsBkv8dNLkC2KS+W0ujA6Zo7WVd80EHaqwFWbOxYq6aoSlUHSK+Lo0CdEkYpYEBz+iz 99NQ== X-Gm-Message-State: AOAM531aB0BM9e9oqD0WyD8v89n/nyNeGTq36BF15osVmIAVWZOuaU9A LyxaG00jfpQcZxKyidI0tt109+2cqTrgyi6xeR8c3zaD X-Google-Smtp-Source: ABdhPJwWZ3zZRBaOaC0sfeJtD0lSMymHpwra39rAV9A+C6bHGaNMNQLFVaQyceCGvHjZ8aUZaZGZLfWDCMN45IlfSY4= X-Received: by 2002:a92:b60a:: with SMTP id s10mr5654711ili.119.1595629939284; Fri, 24 Jul 2020 15:32:19 -0700 (PDT) MIME-Version: 1.0 References: <20200214121620.GA80657@admin.sibptus.ru> <20200214141600.GA82559@admin.sibptus.ru> <20200214204838.360c8f624397c659946bd764@sohara.org> <20200215063818.GE1482@admin.sibptus.ru> <20200215083359.367d8a3e9ddb4942df67d5b5@sohara.org> <58202623-bbf7-eda0-5cb5-fb4749e91e20@watters.ws> <6318251A-973A-4DEC-9271-12333EB11F7B@kicp.uchicago.edu> <800f33cd-0dc1-1ae9-2262-a374bf8c10dd@kicp.uchicago.edu> <20200724170348.51f108ec@archlinux> <1273868562.6647660.1595604615652@mail.yahoo.com> <20200724183331.6363d69c@archlinux> <20200724210127.7d05e22bd81b95388adf32ba@sohara.org> <20200724215949.854b5bc9199b5ae2e6678dc0@sohara.org> In-Reply-To: <20200724215949.854b5bc9199b5ae2e6678dc0@sohara.org> From: Aryeh Friedman Date: Fri, 24 Jul 2020 18:32:08 -0400 Message-ID: Subject: Re: Ask stupid questions and you'll get a stupid answers, was: Technological advantages over Linux To: "Steve O'Hara-Smith" Cc: FreeBSD Mailing List X-Rspamd-Queue-Id: 4BD3q82kH9z4MqH X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20161025 header.b=lJY98OYO; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of aryehfriedman@gmail.com designates 2607:f8b0:4864:20::12a as permitted sender) smtp.mailfrom=aryehfriedman@gmail.com X-Spamd-Result: default: False [-3.68 / 15.00]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-0.98)[-0.984]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20161025]; FROM_HAS_DN(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36:c]; FREEMAIL_FROM(0.00)[gmail.com]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; NEURAL_HAM_LONG(-1.03)[-1.034]; TO_MATCH_ENVRCPT_SOME(0.00)[]; TO_DN_ALL(0.00)[]; DKIM_TRACE(0.00)[gmail.com:+]; RCPT_COUNT_TWO(0.00)[2]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::12a:from]; NEURAL_HAM_SHORT(-0.67)[-0.667]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+,1:+,2:~]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; TAGGED_FROM(0.00)[]; RCVD_TLS_ALL(0.00)[]; RCVD_COUNT_TWO(0.00)[2] Content-Type: text/plain; charset="UTF-8" X-Content-Filtered-By: Mailman/MimeDel 2.1.33 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.33 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 24 Jul 2020 22:32:21 -0000 On Fri, Jul 24, 2020 at 5:00 PM Steve O'Hara-Smith wrote: > On Fri, 24 Jul 2020 16:52:51 -0400 > Aryeh Friedman wrote: > > > Let add one more complication the client wants us to auto populate the > > MySQL DB from our webapp DB which is on a physically separate machine, > but > > refuses to buy a second license for the device DB software and thus we > are > > forced to do our development/alpha testing on live data (i.e. we *MUST* > > have completely working backups made every 15 mins or so). > > Ugh! I really don't miss end-user facing work :) There's something > nice about having sysadmins as the most demanding customers. > Last kicker is the programmer that maintains the low level DB facing code in the device --> Windows server (only supports windows server running MySQL despite bing in Java [they hardcoded a lot of windows only data into the closed source code]) has only worked for the vendor since April while the VP of Engineering (who held the programmers job before April) refused to answer the following question saying it was irrelevant to having two programs updating the physical DB at once: "Are there any concurrency issues we need to aware when auto populating the patient data?" (ok "refused" is too polite of a description for what he actually said "don't go down that rabbit hole, this conversation is over!" [and hangs up on us by slamming the phone down].... this despite direct orders from the CEO to give all possible aid and answers). We asked this question after he said that the tables/queries we were updating where not used and/or referenced any the real time data (despite the fact that we can so clear as day in the transaction log that it did reference it and that the real time data referenced it but in such a way that it was clear there was DB like communication going on that was hidden to us [the real time data referred to the keys of records that had not been created yet but where created right after their reference in the real time data for the first time!])... Oh forgot to mention internal DB ID's are not auto generated or auto incremented by computed by counting the number of rows and adding one in the current table. The vendor so incompetent it is beyond me how the FDA ever approved this device! (Sadly we know how the FDA approved it because the above is slightly above average for the software engineering quality of medical device software).... If being sick doesn't kill the cure will if it involves medical software! (which is required by law for record keeping if nothing else) -- > Steve O'Hara-Smith | Directable Mirror Arrays > C:\>WIN | A better way to focus the sun > The computer obeys and wins. | licences available see > You lose and Bill collects. | http://www.sohara.org/ > _______________________________________________ > freebsd-questions@freebsd.org mailing list > https://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to " > freebsd-questions-unsubscribe@freebsd.org" > -- Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org