Is it possible to save data to sqlite using flash player plugin rather then AIR?

[cosmits]

Hi all!

We have a flash web app.

we thought to use local storage to enhance performance and responsiveness.

LSO falls short to sqlite.

AIR is too far on the roadmap for us productwise,

therefore wanted to ask if the flash player had evolved to include sqlite local storage from the browser like HTML5 has access to...

cheers.

[moccamaximum]

Why would you use SQLlite in a server environment when you can easily use the real deal (MySQL)?

With php its a no brainer to read/write to mySQL.

If you want to use local storage LSO is (for good reasons) the only option flash will provide, otherwise you would open doors to all kinds of security problems.

You can be sure if someone hacked out a way to secretly install sqllite via flash, adobe would be wise to close that leak asap.

AIR is too far on the roadmap for us productwise

?

Its not like you have to convert anything if you used FlashPro/FlashBuilder etc. to publish to AIR.

In my experience you can use your existing Flash-AS3 Code Assets etc 100% to export to AIR (not the other way round obviously).

AIR delivers the complete Flash Experience with a slightly bigger runtime.

[cosmits]

Hi Mocca and thank you for responding

It would be ideal to have a local storage that would sync with the remote mySql and nnot replace it.

Like AIR apps can sync local sqlite db with coldfusion remote connection to remote DB.

the result is that the user doesn't need to wait for data to be loaded and processed by the server

instead it can be done on the client, and have the two db's sync in the background.

the result is a significuntly more responsive user experience.

have a look at two Node.js frameworks which are aiming to create this kind of user experience with push and sockets... - Meteor.js & Derby.js

I believe the same level of responsiveness & slik user experience could be achived using flash local sqlite and sync with remote db in the background.

HTML5 has access to local storage using sqlite, HTML5 is running in the browser, and is exposed to the same security threats and still - it's an accessible and attractive option to the developer.

We want our app to be a web-app, accessible via the browser, not having the user download & install if he doesn't want to...

besides, not always the migration from browser based flex web app to AIR is that smooth as you say it is.

much of the functionality is tied with JS communication in the hosting HTML vie ExternalInterface

and many other use-cases that assume the browser is present, so it will take quite a while for us to convert it to AIR

therefore, if this is the only reason to convert, I don't see why not allow sqlite access to the flash plugin if HTML5 web apps has this accessability.

cheers

[moccamaximum]

I have a hard time reading your response. Consider using paragraphs next Time, please.

It is a little irritating for me why you would ask on a flash forum how to tie your Game storage option to html5/javascript browser,

when your response shows that you have a little knowledge about that html5 and Flash are considered at the moment not exactly best pals (thanks to the Fruit People).

With External Interafce you can practically trigger any javscript that a browser can make sense of with flash.

But again: Why would you assume that html5 storageusage with Flash would give you (at the moment)  a better responsiveness than Starling/Stage3D?

Besides: html5 support on the browsermarket is like 40% at the moment, so you would definitively have to have a second fallback option if your users are not iPoop-users

Good luck with that, but If your javascript/htm5 knowledge is not non the same level as your as3 skills, I`m tempted to bet that it will take you a lot of more effort

to migrate your flashgame to a flash/javascript/htm5/sqlLite solution, then take the simple approach to use AIR.

[cosmits]

Mocca Hello

Please don't get me wrong

I'm 100% AS3 guy. I'm not trying in anyway to bash the flash platform I hold dear.

We built an enourmous Flex Web-app (we will not write it from scratch in Starling)

We are looking to enhance the user experience by having our current web-app be more responsive.

this persived performance can be achived with a local db & a remote db synching in the background having the client communicating with the local one.

I mentioned migrating flex web-app to AIR is not optional for us at the moment for two reasons:

• since we don't want to force the site visitor to downlowd a desktop application
• and have some dependencies in JS libraries and browser integration.

you mentioned a security issue, being the reason sqlite is not offered to the flash player

that was the reason I mentioned localstorage of html5. because it has this access from the browser

thus having the same security considerations as you mentioned.

You can of course imagine I attack flash (there's nothing more remote from the truth then that, I invested 12 years in the flash platform)

Or you can treat this seriously and consider this feature to be worthy of promoting to go in the dev cycle wishlist. (don't have a clue how to promote it inside Adobe)

Speaking of Adobe - I heard the CTO Kevin Lynch is moving to Apple. do you think that is a good thing for the flash platform

or do you think Shantanu Narayan needs to draw conclusions?

[moccamaximum]

Sorry, my statement came over more aggressive than I intended.

this persived performance can be achived with a local db & a remote db synching in the background having the client communicating with the local one.

So you already did what you asked? Are there any examples you can link to?

consider this feature to be worthy of promoting to go in the dev cycle wishlist.

No, I don`t. Why would you add a feature to swf that air already has? If you only want to employ sqlLite of Safari et al. then use a javascript bridge to do it.

Which you seem competent enough from what get from your expertise.

Targeting HTML5 features with Flash would be contradicting any of Adobes recent Moves (for example to build a Workflow with Edge tools to adress JS/HTML5).

[cosmits]

appology accepted, no worries, this is quite a charged conflict.

Why would you add a feature to swf that air already has?

Because Air features are not available for web-apps that live inside the browser,

Web applications or Rich Internet Applications as those were propogated by Adobe for many years are being built and maintained with flash & flex,

though management in Adobe decided to take a turn and promote the notion that flash is for games & video and move all interactive web aspirations to HTML5 and Edge (will take take some time till this newborn product will mature to the level of flash & flex), You have many developers who write web apps with flash & flex.

Your idea to use ExternalInterface (The JS Bridge) to take advantage of html5 localstorage is actually a good one and can work for our needs.

strange to get this kind of advice in an Adobe flash forum but I guess I should remind myself that these are not holy-wars, but dev-tools to be used to best fit the task at hand

thank you for your time

Cheers

[moccamaximum]

Good luck with your efforts 😉