tweets
35 rows where favorite_count = 15 and user = 33521530
This data as json, CSV (advanced)
Suggested facets: source, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, lang, created_at (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1225559755080585216 | swyx 33521530 | 2020-02-06T23:19:50+00:00 | ✍️Scrollbar Shenanigans Messing around with Webkit Scrollbar Styling like it's 1999! https://www.swyx.io/writing/scrollbar-shenanigans | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 110] | 0 | 1 | 15 | 0 | 0 | 0 | en | ||||||||||
| 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 | ||||||||||
| 1360757289032933378 | swyx 33521530 | 2021-02-14T01:06:34+00:00 | 🚨 Descript's 2 Killer Features for Podcast Editing A quick demo of how @DescriptApp lets you easily remove pauses and filler words. I immediately upgraded to the Pro plan after I saw this. cc @jbrancha https://youtu.be/du8xatGd0zE | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 230] | 1360739396236943360 | 33521530 | swyx | 0 | 1 | 15 | 0 | 0 | 0 | en | |||||||
| 1367303433015808004 | swyx 33521530 | 2021-03-04T02:38:36+00:00 | 🆕 Short post: Workshopping https://www.swyx.io/workshopping/ Not everything should be public. Sometimes it's better to iterate semi-privately. An idea inspired by Broadway tradition, which helps solve the Consistency vs Quality tradeoff. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 230] | 0 | 3 | 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 | ||||||||||
| 1419836176681213952 | swyx 33521530 | 2021-07-27T01:44:58+00:00 | Suddenly reminded of this @bcantrill talk: https://youtu.be/30jNsCVLpAE and I think I have my answer - If it takes you 2 days to chase down an intermittent bug, perhaps that *IS* the bug. Even though this talk is 4 years old but feels like @mipsytipsy is beating the same drum today. https://twitter.com/swyx/status/1419434119319093250 | 1419434119319093250 1419434119319093250 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 3 | 15 | 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 | |||||||||
| 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 | ||||||||
| 1432569213688823810 | swyx 33521530 | 2021-08-31T05:01:31+00:00 | Today's clip: @MarkLovesTech's journey to MongoDB, on the excellent StackOverflow podcast https://share.transistor.fm/s/11c1a958 Mark stands out for 2 reasons: He's a relational databases guy that has embraced NoSQL, and he's the rare CTO that's still in LOVE with technology (per his handle)! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 2 | 15 | 0 | 0 | 0 | en | ||||||||||
| 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 | ||||||
| 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 | ||||||||
| 1440196339405508609 | swyx 33521530 | 2021-09-21T06:08:59+00:00 | 🆕 Today's clip is on Podcast Economics: The Math to $14,000 a month: 10,000 fans * 4 ads a week * 25 CPM each ad = $1,000 a week, $4k a month 50,000 fans => $20k a month Sales cut - 15-30% https://share.transistor.fm/s/6d8837a6 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 221] | 0 | 2 | 15 | 0 | 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 | ||||||||
| 1448047600318365697 | swyx 33521530 | 2021-10-12T22:07:05+00:00 | @temporalio The rest of OSS startup moat I reckon comes down to 2 things: - Sweat the DX: Intuitive, honest docs. Treating onboarding like game design. Handling exceptions (https://twitter.com/swyx/status/1294689838872981506?lang=en). Build a media company around domain, then build community. Mindshare -> market share. | 1294689838872981506 1294689838872981506 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 289] | 1448044941679022083 | 33521530 | swyx | 1 | 4 | 15 | 0 | 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 | ||||||
| 1452772699512524800 | swyx 33521530 | 2021-10-25T23:02:57+00:00 | Looking forward to host the 7th @temporalio meetup tomorrow at 9am PT! Presenting: 💰 Temporal at @Stripe 🗺️ Temporal Feature Map 🎉 2 Year Anniversary Q&A Signup at https://temporal.io/meetup! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 196] | 0 | 5 | 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 | ||||||||
| 1455820522915127299 | swyx 33521530 | 2021-11-03T08:53:55+00:00 | Hard to read but handy report for Community Builders. Some picks: - Typical community spans 6 platforms - Community builders use 13 tools, try 3, no integration - @circleapp has 19% market share!? 🤯 - Chat > Social media > Email > Events Dark horses: Affiliates, QoTD, Advocacy https://twitter.com/OrbitModel/status/1455535930660564995 https://twitter.com/swyx/status/1455820522915127299/photo/1 | 1455535930660564995 1455535930660564995 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 311] | 1 | 1 | 15 | 0 | 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 | ||||||||
| 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 | ||||||
| 1463266140847677454 | swyx 33521530 | 2021-11-23T22:00:08+00:00 | And now @SvelteSociety gets its own fulltime Technical Community Builder in @kevmodrome! https://twitter.com/kevmodrome/status/1463151477174714373?s=20 | 1463151477174714373 1463151477174714373 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 113] | 1458693704764383241 | 33521530 | swyx | 1 | 1 | 15 | 0 | 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 | |||||||
| 1471157778240585728 | swyx 33521530 | 2021-12-15T16:38:41+00:00 | Unintuitive part of building for enterprise: We are more afraid of small workloads than large ones! Baseline cost to service each account dominates gross margin * usage, until you specifically invest to bring that baseline down, and it may not make sense vs other investments 😬 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 0 | 1 | 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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);