Being a huge programming newbie, I need an alternative introduction...?

Dash Python
1

I need this: A Minimal Dash App | Dash for Python Documentation | Plotly and this: Dash in 20 Minutes Tutorial | Dash for Python Documentation | Plotly for postgresql, not pandas. I cannot describe how much struggle I’ve had with python and pandas, hours, weeks, months…I did what I had to do with pandas to convert json files into csv tables, and I converted those csv tables into db-consumable files, and into a postgresql db. It’s still not the way I need it to be, but I’m trying to do what I can. SQL I can learn…I look at it, and it’s hard, but I can process it and learn more on it.

I have the db with thousands of tables and values. I was able to use flask, to display the raw values on an html page, (of only one table in debug mode). Thank the lords for open source snippets for me to learn from.

I already tried django, and after weeks, I only was able to get a malformed view, of only the text of the query, on the html page. What a phail on my end.
I used flask for 10 minutes and I got the table to show up.

I want one table in a graph to begin with. I can work from there. If someone can help me, direct me, to a page that shows those tutorials for plotly dash, with flask, using postgresql instead of pandas, and minimal python hell, I’d be thankful.

Sorry for the rant.

2

Hey @shrykull welcome to the forums.

You are mentioning a lot of terminology in your post which is understandable for someone getting into programming and creating stuff.

Let me just clarify:

  • you need to create an app using dash
  • your data resides in a postgresql database

Questions:

  • what content should your app show?
  • which interactivity is foreseen?
  • how do you interact right now with the db?
2 Likes
3

Sorry for the late response.
I wanted, to start off, for my demo app to display the result of a query that retrieves: all colums, and some rows of the columns. I didn’t want interaction, just to display it. I basically use psql command line tool to interact.

i think I answered that correctly..?
Don’t mean to put anyone off, I really wanted it to work, but I learned to do it with bokeh. I see with bokeh, that it helps generate an html page for my chart/plot, and in that html page, had a lot of stuff present that I was missing in code, and in understanding. I was also trying hard to avoid javascript…

Also, I still had to use a couple of lines of pandas.

Thanks for responding. I’m going to mark my own comment as a solution, since I don’t know how to close the question without deleting it. I didn’t really solve anything, solution seems unfitting.

4

We can always try to figure out something in dash. Just let us know. Don’t miss out in dash :joy::wink:

2 Likes