I have 2 read replicas configured in the database.yml and I want to avoid any write operation in the Ruby on Rails application. When setting database_tasks: false the following exception was raised: /.rvm/gems/ruby-3.2.2/gems/activerecord-7.1.1/lib/active_record/railtie.rb:151:in `block (3 levels) in <class:Railtie>': undefined method…
I have tables level_one_table, level_two_table, and level_three_table. level_one_table to level_two_table: one to multiple rows level_two_table to level_three_table: one to one row Goal: select them all and level_two_table rows able to use LIMIT and ORDER BY. Return data structure like below:…
I have a working jdbc sink connector configuration for postgres using username and password configuration: { "connector.class": "io.confluent.connect.jdbc.JdbcSinkConnector", "connection.url": "jdbc:postgresql://localhost:5432/postgres", "connection.user": "postgres-user", "connection.password": "postgres-pw", "topics.regex": "my-topic", "transforms": "unwrap", "transforms.unwrap.type": "io.debezium.transforms.ExtractNewRecordState", "transforms.unwrap.drop.tombstones": "false", "key.converter": "org.apache.kafka.connect.json.JsonConverter", "key.converter.schemas.enable": "false", "value.converter": "org.apache.kafka.connect.json.JsonConverter", "value.converter.schemas.enable": "false",…
I am trying to save one-to-many entities to PostgreSQL database using Spring Boot and Spring Data JDBC. Main application code: @SpringBootApplication public class TvApplication { @Autowired private SeasonRepository seasonRepository; @EventListener(ApplicationReadyEvent.class) public void saveToDatabase() { Episode episode1 = new Episode("firstEpisode"); Episode…
I am trying to run pg_dump (or even psql) over our postgresql server v13, with binaries from v13 and v16. Both don't work for me, but do work for my colleagues that are not on Mac, not sure if it's…
I'm relatively early in SQL learning. I have made some data which has records where the date is missing. I want to capture as an output records that show the missing dates and the associated department name affected. output of…
I want to store a datframe from a parquet file into a PostgreSQL using Polars using this code: def store_in_postgresql(df): password = 'anon' username = 'postgres' database = 'nyc_taxis' uri = f'postgresql://{username}:{password}@localhost:5432/{database}' engine = create_engine(uri) common_sql_state = "SQLSTATE: 42P07" try:…
I have a table like this: ----------------- id | date ----------------- 1 | 2023-10-07 2 | 2023-10-08 3 | 2023-10-14 and I want to get the record count up to the current record where the date is less than Sunday…
I know that primary key values cannot be repeated. However, I want to make it so that games can be played on more than one platform. For example "Dark Souls" on PC and PS4. How do I modify the relational…
To achieve better performance by reducing multiple DB calls, I want to execute multiple select queries in the same DB call. I'm using PostgresSQL database (version 14.9), Java (version 17) and Springboot (version 3.0.6). Here is my code: private final…