title: Interacting with a .db file from Linux shell
body: <p>I recently installed minidlna, a lightweight UPnP server, on my Raspberry Pi. Since this lacks the web interface of other programs such as Mediatomb, I thought it could be an interesting project for me to write one.</p>
  
  <p>I believe minidlna stores library information in a single file named "files.db". </p>
  
  <hr>
  
  <p>EDIT: I was advised to check the output of <code>file files.db</code> - this was as follows:</p>
  
  <p><code>files.db: SQLite 3.x database, user version 8</code></p>
  
  <hr>
  
  <p>However, I can't find a program that lets me interact with .db files from the shell. I've seen the following programs recommended:</p>
  
  <ul>
  <li>isql</li>
  <li>dbaccess</li>
  <li>sql</li>
  <li>SQLite3</li>
  <li>db.util</li>
  </ul>
  
  <p>In the first four cases, <code>sudo apt-get install</code> cannot find the programs.</p>
  
  <p><code>sudo apt-get install db.util</code> appears to install, but partway through installation, yields the following messages:</p>
  
  <pre><code>Processing triggers for man-db ...
  Setting up gcj-4.7-base (4.7.1-1) ...
  Setting up libgcj-common (1:4.6.3-7) ...
  Setting up libgcj13 (4.7.1-1) ...
  Setting up libgcj13-awt (4.7.1-1) ...
  Setting up gcj-4.7-jre-headless (4.7.1-1) ...
  Illegal instruction
  ERROR: gcj-dbtool did fail; known problem on armv6l
  Setting up gcj-4.7-jre (4.7.1-1) ...
  Setting up gcj-4.7-jre-lib (4.7.1-1) ...
  Setting up gcj-jre-headless (4:4.7.1-1) ...
  Setting up gcj-jre (4:4.7.1-1) ...
  Setting up libservlet2.5-java (6.0.35-5) ...
  Setting up libhsqldb-java (1.8.0.10-11) ...
  Setting up hsqldb-utils (1.8.0.10-11) ...
  </code></pre>
  
  <p>Thereafter, <code>which db-util</code>, <code>which db.util</code>, and <code>which dbutil</code> do not yield any results.</p>
  
  <p>Is db.util the correct program to be installing to interact with .db files? If so, how can I fix the reported error with gcj-dbtool? If not, could someone recommend a better program?</p>