Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

A database is an organised collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. Designers typically organise data to model aspects of reality in a way that supports processes requiring information. Use this tag on questions which ask about ...

-1
votes
0answers
11 views

SQL SSDT Database Projects: Source Control Lookup Data

Does SQL Server SSDT Visual Studio 2017 Database Projects support Source control data for lookup tables, or do we still have to utilize messy Post-Deployment Merge Scripts for multiple tables? Redgate ...
0
votes
1answer
18 views

In a Database Per Service model - should i include the database in the service container?

I am implementing a simple setup with two micro services and would like each of them to have their own DB - each service is running in it's own container. Should i include the DB's in each service ...
1
vote
2answers
38 views

Merging Git Database Commits from One Branch to Another without Cherrypicking

We have main two Git branches at our company: During our Sprint, Everyone has (local branches) Release branch: Contains prepared/developed code, ready for testing, and Master branch: Production- ...
2
votes
1answer
36 views

What is a good storage for storing performance results and visualizing in grafana

Intro I am a tester and need to analyze the results of automated tests (response times and etc.) Current situation 1) I run performance tests using locust.io 2) During test execution, response ...
0
votes
0answers
34 views

Database choice suggestion

I would like to create a database to store how often access tokens in my system are being used. I was thinking of a data model like so - Access Token from (basically I will store this hourly, so ...
0
votes
0answers
34 views

Service for cluster leader with leader election tolerance configuration in kubernetes?

I've deployed a mongodb cluster using stable/mongodb-replicaset There is a service defined as [releaseName]-mongodb-replicaset but it does not appear to point to the primary node. Some applications ...
0
votes
0answers
15 views

Is this a robust implementation of database encryption at rest?

I am looking forward to implement encryption at rest for two+ SQL database servers (Linux). My goal is (obviously) to avoid storing the clear encryption key on the server or store it in a well-known ...
0
votes
0answers
29 views

Which volume solutions are the most convenient when building Docker & microservices based application?

My application consists of few microservices and web (React) frontend. Basically I have auth microservice, application backend service, various data processing services and frontend rendering server. ...
3
votes
2answers
607 views

Docker MongoDB image - How to specify credentials other than in the compose file?

I'm using this docker image https://hub.docker.com/_/mongo/. That image provides a way of initializing a mongodb root database user with env variables which I can specify in the compose file as ...
3
votes
1answer
232 views

What is the impact of using Helm Deployments instead of StatefulSets for Databases like MongoDB or MySQL?

The definition of a stateless app seems to apply to database servers like MongoDB or MySQL. I found Helm Charts as a kind of template-repository for Kubernetes. However, the stable builds all uses ...
1
vote
1answer
15 views

simulate SQL DB usage pattern of a typical cloud native web app with sysbench?

As far as I understand sysbench is for bencharking / test max. performance of a database server. I wish to simulate DB usage pattern of a typical cloud native web app (Twelve-Factor App). Is this ...
4
votes
1answer
571 views

Creating ansible host_vars and group_vars files dynamically

Is it possible to populate host_vars and group_vars with results from a database like we do in dynamic inventories? Actually I'm doing it inside my playbook either with lookups, either by using shell ...
2
votes
2answers
726 views

How to do blue-green deployment with PL/SQL code?

Is it possible to do blue-green deployment when your software is mostly a set of PL/SQL packages? I don't really want to duplicate the database, the financial risks in case of any desyncs are too big....
3
votes
2answers
450 views

macOS testing on Desktop: Docker containers vs. Homebrew installation

Often I test some stuff on my MacBook. Mostly database and data store related stuff (MongoDB, MariaDB, Postgres). I install the software with Homebrew and test. I wonder if I should switch to docker? ...
4
votes
2answers
61 views

Cloud DB operator responsibilities / common tasks

When I feed a search engine with "DBA tasks responsibilities" lots of hits like "What does a DBA do all day?" and even official Oracle manual entries. With modern automation a lot of those tasks don'...
11
votes
3answers
2k views

What are the reasons Docker should not be used for databases?

I'm having a discussion with a friend about use cases for Docker. One guy in the team wants to use Docker for everything - like a kind of universal unix process wrapper. The other thinks that Docker ...
5
votes
2answers
417 views

Google Cloud Storage vs Redis / ElasticSearch

We're building an application that reads data from an API and displays it in a frontend. Due to API limits, we have to cache the API calls meaning that we save the result of the API calls (both user ...
7
votes
2answers
547 views

How to synchronize deployments (especially of database object changes) on multiple environments

I am the DevOps engineer and a software engineer in a team where months back, the developers moved from having a central Oracle DB to having the DB on a CentOS VM on their individual laptops. The move ...
15
votes
6answers
909 views

What practices or tools enable Continuous Deployment of Databases?

Continuous Delivery or Continuous Deployment of infrastructure and code is comparatively simple compared to trying the same approaches for databases, specifically RDBMSs. Code and infrastructure will ...
11
votes
2answers
726 views

How should I store my environment variables?

This is a very broad question about methods and advice regarding environment variables / structure. But ultimately I'm looking for answers for the very specific question of 'How should I store my ...
6
votes
3answers
433 views

DynamoDB vs RDS for a counter store?

I have multiple lambda functions, which a file passes through for processing, and I want to store the status of each computation in a counter, for better logging and monitoring. Current plan is to ...