Category "database"

How would YouTube store data of who liked which videos?

If Youtube uses MongoDB as their database, then how would they store the who liked which videos information? Option 1: Store it in the Videos collection with a

Selecting rows with id's from two other tables

Let's call this table service_status: +---------+----------+-------------+------------+ |service_id| output | created_at | updated_at | +---------+--------

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