Martin, I have run across a problem that I think might be suited to JEQL. We are designing the RDBMS side of a GIS at work. Despite my protests the decision was made to use Microsoft Access instead of MySQL. :[
I did get one small victory. They agreed to avoid creating any GUI forms or reports in Access. They are going to let me do this in Java, so we can port the forms and reports to MySQL when the time comes. I'm thinking I could use JEQL with some simple "flat files" exported from Access to support simple queries from a Java GUI, and use iText for the reporting. Any thoughts on this? Remember this will be a temporary solution. At some point they'll hit the ceiling with Access and we'll move to MySQL. On a somewhat related note I have been working on an scripting engine that processes simple text commands to manipulate alignments and alignment stationing. I started the project to see what it would be like to build an interpreter in Java. I had originally thought I would try it in Java, and if the engine was a sucess try implementing it in C. If you have any insights to share with me about implementing a scripting engine in Java I'd like to hear them. The Sunburned Surveyor P.S. - If you want help setting up a SourceForge project for JEQL let me know. It would give you a place to host the source code and distributable, as well as a mailing list. On Jan 23, 2008 3:15 PM, Michaël Michaud <[EMAIL PROTECTED]> wrote: > Hi, > > Really an interesting discussion. > I will definely keep an eye on this new project. > The feature request from Tore (about querying a shapefile) looks like > one of the interesting features of the GDMS library, the engine behind > OrbisGIS, a recent project driven by Erwan Bocher. > > http://orbisgis.cerma.archi.fr/?page_id=44 > > Michaël > > Martin Davis a écrit : > > > > Not at the moment, but that's an excellent idea! > > I've thought about it once or twice myself, but haven't had the time > > to pursue it. It would be fairly easy to do this in a simplistic way, > > I think. Adding the ability to make use of a shapefile spatial > > index would be a bit more work, simply because JEQL doesn't yet have > > the ability to query through an index. That's definitely in the > > plans, however. > > > > So you'd provide the pathname of the shapefile via the connection URL > > in some way (is there an existing pattern for this?), and then be able > > to run SQL queries directly against the shapefile. > > This would also work with any other datasources which JEQL offers. > > > > Hmmm - I guess I better start a JEQL listserv! > > > > Tore Halset wrote: > > > >> On Jan 23, 2008, at 19:02, Martin Davis wrote: > >> > >>> A further note: although not currently implemented, JEQL will > >>> provide the ability to directly access tables and queries from > >>> databases. Since there is no "impedance mismatch" between the JEQL > >>> data model and the DB data, this should make for very seamless > >>> integration. > >> > >> > >> Does JEQL contain a jdbc driver, so that it can be used from a > >> generic java database client to conntect to things like a shape file? > >> > >> Regards, > >> - Tore. > >> _______________________________________________ > >> jts-devel mailing list > >> jts-devel@lists.jump-project.org > >> http://lists.refractions.net/mailman/listinfo/jts-devel > >> > > > > _______________________________________________ > jts-devel mailing list > jts-devel@lists.jump-project.org > http://lists.refractions.net/mailman/listinfo/jts-devel > _______________________________________________ jts-devel mailing list jts-devel@lists.jump-project.org http://lists.refractions.net/mailman/listinfo/jts-devel
