tweets

This is data scraped from swyx's timeline! See blog post

16 rows where favorite_count = 14 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorited, retweeted, lang, created_at (date)

source 1 ✖

  • Twitter for iPhone · 16 ✖

favorite_count 1 ✖

id user created_at full_text retweeted_status quoted_status place source truncated display_text_range in_reply_to_status_id in_reply_to_user_id in_reply_to_screen_name geo coordinates contributors is_quote_status retweet_count favorite_count favorited retweeted possibly_sensitive lang ▼ scopes
1427988073292476418 Emelia 👸🏻 14063149 2021-08-18T13:37:42+00:00 @JessTelford JWTs for external use tend not to solve the problems people think they do; for internal use, or cross authorisation boundaries, they can be good because then you can assert using public/private key cryptography that the token your presented really came from the authorising server       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 293] 1427986367905161221 14063149 ThisIsMissEm       0 1 14 0 0   en  
1428518661338263567 swyx 33521530 2021-08-20T00:46:04+00:00 @ericnakagawa $4m, seattle       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 26] 1428441265922740225 2349251 ericnakagawa       0 0 14 0 0   en  
1430949616371961862 swyx 33521530 2021-08-26T17:45:48+00:00 i often hear that indie hackers have little to learn from working at bigco or venture track startups. The resource limitations, interpersonal management, product timeline, and transparency lessons are at minimum irrelevant, at worst totally inverse! this is the norm, but       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 274]             0 0 14 0 0   en  
1433123612899229698 swyx 33521530 2021-09-01T17:44:30+00:00 @flybayer @blitz_js @rudiyardley hot take: those people never needed graphql in the first place 🤷‍♂️ but congrats 🎉       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [33, 115] 1433087810320355339 2826554209 flybayer       0 0 14 0 0   en  
1434389932177559555 swyx 33521530 2021-09-05T05:36:24+00:00 Taken from this excellent compendium of Visual Programming - a very valuable format of blogpost! https://drossbucket.com/2021/06/30/hacker-news-folk-wisdom-on-visual-programming/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 121] 1434388834087800832 33521530 swyx       0 2 14 0 0 0 en  
1437407435241689102 swyx 33521530 2021-09-13T13:26:52+00:00 There’s a lot of advocacy of going all in on one cloud on Twitter, but this is the best collection of arguments for multi-cloud I’ve seen in a single talk — from @AdrienneTacke https://youtu.be/6Mzs5y_fjPE       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 202]             0 3 14 0 0 0 en  
1440797518749601803 swyx 33521530 2021-09-22T21:57:51+00:00 Quite a few questions on Smart Servers so far. Coincidentally @chris_mccord just published about their path to Phoenix Liveview, which is worth a look for what the Smart Server paradigm can do https://fly.io/blog/how-we-got-to-liveview/ amazing scoop for @flydotio in hiring him!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 262] 1439966955570618376 33521530 swyx       0 0 14 0 0 0 en  
1441908391211716608 swyx 33521530 2021-09-25T23:32:04+00:00 @jkup my site is still under construction with over a million visitors per year       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [6, 79] 1441872380016701440 255634108 jkup       0 0 14 0 0   en  
1445583402518802437 swyx 33521530 2021-10-06T02:55:15+00:00 @flybayer @blitz_js protip keep a “celebrate wins” or “wall of love” or “feedback” channel in slack where you collect these, you’re going to want them easy to find in future for the psychological pickup/investor update/user research       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [20, 232] 1445398474397212672 2826554209 flybayer       0 0 14 0 0   en  
1447061274148311041 swyx 33521530 2021-10-10T04:47:47+00:00 @dan_abramov ah a man of culture! i don’t think pizza restaurants realize how much business they lose out on when customers walk close, squint at the menu, and walk off when they see that the restaurant are anti pineapple snobs       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 228] 1447029234732523524 70345946 dan_abramov       0 0 14 0 0   en  
1451242768559443976 Ben Kunz 4266261 2021-10-21T17:43:33+00:00 Exceptional post by @swyx. How to create your luck. TLDR: Move more and observe. https://www.swyx.io/create-luck/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 108]             0 7 14 1 1 0 en  
1463718231454011393 swyx 33521530 2021-11-25T03:56:35+00:00 @jkup @AdamRackis finding so many people to mute, this is bliss       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [18, 63] 1463676727431946241 255634108 jkup       0 0 14 0 0   en  
1469128619716870146 swyx 33521530 2021-12-10T02:15:32+00:00 @JoeEmison @dmessing something i didnt stick around long enough to understand at Amplify was why people running atop AWS could build a faster experience than Amplify. You could blame CFN/CloudFront, but then @begin does that, with like a team of 4 people. wish i had the time to figure it out.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 293] 1469052947262754820 272692606 JoeEmison       0 1 14 0 0   en  
1473895021321482242 swyx 33521530 2021-12-23T05:55:31+00:00 @kevinakwok oof you said the thing i didnt dare say       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 51] 1473891723973701635 169791252 kevinakwok       0 0 14 0 0   en  
1473962147965112320 Theodorus Clarence 1228336168892170241 2021-12-23T10:22:15+00:00 + opinions about tailwindcss 👀 awesome book by the way @swyx https://twitter.com/th_clarence/status/1473962147965112320/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 61]             0 2 14 0 0 0 en  
1433682486106542088 swyx 33521530 2021-09-03T06:45:15+00:00 我吃的盐比你吃的饭还要多😱🤯 You could tell who spoke Chinese by the audible gasps in the room. Tony Leung owned every goddamn second he was onscreen in #shangchi https://twitter.com/swyx/status/1433682486106542088/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 149]             0 0 14 0 0 0 zh  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [tweets] (
   [id] INTEGER PRIMARY KEY,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [full_text] TEXT,
   [retweeted_status] INTEGER,
   [quoted_status] INTEGER,
   [place] TEXT REFERENCES [places]([id]),
   [source] TEXT REFERENCES [sources]([id]), [truncated] INTEGER, [display_text_range] TEXT, [in_reply_to_status_id] INTEGER, [in_reply_to_user_id] INTEGER, [in_reply_to_screen_name] TEXT, [geo] TEXT, [coordinates] TEXT, [contributors] TEXT, [is_quote_status] INTEGER, [retweet_count] INTEGER, [favorite_count] INTEGER, [favorited] INTEGER, [retweeted] INTEGER, [possibly_sensitive] INTEGER, [lang] TEXT, [scopes] TEXT,
   FOREIGN KEY([retweeted_status]) REFERENCES [tweets]([id]),
   FOREIGN KEY([quoted_status]) REFERENCES [tweets]([id])
);
CREATE INDEX [idx_tweets_source]
    ON [tweets] ([source]);