search

cockroachdb / cockroach

CockroachDB - the open source, cloud-native distributed SQL database.
https://www.cockroachlabs.com
Other
29.48k stars 3.69k forks source link

qgis: support QGIS #52011

Open otan opened 3 years ago

otan commented 3 years ago

Current known blockers:

Jira issue: CRDB-3989

ajwerner commented 1 year ago

@otan shall we close this?

otan commented 1 year ago

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

goccert25 commented 3 months ago

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

goccert25 commented 3 months ago

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