{"repo":"gavindsouza/instagram-to-sqlite","free":true,"listed":false,"github":"https://github.com/gavindsouza/instagram-to-sqlite","clone":"git clone https://github.com/gavindsouza/instagram-to-sqlite.git","description":"Save data from Instagram takeout to a SQLite database","language":"Python","stars":19,"topics":["instagram","sqlite","takeout","dogsheep","data-warehousing","hacktoberfest"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"instagram-to-sqlite Save data from a Instagram takeout to a SQLite database. Mise en Place This tool only supports JSON data takeouts. Ricing the potatoes $ instagram-to-sqlite chats insta-chats.db /Downloads/takeout-20190530.zip This will create a database file called insta-chats.db if one does not already exist. Serving with the steak Once you have imported Instagram data into a SQLite database file you can browse your data using Datasette. Install Datasette like so: $ pip install datasette Next run If you're new to SQL but still want to see what you could do with this, then 1. Find out what was the first message ever sent on any of your instagram chat rooms Chat rooms refer to any regular, cross-platform or group chat. 2. Awhhgee, how about the second messages? A bit unrealistic but still...maybe you really have to KNOW 3. Okay cool, what if I just want to start reading my chats from their inception like a...normal person...? You will have to figure out the chat room ID you want to query, but it won't be hard to figure that out. References Read more about datasette in the docs. Checkout the dogsheep project if you're interested in building your personal data warehouse ;) Pending stuff This is the rest of the data available in the Instagram takeout that I haven't built import tools for, yet. Currently, only chat data is covered.","default_branch":null,"files":null,"tree":[],"storefront":"/r/gavindsouza","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/gavindsouza/instagram-to-sqlite/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}