Re: How can i share one Database Sqlite between 2 app on pythonanywhere -. Should I prefer postgresql or MySQL - Security

[Balaji Shetty]

Thanks for your reply.

I hosted on pythonAnywhere.

Is it possible for postgresql. 

Should I prefer postgresql or MySQL regarding security issues .

Can you please tell me how to achieve in MySQL. 

Also how can I backup daily data of server on my local machine . 

Can any DB also provide front-end GUI for database access as per user Access  Control Rights ( Permissions ) 

On Thursday, September 5, 2019, Amirhosein Rajabi <a.h.r...@gmail.com> wrote:

I have shared a MySQL database even between two accounts in PythonAnyWhere. But I think there is no possible way for local DBs. If you can access the app1 files from the app2 or otherwise, you may be able to change settings.py for that db.sqlite path.

On Wednesday, September 4, 2019 at 9:40:39 AM UTC+4:30, Balaji wrote:

Hi Everyone

Can anybody suggest me

How can i share one Database Sqlite between 2 app on pythonanywhere.

Currently i have deployed one project on PythonAnywhere.

I have purchases 2 App.

Now i can execute 2 App simultaneous.

I have deployed app1.pythonanywhere.com and app2.pythonanywhere.com

app1.pythonanywhere.com is my real time hosted project. Before making any changes, i create mirror copy of code and Database Sqlite on app2.pythonanywhere.com, make changes and if changes are proper. I make changes in

app1.pythonanywhere.com.

But it is time consuming Process. Better solution may be share database and make changes in Business Logic and reflect in orignal one.

My Simple Question is

How can i share sqlite database between two Project here.

OR

Is there any other way to do the same thing more efficiently?

Thanks in Advance.

--

Mr. Shetty Balaji S.
Asst. Professor
Department of Information Technology,

SGGS Institute of Engineering & Technology, Vishnupuri, Nanded.MH.India

Official: bssh...@sggs.ac.in

  Mobile: +91-9270696267

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/befcb047-eca7-4c78-9dea-49021a32aa18%40googlegroups.com.

--
Mr Shetty Balaji
Asst. Prof.
IT Department
SGGS I&T
Nanded. My. India

[Amirhosein Rajabi]

I enumerate your questions and answer them in order. For the first one, yes, you can have DB using Postgres, but for configurations you have to refer to databases tab in your PythonAnyWhere account. Also you can use PythonAnyWhere help for setting up databases. (Note1: For Postgresql, you need paid accounts, but MySQL could be used by free users. Note2: For MySQL configurations, you have to refer to that databases tab.) 

For the second one, I have to say that I haven't used Postgresql, so I can't advice you in this field but I can say that both of them are better that Sqlite. For instance, database lock could not be implemented on sqlite but MySQL. You can get more information at djangoproject.com. (More: https://docs.djangoproject.com/en/2.2/ref/databases/)

For the third question, back up one, you can use PythonAnyWhere Task service which are bits of codes runned regularly at a specific time daily. Also there are Always-on tasks which could be used only by paid users. I have also set this for my own website which backups daily at 00:00 UTC using "mysqldump" and saves a copy of db which is hosted on <your-username>.mysql.pythonanywhere-services.com on my files on PythonAnyWhere account. Note that if you use MySQL database on PythonAnyWhere your files won't be save at your account but on the mentioned host. You can access this host through PythonAnyWhere accounts with knowing the database host address, username, and password but not from outside PythonAnyWhere such as your local computer. It is a very good idea to backup db for the MySQL complexities (as an alternative for Sqlite) happening in PythonAnyWhere.

Also if you already have clients' data on your Sqlite database you can save them to a json file or other methods and then load them at the new database. (More: https://stackoverflow.com/questions/9984141/django-copy-data-from-one-database-to-another)

For the last question, I don't have enough information about it.

I myself have hosted my database on MySQL and shared it among the main website and an api and judge terminal (since my website is serving a rather judge platform). 

That was all I knew about this matter as a student. Hope it helps you. Apologies for getting too long.

On Thursday, September 5, 2019 at 11:17:27 PM UTC+4:30, Balaji wrote:

Thanks for your reply.

I hosted on pythonAnywhere.

Is it possible for postgresql. 

Should I prefer postgresql or MySQL regarding security issues .

Can you please tell me how to achieve in MySQL. 

Also how can I backup daily data of server on my local machine . 

Can any DB also provide front-end GUI for database access as per user Access  Control Rights ( Permissions ) 

To unsubscribe from this group and stop receiving emails from it, send an email to django...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/befcb047-eca7-4c78-9dea-49021a32aa18%40googlegroups.com.