I have an issue where I kind of know what it is but do not know the solution to it. When I fetch data from an external Snowflake DB, it limits the size of the d
So I'm trying to exclude a bunch of different entries with specific words from my query and I was wondering if there was a more efficient/faster way of doing th
I use lookup tables commonly and sometimes I have some default record in the Lookup table and I think for this record I can use 0 as Primary Key a as shown belo
I'm trying to create a query with a variable number of parameters, giving to the program the name of the table and an Array for the names of parameters and anot
I want to add dynamic themes to my php website which will be stored from the user's database and next time when user uses the website that theme should be shown
I want to check if SQLAlwaysON exists in server. I already know that typing and getting the powershell commands Enable-SQLServerAlwaysON and Disabled-SQLServerA
I'm trying to upgrade from Solr 6.x to 8.x and I'm facing an issue of keeping/saving/importing the old data that I've had. The approaches I tried using the same
I am trying to set up a DynamoDB database where every item is a product. Each product has a list of 1-5 product IDs (12-digit numeric), for example: { 'name
I want to add two conditions in where tag of liquibase and exception is thrown: Reason: liquibase.exception.DatabaseException: Unknown column 'uid' in 'where cl
We are working on the multitenant application in spring boot. We have created different schema for different customer and we also have public scheme for super a
In a blue green deployment environment, I'm trying to use two separate database for each environment. In this case, How does realtime data synchronisation could
I would like to connect my ado connection to a database stored on onedrive so after the development of my application... It can be distributed to multiple users
I have kind of 'restaurant app' with multi tenant architecture. Each Tenant in short words have their Order table where I keep all data regarding orders which w
What is Long here and what on basis do we configure this in JpaRepository? public interface FirstRepository extends JpaRepository<First, Long> { }
So, I have my local database, set it up, ran it from the windows services window. I open MySQL Workbench, and try to connect to the server. Hostname is localho
I have two MongoDB collections in a database named "records". Here's a sample document from the first collection: course_completions { "_id" : NumberInt(1
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
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
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
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