I can insert data into a bytea type column in a table, but I can't select it. It seems like a memory issue, how do I fix it? code sample INSERT INTO bytea_test(data) values (repeat('x', 1024 * 1024 * 1023)::bytea);…
I have two tables. StudentGroup and StudentGroupsMembers. StudentGroup.id = StudentGroupMembers.group_id is the foreign key relation. sg = StudentGroup.joins(:student_group_members).select(" student_groups.id, student_groups.name, count(student_group_members.id) as cnt ").group('student_group_members.group_id, student_groups.name, student_groups.id').where(id: [3,4,5,6,6,7,7,8,8]).where("student_group_members.member_type='ra'") This return ActiveRecord_Relation [#<StudentGroup:0x00007fc11253d088 id: 3, name: "Blah">, #<StudentGroup:0x00007fc11253cc78 id: 4, name: "Foo">,…
Is there a performance difference between doing a self-join vs. case expression when filtering a large table? For example, I have a list of names and professions, and I want to create a column that is only populated if a…
On a virtual machine I have 2 docker containers running with the names <postgres> and <system> that run on the network with name <network>. I can't change options in these containers. I have created a flask application that connects to…
My system is Ubuntu 22.04.1 LTS. I was going through the Django for professionals book and follow all line by line but somehow when i dockerize my django project with postgres it just doesn't run localhost properly, with sqlite all…
What is the best practice to post data to a server, currently my database is a PostgreSql. I would be posting to a REST Api and I want to be safe, to post I was going to use a token…
I would like to create an enforced append only table in my postgres db. After a bit of research, I realized that a solution that will answer my requirements will be to revoke ALL operations on that table from ALL…
I have this PostgreSQL table for storing words: CREATE TABLE IF NOT EXISTS words ( id bigint NOT NULL DEFAULT nextval('processed_words_id_seq'::regclass), keyword character varying(300) COLLATE pg_catalog."default", ) insert into words (words) VALUES ('while swam is interesting'); CREATE TABLE IF NOT…
I have a table where I store timeseries data: customer_id transaction_type transaction_date transaction_value 1 buy 2022-12-04 100.0 1 sell 2022-12-04 80.0 2 buy 2022-12-04 120.0 2 sell 2022-12-03 120.0 1 buy 2022-12-02 90.0 1 sell 2022-12-02 70.0 2 buy 2022-12-01…
I'm trying to implement properly a trigger function in Postgresql. The database consists of three tables, two of which are connected by a third one which is an intermediary: Table MUSICIAN (PK = id_musician) id_musician name birth death gender nationality…