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

how to open db that was opened in another process, using sqliteStudio? #5000

Open
garyLiuxh opened this issue Jun 16, 2024 · 3 comments
Open

Comments

@garyLiuxh
Copy link

Details

as above.

@pawelsalawa
Copy link
Owner

Normally. You just do so.

Remember, that the other process has to commit and pending transactions, that acquired locks on the database - during SQLiteStudio attempt to connect.

@garyLiuxh
Copy link
Author

how to get a lock when open a dbFile using sqlIteStudio.

sample:
process A open dbFile in python: conn = sqlite3.connect('dbFile?mode=rwc&uri=true&journal_mode=WAL&cache=shared', isolation_level=None)
Process B open the dbFile in SQLiteStudio: how to do?

thanks.

@pawelsalawa
Copy link
Owner

You add database to list of registered databases using "Add database" button in top left corner (or from Database menu). Then you fill in the database dialog. Once you accept it, the database will appear on the databases list in the left-side panel. Double click it and there it is - you're connected.

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

2 participants