facebook

Information about connect to a remote DB from MobiOne app

  1. MobiOne Archive
  2.  > 
  3. Getting Help – General
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #341035 Reply

    martec
    Member

    Hello,

    i looking for a tool that can create an interfaces for my destop-app (management software).
    I would connect mobile app to db, and update record… (best it’s the possible to save data in mobile app db, and sync with remote db)

    So, it’s possible with MobileOne build an app “linked” to a remote db? And if it’s possible, can i have documentation about?
    (i found viewtopic.php?f=14&t=5738 but i think it’s a little different my problem)
    Thanks in advance.
    Regards

    #341082 Reply

    nvts
    Member

    Hello,

    Yes it can be done with using mobione to develop the mobile app and then use a PC/Web based administration app that would handle the more robust tasks of the data collected.

    PHP & MySQL is the most common and it does work as I have tested and have it working well.

    Syncing is going to be the most tedious or complicated part you are seeking.

    I am working now on using PouchDB and CouchDB as my new db structure. It is like IndexDB but will all the syncing done for you by using PouchDB on the local/offline side and then it will sync with the server db when it comes back on line.

    You just have to remember that mobione is a designer and not a generator per-say. You have to create the connection and the CRUD needed to use the db side.

    I know there are some other designers with db generators out there, but not very cheap either.

    I have tested db inside mobione apps for MySQL, localstorage, IndexDB & SQLite and now working on the PouchDB side now.

    I know this is not showing you how, but letting you know that it can work with mobione designer.

    Cheers…

    #341113 Reply

    martec
    Member

    Hi,

    thank you! Your replay it’s great, and completed…
    I need to understand now, how it’s complicated to integrate a db in MobiOne for us…

    Thanks again. Regards.

    #341122 Reply

    nvts
    Member

    martec,

    It is not complicated to integrate a db into mobione designer. You just have to develop the connection and the CRUD for what ever db you choose for your app. You will have to code the js and php if using server side db to make this happen and then the js to display on the layout that you designed in mobione.

    Providing a sync for the db’s is the more complicated coding or item as I was referring too.

    That is why I am developing a PouchDB CRUD for my apps at this time. It is a syncing database that also runs as a local db for apps that only need local.

    My first reply was to let you know that it could be done, but there was no simple way without coding. Others have posted some basic samples that will help you. You just need to decide what is going to be your db of choice.

    I have included some screen shots of the screen listing a MySQL db that is on my server with the php scripts and mobione with the js to create the layout. This is my CRUD side that I am developing. Instead of having multiple screens I use and list the db and all the CRUD on the one screen with search to limit the db and sorting asc/desc all on the app screen for the db manipulation.

    See attachment 2013-07-30_074109.png See attachment 2013-07-30_074229.png See attachment 2013-07-30_074257.png See attachment 2013-07-30_074409.png

    I decided this way was the best for what I am developing vs the multiple screens that I was first working with. Now my code is reusable for future apps.

    Cheers…

    Attachments:
    You must be logged in to view attached files.
Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Information about connect to a remote DB from MobiOne app

You must be logged in to post in the forum log in