Category "database"

How to store Bag of Words or Embeddings in a Database

I would like to store vector features, like Bag-of-Words or Word-Embedding vectors of a large number of texts, in a dataset, stored in a SQL Database. What're t

Is the Unity Sqlite database registered?

I create the SQLite database using Unity. As in my code below. private void CreateTable() { using (dbconn = new SqliteConnection(blablabla)) {

Efficiency of Querying 10 Billion Rows (with High Cardinality) in ScyllaDB

Suppose I have a table with ten billion rows spread across 100 machines. The table has the following structure: PK1 PK2 PK3 V1 V2 Where PK represents a partiti

Can I send a database in a zip folder with mantaining the connection between the database and the php file

I want to send a folder that contains my HTML code, CSS, js and PHP. how can I include the database and keep the connection between my files and the database?

How can I create a partitioned table in EF Core?

Let's say I have an object like this: public class ObjectA { public int Id {get;set;} public DateTime CreatedOn {get;set;} ...etc } I want to partitio

How to compare elements from an ArrayList with data from a table in MySQL

The idea is I'm making a little restaurant app in Java so in this class is given the option to make an order. It works this way: the user writes which products

I need to apply a 24hour cooldown after use, and add to the token balance on a correct answer (discord.js v13)

Here is the challenge bot slash command: const { SlashCommandBuilder } = require('@discordjs/builders'); const { MessageEmbed, MessageAttachment

What do these different properties in SQL Server's (Azure Synapse's) Estimated Execution Plan mean?

I'm trying to work on the statistics, and as a part of it, I'm trying to look at the execution plan of certain SELECT * commands with a WHERE condition on a par

Postgres Sql - How to apply Offset on Timestamp

My offset-date-time object I store in the DB with 2 columns, one timestamp(UTC) column and another corresponding offset. For example, if I get: 2017-05-01T16:16

How to speed up collect() from a dbconnect database

I'm reading tables from an odbc driver on an amazonaws server. I am using R 4.0.0 on a 64 bit windows computer. Working from home and using company's VPN so my

TDengine import from csv file

Just found the speed for importing sorted csv file is faster than the speed for importing unsorted csv file in TDengine database, each csv file has 1000000 rows

Consult the mot problem of the openGauss database

After the MOT transaction in the openGauss database is complete, the local memory is not released. How can I find the cause?

When I use the MOT feature of the openGauss database,how can I manually release the numa_node node?

When I use the MOT feature of the openGauss database, the numa_node node is full and is not released for a long time. How can I manually release it? Is there an

Snowflake error in RStudio which limits the size of rows to fetch - Error: nanodbc/nanodbc.cpp:2695: HY000

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

Is there a faster way of using NOT LIKE for a long list of search terms instead of {AND "Column" NOT LIKE '%word1%'} etc, in an SQL Query?

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

Using 0 as Primary Key

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

Dynamic SQL Query in C#

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

Dynamic themes selection by user(PHP) from multiple theme

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

How to check if SQLAlwaysON is existing in server using powershell without a SQL DBA Admin access?

I want to check if SQLAlwaysON exists in server. I already know that typing and getting the powershell commands Enable-SQLServerAlwaysON and Disabled-SQLServerA

Upgrading Solr from 6.x to 8.x and Keeping the data

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