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!reader02.eternal-september.org!news.eternal-september.org!news.eternal-september.org!feeder.eternal-september.org!aioe.org!.POSTED!not-for-mail From: "Dmitry A. Kazakov" Newsgroups: comp.lang.ada Subject: Re: Yes, there is an ADA language Date: Tue, 22 Nov 2016 18:15:40 +0100 Organization: Aioe.org NNTP Server Message-ID: References: NNTP-Posting-Host: s3c6wwRqkurrfTZpuYYZ+w.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:45.0) Gecko/20100101 Thunderbird/45.5.0 X-Notice: Filtered by postfilter v. 0.8.2 Xref: news.eternal-september.org comp.lang.ada:32417 Date: 2016-11-22T18:15:40+01:00 List-Id: On 2016-11-22 17:19, Mr. Man-wai Chang wrote: > Ada does NOT have a good, fast SQL database engine like Foxpro's Rushmore! Sure. Why would anybody use SQL within any decent programming language? SQL makes some sense only with an external DBMS. For an internal DBMS there are much more efficient interfaces than ugly SQL. Provided the DBMS is relational, because depending on the task there are more efficient non-relational DBMS and persistence layers. In any case there is no need to have SQL in the language. Ada perfectly manages SQL RDBMS over bindings to ODBC or specific DB client bindings. I maintain Ada ODBC bindings for external SQL DBMS: http://www.dmitry-kazakov.de/ada/components.htm#ODBC_Bindings For integrated file-based DBMS: SQLite bindings: http://www.dmitry-kazakov.de/ada/components.htm#SQLite For pure Ada file-based persistence: http://www.dmitry-kazakov.de/ada/components.htm#Persistent.Blocking_Files.Transactional A comparison Ada I/O vs. SQLite persistence: http://ada-programming.blogspot.de Ada is as fast you can make it. -- Regards, Dmitry A. Kazakov http://www.dmitry-kazakov.de