I am trying to use a count(..) to get the count value of matching records from a related table, using Laravel 8 (Eloquent). The idea is simply to count the number of tasks assigned to each user. I already have…
I am trying to use a count(..) to get the count value of matching records from a related table. I'm using MySQL 8. The idea is simply to count the number of tasks assigned to each user. If the user…
I'm implementing forgot password functionality in my NextJS app. I'm generating a temporary token whenever the user clicks on forgot password. Should I store the temporary token in the already existing users table, User table user_id user_name forgotpass_token here only…
Let's say I have a table containing cities with their populations and a table containing buildings of different types. I want to know the percentage of people living in cities containing schools. Cities: name pop A 10 B 100 C…
I used to work with Oracle, where after creation of a new database user you need to grant them a few privileges, ex. to connect(CREATE SESSION) to the database or create a table(CREATE TABLE). Otherwise the user is useless and…
I have a table that has about 60 million rows that I use for testing. I want to add a column test_time that should be unique across all rows and spaced 1 second apart from each other. So for instance:…
I need to update a specific value in a column with the json type. All solutions I found online are either for jsonb or don't seem quite right and give me an syntax error and I don't know why. That…
I recently start learning sql database, and I can't find the time complexity for the case where I have a huge amount of tables. For example, I have M tables [table_1, table_2, ..., table_m, ..., table_M], and each table has…
Working in PostgreSQL, I intend to use the output of a CTE as a reference to join another CTE below it. I've used this style countless times in SQL Server and Synapse, however I'm finding it difficult to replicate in…
I recently started learning postgresql, and I had a little problem setting up relationships between tables. I have 2 tables - users and projects. Each project has its creator (user), and each user has an array with his projects. create…