All Questions
45,157
questions
0
votes
1
answer
47
views
Selecting Rows By Specific Column Data in PostgreSQL
I'm trying to build a recipe finder app (PERN stack) like SuperCook but I ran into some problems with my postgres table.
Short description of the desired result. I'd like the user to select some ...
- 13
0
votes
1
answer
63
views
How to store row-position in a database?
I am looking to emulate a feature in Excel/Google Sheets where there is a table of data, but someone may move a row up or down. Here is an example of the interaction:
My first thought as to how to ...
- 109k
-2
votes
0
answers
39
views
is there a way to store unschematised datas in sql database [closed]
mysql : 5.6 java : 11
Am in need of an mechanism to store unschematised data in my db. the case is as follows.
Objective :
To get all user from a 3rd party app and store it in db.
Problem facing :
...
0
votes
2
answers
72
views
How To Import a Big .csv(~2GB) Into a PostgreSQL Table
I am new into databases and PostgreSQL and today I wanted to import this dataset: https://www.kaggle.com/datasets/wilmerarltstrmberg/recipe-dataset-over-2m/data into a PostgreSQL so I can make a ...
- 13
0
votes
1
answer
23
views
Error while trying to migrate data from one table to another in BigQuery
I run into a problem when trying to migrate data between BigQuery tables, I have an old table that has an attribute nested as Float64, I want to migrate the data from this old table, to another one, ...
- 13
-2
votes
1
answer
41
views
How does Tinder gives me only new profiles? [Database design]
I have probably swiped 10k profiles either left or right.
If I open the app tomorrow I will get 10 profiles I have never seen.
How can these profile be queried efficiently?
For sure an SQL query of ...
- 317
0
votes
2
answers
51
views
SQL Query - Ignore row if data is null for multiple rows on single condition
I have a below table
cid
step
cr_time
120
S02
08-JUL-24 09.35.19.000 AM
120
S03
08-JUL-24 01.35.19.000 PM
120
S04
09-JUL-24 02.35.19.000 PM
121
S02
09-JUL-24 07.35.19.000 AM
121
S03
09-JUL-24 02....
- 606
-1
votes
1
answer
41
views
How can I get a separated row instead of a CSV concated group?
I have the following query:
SELECT GROUP_CONCAT(p.name) AS names
FROM cte t
LEFT JOIN products p
ON p.tag_id = t.id
GROUP BY t.orig_id
HAVING SUM(t.id = 6) > 0;
It returns something like this:
...
- 6,575
0
votes
0
answers
22
views
Read one table write to another data race SQL solution
I'm currently learning about database transactions, isolation levels, and SQL in general. I've thought up a problem which involves a potential data race and can't seem to figure out the solution ...
- 13
1
vote
0
answers
57
views
What is a good way to keep the SQL queries in a Rust application that uses sqlx?
At the moment I have my SQL queries as a multiline string in my Rust files.
let sql = r#"
SELECT
*
FROM
public.users
...
- 19k
-1
votes
0
answers
37
views
Why is my query not populating in MS Excel from Access? [closed]
Hi, I am trying to pull my queried data into an excel file but unfortunately it is not populating in excel even though there is data in the access queried table. Any fix to this?
I have tried ...
1
vote
1
answer
53
views
How do I diagnose a 38s planning time for `select *` in Postgres?
I have a table that Postgres is really struggling with planning queries on. I've been running:
explain (analyze, verbose, buffers) select * from lead
The resulting query plan (literally a seq scan) ...
-2
votes
0
answers
29
views
Building database management app, what language? [closed]
I work into administration and as a beginner programmer I wanted to build a database management application. For the choice of the language, What languages do I need? and why? am currently learning ...
0
votes
1
answer
37
views
How to query revisions of learndash courses, lessons and chapters in SQL
I have a database backup from where I would like to get all revision for a course, then for its lessons and for each lessons the chapters.
The revision of a course was easy enough: SELECT * FROM ...
- 853
0
votes
2
answers
73
views
Why do I need to model a join table class?
I have two classes in C#:
public class Student
{
public string Name {get; set;}
public string Email {get; set;}
public List<Course> Courses {get; set;}
}
public class Course
{
...
- 9