database Questions
3
Solved
I am developing a CRM by .net core mvc and EF which needs a lot of DB connection to retrieve and update information. From time to time I face this error during debugging, this is a big project with...
Trifocal asked 27/3, 2021 at 10:57
3
Solved
I am new to asp.net core and I created an app with Asp.Net Core 2.2 +EF using Identity Core to create a registration page and I got this error after I ran the app and introduced some test data(emai...
Neutrino asked 19/9, 2019 at 17:59
5
Solved
I have a (syntactically-valid, not-huge) CSV file. I want to run an arbitrary SQL SELECT query on it; let's assume that it can be a complex query, with some inner queries, with self-joins, maybe wi...
Nagle asked 22/8, 2023 at 13:48
4
We've been using Visual Studio 2017's SQL Server Schema Comparison for all our (SQL Server 2016) migrations and deployments.
However, recently, it has become very slow, taking hours to process. If...
Minstrelsy asked 28/11, 2017 at 8:37
4
Solved
I have two tables:
CREATE TABLE "user"
(
username character varying(35) NOT NULL,
CONSTRAINT user_pk PRIMARY KEY (username)
)
CREATE TABLE item
(
id serial NOT NULL,
username character v...
Voyage asked 6/8, 2013 at 12:17
2
Solved
I am making an application in Flutter, which requires to save the daily data that the users input in the application. The user has 10 daily actions to do.
The app needs to:
Save the daily data tha...
4
I am trying to configure DB2 connection with DB2JDBC Type4 drivers. But I am getting this error.
Exception in thread "main"
com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException:
[jcc][t4][2...
Penicillin asked 23/5, 2013 at 4:36
1
I am working with a database based session driver at the moment, to allow us to store some persistent data across our application,
we create the session like this:
Auth::loginUsingId($user->i...
2
Solved
This error is showing after running this command: sudo systemctl status [email protected]
[email protected] - PostgreSQL Cluster 10-main
Loaded: loaded (/lib/systemd/system/[email p...
Interpose asked 1/12, 2020 at 14:34
2
I have a kubernetes cluster, with a pod running the postgres database, so in Docker. Obviously, I have the data mounted on the host.
I would like to setup Barman to have a backup solution for the D...
Fennelly asked 20/7, 2020 at 8:37
3
Solved
I am just a beginner in MySQL, I need to know how much data can be stored in MySQL. I am developing a web crawler, can I store all the data in MySQL, or do I need to use another Database? Which is ...
1
I'm redesigning the database for one of our apps, to normalise and restructure some of the more gigantic tables.
Our service offers various plans (Personal, Family, Business etc.) that come w...
Ogdon asked 4/9, 2018 at 0:46
17
Solved
I'm trying to store app data of my flutter application in the database, but the complier keeps showing "Future isn't a type" for async func and underlines in red. I've tried removing .ana...
6
Solved
Technology:
Java 1.5 or 1.6
Hibernate 3.4
To avoid update of column name on multiple places on change of column name or tablename, i want to have a constant file for same.
I have following querie...
Natty asked 17/12, 2010 at 18:23
4
Solved
I'm using Django for a small project and I want to make a table with one row to add the description of the project in it. I only need one row and nothing more since it's one description for the who...
Callery asked 31/1, 2016 at 15:59
1
Is it possible to create a partial foreign key (similar to partial indexes) in general sql / postgresql? I have not found a way to force referential integrity in the following case:
Table A is soft...
Helsell asked 28/11, 2017 at 13:1
4
Solved
I'm looking to generate some database test data, specifically table columns containing people's names. In order to get a good indication of how well indexing works with regard to name based searche...
4
Solved
I'm new to nextjs and the new updates are a bit overwhelming for me. It may sound dumb, but my question is: when should I use Server Actions and when should I use Route Handlers. Could I use them b...
Grandee asked 2/1 at 20:21
10
Solved
We're designing an OLTP financial system. it should be able to support 10.000 transactions per second and have reporting features.
So we have come to the idea of using:
a NoSQL DB as our m...
5
Solved
How can I query all tables' all table columns in a database?
Method I've tried:
get all table names using select tablename from pg_tables where schemaname = 'public'
Process cmd string using UNI...
Fresher asked 21/8, 2018 at 3:25
2
Solved
I am trying to understand how Redis AOF file works and maybe write a parser given some simple Redis AOF file. Right now I generated an AOF file by doing these commands in Redis:
SET firstkey first...
Dorking asked 24/3, 2019 at 18:39
6
Solved
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 first project.
Furthermore, I've ext...
Minstrel asked 15/7, 2019 at 7:59
6
Refer this!
I was creating a database and got this error i tried to uninstall and then reinstall postgresql-16 and pgadmin4 but it didn't work for me! It creates a database but gives this error i a...
Bedding asked 11/2 at 5:17
6
I'm really confused on the difference between disjoint and overlapping design constraints in relational databases. I've looked around, but have had a hard time finding an understandable example. Co...
Methodius asked 12/11, 2013 at 4:40
3
Solved
How can I create a Mediumblob within the Laravel schema builder ?
In the docs it says :
$table->binary('data'); // BLOB equivalent to the table
But I need a MediumBlob otherwise the images g...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.