Is there support for stored procedures in Google Bigtable, or support for any similar mechanism for saving multi-statement queries?
I'm looking for a solution where the database schema and data are maintained in xml or in some file format, so that the db schema and the data
having this error do you know what is wrong with my code? Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeh
On one hand, ScyllaDB markets itself as a wide-column database which implies that a single row can contain any number of columns and the number of columns don&r
I am working on an App connecting to the Snowflake database. I stumbled upon an issue while loading CSV files. I was using the NULL_IF condition in copy command
My app aims to allow communal viewing+editing of what are essentially tables. It's a react app (with typescript), so being useable as react component state is r
The original data is 4w 768-dimensional flat, and the sizing tool is used to calculate it should be 118M, the actual memory is 6G, the virtual memory is more th
I found this picture in a document. It shows the queries running on a given SQL database. It looks similar to DBeaver software. However, I couldn't find a way t
I have created a new Spring Starter Project and I specified in application.properties the db settings: spring.jpa.hibernate.ddl-auto=update spring.datasource.dr
I want to calculate total followers of a person from follow and unfollow table using SQl. Form of table are as follows Follow table: Unfollow table: My tries:
Problem background I am trying to pin down to what condition(s) are causing no records / rows the most, so to allow me to find the root cause of what data in th
I am creating one table which has one column which supposed to store more than 5-10k coordinates at a time. I have declared it as longtext but while storing it
While doing a many to many relationship in SQL we create a table that will have the ID of the 2 tables that are forming the relationship. Sometimes in that tabl
It's quite simple to insert data into TDengine database but still got errors. use conn.statement("insert info cache_record values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
I want to make a mongoose schema that will append timeseries data. I got the idea for that model after reading this (https://www.mongodb.com/blog/post/schema-de
For my whole projects I have relationed my multiple collection as this. User model Name:string, email:string, password:string, vehicles:[{ "vehicleId", "vehi
I am trying to list all DEPARTMENT_IDs with PRODUCT_IDs, first where PRODUCT_COST_STATUS = 1 but there are also data with where PRODUCT_COST_STATUS = 0. I prefe
This is my Code * corr_matrix = np.corrcoef(data['Average dewpoint (°F)']data['Average temperature(°F)']) corr = "corr = " + str(round(corr_matrix[1][0]
How can I create a new page when I enter a new product in my database, or hide the parameter inside a normal /.../ ? In this example I will sell Sandles with th
I am building an application for building sports betting models. Basically users can create their own criteria and backtest their models across historical data.