tweets

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

22 rows where favorite_count = 15 and retweet_count = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name

lang 3 ✖

retweet_count 1 ✖

favorite_count 1 ✖

place 0 ✖

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
1264836620831711232 swyx 33521530 2020-05-25T08:32:04+00:00 👍 @igrigorik's @perfnowconf 2019 talk https://www.youtube.com/watch?v=vtIfVPtN6io An instant classic I just referenced for @Sveltejs Radio today. There is a huge difference between the head (us) and torso/tail (everyone else). If you care about impact, you *have* to simplify. https://twitter.com/swyx/status/1264836620831711232/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258]             0 0 15 0 0 0 en  
1376720619400650752 swyx 33521530 2021-03-30T02:19:08+00:00 🆕 post: Blogpost Annealing https://www.swyx.io/blogpost-annealing/ My site is a digital garden, not a magazine. Posts get better *after* publication: More exposure => more "heat" => better quality!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 189]             0 0 15 0 0 0 en  
1425716946977185793 swyx 33521530 2021-08-12T07:13:03+00:00 Every few months I marvel at the perfect timing of the releases of AWS Lambda (max lock in) and Kubernetes (min lock in) and how they make total sense given each cloud’s position. Behind the scenes tech strategists are playing a giant game of 4D chess and we are the pawns.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 274]             0 0 15 0 0   en  
1425924327027838977 swyx 33521530 2021-08-12T20:57:06+00:00 @_developit @jlongster when i grow up i want to be half as cool as jlongster       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [23, 76] 1425880247799517189 16495353 _developit       0 0 15 0 0   en  
1429607755770331140 swyx 33521530 2021-08-23T00:53:44+00:00 of course it was from @benthompson: https://stratechery.com/2018/techs-two-philosophies/ (thanks to @jtao_) he identifies a few other points: - the Jobs school is older - platforms skew Jobsian, aggregators skew Zuckerist - the business model follows (paid vs ads) - they aren’t at odds; we need both https://twitter.com/swyx/status/1429607755770331140/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 273] 1429536652196651012 33521530 swyx       0 0 15 0 0 0 en  
1430949617928048646 swyx 33521530 2021-08-26T17:45:49+00:00 There are exceptions to every rule, a synthesis to be drawn from every dialectic. I think founders who can blend the strategy of scale and the tactics of scrappiness do very well. People like @callmevlad, @agazdecki, the @supabase team, everyone in the @tylertringas portfolio.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 279] 1430949616371961862 33521530 swyx       0 0 15 0 0   en  
1433213036886560768 swyx 33521530 2021-09-01T23:39:50+00:00 Adage: "There are only two ways to make money in software: bundling and unbundling." People doing Monorepo Microservices: https://twitter.com/swyx/status/1433213036886560768/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 122]             0 0 15 0 0 0 en  
1433919002355507201 swyx 33521530 2021-09-03T22:25:05+00:00 casual reminder that extrinsic motivation isn’t harmless, nice to have, or ignorable. They *actively destroy* intrinsic drive. https://twitter.com/swyx/status/968688836468453376?s=21   968688836468453376 968688836468453376   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 151] 1433918146348343297 33521530 swyx       1 0 15 0 0 0 en  
1434429326036983811 swyx 33521530 2021-09-05T08:12:56+00:00 @supabase live footage of Supabase team knocking out milestones https://twitter.com/swyx/status/1434429326036983811/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 63] 1434420702677913608 1219566488325017602 supabase       0 0 15 0 0 0 en  
1436232321271746561 swyx 33521530 2021-09-10T07:37:23+00:00 First time founders obsess about product. Second time founders obsess about distribution. Great cofounder pairs bundle both. https://twitter.com/terronk/status/1436065787408633857   1436065787408633857 1436065787408633857   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 126]             1 0 15 0 0 0 en  
1437814869504319491 swyx 33521530 2021-09-14T16:25:52+00:00 @tlakomy if your EDI persists for 4 hours or more, call a doctor       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 64] 1437814357329682438 1903060381 tlakomy       0 0 15 0 0   en  
1438686269358235660 swyx 33521530 2021-09-17T02:08:30+00:00 @chantastic after building the MVP of this for @ReactRally just to get crickets my current conclusion is that the React community likes talking about this more than they actually want it 🤷🏽‍♂️ part of why i rather just move on to @SvelteSociety which alr has a community of people who "get it"       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 294] 1438195960799117314 12745092 chantastic       0 0 15 0 0   en  
1441436065680609282 swyx 33521530 2021-09-24T16:15:13+00:00 accounts grow ofc - thats the power of SaaS - but i do feel like the market should *pull* you into a barbell than intentionally pursue it.. bc the cognitive dissonance on marketing, product, eng, docs, support etc is huge basically building two companies with one shared codebase       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280] 1441436063923195905 33521530 swyx       0 0 15 0 0   en  
1443034568978620419 swyx 33521530 2021-09-29T02:07:06+00:00 @samselikoff most annoying thing about create react app (i think) is it validates package json making you scared to do stuff like this when thats not its job       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 157] 1443031859663937541 131941348 samselikoff       0 0 15 0 0   en  
1445108356390080515 swyx 33521530 2021-10-04T19:27:35+00:00 @markdalgleish @kentcdodds how is it not called the Kent C. Pod       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 63] 1445107245612634117 257765996 markdalgleish       0 0 15 0 0   en  
1452039338619899913 swyx 33521530 2021-10-23T22:28:50+00:00 @ChopFitzroy @kyleshevlin here https://twitter.com/swyx/status/1420211877276049408   1420211877276049408 1420211877276049408   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 30] 1452034379446816768 955233524587483136 ChopFitzroy       1 0 15 0 0 0 en  
1455609835509092353 swyx 33521530 2021-11-02T18:56:43+00:00 @BenLesh @ApayRus this sold me on rxjs in 2018 but i'm still waiting for the rest of the js world to care about it honestly :(       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [18, 126] 1455598001272016902 23795212 BenLesh       0 0 15 0 0   en  
1455641481276887040 swyx 33521530 2021-11-02T21:02:28+00:00 @seldo also they seem to have a creepy CEO who goes around buying up influencers' domains and squatting on them to try to get them onto his platform 🤮       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [7, 150] 1455640706786099203 15453 seldo       0 0 15 0 0   en  
1458876680257236998 swyx 33521530 2021-11-11T19:17:59+00:00 @levelsio Nomad Airlines when       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 29] 1458876305437446146 1577241403 levelsio       0 0 15 0 0   en  
1474225956504031235 swyx 33521530 2021-12-24T03:50:32+00:00 @dan_abramov 🥲 i promise i still really do love React       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 53] 1473699470307217413 70345946 dan_abramov       0 0 15 0 0   en  
1465448848285835265 swyx 33521530 2021-11-29T22:33:26+00:00 Rich Harris vs Nouveau Riche Harris https://twitter.com/iltimasdoha/status/1462478790509182984       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 35] 1462141656916967426 33521530 swyx       1 0 15 0 0 0 fr  
1432931687441133568 swyx 33521530 2021-09-01T05:01:51+00:00 @chantastic https://twitter.com/swyx/status/1372013877731368961?s=20   1372013877731368961 1372013877731368961   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 35] 1432930900325535750 12745092 chantastic       1 0 15 0 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]);