tweets

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

12 rows where "created_at" is on date 2021-09-11 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorite_count

is_quote_status 2 ✖

  • 0 10
  • 1 2

source 1 ✖

  • Twitter Web App · 12 ✖

created_at (date) 1 ✖

  • 2021-09-11 · 12 ✖
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
1436628297039982592 swyx 33521530 2021-09-11T09:50:51+00:00 Incredible discussion of platform economics and YouTube optimization by @veritasium: https://www.youtube.com/watch?v=S2xHZPH5Sng Non-obvious conflict: subscriptions (follows) vs recommendations (feed). Every ad supported platform wants to maximize time on site, which means the feed eventually wins.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 3 29 0 0 0 en  
1436628890978500609 swyx 33521530 2021-09-11T09:53:13+00:00 @AgentConf @nikgraf 😍 one of my bucket list conferences!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [20, 56] 1436616592612380676 765634822857453568 AgentConf       0 2 7 0 0   en  
1436643604085235714 swyx 33521530 2021-09-11T10:51:41+00:00 @smc90 tries to get @BillCarr89 to defend "Are Right A Lot" in this podcast/blogpost on Future dot com and i'm sorry but blaming your direct reports for letting you ignore them is pretty damn toxic wtf https://future.a16z.com/podcasts/working-backwards-amazon-bezos-memos-releases-narratives/ https://twitter.com/swyx/status/1436643604085235714/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 226] 1390439828571922432 33521530 swyx       0 0 11 0 0 0 en  
1436704692868993034 swyx 33521530 2021-09-11T14:54:26+00:00 @therealboone progress is progress! what were the remaining things you couldn't take out?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 89] 1436703800442634244 35840006 therealboone       0 0 3 0 0   en  
1436708762115473411 Alex Russell 229237555 2021-09-11T15:10:36+00:00 @swyx <but_why.gif> https://twitter.com/slightlylate/status/1436708762115473411/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 25] 1436707990933958657 229237555 slightlylate       0 3 38 0 0 0 en  
1436716037202980868 swyx 33521530 2021-09-11T15:39:30+00:00 @simonw i genuinely think this one assumption made many remaining decisions for them: https://twitter.com/slightlylate/status/1436708762115473411?s=20 I hear unexamined assumptions like these a lot and people don't realize these are far weightier decisions than they seem at first glance. Rhyme shortcircuits reason.   1436708762115473411 1436708762115473411   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 276] 1436710644045152262 12497 simonw       1 0 4 0 0 0 en  
1436716757436321799 swyx 33521530 2021-09-11T15:42:22+00:00 @rauchg @leeerob yeah i don't doubt that switching from CSR to SSR was the unmitigated win here. Still they have characterized it as "initial required JS", sounds like you would have phrased it differently. also no way Nextjs takes up 800kb, something else is going on that they couldnt rip out       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [17, 294] 1436710278494707719 15540222 rauchg       0 0 8 0 0   en  
1436718275585523730 swyx 33521530 2021-09-11T15:48:24+00:00 @slightlylate the reason i suggested templatizing, is your longform commentary on why X is bad and what could be done better is very valuable. webpagetest speaks to perf experts, but the rest of us have no idea what to do with all the info. maybe inject some humor to make it more appealing.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 291] 1436716663013928961 229237555 slightlylate       0 0 3 0 0   en  
1436720513049669632 swyx 33521530 2021-09-11T15:57:17+00:00 I'm no perf expert or perf shamer (let he who is without sin...) But here's what I do believe: 1. local Lighthouse runs are not credible. Use webpagetest or http://web.dev/measure. 2. you do NOT have to use the same tech for app and site! :) https://twitter.com/swyx/status/1317635707838496768?lang=en   1317635707838496768 1317635707838496768   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 269] 1436689311315890177 33521530 swyx       1 10 159 0 0 0 en  
1436721365495783425 swyx 33521530 2021-09-11T16:00:41+00:00 @jbeeko @k_cieslak oh! thats a great shoutout, thank you! 1:5 is aggressive; did he base it on any data or just vague intuition?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 128] 1436721086075310084 551307316 jbeeko       0 0 0 0 0   en  
1436723434659237894 swyx 33521530 2021-09-11T16:08:54+00:00 @NHeinDev twitter search :) https://twitter.com/search?q=from%3Aswyx%20narrow%20interests&src=typed_query       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 51] 1436721662704107522 1333059155154907138 NHeinDev       0 0 1 0 0 0 en  
1436724263919263747 swyx 33521530 2021-09-11T16:12:12+00:00 @slightlylate when i find an example from another field i'll double back and try to show instead of tell. i see these sorts of things in SEO assessment tools every now and then. but the gentle nudging humor is rare.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 215] 1436722125025411078 229237555 slightlylate       0 0 1 0 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]);