Use DB native geometry storage

Created on 4 March 2023, over 1 year ago
Updated 4 June 2023, about 1 year ago

Problem/Motivation

With DB specific backend storage it would be possible to query for points in areas, lines crossing etc. The problem is that Drupal's database abstraction makes, for MySQL/MariaDB at least, this very difficult https://www.drupal.org/project/search_api/issues/2877319#comment-14950996 ✨ Integrate database backend with Search API Location Fixed

Proposed resolution

It should be possible, with a whole entity that is controlled, to add an additional non-entity table that is queried using query, rather than select, insert etc. Or even another DB abstraction library.

Would it then also be possible to write views handlers (join) relationship, filters that also make the queries on the columns using the ST_ functions https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html ?

Remaining tasks

User interface changes

API changes

Data model changes

πŸ“Œ Task
Status

Active

Version

1.0

Component

Code

Created by

πŸ‡³πŸ‡±Netherlands ekes

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.69.0 2024