Skip to main content
C
cosmits
Known Participant
March 20, 2013
Question

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

  • March 20, 2013
  • 1 reply
  • 2483 views

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.

This topic has been closed for replies.

1 reply

M
moccamaximum
Inspiring
March 20, 2013

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.

C
cosmitsAuthor
Known Participant
March 20, 2013

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

M
moccamaximum
Inspiring
March 20, 2013

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices