I'm trying to create tables to store very large volume of data, and I wonder if I can use null TIMESTAMP to save storage? I have a variable update_at, which will be updated to NOW() whenever I modify the associated…
Good afternoon! Looking for some advice specific to Postgres. It does not have an equivalent to CHOOSE(), but I would like to use it to pick a random string from a list. I.e.: SELECT CHOOSE ('red', 'yellow', 'blue', 'green'); Is…
I have a table with column name "collation" whose schema I cannot change. I generated some data I want to insert into this table using the following code snippet: from sqlalchemy.dialects import postgresql data = [{"collation": "foo"}, {"collation":"bar"}] stmt =…
I have a string array that represents the days of the week, but I want to map it to an integer array. I have created a function to do it, but it always returns null, I am sure I am…
I am writing my first Kafka based project and experience some issues with integration. Kafka and Kafka Connect. Here is my docker-compose.yaml version: '3.3' services: database: image: 'postgres:16.2-alpine' restart: always shm_size: 128mb ports: - 5432:5432 env_file: - ./database/.env volumes: -…
I have a column named cancel_date in my table, which stores date in varchar datatype and have some empty rows: id cancel_date 111 2024-03-27T11:27:20.215419+00:00 222 NULL 333 2024-02-23T22:02:41.671511+00:00 444 NULL So, i need to transform date values from cancel_date to…
Facing below error while running app from the cloud however this error is not getting when running from the local. Caused by: java.sql.SQLTransientConnectionException: HikariPool-2 - Connection is not available, request timed out after 30000ms. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)…
I'm trying to make my application work with Docker Compose but every time I run docker-compose up -d, my API crashes at startup (I am TRYING to migrate my database with EF Core in case I am not in production).…
I am trying to construct a full text search where half words should be matched. In my example, the column value is 'offer' and the search term is 'off'. I construct the query like this. The first line does NOT…
I have following data in my table: I need to develop a SELECT statement which returns the output as follows: Following is the script to create table and generate above data: CREATE TABLE employees.employee_data ( emp_id varchar(50) PRIMARY KEY, associations…