I'm starting from a scenario where a PostgreSQL instance is not configured for logical replication and has a table T with X rows. Now, when I'll enable the logical replication, create a replication_slot and a publication for the table T…
I've looked at similar questions but couldn't find my answer. I've got this info: { "_id": "631337640754675725", "characters": [ { "name": "Druuwu", "scores": [ { "date": "2023-09-03", "score": 100 }, { "date": "2023-09-03", "score": 1000 }, { "date": "2023-09-03", "score":…
My objective is to make Postgres choose a faster plan after a large table update. Before the table update, the plan PG choose is what I expect (the faster plan). However, after the update, PG chooses a slower plan (it…
Suppose, we've a table named college. In this database we've the following columns: College ID, College name, State and Established in. Now I want to find the names only of those colleges where the college have another branch in the…
I need a lot of help, I'm trying to upload my Laravel 9 project to my server but I always get this error, SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO) I already configured the .env I already…
The Flutter shared_preferences package comes with a warning that says: there is no guarantee that writes will be persisted to disk after returning Because of that people often recommend using alternative solutions to local storage like Hive or SQFlite. (Aside…
my database has two table games and teams, games migration: $table->unsignedBigInteger('homeTeam'); $table->unsignedBigInteger('awayTeam'); $table->foreign('homeTeam')->references('id')->on('teams') $table->foreign('awayTeam')->references('id')->on('teams') what is relationship between this two table? many to many? should I create "game_team" pivot table? i tried to change design of database but it don't…
I have a DB with posts and tags. I want to find posts that only contain 1 tag with a specific tagId and no other tags at all. The code below works, but it requires the server to filter the…
I am trying to add a field to an aggregation called friendshipStatus and it determines whether the user is friend of the requester or no. i have this whole query [ { $match: (query) ? query : {} }, {…
I have a multidimensional array (This data may also contain very large data). In this data, in a column (example age column) I want to get data in which the data in a column (for example the age column) is…