Database for one app

[aebki]

Hi,


I am thinking in one app, and i have one doubt about the database location.
In this app, all the users have to interact with the same database.
So, how / where i have to locate / host this database?

Thanks in advance...

Regards

[Klaus]

Is this for Mac, Windows, Linux or Mobile?
Does the DB need to be local or online?

[aebki]

Hi Klaus,

Thanks for your answer...

For mobile (for the moment iOS and the Android...But i think it should be the same).
Each user has to interact with the same database. So, i think it should be online! But i don't want to say that i am 100% sure because i don't know how it is for mobile...But i am quite sure!!!
As i don't want to copy the database to each user to can work in local each time i will need to use the database...


Regards

[mcbroh]

Hello Aebki,

I do think your database location should be online, and depending on the database interaction.

Am sure you will get more information regarding this though.

Regards
Mcbroh

[aebki]

Hi,

thanks for the answer...
Regarding what?

And yes, maybe you are right because for the moment i am not managing very well all 'mobile way of doing'...
I need that the user of this app can connect to one database where there are some information he will need to read and other to modify.
And this information just modified it should be accesible to other users in this moment ( even if not all the users and not always ) need to see the data modified by the first user.
But it can happen!


So you have a little bit more info, what is your mind? Online or local ?

Regards.

[Klaus]

Hi aebki,

yes, of course the DB needs to be ONLINE, if more than one user need to access it!

Please also read this thread, there are some things in it you sure have to consider!
http://forums.livecode.com/viewtopic.php?f=12&t=22589


Best

Klaus

[aebki]

Hi Klaus,

Thanks for your post...

I finished to read the thread and it seems to me that what i need is to do the same as the link Simon posted there...

For the other app i am making, i used sqlite...Do you know if here ( On rev / cPanel ) i will have sqlite too or should i make it in mysql?

I don't know if you remember some days ago, how much it costed to me to make work my database in mobile...
It means that now, in this new app, i won't need the specialfolderpath ("engine / documents") to work with the database? Or i will need it? I am afraid with this...

Regards.

[sefrojones]

You will probably want to go with MySQL, and probably won't need specialfolderpath. See my reply to this thread:

http://forums.livecode.com/viewtopic.php?f=12&t=22633

--Sefro

[aebki]

Hi Sefro,

Thanks for you answer...

I will look at the different links you let and see if i can manage...

Regards

[aebki]

Hi,

I tried to do what was in the thread Klaus let me (http://forums.livecode.com/viewtopic.php?f=12&t=22589)

But once i entered in the website ( http://www.on-rev.com/home/), i didn't manage to find the cPanel interface...
And once i login in this website it is redirecting me to the LiveCode site (https://livecode.com/store/account/products/)...

So, how can i arrive to the cPanel's interface to can do the same as it was described in the post? What is the url?

Regards.

[Klaus]

Hi aebki,

you need to have an ON-REV HOSTING account to be able to use the cPanel on their servers!
Do you have one?


Best

Klaus

[aebki]

Hi Klaus,

Thanks for your answer...

I have no account for the moment...
I wanted to try how it would work and if i can manage to do it before to pay for the service...

Regards.