All Questions
Tagged with production-environment database
42
questions
0
votes
0
answers
46
views
SQL Database in production migration - Best approach
I have a SQL database (postgres using amazon RDS) on production with several records, some tables go up to a few millions rows and need to have some structure changes, in my particular case I just ...
- 66
0
votes
0
answers
25
views
Setup web server for django backend: Nginx and Gunicorn configuration before database migration
Is it possible to setup Nginx and Gunicorn on my web server before executing "python manage.py migrate", since my database server is not ready yet?
Chatgpt recommended me to execute first ...
- 51
0
votes
2
answers
3k
views
How to remove prisma models with data in production
I want to delete 2 models from a postgreSQL production database that are no longer used but have data on them.
I am a bit afraid of removing them from the schema and running prisma migrate dev and ...
- 1,300
0
votes
0
answers
80
views
Users change codes directly on the production server
I'm working on a project that has all its data written as python files(codes). Users with authentication could upload data through a web page, and this will directly add and change codes on the ...
- 1
0
votes
1
answer
1k
views
Unable to establish database connection on production for my Laravel project
I have deployed my Laravel project on production but it seems that I am unable to establish a connection with the database I created in CPanel. I need this in order to execute some migrations and make ...
1
vote
1
answer
726
views
The real difference between MEDIA_ROOT (media files) and STATIC_ROOT (static files) in python django and how to use them correctly
The real difference between MEDIA_ROOT and STATIC_ROOT in python django and how to use them correctly?
I just was looking for the answer and i'm still confused about it, in the end of the day i got ...
- 335
1
vote
1
answer
67
views
Updating the permissions for the db user have any effect on existing connections?
I am thinking to add few more permissions to existing database user in a database in MySql db. This is in production and serving a large user group.
Will updating the permissions for the db user have ...
- 1,424
33
votes
4
answers
21k
views
Is it recommended to use Database as a container in Production environment?
Assuming we are using a micro service architecture for a product and we decide to use 'Database per service' model, and deploy in cloud servers by provider like AWS.
It is convenient to have ...
- 1,261
0
votes
1
answer
48
views
I've unintentionally created a production database. Will this destroy the production data that already exists?
Context:
I've built a rails app that's in production. Originally, the scope of the project was small so I didn't need to write tests, but as it grows, it's now imperative that I have them.
As I set ...
- 13
0
votes
2
answers
235
views
Setting up MySQL database for stand-alone Spring Boot application to be used in another device
I'm developing an application using:
Spring boot
MySQL
I'm new to these, and my question is how I can run my application in another device. I'm asking about:
If I set up a MySQL on localhost, how ...
- 2,209
0
votes
1
answer
146
views
How to copy over values from one column to another newly added column?
I am working on a web application that is up and running on a production server. I need to make some changes to the database but I am not sure what is the best way to go about this.
I have a table ...
- 4,061
0
votes
0
answers
30
views
workable solution for isolating development from production in DB2 z/OS
I am a developer and I need to be able to create tables, triggers, view, functions, procedures, constraints, etc. for prototyping solutions for putting business logic rules into the database. My ...
- 382
7
votes
1
answer
3k
views
Is it recommended to run clustered database with Kubernetes in production environment?
Is it reasonable to use Kubernetes for a clustered database such as MySQL in production environment?
There are example configurations such as mysql galera example. However, most examples do not make ...
- 649
-1
votes
1
answer
514
views
How update correctly a database in symfony2?
The official documentation of Symfony2 says that:
"Whether or not you take advantage of migrations, the doctrine:schema:update command should only
be used during development. It should not be used in ...
- 617
0
votes
1
answer
258
views
NoMethodError in StaticPages#home
I get the following error. Can someone help me figure this out for me, please?
Showing /home/bdme551/bdme21/app/views/layouts/application.html.erb where line #4 raised:
undefined method `full_title'...
- 71