tweets

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

28 rows where "created_at" is on date 2021-08-19 and is_quote_status = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, in_reply_to_user_id, retweet_count, favorite_count, lang

is_quote_status 1 ✖

created_at (date) 1 ✖

  • 2021-08-19 · 28 ✖
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
1428149223850012673 swyx 33521530 2021-08-19T00:18:03+00:00 ⚛️ Using MDX to progressively upgrade Docs Links with @reactjs https://youtu.be/LbC4WZoyinI Perhaps a fun @docusaurus hack - you can swizzle MDX components and write your own custom HTML elements that enhance user experience. #extendThePlatform?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 242]             0 2 24 0 0 0 en  
1428210178424406019 swyx 33521530 2021-08-19T04:20:16+00:00 @AyushCodes @ReactRally @Rich_Harris that is some lofty comparison! thanks for watching and glad you liked it 🤗       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [37, 111] 1428206538708033541 1261649364184956929 AyushCodes       0 0 0 0 0   en  
1428222649721712646 swyx 33521530 2021-08-19T05:09:49+00:00 @farzad_yz @ReactRally haha on the livestream? amazing. thank you 🙏🏽       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 68] 1428216444450390022 304289713 farzad_yz       0 0 1 0 0   en  
1428241684798664706 swyx 33521530 2021-08-19T06:25:27+00:00 RT @jakub_smetanka: What was the last book you have read, or you are reading ? I have already finnished The @Coding_Career Handbook by Shaw… 1428025214588366848 1428025214588366848     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 3 0 0 1   en  
1428241827862257664 swyx 33521530 2021-08-19T06:26:01+00:00 @jakub_smetanka @Coding_Career oh awesome news!! I'd love to read more about what really resonated with you!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [31, 108] 1428025214588366848 757480803307753472 smetankajakub_       0 0 2 0 0   en  
1428242133710934018 Kajetan Świątek 1069315566375264261 2021-08-19T06:27:14+00:00 @swyx @ReactRally Thanks! Those are perfect tips. Rushing is definitely something I do when I'm nervous. I'll try to mitigate that when rehearsing.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [18, 148] 1428236014082924548 33521530 swyx       0 0 1 0 0   en  
1428254686138621953 swyx 33521530 2021-08-19T07:17:07+00:00 @stephsmithio @RobertCialdini Today's clip follows up to this with a much more underappreciated principle: Consistency and Commitment! https://share.transistor.fm/s/434ac6e2       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 159] 1427862892976611333 33521530 swyx       0 0 0 0 0 0 en  
1428263984755396624 swyx 33521530 2021-08-19T07:54:04+00:00 @petersuhm @savvycal_ yknow i may be weird but i never use the personalize feature. people im friends with dont need it, and people who are distant i do the “ask for their link and heres mine” trick anyway. i wonder if @derrickreimer has stats on how much it’s ACTUALLY used in practice.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 287] 1428260724942549001 21908850 petersuhm       0 0 2 0 0   en  
1428264197998092293 swyx 33521530 2021-08-19T07:54:55+00:00 @mxstbr @sjwhitworth may also want to check out @louisnicholls_ sales for founders course       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 89] 1428259621257494532 2451223458 mxstbr       0 0 3 0 0   en  
1428264391317721093 swyx 33521530 2021-08-19T07:55:41+00:00 @NadavKeyson amazing. @kevmodrome worth checking out?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 53] 1428254746704551936 146781335 NadavKeyson       0 0 2 0 0   en  
1428266802174332930 swyx 33521530 2021-08-19T08:05:16+00:00 @sebastienlorber @docusaurus thank you!! yeah the real challenge is TWO WAY linking… (aka destination page also gets a list of pages that link to it) i think it is possible but need to hack into the classic theme even further. in gatsby this is easy bc of the data pipeline but here im less familiar       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [29, 299] 1428265486274514947 40663578 sebastienlorber       0 0 1 0 0   en  
1428267482867933191 swyx 33521530 2021-08-19T08:07:58+00:00 @sebastienlorber @reactjs @docusaurus code is here! https://github.com/sw-yx/demo-docusaurus-mdx-preview-poc/blob/ec326366710577162500b78ced31a4734b47b101/src/theme/MDXComponents/index.js#L63 idk if its possible to enable by default, it requires the weird importing and extra metadata for rendering the short description. but i’d love to see if u have ideas.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 243] 1428266511580508164 40663578 sebastienlorber       0 0 2 0 0 0 en  
1428267871528919042 swyx 33521530 2021-08-19T08:09:31+00:00 @sebastienlorber @reactjs @docusaurus ah makes sense. perhaps worth inserting a “you may not need to swizzle! try wrapping instead!” when someone uses the swizzle —danger flag       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 175] 1428267010291601408 40663578 sebastienlorber       0 0 1 0 0   en  
1428268334257037313 swyx 33521530 2021-08-19T08:11:21+00:00 @sebastienlorber @reactjs @docusaurus got u. my thinking on this one is someday i might want to display an excerpt derived from the markdown itself so i can offer rich text in the preview. but no idea how to cut it off automatically/manually.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 243] 1428267246477090820 40663578 sebastienlorber       0 0 1 0 0   en  
1428269886883581952 swyx 33521530 2021-08-19T08:17:31+00:00 @sebastienlorber @docusaurus 🔥 one nuance to handle here is you may also want to track which section links to the page, so in the backlink you can use the #anchor tag to send readers directly to the linked text. mad science bonus goal: include surrounding text       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [29, 264] 1428268180972216323 40663578 sebastienlorber       0 0 1 0 0   en  
1428270277956231169 swyx 33521530 2021-08-19T08:19:04+00:00 @andrewingram @docusaurus yes that was my plan originally. but i think i will want to add options in future. much cleaner to just use a special tag throughout so i can clearly search n replace in future if need be       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 213] 1428268895006298112 9164512 andrewingram       0 0 0 0 0   en  
1428270697105612802 swyx 33521530 2021-08-19T08:20:44+00:00 @sebastienlorber @reactjs @docusaurus i think also would be no problem rendering iframe since same origin, no screenshot needed. yeah ok so we’ll just go with simple metadata for now ♥️       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 187] 1428269843199971332 40663578 sebastienlorber       0 0 1 0 0   en  
1428397753827172353 swyx 33521530 2021-08-19T16:45:37+00:00 @samseely @knocklabs @WorkOS nice!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [29, 35] 1428396736259702798 29101388 samseely       0 0 2 0 0   en  
1428398804932259852 swyx 33521530 2021-08-19T16:49:48+00:00 @fortelabs checks out (chinese names often work best in groups of 4, i might market test 打造二脑 to see how people react. 打造外脑 might be more self evident at the cost of compromising "Second" for "External") https://twitter.com/swyx/status/1428398804932259852/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 204] 1428397878154698752 1909232666 fortelabs       0 0 2 0 0 0 en  
1428403597717368833 swyx 33521530 2021-08-19T17:08:50+00:00 @slightlylate I genuinely struggle with how much to care about standards. Standards are obviously extremely important. but 99.999% of us will never even be involved, much less have meta opinions on the process of rulemaking. yet we (and eventually our users) are all impacted eventually.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 287] 1428401349574623235 229237555 slightlylate       0 0 10 0 0   en  
1428412406909136897 swyx 33521530 2021-08-19T17:43:51+00:00 @acemarke @beyang @github i do wonder at the logistics of essentially scraping github/gitlab.. seems inefficient, I hope you can do a deal with them to get all this data directly @beyang       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 186] 1428403711936798723 727704217012604928 acemarke       0 0 1 0 0   en  
1428431255196995586 swyx 33521530 2021-08-19T18:58:44+00:00 For those who missed my Twitter Spaces chat on @temporalio with @jadenguitarman, here's a recording for posterity! (audio only) Temporal: Not So Temporary https://youtu.be/ErO9Ujccwds       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 179] 1417227355165102081 33521530 swyx       0 0 7 0 0 0 en  
1428450239392804868 swyx 33521530 2021-08-19T20:14:11+00:00 @nbashaw i was quite disappointed to hear about their plans post their new fundraising round from @brianmcc’s pod. they are trying so hard to “go straight” to justify their growth projections but i think they will just end up killing their golden goose.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 255] 1428444015465308166 17424947 nbashaw       0 0 7 0 0   en  
1428452075231342592 swyx 33521530 2021-08-19T20:21:28+00:00 @brianmcc @nbashaw the fun of being a daily tech journalist on east coast time :)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [19, 81] 1428451737313099777 1502 brianmcc       0 0 1 0 0   en  
1428470214522408962 swyx 33521530 2021-08-19T21:33:33+00:00 @brianleroux @DasSurma @jaffathecake not me getting distracted by Surma's calves hot damn he does not skip leg day https://twitter.com/swyx/status/1428470214522408962/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [37, 114] 1428461614827720705 676363 brianleroux       0 0 4 0 0 0 en  
1428470276426289161 Shit User Story 1351114532408668163 2021-08-19T21:33:48+00:00 As a… – remote worker I want to… – give facebook access to four cameras strapped to my head so that… – I can simulate an in-person meeting that could have been an email https://twitter.com/ShitUserStory/status/1428470276426289161/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 168]             0 1136 5795 0 1 0 en  
1428472408139132961 swyx 33521530 2021-08-19T21:42:16+00:00 It pisses me off how poorly developers are taught to validate/parse inputs. Bad assumptions -> bad errors -> bad UX. That simple. If every dev spent 1 hour learning how to validate/parse their inputs properly we'd have dramatically more usable software for the rest of our lives       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 286]             0 22 292 0 0   en  
1428409475229118468 swyx 33521530 2021-08-19T17:32:12+00:00 @JustGage @sotak 🙏       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [17, 18] 1428409299953274882 17006530 JustGage       0 0 1 0 0   und  

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