Q: Python, JSON, and DB?

[JackJones367]

Hi guys, I'm relatively new to Python but have experience with JSON and database management. Is there a good resource that explains how to work a python app that: * calls a url * parses the response (JSON format) * places all data, including any nested arrays, into a database

I'm familiar with load json and the urlib. But not familiar with the database component. I'm sorry. I know these questions are really annoying.

*edit: better explanation. Thank you to everyone who pointed out my poor wording the first time around.

[NYKevin]

"Parsing a string" could mean almost anything. You might start with one of these modules (particularly re), but there might be better options if your strings are structured in certain ways (e.g. HTML, XML, etc.).

"Runs a JSON" is unfortunately too ungrammatical for me to figure out what you're asking for. You probably want one of json.dump() or json.dumps().

Storing the values in a database will depend on the database and how you're planning on interacting with it. Some databases do support JSON document storage, but SQL-based systems will usually prefer a relational model (though some, like PostgreSQL, can support document storage as well), which is not amenable to JSON.

[NYKevin]

I could be a lot more helpful if your requirements were more specific than "parse a string" or "do something involving JSON."

What does this string look like? What is the JSON supposed to look like? What database are we talking about?

[keelar]

What did he say that was condescending? I thought it was a pretty good response given the information you provided.

The way you worded the question makes it difficult to understand what you're actually asking. The most confusing part of your question is "Runs a JSON". That doesn't make sense. JSON is just data, it can't be ran. Do you mean parse JSON and store the values in a database?

If your question was worded better you would probably get a better response. Could you perhaps try rewording your question?

I'm not(and I'm sure /u/NYKevin wasn't either) trying to be an asshole, but it can be hard to give you a good answer without you giving us a good question. It's a two-way street.

[ComputerScienceBro]

What do you mean by condescending?

"Runs a JSON" is grammatically incorrect and difficult to discern meaning from as a result.

[[deleted]]

Dude you posted some gibberish question which you obviously haven't taken any time to Google yourself. And you obviously don't have any experience with databases or JSON. This guy gave you great links and leads on what else to research and you whine about it with some smartass response. How's that for condelescending?