search

pawelsalawa / sqlitestudio

A free, open source, multi-platform SQLite database manager.
https://sqlitestudio.pl
Other
4.67k stars 571 forks source link

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

Open garyLiuxh opened 5 months ago

garyLiuxh commented 5 months ago

Details

as above.

pawelsalawa commented 5 months ago

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 commented 5 months ago

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 commented 5 months ago

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.