daz.dev
daz.dev
PostsComments
XXata
Created by daz.dev on 3/26/2025 in #general
Working with Postgis
Appreciate the confirmation, I'll have to give this some thought. Thanks.
9 replies
XXata
Created by daz.dev on 3/26/2025 in #general
Working with Postgis
Oh. I'm 300 hours into a build with the Xata Client as the data transport library, moving off isn't an attractive proposition now.
9 replies
XXata
Created by daz.dev on 3/26/2025 in #general
Working with Postgis
Going to pause here and switch tasks, but my understanding is that postgis should be active as part of the default shared cluster setup. However I can't activate this, or access the functionality with my current setup/understanding. Any guidance much appreciated!
9 replies
XXata
Created by daz.dev on 3/26/2025 in #general
Working with Postgis
When I try to activate Postgis with CREATE EXTENSION postgis;, I get the error invalid SQL: unsupported statement [CREATE EXTENSION] on strict_with_ddl level, see https://xata.io/sql-support for the support matrix
9 replies
XXata
Created by daz.dev on 3/26/2025 in #general
Working with Postgis
Running SELECT * FROM pg_available_extensions WHERE installed_version IS NULL; returns that I have postgis, and many accompanying packages uninstalled.
9 replies
XXata
Created by daz.dev on 3/26/2025 in #general
Working with Postgis
However I'm still not entirely unblocked. Whenever I run a simple test query such as: 
SELECT ST_Distance(
  ST_MakePoint(-74.0060, 40.7128)::geography, 
  ST_MakePoint(-73.9857, 40.7484)::geography
);
SELECT ST_Distance(
  ST_MakePoint(-74.0060, 40.7128)::geography, 
  ST_MakePoint(-73.9857, 40.7484)::geography
);
I get the response of Error: invalid SQL: function [st_distance] is unknown or not allowed
9 replies
XXata
Created by daz.dev on 3/26/2025 in #general
Working with Postgis
Okay, got it. Eventually found that it's preinstalled from this docs section, and could verify preinstallation with 
SELECT * FROM pg_available_extensions WHERE name = 'postgis';
SELECT * FROM pg_available_extensions WHERE name = 'postgis';
9 replies
XXata
Created by ghqpio on 12/19/2024 in #help
Probably a bug
This is prohibiting me from adding any records with joins, so effectively stopping all data input via the GUI.
11 replies
XXata
Created by ghqpio on 12/19/2024 in #help
Probably a bug
No description
11 replies
SSolidJS
Created by Robin Lindner on 12/30/2023 in #support
Build a Drag & Drop Designer with Solid
This would be a useful framework, for sure. Have you started working on it @PureSoul?
6 replies
SSolidJS
Created by daz.dev on 12/29/2023 in #support
Deploying vanilla Start Beta2 to Netlify fails, edge function crashes
Yeah, I think it was my new-ness to Netlify rather than a problem with Solid Start.
14 replies
SSolidJS
Created by Robin Lindner on 12/30/2023 in #support
Build a Drag & Drop Designer with Solid
For PDF generation, I run https://gotenberg.dev/ as a microservice, with some "print format" CSS boilerplate to define the canvas.
6 replies
SSolidJS
Created by Robin Lindner on 12/30/2023 in #support
Build a Drag & Drop Designer with Solid
Might be a good starting point to hack together a proof of concept: https://solid-dnd.com/
6 replies
SSolidJS
Created by daz.dev on 12/29/2023 in #support
Deploying vanilla Start Beta2 to Netlify fails, edge function crashes
Will try integration of some server functions for completeness.
14 replies
SSolidJS
Created by daz.dev on 12/29/2023 in #support
Deploying vanilla Start Beta2 to Netlify fails, edge function crashes
No netlify.toml required. I'm starting to understand the advantage of Nitro and Vinxi now, your message prompted me to build locally to better understand the process.
14 replies
SSolidJS
Created by daz.dev on 12/29/2023 in #support
Deploying vanilla Start Beta2 to Netlify fails, edge function crashes
Ah yeah, this needs to be set to dist -- obvious now. Netlify deployed: https://659012a4ca65440008130773--iridescent-toffee-84678c.netlify.app/
14 replies
SSolidJS
Created by daz.dev on 12/29/2023 in #support
Deploying vanilla Start Beta2 to Netlify fails, edge function crashes
When I change the Netlify interface Publish directory to /.output it similarly fails
14 replies
SSolidJS
Created by daz.dev on 12/29/2023 in #support
Deploying vanilla Start Beta2 to Netlify fails, edge function crashes
Configuration error:
Deploy did not succeed: Deploy directory "netlify" does not exist
Configuration error:
Deploy did not succeed: Deploy directory "netlify" does not exist
14 replies
SSolidJS
Created by daz.dev on 12/29/2023 in #support
Deploying vanilla Start Beta2 to Netlify fails, edge function crashes
No description
14 replies