Database Viewer

  • Hi, I am looking for a database viewer/browser to look at the Vivaldi files.
    I tried Kexi and Sqlite Browser but cant open any file exept previews_opt_out.db
    I read something in the forum but cant find it anymore.
    Thanks for any hints,


  • Moderator

    I can inspect SQLite files with sqlite3 itself.

    Which file do you want to inspect? Is it really SQLIte? Did you check in terminal with the file command?

    ~ find -type f | xargs file | grep -i sqlite

  • Thanks, file show > Login Data: SQLite 3.x database
    I check "Shortcuts" and "Login Data" but may it work different.
    No idea of databases, I fear.

    Cheers, mib

  • Moderator

    I use sqlite3 to inspect or change SQlite databases.

    ~ sqlite3 -help
    Usage: sqlite3 [OPTIONS] FILENAME [SQL]
    FILENAME is the name of an SQLite database. A new database is created
    if the file does not previously exist.
    OPTIONS include:
       -help                show this message
       -init filename       read/process named file
       -echo                print commands before execution
       -[no]header          turn headers on or off
       -bail                stop after hitting an error
       -interactive         force interactive I/O
       -batch               force batch I/O
       -column              set output mode to 'column'
       -csv                 set output mode to 'csv'
       -html                set output mode to HTML
       -line                set output mode to 'line'
       -list                set output mode to 'list'
       -separator 'x'       set output field separator (|)
       -stats               print memory stats before each finalize
       -nullvalue 'text'    set text string for NULL values
       -version             show SQLite version
    ~ sqlite3 Shortcuts ".tables"
    meta                omni_box_shortcuts
    ~ >sqlite Shortcuts "select * from meta"
    ~ sqlite -column Shortcuts "select * from meta"
    mmap_status  -1
    version      1
    last_compat  1

    But you need a graphical interface. What do you want to do?

  • I am only interested what is stored in the Vivaldi files.
    It is not so important.
    And yes. GUI would be cool.

    Thank you so far, mib

  • Moderator

    Just install SQLitebrowser. Works nice. I just tested it in KDE 4 minutes ago.

    If Vivaldi is not running, copy the file you want to inspect to you home directory. You can open directly by Dolphin' context menu or other file manager and inspect it the file in SQLitebrowser.

  • Thank you is working very well.

    Cheers, mib

Log in to reply

Looks like your connection to Vivaldi Forum was lost, please wait while we try to reconnect.