I downloaded all the posts on Bluesky as of 2023-05-01. Here’s the 1680399 posts from 45457 accounts in a Postgres database.

Download (2.94GB)

Queries to try

Top 10 accounts with most followers:

select * from profile order by (select count(1) from follow where "subjectDid" = profile.creator) desc limit 10;

Output:

                                uri                                |                             cid                             |             creator              |            displayName            |                                                                     description                                                                      |                          avatarCid                          |                          bannerCid                          |        indexedAt         
-------------------------------------------------------------------+-------------------------------------------------------------+----------------------------------+-----------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+-------------------------------------------------------------+--------------------------
 at://did:plc:oky5czdrnfjpqslsw2a5iclo/app.bsky.actor.profile/self | bafyreifjtax5wqyn6zl7h737mfnnk63l5kdep3t2auo75z6awwinr5pq5q | did:plc:oky5czdrnfjpqslsw2a5iclo | Jay 🦋                             | CEO of Bluesky, steward of AT Protocol. Let’s build a federated republic, starting with this server.                                                +| bafkreihquydaf5xer53afkmdefp2hpwbtqcgurxo2hsdkrpwpvm6uhkyg4 | bafkreicgnmvhtmj4arcvwhueygbwvkucd3odvom3lxtfmn6wlqbh3yf7p4 | 2023-05-02T03:23:27.059Z
                                                                   |                                                             |                                  |                                   |                                                                                                                                                     +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                                   | Nature, knowledge, technology. I like to think of a cybernetic forest. 🌱 🪴 🌳                                                                         |                                                             |                                                             | 
 at://did:plc:6fktaamhhxdqb2ypum33kbkj/app.bsky.actor.profile/self | bafyreiaugm44rvh7uc7agdqlx4yfxublurrnkjileb24lwyky4csgukz2m | did:plc:6fktaamhhxdqb2ypum33kbkj | jack                              |                                                                                                                                                      | bafkreigzezczfmvygzhf4d4el5ihh5lrt6dtdilxgcmyu3ikusit36cebi |                                                             | 2023-05-02T03:24:39.506Z
 at://did:plc:z72i7hdynmk6r22z27h6tvur/app.bsky.actor.profile/self | bafyreibqffus4eyyivya3gg22leqy55cbwxyihqtyuenceevc4bwvbk4h4 | did:plc:z72i7hdynmk6r22z27h6tvur | Bluesky                           | Official bluesky account (check domain 👆)                                                                                                           +| bafkreic5kmqlhrhbfnh2bx6fsetvkra4noqja5ngsnnadrvubd6jcoc3ae | bafkreif7lzr3l7ysgwfuiv7q6rtlyebup2mizdgmbhmsunowspiq7m4oee | 2023-05-02T18:08:51.736Z
                                                                   |                                                             |                                  |                                   |                                                                                                                                                     +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                                   | Follow for updates and announcements                                                                                                                 |                                                             |                                                             | 
 at://did:plc:ragtjsm2j2vknwkz3zp4oxrd/app.bsky.actor.profile/self | bafyreigyr7jtqlzftcfrfznjhmwqevzdzgih6vio3v5jl6rcbpycbqus5u | did:plc:ragtjsm2j2vknwkz3zp4oxrd | Paul Frazee (all hoity toity now) | Developer at Bluesky. The one who puts bugs in this app.                                                                                             | bafkreiftyjy6k3t2yi5hh7gwin4p4hkuhp3kqxbzbbzr4gjsgotvcyk73e | bafkreibhvcmv3ziagszmfdgxj3r6z3ivllcfnirhxux4stpifr3xifqjpu | 2023-05-02T03:20:44.736Z
 at://did:plc:p7gxyfr5vii5ntpwo7f6dhe2/app.bsky.actor.profile/self | bafyreibx3xvykykele3dt2i2sogotsnmmckrlqisqcwqmkus6cfjjw56oa | did:plc:p7gxyfr5vii5ntpwo7f6dhe2 | Alexandria Ocasio-Cortez          | Congresswoman for NY14, repping the Bronx and Queens. Grassroots progressive. Funded by everyday people, not lobbyists. A better world is possible. +| bafkreia7pjciqmezep36yotfgas23eie47sy5ymcorzd7exejlxtiox6by |                                                             | 2023-05-05T20:01:01.550Z
                                                                   |                                                             |                                  |                                   |                                                                                                                                                     +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                                   | ocasiocortez.com/about                                                                                                                               |                                                             |                                                             | 
 at://did:plc:vpkhqolt662uhesyj6nxm7ys/app.bsky.actor.profile/self | bafyreiana5uck6quyl53dux5bvpgghecynzlviqzvej6sz547fchsv5dcy | did:plc:vpkhqolt662uhesyj6nxm7ys | Uai?                              | Technical advisor to @bluesky, first engineer at Protocol Labs. Wizard Utopian                                                                       | bafkreihxiic7f65slclhzy3aanyvrclotyvatwmd7lct4g4bwfvnzqlexa | bafkreihxbkzsboqivoqlzaii7ye5ykp3xztbwcnjuos7bbz6zd5irndnqi | 2023-05-02T03:22:09.523Z
 at://did:plc:cm4bwax4evxmkiuwxvvkvlmx/app.bsky.actor.profile/self | bafyreifvf5xxqg7ggw2g2wqfh62y5e5efphna3hbljeg3mduo22up4ey44 | did:plc:cm4bwax4evxmkiuwxvvkvlmx | Thomas Pockrandt                  | Tech Advisor & Digital Strategist 🦾                                                                                                                 +| bafkreidvjlqht65wd64dae5etrgh2xodgubeyoryxu7nugmcdzwv2qk4jq | bafkreid3272rix3d7o5s5umqvfo5alzmhjwzmdfne4hkommwpf5wjqpchu | 2023-05-02T06:25:23.203Z
                                                                   |                                                             |                                  |                                   |                                                                                                                                                     +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                                   | https://thomaspockrandt.com                                                                                                                          |                                                             |                                                             | 
 at://did:plc:pdac24jyypwultrppa457voe/app.bsky.actor.profile/self | bafyreicnkal36xuktylcvzkvhmzrmvklrwbm5jpuvmxfjfoeiztehkiahu | did:plc:pdac24jyypwultrppa457voe | Vishal Gulia 🌞                    | Bluesky’s first memer, early adopter & investor of decentralised social. My mission is to spread humour and joy.                                    +| bafkreihr76fl52k43wklwxtklkhr7tiww7cudjzphxauh6whvf6ohlqmri | bafkreiclaok4chj6g5kvruro7ai7kxtpmyn47lou6g23qt4uw2z2bcfequ | 2023-05-02T05:29:14.433Z
                                                                   |                                                             |                                  |                                   |                                                                                                                                                     +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                                   | www.diamondapp.com/u/VishalGulia                                                                                                                     |                                                             |                                                             | 
 at://did:plc:36tmqxxepo5jlx54peygtx6i/app.bsky.actor.profile/self | bafyreieuchpwxvnjirvsk4adcllnqjxlcor32z3236nx5duvizloevlsvm | did:plc:36tmqxxepo5jlx54peygtx6i | Cat                               | Cats lover                                                                                                                                           | bafkreig24kwjk4kucmeqlgmux2czvgqvbax43w4ovcukfr6rv2yy36chve | bafkreiagc3lyyet62ioy476zja5azjmaax55nakfztslffsggqequjchhu | 2023-05-02T05:54:08.760Z
 at://did:plc:6wpkkitfdkgthatfvspcfmjo/app.bsky.actor.profile/self | bafyreigdmlufln4autqiggpgpi4hwjtlljalrvqpzg5xc6ur6sfpjqirze | did:plc:6wpkkitfdkgthatfvspcfmjo | wint                              | Pussy                                                                                                                                                | bafkreiggofiqpdnz6tfajmu7i5gdqyl7j27h22bqivpmkymuzwd5kcudfm |                                                             | 2023-05-05T18:33:35.121Z
(10 rows)

Top 10 accounts following the most users:

select * from profile order by (select count(1) from follow where "creator" = profile.creator) desc limit 10;

                                uri                                |                             cid                             |             creator              |         displayName         |                                                   description                                                    |                          avatarCid                          |                          bannerCid                          |        indexedAt         
-------------------------------------------------------------------+-------------------------------------------------------------+----------------------------------+-----------------------------+------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------+-------------------------------------------------------------+--------------------------
 at://did:plc:md6i2csjmkfoie6u4ot4kjmn/app.bsky.actor.profile/self | bafyreifj6qpnx5lsh7nwoisfal2bgzojfyqymtnjicjpboiyqblr54tkje | did:plc:md6i2csjmkfoie6u4ot4kjmn | Eddie Silva                 | Al enthusiast | writer | Coffee lover ☕️                                                                         +| bafkreib3g5pqdsyuidrcs4k7etaibpivoj5tfgu5oqvy6fewyfrga6hnzm | bafkreiatd5br5szcttcnchjusmzqvxcrrg4pe2wjzsggwbfkogpjnwqjia | 2023-05-02T19:15:11.388Z
                                                                   |                                                             |                                  |                             |                                                                                                                 +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | Bsky Unauthorized User Counter 🫣                                                                                +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             |                                                                                                                 +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | Most of the images posted here are generated by AI.                                                             +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | 🇺🇸 English  🇧🇷 Português                                                                                         |                                                             |                                                             | 
 at://did:plc:cm4bwax4evxmkiuwxvvkvlmx/app.bsky.actor.profile/self | bafyreifvf5xxqg7ggw2g2wqfh62y5e5efphna3hbljeg3mduo22up4ey44 | did:plc:cm4bwax4evxmkiuwxvvkvlmx | Thomas Pockrandt            | Tech Advisor & Digital Strategist 🦾                                                                             +| bafkreidvjlqht65wd64dae5etrgh2xodgubeyoryxu7nugmcdzwv2qk4jq | bafkreid3272rix3d7o5s5umqvfo5alzmhjwzmdfne4hkommwpf5wjqpchu | 2023-05-02T06:25:23.203Z
                                                                   |                                                             |                                  |                             |                                                                                                                 +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | https://thomaspockrandt.com                                                                                      |                                                             |                                                             | 
 at://did:plc:2rhgf24qcpdxuscon3gwp6it/app.bsky.actor.profile/self | bafyreid5m5u5ievdwjkm32yi2xcndj3lihvnky7u65dusolgmmif4ix3w4 | did:plc:2rhgf24qcpdxuscon3gwp6it | Mr.Preet⭐                   | Fullstack Developer 🇮🇳                                                                                          +| bafkreiacw5l67mam5pa3utpe7ifc4ytyh4rthf5c5t2ksfqk37adtt2dtu | bafkreidfz3xzmtw3mo7dcxcwt6xaag3qxb33wccxmqxtxoy6fno54sn65a | 2023-05-02T10:03:38.126Z
                                                                   |                                                             |                                  |                             |                                                                                                                 +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | Founder: Pinsta.xyz                                                                                             +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | Co-Founder: CircleIt.app                                                                                        +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | Twitter: https://twitter.com/jsonpreet                                                                           |                                                             |                                                             | 
 at://did:plc:gavqr7yuapgfhfr4hvosjyoh/app.bsky.actor.profile/self | bafyreihmwxxxbt367thnmpmdqjk3jmutsprculfe3nudxxuxg6a65mawsi | did:plc:gavqr7yuapgfhfr4hvosjyoh | Nelson Coffee Roaster ☕️ 🐱🎸🏍 | コーヒー豆専門店「Nelson Coffee Roaster」                                                                       +| bafkreifrqxhra4mmipyqazvzgr5fhuundm3qrx7y5pd4flrx27msjy3gji | bafkreifownbu3froekogegccc4goehgadavrilzsqk3twynyqatx7ygo7a | 2023-05-02T18:23:12.402Z
                                                                   |                                                             |                                  |                             | コーヒー業界30年                                                                                                +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | 家にネコがいます🐱                                                                                               +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | フォローは手動✋                                                                                                 +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | コーヒー豆EC☕️🫘 https://ncr.official.ec                                                                          +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | All languages ​​other than Japanese are machine translated.                                                      |                                                             |                                                             | 
 at://did:plc:4usvqnzxonnvz2hyvx2msr4h/app.bsky.actor.profile/self | bafyreibmtutsbpjm33vozzszmurjt5242djdpscjpl2wrqo7jvgfq5w5eu | did:plc:4usvqnzxonnvz2hyvx2msr4h | caleb 2                     | in the clouds. He / They                                                                                        +| bafkreigpk7b6baruwsqpp7et6zpdhjxu7a4gnxxgrwmino2tedugpvqdwy | bafkreig7fqucnf7nnkdel56l5pgjji3q4oeof4y3rnfqdh3uocwkjwu4sa | 2023-05-02T04:49:59.907Z
                                                                   |                                                             |                                  |                             |                                                                                                                 +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | welcome to my alt, unofficial posts here.                                                                        |                                                             |                                                             | 
 at://did:plc:f7du5s6xe4fza2gixnynvzxq/app.bsky.actor.profile/self | bafyreiakdkt7rccq3tjsqbcjtunzhhzyaupfsg4cau2t2oby4olc66fltm | did:plc:f7du5s6xe4fza2gixnynvzxq | shitpost machine 3000       | here to shitpost                                                                                                +| bafkreiec7nqaxcggbzvhmbvxqsp4ejkh5ehqqiiwhejffwk7dnmwyqbelm | bafkreic3gbl7ykso4ecmmn3mdi3m5kk47z6tbw6ana5a7rvpgtet6hy4pu | 2023-05-06T13:27:46.898Z
                                                                   |                                                             |                                  |                             | follow me for 69 years of good luck                                                                              |                                                             |                                                             | 
 at://did:plc:sbalnchbqyuqkwpjjy3zry7f/app.bsky.actor.profile/self | bafyreiezx2zfoewcmurhc6zpaqsjxq6nfnriilvrrmlfmdquyhf2ihsdh4 | did:plc:sbalnchbqyuqkwpjjy3zry7f | Rie                         | Software Engineer, Professional Hugger, Femboy, 🏳️‍🌈                                                             +| bafkreih5mcnl63ancqcs3smd35a62ucj2dwasbnlwmc3fvy3cmxqlzsrum | bafkreiag3g3gapj7otvk3sjkdimbcoh2i56uzq32ytcqmixnx7bxk3fsru | 2023-05-05T20:48:47.941Z
                                                                   |                                                             |                                  |                             | read if cute                                                                                                     |                                                             |                                                             | 
 at://did:plc:pdac24jyypwultrppa457voe/app.bsky.actor.profile/self | bafyreicnkal36xuktylcvzkvhmzrmvklrwbm5jpuvmxfjfoeiztehkiahu | did:plc:pdac24jyypwultrppa457voe | Vishal Gulia 🌞              | Bluesky’s first memer, early adopter & investor of decentralised social. My mission is to spread humour and joy.+| bafkreihr76fl52k43wklwxtklkhr7tiww7cudjzphxauh6whvf6ohlqmri | bafkreiclaok4chj6g5kvruro7ai7kxtpmyn47lou6g23qt4uw2z2bcfequ | 2023-05-02T05:29:14.433Z
                                                                   |                                                             |                                  |                             |                                                                                                                 +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | www.diamondapp.com/u/VishalGulia                                                                                 |                                                             |                                                             | 
 at://did:plc:36tmqxxepo5jlx54peygtx6i/app.bsky.actor.profile/self | bafyreieuchpwxvnjirvsk4adcllnqjxlcor32z3236nx5duvizloevlsvm | did:plc:36tmqxxepo5jlx54peygtx6i | Cat                         | Cats lover                                                                                                       | bafkreig24kwjk4kucmeqlgmux2czvgqvbax43w4ovcukfr6rv2yy36chve | bafkreiagc3lyyet62ioy476zja5azjmaax55nakfztslffsggqequjchhu | 2023-05-02T05:54:08.760Z
 at://did:plc:u66yy4dkibtqvckpvlpvhwbk/app.bsky.actor.profile/self | bafyreicewuhqzsm2fsjk3lpijoygn44gk3jii2vsseosjpwzoldbcduike | did:plc:u66yy4dkibtqvckpvlpvhwbk | Andrew Lombardi 💙☁️          | Head geek at Mystic Coders, software engineer, startup expert, father and passionate about PKM.                 +| bafkreiec5kwx4wghxhp55dr6xwv4gukp63vve67q3xmsxmoeuiah32xp5q | bafkreieba2zbdtjn6ynk75q2l7l4mqk243m55smx2koaz24dla7pvqjipu | 2023-05-03T15:50:57.710Z
                                                                   |                                                             |                                  |                             |                                                                                                                 +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | Former Sr SWE at Twitter                                                                                        +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             |                                                                                                                 +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | https://linktr.ee/kinabalu                                                                                      +|                                                             |                                                             | 
                                                                   |                                                             |                                  |                             | ko-fi: https://ko-fi.com/kinabalu                                                                                |                                                             |                                                             | 
(10 rows)

Top 3 most reposted posts:

select * from post order by (select count(1) from repost where post.uri = repost.subject) desc limit 3;

                                  uri                                   |                             cid                             |             creator              |                                                                                                            text                                                                                                            | replyRoot | replyRootCid | replyParent | replyParentCid |        createdAt         |        indexedAt         |          sortAt          
------------------------------------------------------------------------+-------------------------------------------------------------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+--------------+-------------+----------------+--------------------------+--------------------------+--------------------------
 at://did:plc:dst5a7uf7wtatmp66p5ygzmw/app.bsky.feed.post/3juezhxkcrl2m | bafyreifg2433jfjkwn7qb34o6zrrecdygkxh22eku27scrtj3libz5chge | did:plc:dst5a7uf7wtatmp66p5ygzmw | guess where we’re complaining about it now bitch                                                                                                                                                                           |           |              |             |                | 2023-04-27T21:15:40.989Z | 2023-05-05T17:08:48.008Z | 2023-04-27T21:15:40.989Z
 at://did:plc:53kudcqj7sizx2eaclc5sicc/app.bsky.feed.post/3juhljm3c6o2p | bafyreiccsz6bh4g2chrwohruucshdgc6qdsyh45pcyvjochw5ojwhwdevi | did:plc:53kudcqj7sizx2eaclc5sicc | Reskeet if u think trans people are cool 😎                                                                                                                                                                                 |           |              |             |                | 2023-04-28T21:44:03.137Z | 2023-05-05T22:08:30.997Z | 2023-04-28T21:44:03.137Z
 at://did:plc:ragtjsm2j2vknwkz3zp4oxrd/app.bsky.feed.post/3jtqhia5mxe2z | bafyreibnoomzhzj7qhcphhdeufjur4egobufmhqpsbgowthhp4eomfzrt4 | did:plc:ragtjsm2j2vknwkz3zp4oxrd | 📢 Android is finally here! 🎉                                                                                                                                                                                              +|           |              |             |                | 2023-04-19T17:00:27.839Z | 2023-05-02T03:20:44.736Z | 2023-04-19T17:00:27.839Z
                                                                        |                                                             |                                  |                                                                                                                                                                                                                           +|           |              |             |                |                          |                          | 
                                                                        |                                                             |                                  | Google takes a while to update their search so here’s the direct link:                                                                                                                                                    +|           |              |             |                |                          |                          | 
                                                                        |                                                             |                                  |                                                                                                                                                                                                                           +|           |              |             |                |                          |                          | 
                                                                        |                                                             |                                  | https://play.google.com/store/apps/details?id=xyz.blueskyweb.app&hl=en_US                                                                                                                                                  |           |              |             |                |                          |                          | 
(3 rows)

Top 3 most liked posts:

select * from post order by (select count(1) from "like" as l where post.uri = l.subject) desc limit 3;

                                  uri                                   |                             cid                             |             creator              |                                                                                                            text                                                                                                            | replyRoot | replyRootCid | replyParent | replyParentCid |        createdAt         |        indexedAt         |          sortAt          
------------------------------------------------------------------------+-------------------------------------------------------------+----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+--------------+-------------+----------------+--------------------------+--------------------------+--------------------------
 at://did:plc:dst5a7uf7wtatmp66p5ygzmw/app.bsky.feed.post/3juezhxkcrl2m | bafyreifg2433jfjkwn7qb34o6zrrecdygkxh22eku27scrtj3libz5chge | did:plc:dst5a7uf7wtatmp66p5ygzmw | guess where we’re complaining about it now bitch                                                                                                                                                                           |           |              |             |                | 2023-04-27T21:15:40.989Z | 2023-05-05T17:08:48.008Z | 2023-04-27T21:15:40.989Z
 at://did:plc:oky5czdrnfjpqslsw2a5iclo/app.bsky.feed.post/3jukkbpk5ak2m | bafyreidziqiimnaynh47bt6ybuue2csp5mk3gnpxhnv7onoe4glosdmhty | did:plc:oky5czdrnfjpqslsw2a5iclo | Nobody has a right to access an invite-only closed beta, and if they are creating an account exclusively to jump in and harass people in replies they will be removed.                                                     |           |              |             |                | 2023-04-30T01:59:43.405Z | 2023-05-02T03:23:27.059Z | 2023-04-30T01:59:43.405Z
 at://did:plc:p7gxyfr5vii5ntpwo7f6dhe2/app.bsky.feed.post/3juma3uvbuv22 | bafyreic7xiwblku7pvmu5vxpjdfewphrff53dqct7e62x3mpzjhaa7fgcq | did:plc:p7gxyfr5vii5ntpwo7f6dhe2 | I just want a place to poast and roast without a) nazis and b) the New York Times writing an editorial about it like “aoc said nazis are bad. Is she wrong? We went on a diner date with harlan crow’s PR guy to find out” |           |              |             |                | 2023-04-30T18:02:49.778Z | 2023-05-05T20:01:01.550Z | 2023-04-30T18:02:49.778Z
(3 rows)

Top 3 most replied posts:

select * from post order by (select count(1) from post as reply where post.uri = "replyParent") desc limit 3;

                                  uri                                   |                             cid                             |             creator              |                                                                                          text                                                                                           | replyRoot | replyRootCid | replyParent | replyParentCid |        createdAt         |        indexedAt         |          sortAt          
------------------------------------------------------------------------+-------------------------------------------------------------+----------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+--------------+-------------+----------------+--------------------------+--------------------------+--------------------------
 at://did:plc:oky5czdrnfjpqslsw2a5iclo/app.bsky.feed.post/3jt5pfybq6u2q | bafyreie22vh3vqkdt4kbcfdxfbpmwcfexqg5ovgaqemx2h7nrwelh3o6zi | did:plc:oky5czdrnfjpqslsw2a5iclo | New invite thread —                                                                                                                                                                    +|           |              |             |                | 2023-04-12T06:01:47.209Z | 2023-05-02T03:23:27.059Z | 2023-04-12T06:01:47.209Z
                                                                        |                                                             |                                  |                                                                                                                                                                                        +|           |              |             |                |                          |                          | 
                                                                        |                                                             |                                  | If you want invites, message me here instead of commenting on other threads.                                                                                                           +|           |              |             |                |                          |                          | 
                                                                        |                                                             |                                  |                                                                                                                                                                                        +|           |              |             |                |                          |                          | 
                                                                        |                                                             |                                  | I got access to a cli tool why.bsky.world built to drop invites into your accounts today. 😈😇                                                                                           +|           |              |             |                |                          |                          | 
                                                                        |                                                             |                                  |                                                                                                                                                                                        +|           |              |             |                |                          |                          | 
                                                                        |                                                             |                                  | May or may not distribute. 🪄                                                                                                                                                            |           |              |             |                |                          |                          | 
 at://did:plc:oky5czdrnfjpqslsw2a5iclo/app.bsky.feed.post/3juflvnb3d62u | bafyreiga6tugnvel3x4eb57wbkp5gbu2gpa7eiqmbyconpaedwdy7lvx6m | did:plc:oky5czdrnfjpqslsw2a5iclo | Guys, please don't let "skeets" stick                                                                                                                                                  +|           |              |             |                | 2023-04-28T02:45:27.170Z | 2023-05-02T03:23:27.059Z | 2023-04-28T02:45:27.170Z
                                                                        |                                                             |                                  |                                                                                                                                                                                        +|           |              |             |                |                          |                          | 
                                                                        |                                                             |                                  | The experiment in decentralized naming decisions has resulted in the worst possible term                                                                                               +|           |              |             |                |                          |                          | 
                                                                        |                                                             |                                  |                                                                                                                                                                                        +|           |              |             |                |                          |                          | 
                                                                        |                                                             |                                  | How about skoots? Can we bring back skoots? Bluesky OGs, help me out here, remember skoots?                                                                                             |           |              |             |                |                          |                          | 
 at://did:plc:p7gxyfr5vii5ntpwo7f6dhe2/app.bsky.feed.post/3jupcszqouk2o | bafyreieauaougusit3dzl5hcztnohdxlpebhqfhnj6fhv2j5oggjopaq3u | did:plc:p7gxyfr5vii5ntpwo7f6dhe2 | Right now! AMA                                                                                                                                                                          |           |              |             |                | 2023-05-01T23:29:33.444Z | 2023-05-05T20:01:01.550Z | 2023-05-01T23:29:33.444Z                                                          |                                  | I'm here to shitpost & talk tech mostly, but just so you know where I stand when civil war breaks out                                                                                   |           |              |             |                |                          |                          | 
(3 rows)

Top 10 longest threads:

select count(uri), "replyRoot" from post group by "replyRoot" order by count(uri) desc limit 10;

 count  |                               replyRoot                                
--------+------------------------------------------------------------------------
 697077 | 
  21347 | at://did:plc:nx3kofpg4oxmkonqr6su5lw4/app.bsky.feed.post/3juhgsu4tpi2e
   8623 | at://did:plc:kcevumnk4gjxyegqwbubpajo/app.bsky.feed.post/3julld7hob62y
   2412 | at://did:plc:hdfrgtchoulcxlfzl2qsqdec/app.bsky.feed.post/3juiawxjnuk2y
   2046 | at://did:plc:alrwn2rkxotdsyfnn27op6e7/app.bsky.feed.post/3jtz3qo6zjl23
   1984 | at://did:plc:tuett6q54evdlpvezox5j5zi/app.bsky.feed.post/3juhth2jgyl2r
   1980 | at://did:plc:hsqwcidfez66lwm3gxhfv5in/app.bsky.feed.post/3jucndteqnk2l
   1972 | at://did:plc:izlc5ki5pat26fiammhyfv23/app.bsky.feed.post/3jukv52q4es2a
   1330 | at://did:plc:g74vihxy7k6vsjxwus7g4sn6/app.bsky.feed.post/3juh447up7i2m
   1118 | at://did:plc:7owy6yfqghzcnhskb2a3cg56/app.bsky.feed.post/3jukw75cawu26
(10 rows)

How I downloaded it

What I learned

  • How to download Bluesky data
  • How to use GNU Parallel
  • How to use DigitalOcean Spaces
  • (Edit:) OneDrive is a terrible way to serve files

Read More