Database :: Approach Local Database Management Via Flex/Air App?
Jan 17, 2011
I am planning on using Flash Builder 4/Flex to write an AIR application which is primarily based around recording, storing and analyzing data.I'll be creating charts etc that need to update in almost real time.It's essential to me that the application be able to function without an internet connection so I need a local database of some variety,but I would also eventually like to build in online synchronization of the data where either database can be update each other based on newer information. Moreover, some type of encryption would definitely be welcome, and speed is a large concern
Synchronization: Primarily updates/additions/deletions will be done on the offline database, but ideally I want to have a web interface that will allow the same updates/additions/deletions and will be synced (beyond that I'm not sure exactly how to do it as I can model that based on what is most achievable).I'm wondering if there's any prebuilt engine that could handle the synchronization of 2 databases. I may end up having the web interface only be for additions, which would be significantly easier to sync.. and I may start that way, but i want to build with technologies that will best allow me to implement full online crud at some point.
View 1 Replies
Similar Posts:
Dec 17, 2009
I want to create a Flex 3 application running in Adobe Air that accesses an SQLite database and I need to keep this database in sync with an SQL server 2005 database running a website.Is this something that Flex supports or is it going to be a custom script? Also, has anybody done anything like this?
Edit: The synchronisation can be done on a daily basis rather than real time. The data will be read only from a front end perspective with a CMS to do updates on the website.
View 2 Replies
Mar 17, 2010
I right now making database for employees. May I know how many data base management systems are available in flash?
View 11 Replies
Jun 7, 2010
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything. So, my issue is this. I have a mySQL database hosted I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.Here is my licenseTracker.mxml
<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark"
[code]....
View 9 Replies
Aug 31, 2011
I have updated the mxml code to only show the needed code for the program to run the update.
I am new to Flex and have an issue I hope you all can help me out with.
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything.
So, my issue is this. I have a mySQL database hosted on 000webhost.com, I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.
Here is my licenseTracker.mxml
<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark"
[Code].....
View 1 Replies
Nov 14, 2011
How do I connect Flex3 to a MS Access 2007 local database? Could you provide some example code for a login page using username and password and validating it?
View 2 Replies
Sep 26, 2011
Here is the issue: a client wants his entire equipment inventory accessible by persons navigating to his jquery mobile site. The inventory that exists on the desktop site was, as I understood, built with Flex. Is it possible to access this database for the jquery mobile site? I believe it is. I was then given this information from someone in the know:
Database:
mlxx.db.xxxxxxx.hostedresource.com
login: mxxx
[code]...
View 1 Replies
Mar 17, 2010
how many external sources available in flash like xml....
View 1 Replies
Jan 11, 2010
I am planning to develop a standalone application, which infact will be used for personal purposes. So only single user access may be there. I want to develop it in Flex. Just want some opinions from the gurus over here : Whether i should use Flex or AIR (I know only Flex, AIR i need to start learning)Which database i should use? SQLLite or HSQLDB or some other.
View 3 Replies
Jan 2, 2012
I'm having some trouble getting around a security restriction of flex. Saving a file is apparently an action that can only be invoked upon user interaction. The problem is that after my user clicks on the save button, I need to perform a database query to get the data for the file I want to save.
Because Flex works asynchronous, I have to make the database call and then catch the ResultEvent in a different function. In that function, I no longer have the user's mouseclick event. How am I then supposed to save this file?
[Code]...
View 1 Replies
Dec 14, 2011
I am writing a large flex app that has to connect to a database many times. I currently am using asp pages to connect, but I would like to use the most efficient option. What do you think is the best way to connect to a database from a flex app?
View 1 Replies
Jul 15, 2009
i want to intertwine php, MySql and flash. so i can make a flash movie display text that is in the sql database and a php script to change the database, php > sql = i can do but sql > flash = i can't do..i want it so the sql data show's in a text box in the flash movie...
View 1 Replies
Apr 7, 2012
We are planning a desktop client application with Adobe AIR. The client app will be delivered to our customers with a database, which contains monthly updated marketing data provided by our company. As different customers will buy different sets of data from us, for example, a customer is only interested in marketing data in a specific product category, while another customer need all data in a certain region. After a customer installs this client app, new data will be emailed to the customer every month.
So, the requirement is to keep the data accessible only by the customer who bought it. After reading through AIR's secure local store and database encryption feature, I came up with the following design: each customer will have his own secret key (stored in AIR's secure local store), the secret key is used to encrypt the data that the customer has purchased. Of course, the monthly data that we sent to the customer will be encrypted using the same secret key. So my questions are: is AIR's database encryption and secure local store secure enough for this use case? If someone gets the encrypted database file, can he decrypt the DB?
View 1 Replies
Jun 17, 2010
I am working on a function to generate a form at runtime in Flex based on a call to the DB. The call to the DB returns the field types, id, tooltips etc as an arraycollection, the arraycollection is then parsed in order to ascertain what control to display based on the type field in the array - this bit works fine.However, i am stuck on trying to save the form fields back to the database using a CFC.my form rendering code is as follows but how do i save values entered back to the database? rendering code..
[Bindable]
public var getglobalprofileb:ArrayCollection;
public function init(event:ResultEvent):void {[code].......
View 1 Replies
Mar 21, 2011
Id like to know if theres any way, to create a local database, with actionscript, php and mysql.And communicate with the database, like inserting data to the database, and selecting data from the database,I mean,if actionscript is able to communicate with the local database through php and mysql.
View 3 Replies
Jul 17, 2011
Can I build flash application that connects to database? (MySQL) For example: Photo Gallery that brings me the photos from database...
View 3 Replies
Oct 26, 2006
Is it possible to create a database driven website using these alone? Or do i need to learn any other technology? If i do then what should i learn? I know j2se for the desktop and oracle SQL/MySQL i finally got the feeling that i need to learn PHP anyway along with css and javascript. So it is fine. Also another query. Which CMS should i consider? Wordpress or Joomla?
View 1 Replies
Aug 30, 2010
I'm making a login script and adding the data to my local mysql database using php.it works as long as I browse in my browser to localhost/ flash/ movie.swf but if I just open the folder and run the .swf file it doesnt work
View 2 Replies
Jan 12, 2011
I need to store a large amount of data that will be internally accessed often within a flash file. The database is temporary and does not need to be stored in an external file. Is it possible to use SQLite to create a database that may be used internally in flash? As far as access speeds are concerned, is this an efficient solution?
View 1 Replies
Jun 29, 2011
I need to find a way to develop a program which can run local and server side. I don't know silverlight/flash or something else can do it.Is there any framework/language/platform which can work over internet when internet connection exists and can work when internet went off?
View 1 Replies
Jan 4, 2012
I have got Flash CS5 and i create AIR desktop application. I would like to create and edit sql lite local air database. I know i should use SQLStatement and sqlConnection. Could someone give me any advice about doing that. Maybe some tutorial or something what let me to do that.
I don`t know should i create that database sql lite file earlier and include it to air project or should i create that database in dynamic way by as3? How can i get and edit data from this database? How can i save that local database if it included in air project (i would like to that database file would be inside of air project)?
View 4 Replies
Jan 10, 2012
I would like to have a Flash Application (not air) to connect to a local database. Air is not only getting unsupported by Adobe in LINUX but besides, it has serious problems and miss implementation with SQLite. So we want to connect to a local MySQL database. This application should be simple, so we do not want to also have an unnecessary web server (also local) to make a middle communication between the flash app and the MySQL server. There is this driver that allow to communicate Flash with MySQL [URL] Question is: Would it be any problem using this approach when installing the whole application to each client? (because we also in the installation should install a MySQL server).
View 1 Replies
Jan 15, 2009
But this website is simply superb. I want to how to connect flash to local sql database without the server side scripting.
View 3 Replies
Jan 4, 2008
I want to make an offline desktop app. that stores my company's customers and their data in an XML file, just like a database. so that I'm able to load, edit (create new customers, add to their data) and save it into the XML file which is stored locally. i then want to make a Local Connection to the XML file somehow, so that others in the company can do the same from their PC.. Can anybody tell me if this is possible at all? (making a flash app that writes XML files to any location on a PC that only has network.. edit XML files through Local connection function in flash).
View 3 Replies
Jan 15, 2012
I have a database on a server and I transfer the data from it to a web site. So I need to build a flash grid on this site and to load the data on it. But the problem is that I do not know how to do it. So my question is how to build a dynamic flash grid wich is fill with data from a database? Is there a way to do it with action script only or I must do it another way?
View 1 Replies
Apr 12, 2010
im trying to establish a standardised approach handling event management.ive been using a similar structure to this on all my projects and havent had any problems.url...weve had a new guy start in the office who uses this method, and i can see why its an easy solution to use too, but not sure if we'll run into problems.url...was wondering if anyone had any thoughts on the correct way to handle this, and what potential problems we may come across.
View 1 Replies
Nov 13, 2009
Is it possible for Flash or possibly Adobe AIR to have access to a local Access database?
I will have either a Flash EXE or AIR application running on a local PC (WinXP). The PC will also have a local Access database. I need my Flash application to get the data from this Access database. How would I do this?
I doubt it can be done with Flash or AIR alone (someone prove me wrong or right), but is there an option for some middle-man application to access the data base and send it on to Flash? How would this work?
Or could I read the MDB file into Flash and parse it myself? is there a library for this?
View 2 Replies
Feb 4, 2010
I've started with Flex recently, I've noticed that some plugin for Visual Studio exist, instead of buying a licence for another program (Flex Builder).I was wondering how I could manage to remotely connect to my database with a Flash/Flex application with the help of C#/Asp.Net.
If I've correctly understood what I've read in the last few days, there is basically no way to 'query' to a database with Flex 3. So I suppose there is another way by using a webservice in C# on the database server that would respond to the Http query from Flex.
View 3 Replies
Feb 10, 2010
I have a combo box that is currently getting its information from a database this seems to be working fine.Now I would like to have content from two fields displaying in the combo box at once. Say First Name & Last NameI've added the information to the query fine but the data displayed in the combo box seems to be controlled by the labelField property and it seems to only allow one variable at a time. So it will either display First Name or Last Name but not both at once.here's bit of my code
private function NameData():void { //NAME DATA
var stmt:SQLStatement = new SQLStatement();
stmt.sqlConnection = sqlConn;
[code].....
View 1 Replies
Sep 30, 2009
I use flex and php to retrieve information from my sql database. What i have been doing is formatting the result from the database query into xml and then putting the result into an arraycollection. It all works fine except one of my database fields contains a lot of text that website users enter and as xml doesn't like tags like <> so I leave it un formatted but I would like to format it. Would I be better using flashvars or text than xml? Or is there another way?
View 3 Replies
