You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
It just took me an embarrassing amount of time to figure out how to browse all the db tables using a postgres client. I don't think the current check included in instructions (to run psql -d sidewalk and \du) is quite enough to get new users fully set up to query the db whenever they need to. I'm wondering if it's perhaps a good idea to include specific instructions on how to use the postgres client to query for adhoc data. For example, just check that you are able to run a simple query (e.g. 'SELECT * FROM webpage_activity LIMIT 100;) to make sure you're fully set up. I think this would be simple to write up and would help to confirm that the installation has succeeded -- happy to do this if it seems helpful.
However, I'm not sure how much of this changes as a result of using docker... perhaps this will be easier then? Should I still add this step to the instructions?
The text was updated successfully, but these errors were encountered:
It just took me an embarrassing amount of time to figure out how to browse all the db tables using a postgres client. I don't think the current check included in instructions (to run psql -d sidewalk and \du) is quite enough to get new users fully set up to query the db whenever they need to. I'm wondering if it's perhaps a good idea to include specific instructions on how to use the postgres client to query for adhoc data. For example, just check that you are able to run a simple query (e.g. 'SELECT * FROM webpage_activity LIMIT 100;) to make sure you're fully set up. I think this would be simple to write up and would help to confirm that the installation has succeeded -- happy to do this if it seems helpful.
However, I'm not sure how much of this changes as a result of using docker... perhaps this will be easier then? Should I still add this step to the instructions?
The text was updated successfully, but these errors were encountered: