So i'm trying to use Supabase + typescript but when i want to use insert(), update(), upsert() and other functions im getting an error when i want to declare the object that i want to declare "Type <Restaurant> does not…
I have a table with ID, seniority level, and salary (Postgres) CREATE TABLE people ( id int, seniority_level varchar(255), salary int ); The goal is to hire as many senior people under a budget of 40,000 and with the remaining…
I am working in Rails and Postgres. I have a table Problems, which has a few columns. I have another table ExtraInfos, which references Problems and has three columns: problem_id, info_type, info_value. For example: Problems: id problem_type problem_group 0 type_x…
A Product can have various sizes so I added one to many relation. But Each product can have only 1 unique size, i.e, in many to many the sizes should not repeat. For instance, Product X can have size 1,…
I am writing an sql program that creates a table with columns computed in a function. The function returns the record type. This is what the header looks like: create or replace function get_items(col1 int, col2 int) returns record What…
The project is a django web app, packed on docker containers. For some reason, I cannot run the server and launch it. when I run "manage.py runserver", this error occurs: File "C:UsersandreAppDataLocalProgramsPythonPython310libsite-packagespsycopg2__init__.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory,…
I am trying to switch my Django database from SQLite3 to PostgreSQl, so I follow many tutorials to install and setup Postgres with Django project. I did the following: pip install psycopg2, pip install psycopg2-binary and I modified the settings.py…
When passing the text in SQL query that has qoutes (for example: I'm --text---) that ' in I'm needs to be doubled up so that server won't crash. How to do that in javascript? Is there some NPM package or…
I want to query ActiveRecord collection and select records, where string value inside jsonb field is included in a given array. Model: create_table "dishes", force: :cascade do |t| ... t.jsonb "params" ... end Content of params always has this structure:…
I have a postgres column which is like so: It only has numbers or empty string. I want to be able to sort the numbers by the numbers but as I go to cast the column to a float, it…