Category "database"

SQLite-net-pcl Comparing Dates

As stated in the question I am attempting to do a date comparison for tasks that are done within a specific date range. My model has a boolean called "Done" and

Bug in Weaviate - Update data object instance (Python Client)

I have a Weaviate instance running (ver 1.12.2) I am playing around with the Python client https://weaviate-python-client.readthedocs.io/en/stable/ (ver 3.4.2)

PreparedStatement getMaxRows always returns 0

So i have a problem where i want to see how many rows there are in my database, after i've made an update. Im trying to use "GetMaxRows" but it always returns 0

Wordpress Multisite installation issue on staging website

I am trying to change my website into multisite on my staging server. When I add define('MULTISITE', true); in wp-config.php on my local machine setup, it works

How to delete a record depending on the following record

I have a table with the following columns Car | User | Location | Time | Type The type can be 'OUT' if the user's request to rent the car is accepted

Laravel 8 how to join many to many relationship tables and create a query using DB

I am using Laravel 8 and I want to display list of event by joining tables that have many to many relationship. Here is how my tables look: Users Table | id |

How to store attachment file in an email in a database?

I used this code to store attachment xlsx files from a specific address email in Outlook, but now I would like to store these files in a database in SQL Server,

Sqlite3 recover runs into out of memory error

I'm trying to recover a broken sqlite database using the recover feature of sqlite3.exe: sqlite3.exe borken.db ".recover" | sqlite3 fixed.db The broken databas

Import CSV file (convert to JSON format) into Deta Base (database)

I try to convert the CSV file into JSON format and import it into Deta Base (database). Here is a main.py code I run from a terminal. No error shows up, but Det

Database schema design optimized for scoring rows to sort on

I want a table like this which has scores column, and whenever basket1 or basket2 are added to table I want to update scores of the columns in basket.So say bas

My php code loops and doesn't explore my database [duplicate]

Hello I'm currently trying to create a page based on a database under mysql that would update itself for a client. However what I'm trying to

how to modify already defined composite key in liquibase

I need to alter a table to modify the order of the indexes created from the composite key for the below mentioned changeset. <changeSet author="demo (generat

Rspec and SQL: Index 0 is out of range

I am trying to run my code and I get the following error: Failure/Error: Bookmark.new(id: res[0]['id'], title: res[0]['title'], url: res[0]['url']) IndexError:

How to get sum of multiple rows in a table dynamically

I am trying to get the total sum from columns of a specific data type(money) for multiple tables in a database. Currently I am able to get the list of columns f

Is there a way to backup/export & import Strapi data

So I am at the place where I lost all of my Strapi data after moving from local to remote host and deploying my Strapi through herokuapp.com I am using Strapi i

with put request data dosent update in ui without reload page

i have an issue .i am doing a project where want to update quantity of product.i am able to sending updated data to database with put request but my ui desent

Is there a way to download and import multiple .tsv files into excel or access?

I am trying to create a database from SEC filings. The filings come in .tsv files and are structured in folders by year and quarter. Ever folder contains about

vue: Downloading excel files using node-xlsx

I am very new to programming and working on a web project. I used node-xlsx make a button that export excel data. But I got an error "Cannot read properties of

How can I set 'id' as biginteger and autoincrement in phinx for PostgreSQL?

I tried to set as only biginter but it lost its autoincrement properties. So I tried adding auto-increment as well. $table->changeColumn('id', 'biginteger',

Why does a known type produce a runtime error but an inferred type produces a null value?

Let's take the following example from BigQuery, but it's the same across all other databases I've seen: with tbl as ( select [1,2,3] as arr, '{"IDS": [1