tweets

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

30 rows where favorite_count = 14 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, in_reply_to_screen_name, is_quote_status, retweet_count, favorited, retweeted, lang

favorite_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
1420635902032846852 swyx 33521530 2021-07-29T06:42:47+00:00 Today's mixtape: A clip from 1984, inspired by the Loki TV Series https://swyx.transistor.fm/episodes/1984-vs-brave-new-world-pt-1-intelligence-squared https://twitter.com/swyx/status/1419128271799656449 https://twitter.com/swyx/status/1420635902032846852/photo/1   1419128271799656449 1419128271799656449   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 114]             1 0 14 0 0 0 en  
1427988073292476418 Emelia 👸🏻 14063149 2021-08-18T13:37:42+00:00 @JessTelford JWTs for external use tend not to solve the problems people think they do; for internal use, or cross authorisation boundaries, they can be good because then you can assert using public/private key cryptography that the token your presented really came from the authorising server       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 293] 1427986367905161221 14063149 ThisIsMissEm       0 1 14 0 0   en  
1428518661338263567 swyx 33521530 2021-08-20T00:46:04+00:00 @ericnakagawa $4m, seattle       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 26] 1428441265922740225 2349251 ericnakagawa       0 0 14 0 0   en  
1430949616371961862 swyx 33521530 2021-08-26T17:45:48+00:00 i often hear that indie hackers have little to learn from working at bigco or venture track startups. The resource limitations, interpersonal management, product timeline, and transparency lessons are at minimum irrelevant, at worst totally inverse! this is the norm, but       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 274]             0 0 14 0 0   en  
1433123612899229698 swyx 33521530 2021-09-01T17:44:30+00:00 @flybayer @blitz_js @rudiyardley hot take: those people never needed graphql in the first place 🤷‍♂️ but congrats 🎉       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [33, 115] 1433087810320355339 2826554209 flybayer       0 0 14 0 0   en  
1434389932177559555 swyx 33521530 2021-09-05T05:36:24+00:00 Taken from this excellent compendium of Visual Programming - a very valuable format of blogpost! https://drossbucket.com/2021/06/30/hacker-news-folk-wisdom-on-visual-programming/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 121] 1434388834087800832 33521530 swyx       0 2 14 0 0 0 en  
1437407435241689102 swyx 33521530 2021-09-13T13:26:52+00:00 There’s a lot of advocacy of going all in on one cloud on Twitter, but this is the best collection of arguments for multi-cloud I’ve seen in a single talk — from @AdrienneTacke https://youtu.be/6Mzs5y_fjPE       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 202]             0 3 14 0 0 0 en  
1440797518749601803 swyx 33521530 2021-09-22T21:57:51+00:00 Quite a few questions on Smart Servers so far. Coincidentally @chris_mccord just published about their path to Phoenix Liveview, which is worth a look for what the Smart Server paradigm can do https://fly.io/blog/how-we-got-to-liveview/ amazing scoop for @flydotio in hiring him!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 262] 1439966955570618376 33521530 swyx       0 0 14 0 0 0 en  
1441441101626306566 swyx 33521530 2021-09-24T16:35:13+00:00 Just signed up for @CascadiaJS! Hybrid conf (both online and in Seattle, Portland, and Vancouver) happening Nov 3-4. https://2021.cascadiajs.com/schedule Looking forward to see all these amazing speakers! https://twitter.com/swyx/status/1441441101626306566/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 193]             0 0 14 0 0 0 en  
1441908391211716608 swyx 33521530 2021-09-25T23:32:04+00:00 @jkup my site is still under construction with over a million visitors per year       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [6, 79] 1441872380016701440 255634108 jkup       0 0 14 0 0   en  
1443446713591623681 swyx 33521530 2021-09-30T05:24:49+00:00 If you take a salary, would you take some % of it in Bitcoin today?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 67]             0 4 14 0 0   en  
1444556693673701378 swyx 33521530 2021-10-03T06:55:28+00:00 @jlengstorf @astrodotbuild right here with ya :) https://twitter.com/swyx/status/1172690454363672577?s=20   1172690454363672577 1172690454363672577   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 72] 1442707241627385860 15668072 jlengstorf       1 1 14 0 0 0 en  
1444560899797176321 swyx 33521530 2021-10-03T07:12:11+00:00 Unsolicited compliment: I am enjoying watching along how @9ranty is building his Loom competitor in public. Lots of little gems and the video result looks great! Worth checking out http://tella.tv Am not a regular user yet but #BuildInPublic updates keep me interested. https://twitter.com/TellaHQ/status/1443129037854019589   1443129037854019589 1443129037854019589   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             1 0 14 0 0 0 en  
1445111500931153922 swyx 33521530 2021-10-04T19:40:05+00:00 Events are underrated for community building 🔥 Find ways to get off Slack! All year we've been hosting @temporalio meetups with a good mix of users and employees speaking. Most recently we've been really ramping up guest speakers, from @Bolt to @AirbyteHQ and now @NetflixEng 🚀 https://twitter.com/temporalio/status/1445091864244207618   1445091864244207618 1445091864244207618   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278]             1 1 14 0 0 0 en  
1445583402518802437 swyx 33521530 2021-10-06T02:55:15+00:00 @flybayer @blitz_js protip keep a “celebrate wins” or “wall of love” or “feedback” channel in slack where you collect these, you’re going to want them easy to find in future for the psychological pickup/investor update/user research       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [20, 232] 1445398474397212672 2826554209 flybayer       0 0 14 0 0   en  
1447061274148311041 swyx 33521530 2021-10-10T04:47:47+00:00 @dan_abramov ah a man of culture! i don’t think pizza restaurants realize how much business they lose out on when customers walk close, squint at the menu, and walk off when they see that the restaurant are anti pineapple snobs       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 228] 1447029234732523524 70345946 dan_abramov       0 0 14 0 0   en  
1447688291818508296 swyx 33521530 2021-10-11T22:19:20+00:00 One of my favorite things at work is flipping low-trust situations into high-trust ones. Teams move at the speed of trust. I think it is one of the most critical things you can do early on in any job. RTing this bc first time I've seen Trust broken down to an equation! https://twitter.com/ryan_caldbeck/status/1013626221601738754   1013626221601738754 1013626221601738754   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 270]             1 1 14 0 0 0 en  
1450575707826839554 swyx 33521530 2021-10-19T21:32:53+00:00 Lol - the top pieces of news yesterday according to @newsycombinator: - Apple launching Macbook Pros - Apple launching M1 Pro/M1 Max - my blogpost https://news.ycombinator.com/front?day=2021-10-18 https://twitter.com/swyx/status/1450575707826839554/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 172] 1450201578330222593 33521530 swyx       0 0 14 0 0 0 en  
1450648649747222534 swyx 33521530 2021-10-20T02:22:44+00:00 @stephsmithio do i get a bingo https://twitter.com/swyx/status/1426672482975551490   1426672482975551490 1426672482975551490   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 54] 1450646128416854018 626691391 stephsmithio       1 0 14 0 0 0 en  
1451242768559443976 Ben Kunz 4266261 2021-10-21T17:43:33+00:00 Exceptional post by @swyx. How to create your luck. TLDR: Move more and observe. https://www.swyx.io/create-luck/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 108]             0 7 14 1 1 0 en  
1455019275614232579 swyx 33521530 2021-11-01T03:50:02+00:00 @rauchg oh my god i didnt know that. i bet this is my problem because the flags are just not working!!! thank you!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 115] 1455014320987787271 15540222 rauchg       0 0 14 0 0   en  
1462819374251741185 Art Lapinsch 154491048 2021-11-22T16:24:51+00:00 Using Launch Cheat Sheet by @swyx as the basis for the rework. It's a fantastic resource. https://github.com/sw-yx/launch-cheatsheet       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 114] 1462819032730517512 154491048 artlapinsch       0 4 14 1 1 0 en  
1462837614390628357 swyx 33521530 2021-11-22T17:37:20+00:00 @anuraggoel huge congrats team!!! well written announcement and disclosure of roadmap, gives us a way to stay excited beyond just the funding!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 142] 1462790152489558028 14927721 anuraggoel       0 1 14 0 0   en  
1463718231454011393 swyx 33521530 2021-11-25T03:56:35+00:00 @jkup @AdamRackis finding so many people to mute, this is bliss       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [18, 63] 1463676727431946241 255634108 jkup       0 0 14 0 0   en  
1469128619716870146 swyx 33521530 2021-12-10T02:15:32+00:00 @JoeEmison @dmessing something i didnt stick around long enough to understand at Amplify was why people running atop AWS could build a faster experience than Amplify. You could blame CFN/CloudFront, but then @begin does that, with like a team of 4 people. wish i had the time to figure it out.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 293] 1469052947262754820 272692606 JoeEmison       0 1 14 0 0   en  
1469677279315959810 Rahul Padalkar 1939826354 2021-12-11T14:35:43+00:00 Was searching for videos that explain React Hooks. Came across @swyx 's "Getting Closure on React Hooks", from @jsconfasia 2019. Such an awesome talk. Highly recommended! Tried it myself and here's the repl link 👇 https://replit.com/@RahulPadalkar/AmpleSpitefulExtension#index.js Talk 👉 https://www.youtube.com/watch?v=KJP1E-Y-xyo       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 272]             0 1 14 1 1 0 en  
1473895021321482242 swyx 33521530 2021-12-23T05:55:31+00:00 @kevinakwok oof you said the thing i didnt dare say       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 51] 1473891723973701635 169791252 kevinakwok       0 0 14 0 0   en  
1473962147965112320 Theodorus Clarence 1228336168892170241 2021-12-23T10:22:15+00:00 + opinions about tailwindcss 👀 awesome book by the way @swyx https://twitter.com/th_clarence/status/1473962147965112320/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 61]             0 2 14 0 0 0 en  
1474097799491112960 swyx 33521530 2021-12-23T19:21:17+00:00 Extremely impressed by @AirbyteHQ's 2021: Mar: 5m Seed @Accel May: 26m Series A @Benchmark Dec: 150m Series B @altcap + Coatue Took 1 yr to get to 1/4 of Fivetran (founded 2012) 🤯 Was only tipped off by @roopakv + case study with @temporalio, but have to pay close attn now. https://twitter.com/MichelTricot/status/1474055955734319112 https://twitter.com/swyx/status/1474097799491112960/photo/1   1474055955734319112 1474055955734319112   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 302]             1 1 14 0 0 0 en  
1433682486106542088 swyx 33521530 2021-09-03T06:45:15+00:00 我吃的盐比你吃的饭还要多😱🤯 You could tell who spoke Chinese by the audible gasps in the room. Tony Leung owned every goddamn second he was onscreen in #shangchi https://twitter.com/swyx/status/1433682486106542088/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 149]             0 0 14 0 0 0 zh  

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