tweets

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

36 rows where is_quote_status = 0 and retweet_count = 6 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, favorite_count, favorited, retweeted

is_quote_status 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
1189555830544355330 swyx 33521530 2019-10-30T14:53:05+00:00 Levels of Impostor Syndrome working at @Netlify: 😍Seeing Coworkers 😱😱Representing the company in public 🤯🤯🤯Seeing the people applying to work here       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 149]             0 6 207 0 0   en  
1278665379544350720 swyx 33521530 2020-07-02T12:22:37+00:00 Something I didn't appreciate until I was a tool maker for while: - Scalability is a feature AND a cost - Tools designed to make small things should work very differently from tools designed to make big things - But you can design for graceful & *reversible* "eject"       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 271]             0 6 53 0 0   en  
1360316059987808256 swyx 33521530 2021-02-12T19:53:16+00:00 🆕 quick post: The Simple Magic of Prefixed URLs https://dev.to/swyx/the-simple-magic-of-prefixed-urls-46l1 It's amazing that you can enhance the open web by just accepting URLs and doing something interesting with it!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 184]             0 6 45 0 0 0 en  
1420471522703986688 Feross 15692193 2021-07-28T19:49:36+00:00 "Apple's web engine consistently trails others in both compatibility and features, resulting in a large and persistent gap with Apple's native platform." Progress Delayed Is Progress Denied https://infrequently.org/2021/04/progress-delayed/ @slightlylate       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 229]             0 6 26 0 1 0 en  
1425204981804650496 swyx 33521530 2021-08-10T21:18:41+00:00 Need research help: What is the best job scheduling/cronjob system you've used and what's one thing you LOVE about it?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 118]             0 6 99 0 0   en  
1425487171172044815 React Summit 🗓 June 17 & 21, 2022 3023155108 2021-08-11T16:00:00+00:00 There was a time before #ReactJS, and there will be life after. If you tie yourself too closely to any tech, you might trap yourself. @swyx zooms out from the state management library du jour to see what timeless lessons we can learn from #ReactJS: https://buff.ly/37tzisJ       Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 0 [0, 274]             0 6 11 0 1 0 en  
1425503610213785600 swyx 33521530 2021-08-11T17:05:19+00:00 RT @ReactSummit: There was a time before #ReactJS, and there will be life after. If you tie yourself too closely to any tech, you might tra… 1425487171172044815 1425487171172044815     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 6 0 0 1   en  
1425556759435898882 swyx 33521530 2021-08-11T20:36:31+00:00 @vercel nextjs 12 is gonna build your app before you write it       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 61] 1425503907019730956 4686835494 vercel       0 6 347 0 0   en  
1425889455643119616 swyx 33521530 2021-08-12T18:38:32+00:00 No Apple, I don't have any music on iTunes. No Apple, I don't run my email on Apple Mail. No Apple, I don't need to look up the meaning of a word I accidentally selected and force clicked.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 190]             0 6 87 0 0   en  
1427373400616407051 swyx 33521530 2021-08-16T20:55:12+00:00 RT @feross: "Apple's web engine consistently trails others in both compatibility and features, resulting in a large and persistent gap with… 1420471522703986688 1420471522703986688     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 6 0 0 1   en  
1427457113463300106 swyx 33521530 2021-08-17T02:27:51+00:00 Are we stuck with 5 star rating systems forever? A single irate customer can total someone’s livelihood with a 1 and there’s no meaningful difference between a 4.6 and a 4.7. Is anyone working on a viable alternative to the tyranny of Black Mirror style rating systems?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 270]             0 6 130 0 0   en  
1432108101440733184 swyx 33521530 2021-08-29T22:29:13+00:00 DevOps theory: We wanted Devs to do more Ops We got Ops being forced into Dev       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 79]             0 6 101 0 0   en  
1434183926868635648 swyx 33521530 2021-09-04T15:57:48+00:00 Just got a preview of @IncredibleDevHQ from @jerriclynsjohn. If you want an integrated, collaborative platform for dev video content, hit him up for a demo! Related tools in dev/video space: @loom, @TellaHQ, @mmhmmapp, @replayio, @usebubbles, @GetShareX, @birdeatsbug, @iterspace https://twitter.com/swyx/status/1434183926868635648/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 6 26 0 0 0 en  
1437109166334783494 swyx 33521530 2021-09-12T17:41:40+00:00 👀 Working on next post: "Why do webdevs keep trying to kill REST?" This one's been baking for a while - ever since I saw the innovation in @Reactjs Server Components and Rails Hotwire. Subscribe if you'd like to read a draft tonight! https://swyx.io/subscribe 🙏🏽 https://twitter.com/swyx/status/1437109166334783494/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 263]             0 6 186 0 0 0 en  
1440267058340634624 swyx 33521530 2021-09-21T10:50:00+00:00 TIL about the "DeWitt Clause": https://en.wikipedia.org/wiki/David_DeWitt#DeWitt_Clause Has there ever been a pettier mofo in tech than Larry Ellison? https://twitter.com/swyx/status/1440267058340634624/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 118]             0 6 28 0 0 0 en  
1443289480606015490 Joe Previte 1567529924 2021-09-29T19:00:01+00:00 Indie Hacking Resources 📚 If you're new to indie hacking, these are a couple resources I'd start with: - https://www.indiehackers.com/start - https://joeprevite.com/launching-first-product - https://github.com/sw-yx/launch-cheatsheet - https://www.indiehackers.com/growth-bites       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 209]             0 6 13 0 0 0 en  
1444542756647419909 Coding Career Community 1249002899897647105 2021-10-03T06:00:06+00:00 "This career feels like a few key hours every year with a few near mandatory year-long cool-down periods in between where what you do barely matters." 😬 Who else has felt like this and what did you do about it? https://old.reddit.com/r/cscareerquestions/comments/pzofk7/this_career_feels_like_a_few_key_hours_every_year/ https://twitter.com/Coding_Career/status/1444542756647419909/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 236]             0 6 36 0 0 0 en  
1447389381384282112 swyx 33521530 2021-10-11T02:31:34+00:00 This is an excellent read from @hosseeb and clearly articulates the problem with “we’re X, but decentralized” startups. Lots of first principles here: https://haseebq.com/why-decentralization-isnt-as-important-as-you-think/ The fact that it comes from a card carrying member of the community makes this impossible to dismiss. https://twitter.com/swyx/status/1447389381384282112/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 278]             0 6 55 0 0 0 en  
1448361227306946561 Temporal 1204202807298969600 2021-10-13T18:53:20+00:00 We are having a #kubecon2021 happy hour sponsored by Temporal. Our founders @mfateev and @samarabbas77 will be there along with some members of our awesome team. Invite details: https://lu.ma/temporalkubecon       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 202]             0 6 9 0 0 0 en  
1453795383109324800 swyx 33521530 2021-10-28T18:46:44+00:00 @wongmjane poor Microsoft with 2.4 trillion market cap still waiting for senpais to notice them       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 95] 1453794889091588100 337119125 wongmjane       0 6 360 0 0   en  
1454491471436926985 swyx 33521530 2021-10-30T16:52:44+00:00 @dan_abramov i think @JessTelford is trying that with http://cete.io! just really hard to compete in mindshare with a company literally called meetup dot com :(       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [13, 170] 1454489160820174862 70345946 dan_abramov       0 6 16 0 0 0 en  
1456668099739111424 Aliza Aufrichtig 49150150 2021-11-05T17:01:53+00:00 Tune in today at 2pm ET / 11am PT to hear @Rich_Harris and me talk with my dear old pal @jeanqasaur on #PLTalk about the journey from JavaScript to TypeScript on the NYT coronavirus tracker, amongst other fun topics. Just one hour away! https://www.twitch.tv/jeanqasaur       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 264]             0 6 38 1 1 0 en  
1456682921620688902 swyx 33521530 2021-11-05T18:00:47+00:00 RT @alizauf: Tune in today at 2pm ET / 11am PT to hear @Rich_Harris and me talk with my dear old pal @jeanqasaur on #PLTalk about the journ… 1456668099739111424 1456668099739111424     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 6 0 1 1   en  
1458878468150620181 Tom Preston-Werner 5502392 2021-11-11T19:25:06+00:00 When I was interviewed on Live TV by Fox News after the big GitHub Series A, they got the investor wrong, spelled "repository" wrong, did abominal things to em dashes, mis-capitalized GitHub, and called pull requests "e-notes". QED. https://twitter.com/mojombo/status/1458878468150620181/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 232] 1458878458319171592 5502392 mojombo       0 6 131 1 1 0 en  
1459249053586255873 swyx 33521530 2021-11-12T19:57:40+00:00 It's been a fun few years, but today was my last day of the week. Excited to announce that I'm staying put eating my feelings watching everyone switch jobs for ridiculous amounts of money!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 188]             0 6 409 0 0   en  
1462108361621745664 Pier 1360839410 2021-11-20T17:19:32+00:00 @sveltejs @vercel seems to be going all in with Svelte which makes me very happy 😍 - Hired @Rich_Harris to work on it full time - Sponsored #SvelteSummit - First speaker is a Vercel dev rel basically selling Svelte - @rauchg travelled to NYC It feels like something big is coming!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 283] 1462101412431777797 1360839410 PierB       0 6 44 1 1   en  
1462128844719247364 swyx 33521530 2021-11-20T18:40:56+00:00 RT @PierB: @sveltejs @vercel seems to be going all in with Svelte which makes me very happy 😍 - Hired @Rich_Harris to work on it full time… 1462108361621745664 1462108361621745664     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 6 0 1 1   en  
1462843985970425857 Alex Zdanov 1455586383901331462 2021-11-22T18:02:39+00:00 How I apply @swyx's priority list: Systems > Goals Discipline > Motivation Trust > Distrust Principles > Tactics Writing > Reading Vulnerability > Confidence North Stars > Low Hanging Fruit Trends > News Habits > Sprints Questions > Answers Problems > Solutions People > Projects       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 315]             0 6 52 1 1   en  
1462850627801731072 swyx 33521530 2021-11-22T18:29:02+00:00 RT @AByteOfCodeAlex: How I apply @swyx's priority list: Systems > Goals Discipline > Motivation Trust > Distrust Principles > Tactics Writi… 1462843985970425857 1462843985970425857     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 152]             0 6 0 1 1   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  
1463940387223982080 swyx 33521530 2021-11-25T18:39:21+00:00 RT @altalogy: Black Friday deals? We prefer giveaways🥰 How about a $5,000 worth design sprint to tweak your landing page or product? To e… 1463612122026450946 1463612122026450946     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 6 0 1 1   en  
1465230968143237124 swyx 33521530 2021-11-29T08:07:40+00:00 Every so often I realize someone hasn't tweeted in a while, check their profile and realize they've become disillusioned with social media and just peaced out. On one hand, I'm happy for them. On the other, I miss them. On my third hand, I wonder when it will be my turn.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 274]             0 6 133 0 0   en  
1467666370988965888 swyx 33521530 2021-12-06T01:25:05+00:00 RT @mojombo: When I was interviewed on Live TV by Fox News after the big GitHub Series A, they got the investor wrong, spelled "repository"… 1458878468150620181 1458878468150620181     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 6 0 1 1   en  
1469826858652880896 swyx 33521530 2021-12-12T00:30:05+00:00 "If you were a character in a book, what would your readers be yelling at you to do?" Fave thought exercise of mine, from @ESYudkowsky.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 136]             0 6 47 0 0   en  
1471004012971323392 swyx 33521530 2021-12-15T06:27:41+00:00 jQuery won the battle but Mootools won the war       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 46] 1470795050225307655 33521530 swyx       0 6 61 1 0   en  
1475105975518765063 swyx 33521530 2021-12-26T14:07:25+00:00 Imagine if those "Career Days" they do for kids came with honest guidance on probability of success: Actor - 90% luck, 5% talent, 5% hard work Doctor - 10% luck, 10% talent, 80% hard work Fireman - 5% luck, 10% talent, 85% hard work Founder - 30% luck, 20% talent, 50% hard work       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 6 98 1 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]);