qgis: support QGIS

[otan]

Current known blockers:

• usage of DECLARE (sql: support SQL declare (cursor) #41412) -- see sql: support SQL declare (cursor) #41412 (comment) for details
• use of bounding box comparators

Jira issue: CRDB-3989

[ajwerner]

@otan shall we close this?

[otan]

i haven't tried QGIS recently to know the issues after these two blockers - i'll keep it open until someone does.

[goccert25]

Hey just following up here, does cockroachdb support QGIS yet? If not is it on the roadmap?

[goccert25]

To follow up, I tested on a M3 MacBook Pro and it didn't work (QGIS crashed). The following is what I did:
docker pull cockroachdb/cockroach:v23.2.2
then
docker run -d \ --name=roach1 \ -p 26257:26257 -p 8080:8080 \ -v "${PWD}/cockroach-data:/cockroach/cockroach-data" \ cockroachdb/cockroach:v23.2.2 start-single-node \ --insecure

then connecting to the db with docker exec -it roach1 ./cockroach sql --insecure

then seeding the db with CREATE DATABASE gis_data;

USE gis_data; CREATE TABLE locations ( id SERIAL PRIMARY KEY, name STRING, location GEOGRAPHY );

INSERT INTO locations (name, location) VALUES ('Place A', 'SRID=4326;POINT(-74.0059413 40.7127837)'), ('Place B', 'SRID=4326;POINT(-73.935242 40.730610)'), ('Place C', 'SRID=4326;POINT(-74.0060 40.7128)'), ('Place D', 'SRID=4326;POINT(-73.985655 40.748817)'), ('Place E', 'SRID=4326;POINT(-73.977622 40.763896)');

I then tried to connect with QGIS using the steps in this link (https://scdm.geography.wisc.edu/2020/12/08/spatial-database-connect-to-postgresql-postgis-through-qgis/)

and it crashed after step 3