Link SketchUp with Database

[RallouD]

Hi

I am a researcher and I am looking for an application to provide a direct link between SketchUp and database so that editing data in sketchup it is updating my database and vice versa.
Actually, I would like to integrate the Room Data Sheet data into Sketch up.
Does anyone have done something similar? Any advise could be useful.

Thanks!
Rallou

[macgile]

hi rallouD

try this : http://pleac.sourceforge.net/pleac_ruby/dbaccess.html

[Jim]

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.

[Chris Fullmer]

Jim is there a PC and Mac easy single click installation solution for the server and php installation? I'm also looking at database access and I'm not pleased with what I'm finding yet.

Did anyone ever get sqlite3 and sketchup ruby working?

[Jim]

If you have an extra PC on the network, a standard Linux install will probably come with everything you need.

I use wampserver for windows. Wamp is short for Windows, Apache, MySQL, PHP.

[AdamB]

@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.