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.9 required=5.0 tests=BAYES_00 autolearn=unavailable autolearn_force=no version=3.4.4 Path: eternal-september.org!reader01.eternal-september.org!feeder.eternal-september.org!aioe.org!.POSTED.3d73Ybk3C5U4I2t8lv+lAQ.user.gioia.aioe.org!not-for-mail From: "Dmitry A. Kazakov" Newsgroups: comp.lang.ada Subject: Re: gnatcoll_db2ada problem "Database not supported:" Date: Fri, 27 Dec 2019 12:26:51 +0100 Organization: Aioe.org NNTP Server Message-ID: References: NNTP-Posting-Host: 3d73Ybk3C5U4I2t8lv+lAQ.user.gioia.aioe.org Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@aioe.org User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:60.0) Gecko/20100101 Thunderbird/60.9.1 X-Notice: Filtered by postfilter v. 0.9.2 Content-Language: en-US Xref: reader01.eternal-september.org comp.lang.ada:57765 Date: 2019-12-27T12:26:51+01:00 List-Id: On 2019-12-27 11:48, George J wrote: > And my question is. What if i already have some big database and want to create an Ada app to work with. That is 80% of the cases. > Can i work with it in the same way? You can work in a normal way, i.e. create environment (if required), open connection, prepare statement, bind parameters, execute statement, fetch results. It is no rocket science. > May be i don't know something. Or i can work with db file with connecting to him and send direct SQL queries? That is the way to do it. > I've never worked with databases with Ada so this theme is very difficult for me now. But interesting) Ada does not differ in working with DB to any other language. I understand that you are stuck with some higher-level DB client abstraction. I would tentatively suggest to use a more direct method. In my view if abstraction is needed, then it must be higher, e.g. a persistency layer abstracting all DB and whole SQL mess away. Otherwise, it only complicates the ugly stuff, IMO. P.S. Talking about big databases, SQLite3 is absolutely unsuitable for dealing with a big database. It is not an intended use case of. -- Regards, Dmitry A. Kazakov http://www.dmitry-kazakov.de