Database for one app

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
aebki
Posts: 126
Joined: Tue Jan 06, 2015 5:48 pm

Database for one app

Post by aebki » Wed Jan 14, 2015 1:27 pm

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
Posts: 13806
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: Database for one app

Post by Klaus » Wed Jan 14, 2015 1:34 pm

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

aebki
Posts: 126
Joined: Tue Jan 06, 2015 5:48 pm

Re: Database for one app

Post by aebki » Wed Jan 14, 2015 4:29 pm

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
Posts: 15
Joined: Wed Nov 19, 2014 5:05 pm
Location: Sweden

Re: Database for one app

Post by mcbroh » Wed Jan 14, 2015 4:43 pm

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
Posts: 126
Joined: Tue Jan 06, 2015 5:48 pm

Re: Database for one app

Post by aebki » Wed Jan 14, 2015 5:00 pm

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
Posts: 13806
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: Database for one app

Post by Klaus » Wed Jan 14, 2015 5:02 pm

Hi aebki,

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

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
Posts: 126
Joined: Tue Jan 06, 2015 5:48 pm

Re: Database for one app

Post by aebki » Wed Jan 14, 2015 5:50 pm

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
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 447
Joined: Mon Jan 23, 2012 12:46 pm

Re: Database for one app

Post by sefrojones » Wed Jan 14, 2015 7:15 pm

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
Posts: 126
Joined: Tue Jan 06, 2015 5:48 pm

Re: Database for one app

Post by aebki » Wed Jan 14, 2015 10:07 pm

Hi Sefro,

Thanks for you answer...:-)

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

Regards

aebki
Posts: 126
Joined: Tue Jan 06, 2015 5:48 pm

Re: Database for one app

Post by aebki » Sat Jan 24, 2015 4:27 pm

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
Posts: 13806
Joined: Sat Apr 08, 2006 8:41 am
Location: Germany
Contact:

Re: Database for one app

Post by Klaus » Sat Jan 24, 2015 4:51 pm

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
Posts: 126
Joined: Tue Jan 06, 2015 5:48 pm

Re: Database for one app

Post by aebki » Sat Jan 24, 2015 6:14 pm

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.

Post Reply

Return to “Databases”