I'm building an Android application based on an old Android project. In my new application I'm using Room. I have to use the same database that is used in the
Using Postgres 9.6 with postgres_fdw extension, there any means to keep the tables present within the local schema in-sync with the tables on the remote databas
I'm having a problem with running unit tests in django while using ElephantSQL, when running command python manage.py runserver everything works just fine, I'm
I need to create a VIEW/Select statement that will take a start date, and create 3 different rows for each date. One row calculates 30 days, from the start date
I have ~100,000 to 1,000,000 rows to insert into an Oracle18c database. I'm quite new with Oracle and this order of magnitude of data. I reckon there must be so
I have a compound index on a sharded cluster living on Mongo Atlas. The Atlas UI tells me the index size is 10.1GB. Similarly, MongoDB Enterprise > db.myColl
Using a ORM, I want to do a POST request letting some fields with a null value, which will be translated in the database for the default value specified there.
I have a table of shops and anoher table of shop configs (plan, discounts and Others configs), I need to add some Fields to store SMTP configs. Should I create
I'm working with 60 different datasets, each of them with a ton of data in them. I'm trying to build a loop to go through each of the datasets (they are text fi
Custom Bash Script in DA: /directadmin/scripts/custom/domain_create_post.sh Below code: SET UP DATABASE VARIABLES dbpass=$(openssl rand -base64 12) > /dev/n
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