Skip to main content
Participant
March 18, 2009
Question

ExtendScript and SQLite

  • March 18, 2009
  • 2 replies
  • 1200 views
Hello,

I need to query a small SQLite Database from within Bridge. Does anyone know if that is possible.
Maybe via:

1. "Integrating External Libraries", which is too hardcore for me :(
2. Commandline, which is not that nice
3. A small AIR app connected via SwitchBoard

Has anyone coped with this task before?

Regards, Markus
This topic has been closed for replies.

2 replies

Participant
March 18, 2009
thanks Bob,
this would be the easiest solution for me, but I forgot to mention, that the db should be local (thats why sqlite) on the users machine. There is an standalone air application that should be altered/ported to be running as SWF in a bridge tabbed palette. SWFs seem not to offer support for using sqlite directly and so I thought I could do the queries with extendscript. I will give the commandline approach a try, or maybe there is another solution?
Apart from this project, I find the idea of having a small database available in my Bridge Scripts very very promising. XML is fine for storing data, but searching, sorting, deleting, joining data is much work:(

Regards, Markus
March 18, 2009
Best bet would be to create a simple web service interface to the db. You can then use the http stuff in the web lib, write or use one of the Socket based http clients that folks have written, or use PatchPanel.

Bob