Oh absolutely, just an experiment, I am really curious about doing things like video editing etc on the client side.
I did use this to delete a lot of old tweets though.
I did use this to delete a lot of old tweets though.
SELECT substr(date,1,7) as d, count(*), min(likes+retweets) FROM tweets GROUP BY d ORDER BY d DESC;
This is also a great way to backup tweets etc.
Of course I have multiple SQLite files with all the data, whenever I want to delete “more”, I just take a new Twitter dump.