Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Resources]: SQLite storage #1566

Open
jonaro00 opened this issue Jan 25, 2024 · 2 comments
Open

[Resources]: SQLite storage #1566

jonaro00 opened this issue Jan 25, 2024 · 2 comments
Labels
Feature Poll Upvote this issue if you want to see this feature in Shuttle S-Investigation This issue needs further investigation or design to figure out a solution

Comments

@jonaro00
Copy link
Member

jonaro00 commented Jan 25, 2024

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 👍 if you want this feature. Comment if you have suggestions related to this feature.

@jonaro00 jonaro00 added S-Investigation This issue needs further investigation or design to figure out a solution Feature Poll Upvote this issue if you want to see this feature in Shuttle labels Jan 25, 2024
This was referenced Jan 25, 2024
@apps4uco
Copy link

apps4uco commented May 4, 2024

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
Copy link
Member Author

jonaro00 commented Jul 1, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Feature Poll Upvote this issue if you want to see this feature in Shuttle S-Investigation This issue needs further investigation or design to figure out a solution
Projects
None yet
Development

No branches or pull requests

2 participants