@jim said:

For me, the easiest thing to do would be to use a WebDialog to communicate with a server where some php scripts handle the db interactions.

+1

Trying to crowbar in sqlite into Sketchup Ruby is a fool's errand. Better to use a WebDialog to send & receive html requests that are processed by some web server that actually does the talking to the server DB.

So decide what your html requests are going to look like (don't pollute them with sql) eg :

http://foo.com?cmd=dir
http://foo.com?cmd=get&sheet=ABC

then write some server side code to parse those requests and do actual sql queries to squirt html back to you.