I retrieve some data from my DB, where I have a Column called "icon" in which I stored some Strings. For each of them, I want to pass in the Icon class of Flutt
Struggling to understand why my query is taking ~8-12s to complete when my table has millions of rows. I can force it to use a specific index, and depending on
Hi I am trying to remove A row from a recycle view and once it is removed from the recycle view it should also be removed from the firebase realtime database. I
I have a shema database in file type XSD this file contains descriptions of all tables. My question is how I can use this file to create a database in MySQL. i
I am trying to migrate a large portion of one postgres database to another postgres database that has a slightly different layout/table names/column names. But
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