Category "database"

SQLAlchemy: What is the best way to validate a model before inserting or updating

I'm trying to validate a SQLAlchemy model before it is inserted or updated, e.g class MyModel(db.Model): foo = db.Column(db.String(255)) bar = db.Colum

Oracle 19c compatibility with jdk7

I would like to know if oracle 19c is compatible with jdk 7. I have found out 2 drivers for oracle 19c ojdbc8 : for jdk8, jdk9 and jdk11 ojdbc10 : for jdk10 and

How can I get a React application to send SQL queries to an Oracle database and retrieve results?

Background: I need to create a web application that connects to an Oracle database hosted by my university through a VPN. The app does not have to be hosted onl

How to check keyspace and table size in Amazon Keyspaces

We recently migrated from Cassandra to AWS Keyspaces and I am just wondering how to check for table and keyspace total size in AWS keyspaces. Any help or sugges

What does the function fn:data() do in exist-db?

I would like to know what the fn:data() function does in exist-db. I can't find the answer anywhere on the web.

Unable to drop database mysql: ERROR 3664 (HY000)

I have a database in my application named X-Files. I want to drop it. But whenever I run the command drop database X-Files I am getting following error: mysql

How can I display the header of columns of all tables within a SCHEMA

I would like to list out all the tables and column headers within a SCHEMA to be displayed in Rows within MySQL, I can't seem to find an answer online and would

How to consolidate TypeORM migrations

At the moment I'm not a guru on TypeORM and have made a few mistakes with my migrations - with our non-production database now in a state where I'd like it, is

After submitting the data from the form it directs to white screen

I have an issue when I clicked the button and submit the data from the form.it gets directly to the white screen and nothing happen I checked the database it do

ClickHouse connection refused after shut down Linux OS (error Code: 210. DB::NetException: Connection refused)

I saw a previous post on StackOverflow related to my question. I tried to handle this connection problem by entering sudo nano /etc/clickhouse-server/config.xml

MongoDB Updating Boolean Inside Object

I am trying to update a boolean inside of an object in my discord.js v13 bot but it does not update here are the things i've tried: await gu

'The variable name '@' has already been declared. Variable names must be unique within a query batch or stored procedure.'

string subject= "INSERT INTO Subjects (ThesisNo, [Subject]) VALUES (2, @subject)"; SqlCommand commandSubject = new SqlCommand(subject,con); string temp

AWS: Why does my RDS instance keep starting after I turned it off?

I have an RDS database instance on AWS and have turned it off for now. However, every few days it starts up on its own. I don't have any other services runnin

Can you help me to fix the connection with my DBeaver?

I don't speak English, sorry. I have this message to my DBeaver Can you help me to fix the problem ? Network error Motif: Network unavailable: javax.net.ssl.SS

generate auto increment id (int) in java for multi instance application

I have a table which stores users information(id, name, surname, address, email, etc). I don't want to use auto-increment function of the database. So, we don't

Dynamic Icons in Flutter

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

Slow MySQL query on 2mill record table despite indexes

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

Remove a Row from recycle view and Firebase

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

create shema databse using XSD in mysql

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

How can I migrate data from one PostgreSQL database to another (with slightly different table/column names)?

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