So i am trying to learn how to store pgsql queries on a google map. So my database contains two json columns for the lat/long. I have the slightest idea of how to query json from pgsql and display it on google maps. Can someone give me some tutorials or can someone give me some insight on getting this done?
The usual way to do that is to choose a "backend" programming language, like python, php and write a little program on a web server like Apache, which connects to the database and queries the data when the browser asks for it.
There are many such projects, you can use google, github to find open source projects for it, or use stackoverflow to find answers for specific parts of it.