tweets

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

23 rows where is_quote_status = 1 and retweet_count = 2 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, favorite_count, favorited, retweeted

user 2 ✖

retweet_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
1420456538553024516 swyx 33521530 2021-07-28T18:50:04+00:00 💯 I've been putting out my mixtape (http://swyx.transistor.fm/) for 145 days now and its been a great way to take audio notes + add personal commentary. So much of podcasting is either "Shallow Interview of Famous Person" or "Two guys and a mic". Make mixtapes cool again! https://twitter.com/BrittneyPostma/status/1420442392637939712   1420442392637939712 1420442392637939712   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 270]             1 2 20 0 0 0 en  
1421190477571710978 swyx 33521530 2021-07-30T19:26:28+00:00 this is incredible to watch. I thought that Flippa/Empire Flippers had cornered this sleepy market, but Andrew is shaking it up with his infectious energy and focus. Building a credible “Zestimate for SaaS” is going to set this thing on 🔥 https://twitter.com/agazdecki/status/1421069160973434880   1421069160973434880 1421069160973434880   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 239]             1 2 31 0 0 0 en  
1425512518437330944 swyx 33521530 2021-08-11T17:40:43+00:00 Proud to be joining a conference that is taking measured Covid precautions. If you're in the East Coast, come see my first ever talk on @temporalio and the *amazing* list of other speakers at @renderATL! https://www.renderatl.com/speakers https://twitter.com/ThugDebugger/status/1425477419524308994   1425477419524308994 1425477419524308994   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 228]             1 2 15 0 0 0 en  
1428246127464259585 swyx 33521530 2021-08-19T06:43:06+00:00 Speaking tip - it's not about quantity! Don't rush! Two helpful techniques: - Pause. In a world of nonstop noise... Silence stands out. - Repeat. Repetition consciously underlines the important. Recap your points every 5-7 minutes. You'll naturally calm down. https://twitter.com/KajetanSw/status/1428242133710934018   1428242133710934018 1428242133710934018   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 261]             1 2 26 0 0 0 en  
1431046098223779844 swyx 33521530 2021-08-27T00:09:12+00:00 What amazes me about Streamyard is that it wasn’t… *great*. The onscreen graphics were limited and the streaming wasn’t high quality. But it was easier to use than OBS, and scaled fine thru the pandemic. I hope both founders made $100m, and I hope someone makes a competitor! https://twitter.com/nathanbarry/status/1430995711575793667   1430995711575793667 1430995711575793667   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 277]             1 2 22 0 0 0 en  
1433218630745948160 swyx 33521530 2021-09-02T00:02:04+00:00 @TkDodo yes! illustrated: https://twitter.com/swyx/status/1010922550912802816?s=20   1010922550912802816 1010922550912802816   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 49] 1433096271443775494 44217212 TkDodo       1 2 19 0 0 0 en  
1433718525420470279 swyx 33521530 2021-09-03T09:08:28+00:00 If you work in Silicon Valley, or in the technology world, and you can explain complex topics / terms in an easy to understand* way, that’s an INSANELY valuable skill. *But don’t gloss over the details! All the good stuff is in the details - develop a keen eye for those! https://twitter.com/BullandBaird/status/1433424538025349120   1433424538025349120 1433424538025349120   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 272]             1 2 30 0 0 0 en  
1436423696592297987 swyx 33521530 2021-09-10T20:17:51+00:00 I had the pleasure of joining @Zephraph and @HipsterSmoothie on @DevtoolsFM to talk Temporal! https://www.youtube.com/watch?v=yNOkWFGejUs They edited me to sound smarter than I look! We covered what Temporal is, and how we are thinking about Developer Experience 👀 https://twitter.com/DevtoolsFM/status/1436362948956639237?s=20   1436362948956639237 1436362948956639237   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 271] 1428431255196995586 33521530 swyx       1 2 8 0 0 0 en  
1441863319317516290 swyx 33521530 2021-09-25T20:32:58+00:00 Specific things you can do that turn experts into mentors and friends: - Explain X in your own words - “Yes, and” their demos - Summarize their talks - Help repro issues - Answer FAQs Pick Up What They Put Down and you’ll be expert soon enough. How do you think they started?! https://twitter.com/techgirl1908/status/1441794957543608324   1441794957543608324 1441794957543608324   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 279]             1 2 35 0 0 0 en  
1443093060473090051 swyx 33521530 2021-09-29T05:59:31+00:00 It’s been incredible to watch @nutlope’s career grow ever since he joined webdev twitter in college! He’s been a daily positive presence in the @Coding_Career discord and I feel lucky to have met him before he was “famous” Great hire by @leeerob and @rauchg — only the beginning! https://twitter.com/Nutlope/status/1442926717635477504   1442926717635477504 1442926717635477504   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             1 2 30 0 0 0 en  
1444372437722824713 swyx 33521530 2021-10-02T18:43:18+00:00 Seeing two extremes: 1. “Our blog is for top of funnel” - @logrocket, @digitalocean 2. “Our blog is for hiring” - @cloudflare, @figma, @airbnb, @NetflixEng, @RazorpayEngg, @GitHubEng, @WixEng, @ShopifyEng, @ArtsyOpenSource “bit of both”: @flydotio, @thoughbot, @testdouble https://twitter.com/eastdakota/status/1444337534759149574   1444337534759149574 1444337534759149574   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 276] 1444098448874086400 33521530 swyx       1 2 38 0 0 0 en  
1446671799131934720 swyx 33521530 2021-10-09T03:00:09+00:00 Gifted program saved my life. I was a weirdo that struggled to fit in and would absolutely have blamed or harmed myself if they had not put me in with other weirdos and made it ok to be weird together. It didn’t privilege us so much as put us on a gentler path to socialization. https://twitter.com/primalpoly/status/1446485504468398085   1446485504468398085 1446485504468398085   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 278]             1 2 77 0 0 0 en  
1448024107618947072 swyx 33521530 2021-10-12T20:33:44+00:00 Probably my biggest test of confidence was in March when @martin_casado and @davidu pushed back on the open source religion - if your monetization is SaaS, then open source is just marketing (there's nuance here, pls read his replies before reacting) https://twitter.com/swyx/status/1373425786351284228   1373425786351284228 1373425786351284228   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 275] 1448024106633363456 33521530 swyx       1 2 12 0 0 0 en  
1452046180683161609 swyx 33521530 2021-10-23T22:56:01+00:00 it worries me that there’s an uncritical acceptance of @Reactjs conclusions without examining if those assumptions apply to you. React is verbose React is successful Must be verbose to be successful Here’s my attempt to articulate more timeless lessons than “2 way binding bad”: https://twitter.com/swyx/status/1383516418205835264   1383516418205835264 1383516418205835264   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             1 2 49 0 0 0 en  
1454251874849202185 swyx 33521530 2021-10-30T01:00:40+00:00 Cloudflare rounding up the Jobs to Be Done of Cloud (i have a separate post on that) https://twitter.com/cloudflaredev/status/1454092772177235972   1454092772177235972 1454092772177235972   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 109] 1450539279973699586 33521530 swyx       1 2 19 0 0 0 en  
1458693704764383241 swyx 33521530 2021-11-11T07:10:55+00:00 somehow missed that @Netilfy hired an official Technical Community Builder! 🚀 https://twitter.com/domitriusclark/status/1447988170293923841?s=20   1447988170293923841 1447988170293923841   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 102] 1397912340893294598 33521530 swyx       1 2 11 0 0 0 en  
1459327954794647556 swyx 33521530 2021-11-13T01:11:12+00:00 Huge shout out @BrittneyPostma for #FollowFriday! On top of running a podcast, blog, merch, and her own freelance dev/design business, she's led the creation of @SvelteSirens and galvanized the @SvelteSociety in a whole new way with her talents. Follow @BrittneyPostma!! https://twitter.com/BrittneyPostma/status/1412032180465831939 https://twitter.com/swyx/status/1459327954794647556/photo/1   1412032180465831939 1412032180465831939   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 296]             1 2 19 0 0 0 en  
1462975159548088332 swyx 33521530 2021-11-23T02:43:53+00:00 P.S. if you want to see the latest in JS reinvention come join the @temporalio meetup tomorrow where we are launching our new TypeScript SDK in beta! https://twitter.com/temporalio/status/1462970544379162627   1462970544379162627 1462970544379162627   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 149] 1462923803189645315 33521530 swyx       1 2 15 0 0 0 en  
1463691217078607875 swyx 33521530 2021-11-25T02:09:14+00:00 @johnlindquist @typescript this also works in javascript! https://twitter.com/swyx/status/1172604337366941697   1172604337366941697 1172604337366941697   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [27, 57] 1463576962891276298 15430177 johnlindquist       1 2 32 0 0 0 en  
1471580713946214402 swyx 33521530 2021-12-16T20:39:17+00:00 an unqualified, low effort “it depends” isn’t wisdom. it’s lazy and nihilistic. here’s how to give a great “it depends”: https://twitter.com/swyx/status/1100275989622505472   1100275989622505472 1100275989622505472   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 121] 1202207460292988929 33521530 swyx       1 2 10 0 0 0 en  
1473192929414070273 Nina 1354787371494084612 2021-12-21T07:25:39+00:00 Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "what we're really talking about here is turning fixed costs to variable costs which makes sense for a startup getting off the ground." https://twitter.com/briansowards/status/1472731566732414979   1472731566732414979 1472731566732414979   Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 255]             1 2 12 1 1 0 en  
1473206717403959297 swyx 33521530 2021-12-21T08:20:26+00:00 RT @Nina_Ledid: Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "wh… 1473192929414070273 1473192929414070273     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 2 0 1 1   en  
1473991924285538304 swyx 33521530 2021-12-23T12:20:34+00:00 I wrote down my personal “rules of Twitter” in my @Coding_Career book and love it when newcomers find it useful! Twitter can be so confusing with the firehose of hot takes, petty squabbles, and serious announcements, but it’s a career hack for dev networking when done right. https://twitter.com/th_clarence/status/1473962147965112320   1473962147965112320 1473962147965112320   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 277]             1 2 33 0 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]);