Not exactly a robotlegs question :) database on adobe air

bojamunje's Avatar

bojamunje

10 Nov, 2013 10:27 AM

What kind of databases do you use on offline air apps (if you make that kind of apps)

I want to create an app that will work offline, but sync with online database, and I like mongodb like databases more than sql dbs.

Can you please share your approach to this kind of work?

thank you :)

  1. Support Staff 1 Posted by Ondina D.F. on 13 Nov, 2013 10:51 AM

    Ondina D.F.'s Avatar

    Hello,

    Indeed, this is not a robotlegs question:)
    It's not even just an AIR problem.
    Database synchronization is a really complicated matter.
    I suggest you ask your question on stackoverflow [http://stackoverflow.com/]
    But, firstly you'd better narrow down your question and describe your specific use case.

    Some of the questions, I think, you'd need to ask yourself:

    • what do you want to synchronize? row-based sync, field-based sync?
    • is the online database residing on a central server?
    • is the client db a subset of the central db or is it a 1 to 1 copy?
    • do you need a db replication mechanism ?
    • is the sync process one-way ( server to client, or client to server) or both ways?
    • how often do you need to synchronize the DBs?
    • are you using GUIDs, composite keys or a key pool server?
    • can you afford using a commercial middle-ware for conflict detection and resolution, kind of a sync server?
    • is security important?

    For Air, as an inspiration:
    http://flex.sys-con.com/node/834097

    http://www.cleartoolkit.com/dokuwiki/doku.php?id=clearwiki:20.clear...

    Ondina

  2. Ondina D.F. closed this discussion on 23 Dec, 2013 09:23 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac