From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.1 required=5.0 tests=BAYES_00, PP_MIME_FAKE_ASCII_TEXT autolearn=no autolearn_force=no version=3.4.4 Path: eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!mx02.eternal-september.org!feeder.eternal-september.org!news.albasani.net!reality.xs3.de!news.jacob-sparre.dk!loke.jacob-sparre.dk!pnx.dk!.POSTED!not-for-mail From: "Randy Brukardt" Newsgroups: comp.lang.ada Subject: Re: Ada package registry? Date: Fri, 5 Feb 2016 18:30:35 -0600 Organization: JSA Research & Innovation Message-ID: References: <02241ec4-0f95-4f63-9abc-092f167eb59e@googlegroups.com> <56af17b7$0$301$14726298@news.sunsite.dk> <56b06eb8$0$301$14726298@news.sunsite.dk> <1454483747.2785.135.camel@obry.net> NNTP-Posting-Host: rrsoftware.com X-Trace: loke.gir.dk 1454718636 6311 24.196.82.226 (6 Feb 2016 00:30:36 GMT) X-Complaints-To: news@jacob-sparre.dk NNTP-Posting-Date: Sat, 6 Feb 2016 00:30:36 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 Xref: news.eternal-september.org comp.lang.ada:29370 Date: 2016-02-05T18:30:35-06:00 List-Id: "Björn Lundin" wrote in message news:n90hnb$3bd$1@dont-email.me... > On 2016-02-04 22:21, Randy Brukardt wrote: >> "Björn Lundin" wrote in message >> news:n901l6$b7$1@dont-email.me... >>> On 2016-02-04 17:59, Dmitry A. Kazakov wrote: >>>> On 2016-02-04 17:52, Björn Lundin wrote: >>>>> On 2016-02-03 23:11, Randy Brukardt wrote: >> ... >>> Especially bad is when a customer cannot pull data to Excel. >> >> Why would that be hard? I do it all the time in my programs, no database >> (or >> even persistent storage) in sight. It's easy to read/write .csv files in >> Ada, and I believe that someone even has a library for writing .xls >> files. > > Yeah, having millions of records in .csv and > joining with a couple of other .csv files with > the same amount of data and > sounds like a really good idea... > If you got plenty of time, that is. Huh? You said that it is hard to pull data to Excel, and I disagreed. You didn't say anything about pulling *all* of the data -- and why would you do that? Excel would fall over if you gave it a million lines of anything - the maximum number of rows is (or at least was) less than that. Obviously, you'd do the selection before exporting to Excel (the case I was talking about). > Looking at a customers trace table I see they generate about 100_000 > records a day. Order lines are around the same. > Data saved for a month or two, before moving to long-term storage (db > not connected to production) Way too much data -- clearly a business that is far too large to be managable. I don't care too much about the problems of entities that we'd be better off without in the first place. ... >> The real reason to stick with non-Ada tools is when large parts of the >> system already are in a non-Ada language, and you're just adding to it. > > Nope, the real reason is that SQL is a good enough way for > non-engineers (read economists/warehouse manager etc) to make reports. > They do not write their own Ada programs. They do not care. > They want to use Excel and get data in ways THEY understand. Surely. But the number of such people that can understand SQL well enough to do anything beyond the trivial has to be countable on fingers and toes. They typically use report tools to get such data, and those tools surely wouldn't have to be based on SQL (or anything in particular). > I'd like to hear of an ERP system (or WMS) that does NOT > use a DBMS, and has customers with 1_000+ employees. I don't care about systems for organizations that necessarily are in hell. I *hope* they waste their time with fancy ERP systems rather than getting anything done so they can go out of business faster... :-) Randy.