tweets

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

25 rows where favorited = 1, is_quote_status = 0 and retweeted = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, retweet_count

favorite_count 25 ✖

retweeted 1 ✖

is_quote_status 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
1451309430830612495 swyx 33521530 2021-10-21T22:08:26+00:00 Nice alternative to "What's your greatest weakness?": "What is one skill you would like to work on, that would make you much more effective at work?"       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 150]             0 10 138 1 0   en  
1451412869065547777 swyx 33521530 2021-10-22T04:59:28+00:00 how many vacation days have you taken this year?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 48]             0 2 22 1 0   en  
1451584443534102533 swyx 33521530 2021-10-22T16:21:15+00:00 Me before we ship: "this is great! we worked so hard on it and it shows!" Me after even a little bit of user feedback: "wow this is terrible we have so much more work to do 😅" if you think you're done, you haven't talked to users enough.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 239]             0 4 124 1 0   en  
1453508738241814533 swyx 33521530 2021-10-27T23:47:42+00:00 For Developer Experience peeps: I met @Silassao at KubeCon recently and he was thinking thru a lot of the same problems at @DataStax. We had a recorded conversation today about how we're using feature mapping to harmonize the DX for @Temporalio! https://youtu.be/ddKDPikKbNk       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 272]             0 2 11 1 0 0 en  
1458156097622007809 swyx 33521530 2021-11-09T19:34:39+00:00 Free Startup Idea: Chaos Monkey for Meetings Randomly cancel recurring meetings and see if anyone notices       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 106]             0 74 638 1 0   en  
1459667585272713218 swyx 33521530 2021-11-13T23:40:46+00:00 🗽 Just booked a giant AirBnB for next week's NYC Svelte Summit (https://lu.ma/sveltenyc)! If any out of towners are considering flying in for #SvelteSummit, we have 1-2 beds left in the SvelteShack. DM to join! If you're local and interested in the future of the Web, join us:       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 2 33 1 0 0 en  
1462141656916967426 swyx 33521530 2021-11-20T19:31:50+00:00 This is getting out of hand - now there are TWO of them! -@Rich_Harris and @bennorskov at #SvelteSummit https://twitter.com/swyx/status/1462141656916967426/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 104]             0 3 170 1 0 0 en  
1462923803189645315 swyx 33521530 2021-11-22T23:19:49+00:00 JS Devs: Would not be caught dead using PHP Also JS Devs: Furiously reinventing PHP since 2013       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 95]             0 89 910 1 0   en  
1464873480654974981 swyx 33521530 2021-11-28T08:27:08+00:00 Take more pictures of yourself, and of the people and things you take for granted every day. These are the good old days.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 122]             0 85 554 1 0   en  
1465523933512232963 swyx 33521530 2021-11-30T03:31:48+00:00 If you had to choose, would you want your favorite writers/content creators to put their best stuff: - behind a $15 monthly subscription, - into a $99-299 onetime sale, or - make it free ($0) but with ads? Remember - you WANT to support their work - but what format is best?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278]             0 1 9 1 0   en  
1466641806007812098 swyx 33521530 2021-12-03T05:33:50+00:00 I think I have a memory leak on my machine. It slows down more and more every single day I let it "sleep" instead of shutting down. This is the first time it's been so obvious but I dont know the cause since its been slowly deteriorating. Any tips for identifying memory leaks?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 0 32 1 0   en  
1467249786604584961 swyx 33521530 2021-12-04T21:49:43+00:00 What's the best way to be confident without being overconfident?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 64]             0 9 91 1 0   en  
1468292823443070983 swyx 33521530 2021-12-07T18:54:23+00:00 The nature of UX bugs is that they are low priority in the short term (minor inconvenience), and high priority in the long term (evidence of lack of polish; persistent friction). If your issue prioritization doesn't include issue age you are almost certainly missing this.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 273]             0 21 130 1 0   en  
1469092201376354305 swyx 33521530 2021-12-09T23:50:49+00:00 Hardest part of having a dual “bottom-up” + “top-down” pricing strategy is minding the sharp edges. Just spent an hour today patiently explaining to a vendor why it doesnt make sense for my monthly bill to go from $150 for a team of 6 to $3000 for a team of 7.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 261]             0 13 211 1 0   en  
1470786647788765201 swyx 33521530 2021-12-14T16:03:57+00:00 The Great Resignation to @Vercel pipeline       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 41]             0 14 447 1 0   en  
1470787094750449665 swyx 33521530 2021-12-14T16:05:43+00:00 At this point they might as well rename Vercel’s slack to VC39       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 62] 1470786647788765201 33521530 swyx       0 2 128 1 0   en  
1470788640846462979 swyx 33521530 2021-12-14T16:11:52+00:00 Imagine accidentally holding a JSConf in your daily standup       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 59] 1470787094750449665 33521530 swyx       0 28 362 1 0   en  
1470789190417719303 swyx 33521530 2021-12-14T16:14:03+00:00 The same consolidation play Microsoft made for developer tools, @Vercel is now making for developers       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 100] 1470788640846462979 33521530 swyx       0 4 87 1 0   en  
1470791843222753280 swyx 33521530 2021-12-14T16:24:36+00:00 Everybody making @vercel comparisons to avengers is thinking too small Vercel Class of 2021 looks more like https://twitter.com/swyx/status/1470791843222753280/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 108] 1470789190417719303 33521530 swyx       0 11 158 1 0 0 en  
1470795050225307655 swyx 33521530 2021-12-14T16:37:20+00:00 Prediction: @vercel to acquire @codesandbox       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 43] 1470791843222753280 33521530 swyx       0 0 149 1 0   en  
1471004012971323392 swyx 33521530 2021-12-15T06:27:41+00:00 jQuery won the battle but Mootools won the war       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 46] 1470795050225307655 33521530 swyx       0 6 61 1 0   en  
1473889021718073347 swyx 33521530 2021-12-23T05:31:40+00:00 The best minds of my generation are throwing themselves into virtual currencies, virtual realities, and virtual machines. Are future historians going to look back on this time and wonder who was left building for the real world?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 229]             0 35 451 1 0   en  
1474271524110491649 swyx 33521530 2021-12-24T06:51:36+00:00 Strong Opinions on heading tags in HTML (h1, h2, h3, etc): - should all have id’s set - should all have discoverable anchor links (see: github markdown, or my blogposts) - (when appropriate) highlight link target, eg when one item in a multiple column layout (using :target)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 275] 1474267015334752257 33521530 swyx       0 2 25 1 0   en  
1474697989713059841 swyx 33521530 2021-12-25T11:06:13+00:00 Sometimes wonder what would’ve happened to software if GitHub didn’t exist: - Pull requests would not exist - Most code would not be open source by default - Harder to learn ~everything without search - No ⭐️ system to skew tech choices - Git may not have won version control       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 276]             0 49 701 1 0   en  
1475105975518765063 swyx 33521530 2021-12-26T14:07:25+00:00 Imagine if those "Career Days" they do for kids came with honest guidance on probability of success: Actor - 90% luck, 5% talent, 5% hard work Doctor - 10% luck, 10% talent, 80% hard work Fireman - 5% luck, 10% talent, 85% hard work Founder - 30% luck, 20% talent, 50% hard work       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 6 98 1 0   en  

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]);