Tutorial: SQLite and Processing, Part II
--D. Thiebaut 17:01, 30 June 2011 (EDT)
This is the second part of a quick tutorial to accessing an SQLite database from Processing. Check out Part 1 for how to run the example in Processing's IDE.
Setup
- First follow the steps of this great tutorial for creating Processing applications with Eclipse. Remember the steps for adding the core.jar library to your Eclipse project.
- Get the same archive zip file as in Tutorial 1
- Unzip it
Eclipse
- Start Eclipse
- Create a new project, call it SQLiteTest
- Create a new package', call it SQlitePackage
- Create a new Java classes in the pacakge called example1.java and copy/paste the contents of the SQLite_example1.pde file which you'll find in the example folder of the zip file.
- Locate the SQL.java and SQLite.java programs in the source, de, bezier, data, sql folders of the zip file, and import them into the package using Eclipse's File, Import, File System utility.
- Edit the 2 SQL*.java files so that the package line at the top reads
package SQLitePackage;
- Edit the contents of example1.java as illustrated in here.
- Import the core.jar Processing library into your project (see above).