Tag - RTREE - Synopse Open Source

This is a major step for the framework.

Among a lot of new features and bug fixes:

Dynamic arrays and Record handling, including low-level access and high-level handling for the ORM part of the framework (using TDynArray wrapper);
Business rules now handled via filtering and validating classes for both our ORM and the Synopse Big Table;
New full-featured logging classes, with exception handling, stack trace and JSON serialization;
Custom SQL functions and TSQLRecordRTree to implement R-Tree virtual tables;
Batch sequences for adding/updating/deleting multiple records;
Secure RESTful authentication via per-user light sessions, and per-query signature;
Define custom Virtual Tables (i.e. access any kind of data from SQL) in Delphi code;
New HTTP server using fast http.sys kernel-mode server and zip / SynLZ compression;
SynTaskDialog unit native under Vista,Seven with emulation code under XP/2000 ;
User Interface automated Generation using standard VCL or proprietary TMS components;
Documentation completed - more than 600 pages by now, including general User Guide and exhaustive Technical Reference;
Updated SQLite3 database engine to version 3.7.6.3;
Numerous bug fixes, speed and feature enhancements (including in the PDF and other UI-related units).

Open Source project, for Delphi 6 up to XE, licensed under a MPL/LGPL/GPL tri-license.

TSQLRecordRTree to implement R-Tree virtual tables

An R-Tree is a special index that is designed for doing range queries.

R-Trees are most commonly used in geospatial systems where each entry is a rectangle with minimum and maximum X and Y coordinates. Given a query rectangle, an R-Tree is able to quickly find all entries that are contained within the query rectangle or which overlap the query rectangle.

This idea is easily extended to three dimensions for use in CAD systems. R-Trees also find use in time-domain range look-ups. For example, suppose a database records the starting and ending times for a large number of events. A R-Tree is able to quickly find all events, for example, that were active at any time during a given time interval, or all events that started during a particular time interval, or all events that both started and ended within a given time interval. And so forth. See http://www.sqlite.org/rtree.html

Since the 2010-06-25 source code repository update, the RTREE extension is compiled by default within all supplied .obj files of the framework.

A dedicated ORM class, named TSQLRecordRTree, is available to create such tables. It inherits from TSQLRecordVirtual, like the other virtual tables types (e.g. TSQLRecordFTS3 or our custom virtual tables).

Synopse Open Source

Tag - RTREE

Synopse SQLite3 Framework 1.13

TSQLRecordRTree to implement R-Tree virtual tables