title: Installing SQLite On Mac OSX - Or, Is There A Recommended Alternate DB?
body: <p>I'd like some advice on SQLite in OSX Snow Leopard.</p>
  
  <p>I've read a gazillion posts and, of course, nearly all tell of the problems, and not the solution.  Before attempting an install that may lead to problems, <strong>I'd like to get the "<em>Here's how to do it</em>" that works</strong>.</p>
  
  <p>I do have MySQL installed and can use it in Netbeans.</p>
  
  <p>I also use SQLite as part of my Android app programming (via Eclipse).</p>
  
  <p>I also use the database that comes with Netbeans/java but, it requires going through lot's of hoops to run it outside the NB IDE.</p>
  
  <p>I also use Base (the OpenOffice database).</p>
  
  <p>Although I can easily turn on/off MySQL from the convenient add-on to the Sys Pref's, it is a memory hog and memory isn't released after turning off the connection and turning it off. Also, I don't really need it's power for my minimal db needs so, I'd like to use a smaller footprint, such as SQLite.</p>
  
  <p><strong>Some Questions</strong>:</p>
  
  <ol>
  <li><p>Since I use SQLite with Android, is it available to use in standard Java from Eclipse <strong>?</strong>  How about from Netbeans <strong>?</strong>  (I prefer Netbeans for standard java programming). And, how to run it outside Eclipse/Netbeans IDE <strong>?</strong>.</p></li>
  <li><p>Where can I find the Simplest install instructions <strong>?</strong></p></li>
  <li><p>Is there a GUI interface available that enables basic db create/query...etc (What and where to find it <strong>?</strong>). Perhaps even a tutorial... I'd like to be able to work with a database as a stand-alone rather than through a cumbersome IDE. </p></li>
  <li>Is there an alternate stand-alone <strong>?</strong> </li>
  </ol>
  
  <p>Thanks - any input is much appreciated.</p>