I have two database tables. What I need to do is to copy specific data from one storage to another, but also keep the mapping to the photos. First part I can do easily writing INSERT INTO item (storage_id, price,…
i have following bson data in mongoDB {name : "c1" arr : [ { partyName : "p1", poNumber : "789", }, { partyName : "p1", poNumber : "700", }, { partyName : "p3", poNumber : "889", } ] }, {name…
I need to kill my session, if I'm blocking other sessions.But as of now we have only option to kill own session blocked by other sessions using lock_timeout. Do we have option in postgres to timeout own session, if our…
A team is developing a stateless docker container with the Cassandra database to be run under Kubernetes, with all data and metadata files shipped inside the container, so putting the database into a read-only mode would be ideal. The app…
Let's say I am using COPY to stream data into my database. COPY some_table FROM STDIN I noticed that AFTER stream had finished, database needs significant amount of time to process this data and input these variables into the table.…
I have this existing query: SELECT to_json(table1) FROM table1 To return all of table in a nice json format. I need to add a join to this query, so my new query looks something like this: SELECT (field1, field2, table2field1)…
I am creating a complete user login and registration Backend system with Email Verification and usage of PostgreSQL to store the user's credentials. I've come to a point where I am having problems at the security layer. To be more…
I am new to PostgreSql, I am having a table like below, I need to get output as count of the given word (test) in text_col like below table using ts_vector function, Please give me some suggestion, Thanks !.
I have a regular Wordpress site (not a multisite or network). In phpMyAdmin there are 22 lines for wp_options (each one has a difference beginning such as xxxx_wp_options) and each one is about 35MG each. Is this supposed to be…
I have a central database containing millions of IDs. And I have a group of users (50-100 users), all being able to request extraction of IDs from this big database. Atm what I do is when a user sends a…