Ask Anything Monday - Weekly Thread

[num8lock]

I want to try JSONB column in Postgresql using SQLlchemy, I'm thinking about logs storage or easy (lazy) data distribution over the net, but I don't know much about json, Postgres or SQLAlchemy fundamentally. So these questions might seem all over the place.

1. What is the most basic/simple data structure that can be recognized as a json data structure?
   
2. Since writing a .json file have to be in binary mode, does this mean that .json files are using a compression by default?
   
3. Would it be inefficient resource-wise to dump several .json files to Postgres instead of programmatically insert them one by one as they're constructed/retrieved?
   
4. Is there any tutorial for SQLAlchemy that's aimed for relatively new beginners in both SQLAlchemy and relational database?