"refresh" button function? #2648
Replies: 6 comments 11 replies
-
|
It should reload the data and display it when you view via the 'browse data' tab. If you use the 'execute sql' tab, the database is read each time. |
Beta Was this translation helpful? Give feedback.
-
|
Similar to #2508 then.... |
Beta Was this translation helpful? Give feedback.
-
|
so, from what i gather, pressing the "reload" button should have the EXACT same effect as closing the database and re-opening it? cuz that's not what i'm seeing. i press reload and nothing happens. i close and reopen the database and NOW i see different data. |
Beta Was this translation helpful? Give feedback.
-
|
As per one of my other comments. If you create one database and fire up two instances of DB4S, can you get them to see the same data (as per my screencast). I'm trying to work out if its a MacOS thing, a database thing, or just something wacky on your particular installation. It'll have to be a proper file database and not an in-memory database. My screencast shows adding some records and this is reflected in the other instance. |
Beta Was this translation helpful? Give feedback.
-
|
i'm not disputing your testimony, i'm just giving mine. as per one of my other comments, it's a disk database, not in-memory. the transaction is committed. i click refresh in the db: no refresh. i close and re-open: there IS a refresh. that's it. is there something more i can provide that will help this situation? |
Beta Was this translation helpful? Give feedback.
-
|
Oh no - I'm not disputing you at all either - just starting with what 'should' work, so we can work backwards to find where the problem lies - maybe its the database, a setting in it, or its DB4S, or its just a freaky installation. If you can confirm you get a 'baseline' working as per my screencast, then we can try further on the real database, etc. Just trying to get a baseline - not saying you're not getting an error, etc. 😊 |
Beta Was this translation helpful? Give feedback.
-
|
DB4S doesn't 'auto update' (although that feature has been requested). Just because the last modified date of the database has changed, doesn't mean the table the user is watching has changed. A database might contain fifty tables. For the avoidance of doubt, the refresh button does work as intended. I even opened a database in read-only mode to test it wasn't an 'edge case' and that feature didn't work/was broken for read-only databases. Rec.0093.mp4Are the databases local? You say 'macOs' but it's not using some wacky file system is it? I know there are issues with DB4S accessing databases across virtual file systems and the like, or on a remote device (eg, a phone). |
Beta Was this translation helpful? Give feedback.
-
|
sure but instead of periodically refreshing, instead, refresh when the datestamp changes
modern file systems let you set up a listener on a file, so the OS notifies you when the file changes
… On Mar 30, 2021, at 4:22 AM, Chris Locke ***@***.***> wrote:
Similar to #2508 <#2508> then....
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub <#2648 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAB7ODS6D2427FANJ2MIZO3TGGX55ANCNFSM4Z6GZWIQ>.
|
Beta Was this translation helpful? Give feedback.
-
|
But the filechange might not relate to that table. If I'm adding a log record every second, but monitoring the doodah table, I don't want a refresh on the doodah table every second... |
Beta Was this translation helpful? Give feedback.
-
|
I know this is an old discussion but I use a Mac and had the same trouble with the 'refresh button'. I had an instance of DB Browser for SQLite Version 3.12.2 (Built for x86_64-little_endian-lp64, running on x86_64, Qt Version 5.15.2, ...
db_filename = 'test.sqlite3'
# Connection that doesn't 'refresh'
# db = SqliteDatabase(db_filename)
# Sqlite database using WAL-mode and 32MB page-cache.
db = SqliteDatabase(db_filename, pragmas={
'journal_mode': 'wal',
'cache_size': -32 * 1000})
...The first connection method, i.e. without enabling WAL-mode, causes the refresh button to do nothing. The second method works as expected. I cant try it on Windoze, because I'm alergic to Windoze... ;-) I hope this may help some poor soul having the same issue. |
Beta Was this translation helpful? Give feedback.
-
|
I noticed the same thing - first time user here on a Mac M1. I was expecting to see a refresh button on the first tab ("Database Structure") but only see it on the "Browse Data" tab. This does update table information when a table already exists but doesn't refresh database tables/structure. So, for example, if I create an empty DATABASE_DB file and open it in the browser, then create a table in the DB (via a separate process) and refresh in the "Browse Data" tab I don't see the table. I have to reopen the database. I'd love to see a "refresh structure" button on the first tab. If that's not planned currently would be happy to look into creating this as it would be really useful to me. |
Beta Was this translation helpful? Give feedback.
-
|
Good point! I have just added such a button. Depending on your operating system you can either download a nightly build for Windows or macOS here by tomorrow or download an AppImage for Linux here in a couple of minutes. |
Beta Was this translation helpful? Give feedback.
-
|
Sounds like the kind of thing that shouldn't be too hard for us to add a button for. 😄 |
Beta Was this translation helpful? Give feedback.
-
|
I'm using qlitebrowser to open a SQLite3 database read-only to inspect the data written by some apps during development. No amount of pressing "reload", F5 or executing SQL statements actually reloaded the database, so when my app eg. created additional tables, I could not see them unless I re-opened the database. Using read-only mode to avoid acquiring a lock on the database which would prevent the app from writing to it. So, having a button to reload the database structure and maybe also a button to toggle read-write, to cope with the locking issue, would be really beneficial. I'm using this version of the software: DB Browser for SQLite Version 3.12.2 Built for x86_64-little_endian-lp64, running on x86_64 |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
I thought the refresh button would reload from disk but .. am i wrong about that?
is there a "reload" function so i don't have to close the DB then open it again?
Beta Was this translation helpful? Give feedback.
All reactions