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 X-Received: by 10.31.178.137 with SMTP id b131mr5183006vkf.10.1466109185457; Thu, 16 Jun 2016 13:33:05 -0700 (PDT) X-Received: by 10.157.27.242 with SMTP id v47mr47976otv.16.1466109185352; Thu, 16 Jun 2016 13:33:05 -0700 (PDT) Path: eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!mx02.eternal-september.org!feeder.eternal-september.org!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!v48no2952377qgd.0!news-out.google.com!v8ni456qgv.0!nntp.google.com!v48no2952374qgd.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.lang.ada Date: Thu, 16 Jun 2016 13:33:05 -0700 (PDT) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=130.255.19.172; posting-account=Zsf4jwoAAADEqwCydv835KU9-S3h_Y26 NNTP-Posting-Host: 130.255.19.172 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: ANN: AdaBase 3.1 - includes Spatial data / Geographic object support From: jrmarino Injection-Date: Thu, 16 Jun 2016 20:33:05 +0000 Content-Type: text/plain; charset=UTF-8 Xref: news.eternal-september.org comp.lang.ada:30765 Date: 2016-06-16T13:33:05-07:00 List-Id: I had intended that release 3.1 of AdaBase be a quick improvement that would add three new native data types: 1) Bit type (like bit flags) 2) UTF8 encoded strings 3) Spatial data types / OpenGIS Geometry The first two were relatively straight-forward. Bits were sort of already supported but inconsistently and sometimes as strings. Now they are an array of bits for easy manipulation. AdaBase tries to be smart with regard to encoding. It forces the server to send text strings encoded as UTF8 and stores it natively and decodes them to strings/w/ws/ as necesary. The support for MySQL spatial data types and the PostGIS extension for PostgreSQL took far longer than I anticipated. The result is pretty good, I think, it allows AdaBase to directly query geometry fields without the use of database server-side functions to convert and extract. It reads the internal format of MySQL and PostGIS directly and converts them to Well Known Binary (WKB) which can be used to construct AdaBase Geometry objects and also into Well Known Text. This eliminates a lot of overhead as point data can be directly used immediately after a simple query that pulls raw column data. I wrote a pretty log documentation[1] page with two separate test cases to show geometry data extraction and the geometry data construction and insertion. I don't know if anybody needs this feature, but I have a feeling there aren't a lot of database API packages that can handle GIS data like this. John [1] https://jrmarino.github.io/AdaBase/geometry.html [2] https://github.com/jrmarino/AdaBase