search

shuttle-hq / shuttle

Build & ship backends without writing any infrastructure files.
https://shuttle.rs
Apache License 2.0
5.82k stars 245 forks source link

[Resources]: SQLite storage #1566

Open jonaro00 opened 6 months ago

jonaro00 commented 6 months ago

Our current way of persisting files in Shuttle might be going away in the future. We are offering a Turso integration, which is a cloud hosted SQLite. We want to hear your thoughts on if a Shuttle-native SQLite storage is desired.

Related:

This issue is a part of the Product Feature Poll (all issues). React with :+1: if you want this feature. Comment if you have suggestions related to this feature.

apps4uco commented 2 months ago

That would be seriously useful, especially if

https://www.sqlite.org/rtree.html could be enabled and the geo spatial support configured.

SELECT load_extension('libstgeometry_sqlite.so','SDE_SQL_funcs_init');

It would be great for showcasing proofs of concept, before migrating to rds.

jonaro00 commented 4 weeks ago

After #1565 is done, it might be possible to use SQLite on S3 with https://github.com/awslabs/mountpoint-s3