Looking for an PL/SQL library for 2D grid processing (each row represents one cell).

Question

Hi,

I am going to create an app for managing grid-like model - cells at [X,Y] coordinates.

This model will be persisted in a RDBMS.

I want to keep much of the processing right in the DB server.

So I am looking for an PL/SQL library for 2D grid processing (each row represents one cell).

It should know to do algorithmic things like selecting cells within given distance, find paths based on cells properties, etc.

Do you know about something like that? Preferably for MySQL / PostgreSQL.

Thanks, Ondra

Answer 1

Try to look at PostGIS it should have all you need. This is for PostgreSQL, for MySQL I don't know any solution.