Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>Finally solved (by work around of not installing in GAC):</strong></p> <p>To open Firefox 4.0 places.sqlite you must use a version 3.7 or upper from sqlite.</p> <p>I installed sqlite-dotnet-x86-1007000.exe from <a href="http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki" rel="nofollow">here</a>, but did <strong>not</strong> check the install in GAC checkbox. Install in GAC is still faulty.</p> <p>Now the following PowerShell Code works fine on a copy of places.sqlite (remember you can't open it while locked by Firefox):</p> <pre><code># adapt these two lines to your loacal system [System.Reflection.Assembly]::LoadFrom("C:\Program Files\System.Data.SQLite\bin\System.Data.SQLite.dll") $ConnectionString = "Data Source=C:\Var\sqlite_ff4\places.sqlite" $conn=new-object System.Data.SQLite.SQLiteConnection $conn.ConnectionString=$ConnectionString $conn.Open() $sql = "SELECT * from moz_bookmarks" $cmd=new-object System.Data.SQLite.SQLiteCommand($sql,$conn) $ds=New-Object system.Data.DataSet $da=New-Object System.Data.SQLite.SQLiteDataAdapter($cmd) $da.fill($ds) $conn.close() $ds.tables[0] </code></pre> <p>Since sqlite-dotnet-x86-1006900.exe they spitted SQLite.Interop.dll from System.Data.SQLite.dll, but had problems with installing it in GAC. If you check the install in GAC checkbox, you get an Unable to load DLL 'SQLite.Interop.DLL error. There is a closed <a href="http://system.data.sqlite.org/index.html/tktview?name=54e52d4c6f" rel="nofollow">ticket</a> for this error, but I think it is not fixed. The ticket is reopened again. check there for new work arounds or solutions.</p>
    singulars
    1. This table or related slice is empty.
    1. POOpening Firefox file 'places.sqlite' with PowerShell and System.Data.SQLite
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USbernd_k
    1. USbernd_k
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODid you check the option "GAC" on installation? Try to do this and then use the workaround (it was me BTW who posted that, so I did try this, it worked for me).
      singulars
      1. PO
      1. USRoman Kuzmin
    2. COYes I tried it. The other dllS go to C:\Windows\assembly, but SQLite.Interop.dll is missing. Going back to the old version to develop my scripts until there is a fixed precompiled version. I don't want to spend time compiling it myself.
      singulars
      1. PO
      1. USbernd_k
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload