Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

Posts tagged database

3 child tags

For questions about databases in general. A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, stored procedures and other objects. Avoid using this as it is too generic and replace it with the actual used database instead whenever possible.

This tag doesn't have a detailed wiki yet.

72%
+6 −1
Q&A Best practices in setting up a development & production environments

I am developing a web app that is tied to a database. My codebase is stored on a private GitLab instance. I would like to set up a workflow that would look something like this: I have a developm...

1 answer  ·  posted 1y ago by Mu3‭  ·  last activity 2mo ago by Mithical‭

Question database devops
33%
+0 −2
Q&A How to distinguish between single and multiple file media?

In a media manager I have database tables for files, media and collections. When a user is browsing a collection I want there to be links to see the metadata for single file media like books, movi...

2 answers  ·  posted 6mo ago by filosoful‭  ·  last activity 6mo ago by r~~‭

Question database
40%
+2 −4
Q&A unable to create databases in Ruby

I had installed Ruby. rvm install 2.6.6 I had Ruby which version was 3.0.0. I had removed it. Then, installed 2.6.6. When I try bundle install I got no error. When I tried following command...

0 answers  ·  posted 2y ago by deleted user  ·  edited 1y ago by Alexei‭

66%
+2 −0
Q&A How to write database friendly code when using an ORM?

There are a lot of articles and presentations that show little love for ORMs. This is mainly because some queries are so complex and heavy on the database that they lead to significant issues in p...

1 answer  ·  posted 1y ago by Alexei‭  ·  last activity 1y ago by Alexei‭

75%
+4 −0
Q&A In the current development context (2020+), is there any reason to use database triggers?

I have not used a database trigger in years in the projects of the teams I have worked in, but I have seen them being used by other teams. Back in 2009, it seemed like a heated debate, but I am wo...

1 answer  ·  posted 1y ago by Alexei‭  ·  last activity 1y ago by Derek Elkins‭

50%
+1 −1
Q&A How to grant privileges to a user on a database specifically (i.e. not globally) in PHPMyAdmin?

In PHPMyAdmin 5.1.1 I have created a user account and a database with the same name and granted all privileges to the user on that database. I have exported the database to a backup file, deleted ...

1 answer  ·  posted 1y ago by deleted user  ·  last activity 1y ago by deleted user

Question database
75%
+4 −0
Q&A What are the disadvantages of using SQL Server Replication - Transactional Replication type?

The context A reports related process is directly reading the production operational database once about two hours. This involves reading all the data from some 70 tables which takes a couple minu...

0 answers  ·  posted 1y ago by Alexei‭

71%
+3 −0
Q&A How to copy a PostgreSQL database to another machine.

I have to debug an error which seems to only happen with some set of data present in our PostgreSQL database. I'd like to copy said database to my local machine so I can perform tests without affe...

1 answer  ·  posted 2y ago by Estela‭  ·  edited 2y ago by Alexei‭

50%
+0 −0
Q&A When is information schema not needed and when is it indeed when migrating from one website hosting provider to another?

In some situations, could it be problematic to migrate a website's database (MySQL) from one website hosting provider to another without the information schema or with the information schema? In m...

0 answers  ·  posted 2y ago by deleted user  ·  edited 2y ago by deleted user

Question mysql database
75%
+4 −0
Q&A Is migrating emails from one hosting provider to another a trouble?

I rent a shared-hosting environment with CentOS-Bash, Apache, PHP, MySQL and a web-based IMAP email client (Roundcube) and some more tools, on which I host my personal website; I don't have Cpanel...

1 answer  ·  posted 2y ago by deleted user  ·  last activity 2y ago by manassehkatz‭

75%
+4 −0
Q&A How to reason about transaction isolation during development

Consider the following code: public class OnlineShoppingService { @Transactional public void cancelOrder(String id) { if (shipmentRepository.findShipmentForOrder(id) != null) { ...

1 answer  ·  posted 2y ago by meriton‭  ·  last activity 2y ago by Alexei‭

70%
+5 −1
Q&A How to separate DB query logic from the application other than implementing a repository on top of an ORM?

I've been doing a lot of reading on implementing the repository pattern in C# projects and found controversy, or shall I say some strong criticism, made by seemingly very smart people with previous...

1 answer  ·  posted 2y ago by Marc.2377‭  ·  last activity 2y ago by Alexei‭