database Questions

Postgresql – Group By with Having Count, not working as expected

August 9, 2023
imaskingbruh
2 Answers

SELECT * FROM destinations; id | updated_at | created_at | name | image --------------------------------------+----------------------------+----------------------------+----------------------------------------------+---------------------------------------------------- cf534cd9-56dd-43d5-87bb-713538ec748d | 2023-08-08 23:44:42.822226 | 2023-08-08 23:44:42.822226 | Afghanistan | https://x.cloudfront.net/flags/af.svg af4e3ac4-e9a6-4c17-8077-664d896f3a7f | 2023-08-08 23:44:42.822226 | 2023-08-08 23:44:42.822226 | Aland Islands | https://x.cloudfront.net/flags/ax.svg b377b81e-3a0c-4768-84c4-bba67e3bae1b | 2023-08-08…

VIEW QUESTION

How can we store pdf and images in mongodb database?

August 8, 2023
Udit Mishra
2 Answers

What is the best way through which we can store pdf and images in mongoDB database. I was creating a careers page, in which the user have to submit his image and the resume along with other necessary details. How…

VIEW QUESTION

Can I add a hint clause to a materialized view in postgreSQL?

August 7, 2023
piik
2 Answers

Can I add a hint clause to a materialized view in PostgreSQL as follows? or is there another way? ex1. CREATE MATERIALIZED VIEW MV1 /*+ IndexScan(tableA) */ SELECT... ex2. /*+ IndexScan(tableA) */ REFRESH MATERIALIZED VIEW MV1 I tried both, but…

VIEW QUESTION

Joining multiple junction tables and grouping results in a JSON-formatted array

August 7, 2023
Nico
2 Answers

Say I have a table of people: +----+------+ | id | name | +----+------+ | 1 | John | | 2 | Mary | | 3 | Jane | +----+------+ And various tables for clothing of various types, e.g. a…

VIEW QUESTION

Postgresql – Clojure insert data to db

August 5, 2023
Bo-Peep
2 Answers

i started learning clojure, and i have one problem. I just have 2 files, project.clj (defproject test-clojure-project "0.1.0-SNAPSHOT" :description "A simple Clojure web project" :dependencies [[org.clojure/clojure "1.10.0"] [ring "1.10.0"] [ring/ring-jetty-adapter "1.10.0"] [ring/ring-json "0.5.0"] [cheshire "5.10.0"] [org.postgresql/postgresql "42.3.1"] [org.clojure/java.jdbc "0.7.11"] ;;…

VIEW QUESTION

I am running MySQL query with in the where column and getting no results

August 3, 2023
sreddy
2 Answers

I am running the below MySQL query from c# code and the backlash is recognized only I enter it twice. Is it something I am missing in MYSQL database settings that's causing this Not Working SELECT * FROM user where…

VIEW QUESTION

Mysql – How to get the records of X and its referrals in one query?

August 2, 2023
ProfomStat
2 Answers

I have got 3 tables. Orders Clients Referrals ----- ----- ----- id id id total_price name name receiver_client_id status client_id While adding order, sometimes the receiver is CLIENT, sometimes REFERRAL, so receiver_client_id can have both client_id or referral_id. Referrals are…

VIEW QUESTION

Postgresql – Updating JSON File

August 2, 2023
Mahina Sheikh
2 Answers

so I am trying to update the JSON file using this particular query, but everytime i run this, it throws the error and my database isnot updated. cursor = connection.cursor() updated_data = { "Name": "John", "Age": "53", "SSN": "374875430" }…

VIEW QUESTION

Postgresql – How to do a Multi-level Relationships ? (Multiple Table relation in one column)

August 2, 2023
GisCat
2 Answers

I have a postgresql database with four tables: User, Country, City, and Street. The User table contains information about users, including their name, level (which can be "Country", "City", or "Street"), and ids that corresponds to the ID of the…

VIEW QUESTION

Im new to PHP and i try to make a button for purging data on PHP older than 7 days

My code doesn't work , i do some searching and try to wrap the code together <?php $del = mysqli_query($con,"DELETE FROM tb_absen_mingguan WHERE tanggal=$_GET[tanggal] <= CURRENT_DATE - INTERVAL 7 DAY;"); if ($del) { echo " <script> alert('Data telah dihapus !');…

VIEW QUESTION