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

Document attach database shenanigans #140

Open
skysphr opened this issue Apr 18, 2023 · 2 comments
Open

Document attach database shenanigans #140

skysphr opened this issue Apr 18, 2023 · 2 comments

Comments

@skysphr
Copy link

skysphr commented Apr 18, 2023

I've discovered that in order to use "ATTACH DATABASE", one should use ProjectSettings.globalize_path(path) on the database path and throw that into the query. For paths in res://, exported projects should use OS.get_executable_path().get_base_dir()
as a base directory, as per the docs.

@2shady4u
Copy link
Owner

2shady4u commented Jun 18, 2023

Hello @skysphr

Thank you for reporting this :) I will see if I can add the necessary documentation to the README.md

@ionous
Copy link

ionous commented Sep 27, 2023

regarding attach and the item on the faq My Android/iOS/HTML5 application cannot access the database! -- one possible solution might be to attach a read-only db ( in res ) to a writable one ( in user. )

i haven't tried it but this stackoverflow seems to indicate it might work.
https://stackoverflow.com/questions/4637790/sqlite3-read-only-main-database-and-attach

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants