No internet connection
  1. Home
  2. Training and Certification

Send data to postgresql

By tan sou wei @souwei2020-10-06 02:57:00.983Z

HI there, i have done using node-fetch to get data from api url, however i am having problem in sending data to postgresql, i am thinking using node-postgres to send data, but i not so familiar, can you suggest any other ways? Thank you.

Solved in post #7, click to view
  • 9 replies
  1. M
    @marc_lin2020-10-06 03:25:33.951Z

    Hi @souwei,

    For sending data to the PostgresSQL, please refer to the source code mqtt-postgres-k8s in the level 2 training course.

    Thank you~

    1. In reply tomarc_lin:
      Stan sou wei @souwei2020-10-06 09:37:23.819Z

      hi sir, i have tried with the method you gave, with the credential key also, i able to get the data view using ingress url, but the table is missing when i want to make dashboard. i am using the code to create table.
      module.exports.sqlCreatTable = CREATE SCHEMA "final_projects"; ALTER SCHEMA "final_projects" OWNER TO "g_final_project"; CREATE TABLE IF NOT EXISTS "final_projects"."temperature_souwei_tan"( id serial, timestamp timestamp without time zone NOT NULL DEFAULT (current_timestamp AT TIME ZONE 'UTC+0'), temperature integer, PRIMARY KEY (id) ); ALTER TABLE "final_projects"."temperature_souwei_tan" OWNER to "g_final_project"; GRANT ALL ON ALL TABLES IN SCHEMA "final_projects" TO "g_final_project"; GRANT ALL ON ALL SEQUENCES IN SCHEMA "final_projects" TO "g_final_project";;

      1. M@marc_lin2020-10-06 09:54:43.842Z

        Hi @souwei,

        Please provide more information about your situation and print-screen.


        1. Stan sou wei @souwei2020-10-06 10:10:54.538Z

          I try to find the temperature_souwei_tan but its not there for selection. i check with the url of mine, and it is fine and responded 200 ok. I am sorry for not so good at it. Thank you

          1. M@marc_lin2020-10-06 10:57:10.039Z2020-10-06 11:20:12.165Z

            Hi @souwei,

            You might implement previous course unit of Level 2 then do the final project.
            Please try to use the same method in the previous course unit to check the table in the Postgresql by PGadmin first.

            1. Stan sou wei @souwei2020-10-07 03:36:14.031Z

              hi sir, as mentioned by you, i able to create table and the timezone i set with timezone, but i did not showed value in dashboard.
              is my coding wrong? i use the time zone code as below
              timestamp timestamp with time zone
              default (TIMESTAMP '2020-03-17 09:00:00' AT TIME ZONE 'JST')

              1. M@marc_lin2020-10-07 08:12:15.684Z

                Hi @souwei,

                How do you confirm the table you constructed?
                Have you made sure the table you built in the Progressql by the PGadmin as I mentioned before?
                If yes, try to check the data source setting of the table you use in the Dashboard.

                1. Stan sou wei @souwei2020-10-07 08:20:45.844Z

                  Hi sir, this is how i observed that i have create my table in postgresql. sorry if i did not show clear info to you. ok i will check the dashboard setting. thanks

                  1. S@sk_chen2020-10-16 02:20:50.363Z

                    Our final-project-demo architecture is to connect the local data to the wise-paas (external cloud) , so the host needs to use external host, you can view postgresql secret in portal-service and find the external host .

                    host:Internal connection for use
                    External host:External connection for use