Best Solution Architecture

this time i'm dealing with this issues, 开发者_开发知识库we are currently starting a new project in which there are several requirements that we need to accomplish.

• Solutions must run on Mac,Windows and Linux.
• Can be configured to use a embedded database engine such as SQLite or Apache Derby, and can also be configurated to connect to a remote database engine. MySQL for instances.

• One module of this solutions is planning to run on a table under Android OS.

  Doing some researchs, I found adobe air and it fix to most our requirements, as far as i know it can run under windows,mac and linux and even android OS. but unfortunately is not perfect because there are a couple of restriction about Peripherals handlers (has to be implemented using java code) and remote database handlers (we need to use a php or java code to connect to it).

  Do you guys have any advice in order to architected this solutions as better as possible

Well, there are many cross-platform frameworks to choose from. What is appropriate depends on many factors. Here are a few you might look at:

• Java (using Swing, possibly SWT + JDBC)
• JavaFX
• using a scripting language such as Python (not sure what GUI language you can use then)

Java is probably the best option at least for Android, as it's the offical, recommended language/API. Also, it's widely used, and free software.

I'd be somewhat wary of Adobe AIR, as it's a proprietary platform, so you'll always be at Adobe's mercy for support of new platforms etc. But that is your decision to make...

Also note that Adobe AIR for Android is still in beta:

The Adobe AIR SDK and Adobe AIR runtime is scheduled to support Android by the second half of 2010. Integrated tooling support will be announced at a later date.

( http://labs.adobe.com/technologies/air2/android/ )

you could look towards a service-oriented architecture for answers. If you develop a number of services that connect directly to your database then you could utilize these services from a number of platforms even android or iphone ones. Adobe AIR is something I looked at but from what I have read I cant get enough confidence. Web services however especially if you go down the route of REST could offer many advantages.