I have a Data Guard with primary and standby database. But I have a problem, so my problem is like this. In primary if I query from v$archive_gap, I will get an
I love using docker & docker-compose for both development and production environments. But in my workflow, I keep considering dockers as disposable: it me
Given relations A(a,b,c), B(e,f), C(d,g,h), where A has 800 tuples, B 200 and c 500. In worst case gives the expression A * B * C ( with * natural join) : a) 8
according to this diagram...how many people can get privileges? and what is a horizontal and vertical propagation? did find something here which says Suppo
I know this is kind of a stupid question but it gives me a lot of problems. Me and my partners in college projects have a lot of issues making the database mdf
This is using Microsoft SQL Server 2012. I have a program that has multiple versions, each one has some schema changes to the underlying SQL database. In an at
The openGauss is said to be 1.5M tpmC on 2-socket Kunpeng server. But how can I reproduce the results step by step?
I'm having a hard time wrapping my head around the issue of an ELO-score-like calculation for a large amount of users on our platform. For example. For every u
Im designing a database for a web app. I'm struggling with the notifications topic: in my web app there will be a forum with messages, comments, and users. I wo
I have read the MySQL mannual about intention lock： http://dev.mysql.com/doc/refman/5.5/en/innodb-locking.html#innodb-intention-locks It says that "To m
Table timestamp | tracker_id | position ----------------------------------+------------+---------- 2020-02-01 21:53:45.571429+05:30 |
I'm currently creating an app in Oracle APEX and for some unknown to me reason while trying perform UPDATE/DELETE action by clicking on 'edit' button in the rep
I have a Google Cloud SQL MySQL 2nd Gen 5.7 instance with 70GB of unused storage. I want to reduce the unused storage of my instance as this is one of the major
I noticed that whenever I create a class using database information in Laravel, the table name must be plural. Why is this?
This issue is totally driving me insane. I spent months with this, trying to make a SIMPLE NODE APP WORK. I finally managed to make an APP work in a nice server
echo '<pre>'; var_dump($_FILES); echo '</pre>'; exit; $errors = []; $title = ''; $price = ''; $description = ''; echo $_SERVER['REQUEST_M
In a Swift app, how does one connect to a Postgres database server? In Java, we use JDBC with an compliant driver to connect to a Postgres server, communicate
We are using flyway to manage database schema version and we are facing a problem. Since we work as a team and use git as our source code management, there woul
I'm little wonder please help me out. My query is :- Invoice::join('orders', 'orders.invoice_id', '=', 'invoices.id')->groupBy('invoices.id')->get();
I am browsing through a code that is not mine and I would like to manually change a few pieces of data within the database of the application. The code is using