tweets

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

35 rows where favorite_count = 17 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, is_quote_status, retweet_count, favorited, lang

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
1245551305881317378 Aella 795885295 2020-04-02T03:19:07+00:00 Here's all of my twitter polls, in a google spreadsheet: https://docs.google.com/spreadsheets/d/1q2plaBw2UEYelx8bFP1dEi9zAcH5se_ZJvxLZISdN8o/edit?usp=sharing It's not fully updated, missing a few months. I'm getting tired of manually inputting polls; is anybody bored and/or skilled and feels like updating the sheet?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 242]             0 0 17 0 0 0 en  
1288231120295714816 swyx 33521530 2020-07-28T21:53:27+00:00 My Notes on "Growing a Language", by Guy Steele https://dev.to/swyx/notes-on-growing-a-language-by-guy-steele-5501       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 72]             0 3 17 0 0 0 en  
1426638568714227712 swyx 33521530 2021-08-14T20:15:15+00:00 i was wondering how long until i saw my meme in the wild. https://twitter.com/sparkleops/status/1426401808814018563?s=21 10 days. it took 10 days       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 108] 1423025792783568899 33521530 swyx       1 0 17 0 0 0 en  
1427351643985629212 swyx 33521530 2021-08-16T19:28:45+00:00 💡 Product focused DevRel is the most ill-defined path. Most devrels spend most of their time advocating TO developers than FOR them. But DevRel can provide tremendous value for product launches and building integrations, tooling, and MVPs. https://twitter.com/swyx/status/1427351643985629212/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 240] 1427351641095753755 33521530 swyx       0 3 17 0 0 0 en  
1432864032235540480 swyx 33521530 2021-09-01T00:33:01+00:00 One of Java's advantages over C++ is automatic garbage collection, whereas one of Go's advantages over Java is its native CSP model. At a 50,000 ft view you can see languages as advancing by the number of hard problems that are elegantly solved by convention or language feature. https://twitter.com/swyx/status/1432864032235540480/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279] 1432864028842356736 33521530 swyx       0 4 17 0 0 0 en  
1434388834087800832 swyx 33521530 2021-09-05T05:32:02+00:00 Always bet on text: “The breadth, scale and depth of ways people use text is unmatched by anything. There is no equivalent in any other technology… Nothing else comes close.” https://graydon2.dreamwidth.org/193447.html       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 200]             0 1 17 0 0 0 en  
1436002996660363267 devtools.fm 1389094644328271872 2021-09-09T16:26:08+00:00 How do you view software? @swyx approaches tools with a "Would I Invest in this thing" mindset! https://twitter.com/DevtoolsFM/status/1436002996660363267/video/1       LaterMedia e5057be9f0fb05c9d0d7206d7e0b388a4067eb68 0 [0, 95]             0 2 17 0 1 0 en  
1437994181226602496 swyx 33521530 2021-09-15T04:18:24+00:00 @mjackson @dan esp notable that the current M1s dont support 2 external displays, just 1… so may be worth waiting for the future MBP for that       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 141] 1437956847235784707 734903 mjackson       0 0 17 0 0   en  
1438218996088590336 swyx 33521530 2021-09-15T19:11:44+00:00 @stolinski @Gifted_Geek my mind was blown when i first saw that the entirety of the Svelte stores implementation (writeable, readable, derived + full typing + comments ) is just 200 lines of code https://github.com/sveltejs/svelte/blob/master/src/runtime/store/index.ts       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 219] 1438208450215952388 18727585 stolinski       0 1 17 0 0 0 en  
1438219076858310659 swyx 33521530 2021-09-15T19:12:03+00:00 @stolinski @the_aceix scott woke up on the spicy side of bed today       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [22, 66] 1438193202528411653 18727585 stolinski       0 0 17 0 0   en  
1439031496648527872 swyx 33521530 2021-09-18T01:00:19+00:00 @stolinski @sveltejs turns out the single file format is a really good fit for markdown extensions, right down to inline styles :) @evilpingwin is a mad genius. He did this talk for last year's Svelte Summit: https://www.youtube.com/watch?v=S3j1fLzC8_E       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [21, 233] 1438991516647706627 18727585 stolinski       0 1 17 0 0 0 en  
1439702640217124867 swyx 33521530 2021-09-19T21:27:12+00:00 For those who prefer audio, there's a full transcript here as well, thanks to @DescriptApp and @TransistorFM https://swyx.transistor.fm/episodes/weekend-drop-sunil-pai-react-and-the-meta-of-the-web       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 134] 1439702355553886211 33521530 swyx       0 2 17 0 0 0 en  
1440052933555417092 Arnold Ho 1347260005460934657 2021-09-20T20:39:08+00:00 Just finished 'the coding career handbook' written by @swyx cover to cover, it has some really solid advices in there and I really recommend anyone at any stage of their career to read it! I already know I'll be referring to it again and again in the future! #CodeNewbie       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 270]             0 4 17 0 1   en  
1440801054967287812 swyx 33521530 2021-09-22T22:11:54+00:00 @geddski join @SvelteSociety you know you want to       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 51] 1440762195223089164 39607761 geddski       0 0 17 0 0   en  
1441533645223694339 swyx 33521530 2021-09-24T22:42:58+00:00 @flybayer damn you taking @Flightcontrolhq literally huh       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 56] 1441531298032541698 2826554209 flybayer       0 0 17 0 0   en  
1445840729817825280 swyx 33521530 2021-10-06T19:57:47+00:00 @EmmaBostian non citizen, visited Croatia to speak at @InfobipShift, came back to Seattle and was denied entry despite having 2 doses of American vaccine in me and a negative Covid test. Detained for 8 hours and shipped out to Mexico to quarantine for 14 days causing me to miss @renderATL.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 290] 1445840226274926599 491821358 EmmaBostian       0 0 17 0 0   en  
1448894109716922373 swyx 33521530 2021-10-15T06:10:49+00:00 @ASpittel ALI HAVE YOU TRIED `GH PR CHECKOUT` IT IS AMAZING       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 59] 1448752696371015681 3092104835 ASpittel       0 0 17 0 0   en  
1450174336959062017 swyx 33521530 2021-10-18T18:57:59+00:00 @ryanchenkie been solely on it for a year doing full stack work where you been bruh       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 83] 1450171128668905473 30654945 ryanchenkie       0 0 17 0 0   en  
1452856161246461952 swyx 33521530 2021-10-26T04:34:36+00:00 @dimaip @fulligin @freeCodeCamp me. and it was worth it https://medium.com/hackernoon/no-zero-days-my-path-from-code-newbie-to-full-stack-developer-in-12-months-214122a8948f       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [32, 79] 1452855244065583108 240638492 dimaip       0 2 17 0 0 0 en  
1453404264416485379 swyx 33521530 2021-10-27T16:52:34+00:00 @github Windows: Ctrl+K or Ctrl+Opt+K Mac: Cmd+K or Cmd+Opt+K There's secret shortcuts as well for user/org/repo search, open in http://github.dev, create new issue, edit/subscribe/lock/transfer issue, and copy permalink! docs here: https://docs.github.com/en/get-started/using-github/github-command-palette       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 264] 1453401130994520068 33521530 swyx       0 1 17 0 0 0 en  
1453432595186810886 swyx 33521530 2021-10-27T18:45:08+00:00 Amazing game to pick your favorite coding font by heads up battle: https://codingfont.com/ I just discovered my favorite coding font is Azeret Mono! Thanks @typogramco!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 170]             0 2 17 0 0 0 en  
1453522590941597697 swyx 33521530 2021-10-28T00:42:45+00:00 It's only been ~1.5 years since I wrote the @coding_career book. When I first put up the http://learninpublic.org page, "From Junior to Senior" was just a tagline. Now it's a reality!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 185] 1453522590094413825 33521530 swyx       0 4 17 0 0 0 en  
1453585223594041351 swyx 33521530 2021-10-28T04:51:38+00:00 just found out Garry blocked me :( this was our last interaction…which he retweeted so i think he was ok with it? people can block or mute however they want, and i try not to care. but it hurts a little when its someone i look up to and i dont know what i did :(       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 264] 1394440978199506947 33521530 swyx       0 1 17 0 0   en  
1454258290959945731 swyx 33521530 2021-10-30T01:26:10+00:00 Everyone in the UI devtools/low code space has nostalgia goggles for VB6. I certainly remember the joy of plopping a button on that breadboard for the first time and then hooking up the handler. Utopia has the opportunity to put the "I" back into "IDE". Just add design system. https://twitter.com/swyx/status/1454258290959945731/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279] 1454258287868723204 33521530 swyx       0 0 17 0 0 0 en  
1455625614711353345 swyx 33521530 2021-11-02T19:59:25+00:00 @AdamTuttle @sveltejs @SvelteSociety @Rich_Harris @stolinski, @BrittneyPostma, @Wattenberger, @askRodney, @onlyspaceghost, @h_i_g_s_c_h and many more! we keep an informal list of "Svelte Teachers" here https://twitter.com/i/lists/1449103461321035778?s=20       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [50, 226] 1455614810922553350 9686352 AdamTuttle       0 3 17 0 0 0 en  
1458241442883653641 swyx 33521530 2021-11-10T01:13:47+00:00 Excellent read as usual by @Eugenewei: https://www.eugenewei.com/blog/2021/9/29/and-you-will-know-us-by-the-company-we-keep Elements of Offensive Graph Design - Social capital vs Entertainment vs Utility: Pick 2 - Social network to solve cold start - Interest network to solve churn - To build: pruners, filters, recommenders, collaboration https://twitter.com/swyx/status/1458241442883653641/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 0 17 0 0 0 en  
1460548511917764611 swyx 33521530 2021-11-16T10:01:15+00:00 @preetster @TwitterBlue twitter eng interview: design distributed system in 30 minutes twitter eng job: take 3 years to add folders to bookmarks, another 3 years for search       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [24, 173] 1460477334079737858 16343912 preetster       0 0 17 0 0   en  
1463612122026450946 Altalogy 1055044667320995843 2021-11-24T20:54:57+00:00 Black Friday deals? We prefer giveaways🥰 How about a $5,000 worth design sprint to tweak your landing page or product? To enter, quote tweet this with a short company desc. We'll announce the lucky winner on Mon, 29th. You have to be following us so we can DM you if you win!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 6 17 1 1   en  
1463764094788378626 swyx 33521530 2021-11-25T06:58:50+00:00 @brianleroux senator i cant define it but i know it when i see it       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 65] 1463575554674741251 676363 brianleroux       0 0 17 0 0   en  
1463966459244146696 swyx 33521530 2021-11-25T20:22:57+00:00 TIL I couldve used `git grep` instead and it would have probably worked 🤦‍♂️ https://will-keleher.com/posts/5-Useful-Bash-Patterns.html https://twitter.com/swyx/status/1463966459244146696/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 100] 1455012914620813321 33521530 swyx       0 0 17 0 0 0 en  
1467978846150430724 swyx 33521530 2021-12-06T22:06:45+00:00 My @MongoDB podcast episode is live! https://mongodb.libsyn.com/ep-93-swyx-learn-in-public-and-temporal Ever since I heard the epic @mlynn and @marklovestech episode I've been really enjoying the podcast so it was an honor to join and talk about #LearnInPublic, @Coding_Career, and @temporalio!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 254]             0 7 17 0 0 0 en  
1468703734062624773 Rick Blalock 9083902 2021-12-08T22:07:12+00:00 Quote of the day goes to @swyx : "You can learn a lot on the internet for the low low price of your ego" 🔥 https://mongodb.libsyn.com/ep-93-swyx-learn-in-public-and-temporal       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 130]             0 1 17 1 1 0 en  
1469469209864269825 swyx 33521530 2021-12-11T00:48:55+00:00 also if your build tool has >4 letters or >1 syllable you are clearly NGMI       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 80] 1469466996848824322 33521530 swyx       0 1 17 0 0   en  
1473316076893081602 Coding Career Community 1249002899897647105 2021-12-21T15:35:00+00:00 "The best places to grow are not the places where everything is peachy. It's the places where there's pressure on you to perform, and there is space for your performance to really make an impact." @li_haoyi with some gold career advice on where to work: https://www.lihaoyi.com/post/ReflectingonFourYearsatDatabricks.html https://twitter.com/Coding_Career/status/1473316076893081602/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278]             0 4 17 1 1 0 en  
1445112871424339974 Osman Cea 120550262 2021-10-04T19:45:32+00:00 Dudes, esta conversación entre @swyx y @threepointone es puro oro. https://www.youtube.com/watch?v=H3h1WICelqs       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 91]             0 3 17 0 1 0 es  

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