title: SQLite & Its Drivers
body: <p>I'm new to the SQLite database, and more generally, to the concept of embedded databases altogether. I'm used to creating a connection string and connecting to a remote DB server (MySQL, MSSQL Srv, Oracle, etc.). I know this question is probably quite silly, but being in uncharted waters here, I can't seem to find the answer to this on my own.</p>
  
  <p>So I'm writing a Java app that uses SQLiteJDBC as the Java driver for SQLite (the app's embedded db) and am creating the tables and inserting records into them from the Java app itself. What I'd like to do is download/install SQLite on my system - completely independent of the Java app - and then write SQL scripts that will do the "<em>skeletonizing</em>" (creating &amp; insertions) of the database file itself, then copy that .sqlite file into my project directory where the app can then use it.</p>
  
  <p>I'm just finding it incredibly difficult to develop database schema from inside the Java app itself; just seems like an unnecessary step.</p>
  
  <p><strong>So, my question:</strong></p>
  
  <p>Is this even possible? To create, say, myProgramDB.sqlite off the command line with the SQLite tool, and then (essentially) cut-n'-paste that file into my Eclipse/NetBeans project (of course, in the right directory!) and have it work? This is also assuming I have correctly imported the SQLiteJDBC JAR into my project through the IDE.  I just want to create the DB somewhere else, then copy it into my project, instead of developing the DB <em>through</em> my app directly.</p>
  
  <p>Thanks for any insight!</p>