SQLibrary

SQLibrary.

a library for the programming environment processing.
last update, 03/23/2010.

SQLibrary lets you communicate with a MySQL, PostgreSQL or SQLite database.

please note: working with a remote database in a plublicly accessible applet is highly insecure.

download

download SQLibrary version 0.1.0 in .zip format

installation

before trying to use this library with any database make sure you have that up and running. the library is just a wrapper to help connect to already installed and running databases (MySQL, SQLite, PostgreSQL).

installing the library itself:

• quit processing
• find your sketchbook folder, see second paragraph here
• add a folder called libraries (lowercase) to your sketchbook if its not already there
• move the SQLibrary-0.1.0.zip into that libraries folder
• unzip it in place
• rename it to SQLibrary
• start processing and run one of the included examples to see if the lib is working

keywords MySQL, SQLite, PostgreSQL, SQL, database

documentation. have a look at the online documentation here. a copy of the documentation is included in the .zip as well.

source. the source code is included in the download.

examples

find a list of examples in the current distribution of SQLibrary, or have a look at them by following the links below.

• MySQL_example1
• MySQL_example2
• MySQL_timestamp
• PostgreSQL_example1
• SQLite_example1

tested

platform osx
processing 1.0 (016x)
dependencies mysql, sqlite and postgresql jdbc drivers (all included)

demos

You've built something nice with this lib? Mail me the link and i'm happy to "add" you to "the list below".