so I want to build a intventory Management database. My schema looks like this: Database Schema An Itemclass (screwdriver, hammer, measuring device,...) can have many items (screwdriver1, screwdriver2,...) Everything is fine and working as expected. But now i want to…
I am new to React Native and app development. So I am making a basic app that once opened, a modal opens up for use to login. User authenticates with Supabase, and then modal goes away to user can start…
I have the following table: create table table1 ( id serial, workdate date, col1 varchar, col2 varchar, col3 varchar ); And I have inserted the following data: insert into table1(id, workdate) values (DEFAULT, '01/12/2023'); Now I updated it, looking to…
I am taking over maintenance on some older ASP.NET projects. I see code like the following all over the place. Shouldn't the database objects be wrapped in using statements? The server is busy and runs for months as is without…
I am getting these errors (please see below) after I restart my psql database. This occurs after i install pgaudit and adding pgaudit on my postgresql.conf. I wonder what am i missing, is it a problem on pgaudit installation? 2024-01-22…
So I have a table where I have column A, B, C,D. Column A has values which have corresponding multiple values in column B.I need to check if all the values in column C and D are null for the…
I have a table like this librarylog patronName bookId dueDate John 24 2024-01-14 Sam 42 2024-01-07 Bob 13 2024-01-07 I'm trying to create a SQL query which updates all the dueDate values and increases them by a week. This is…
Customers Field Type Null Key Default Extra recno int NO PRI NULL auto_increment CustomerKey int NO NULL MaintDate date YES NULL Service Orders Field Type Null Key Default Extra recno int NO PRI NULL auto_increment CustomerKey int NO NULL ServiceDate…
I want to have a result of unique row of id, date_col1, with max (or last) of date_col2, and the value contained in the same row as max(date_col2). My table is like this sample: id date_col1 date_col2 value 1 2023-01-02…
I am trying to makemigrations in my project with Django using postgresql. But I have been having the following error: (agenda_api) C:UsersfelipOneDriveEscritorioManagmentCursosDjangoagendadjagenda>python manage.py makemigrations Traceback (most recent call last): File "C:UsersfelipOneDriveEscritorioManagmentCursosDjangoagenda_apilibsite-packagesdjangodbbackendspostgresqlbase.py", line 25, in <module> import psycopg2 as Database File…