tweets

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

37 rows where "created_at" is on date 2021-09-29 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, is_quote_status, retweet_count, retweeted

created_at (date) 1 ✖

  • 2021-09-29 · 37 ✖
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
1443024483170729989 swyx 33521530 2021-09-29T01:27:01+00:00 Just saw a demo of @Serverless Cloud from @jeremy_daly on @mavi888uy's channel: - API routing + serverless - @DynamoDB storage + querying (incl/ GSIs) - scheduled functions - data streams no YAML, no CDK, no IaC.... JUST BUSINESS LOGIC. https://www.youtube.com/watch?v=1TKedWps7nU https://twitter.com/swyx/status/1443024483170729989/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 263] 1435471481266388993 33521530 swyx       0 9 42 0 0 0 en  
1443025337848266763 swyx 33521530 2021-09-29T01:30:25+00:00 @MylesBorins @jkup @robwormald this goes against everything i have ever heard about the waste recycling industry       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [31, 112] 1443024260633616389 150664007 MylesBorins       0 0 0 0 0   en  
1443026395832127496 𝚍𝚊𝚛𝚔𝚜𝚝𝚊𝚛 256053691 2021-09-29T01:34:37+00:00 6 months of @darkstardao. 12 essays on Web3. In order-- March 1, 2021: A New Media Structure: The Ownership Economy by @jarroddicker @Flynnjamm @patrickxrivera https://darkstar.mirror.xyz/srmoGiN_1pg_toQGzCupkjWFOaf8xi0mM60zYpn_pwI /1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 192]             0 23 122 0 1 0 en  
1443032123649241091 Taylor Poindexter 876448351268380672 2021-09-29T01:57:23+00:00 I told my friend I was both scared and excited to officially join Spotify next month and she pointed me to this excerpt. It was just the reminder I needed & this may be my new favorite rallying cry. https://twitter.com/engineering_bae/status/1443032123649241091/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 202]             0 16 135 0 0 0 en  
1443034093080375301 swyx 33521530 2021-09-29T02:05:12+00:00 The Man in the Arena - Teddy telling us to get in the ring, not to cheer or jeer from the sidelines. https://twitter.com/engineering_bae/status/1443032123649241091   1443032123649241091 1443032123649241091   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 100] 1376108052005351425 33521530 swyx       1 0 7 0 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  
1443039203260919814 swyx 33521530 2021-09-29T02:25:31+00:00 @arvidkahl hey dont kink shame       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 30] 1442940646549905415 343990983 arvidkahl       0 0 1 0 0   en  
1443041018501230597 swyx 33521530 2021-09-29T02:32:43+00:00 @ajcwebdev @jeremy_daly @serverless @mavi888uy @dynamodb its dynamo, when they say GSI its a dynamo concept. but they implemented some nice range request syntax stuff that im not sure is native to dynamo       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [57, 203] 1443039832708550657 30723962 ajcwebdev       0 0 3 0 0   en  
1443041288975048706 swyx 33521530 2021-09-29T02:33:48+00:00 @iansu @samselikoff oops.. i must be misattributing then, glad i caveated with "i think". all i know is it was a popular build tool that kept fussing over my package.json. maybe gatsby? also this might be 3 years out of date since ive stopped being fancy with package jsons       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [20, 273] 1443040622730833921 15755614 iansu       0 0 6 0 0   en  
1443046610963865601 swyx 33521530 2021-09-29T02:54:57+00:00 RT @jarroddicker: 6 months of @darkstardao. 12 essays on Web3. In order-- March 1, 2021: A New Media Structure: The Ownership Economy b… 1443026395832127496 1443026395832127496     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 23 0 0 1   en  
1443049286376124423 swyx 33521530 2021-09-29T03:05:35+00:00 @elyktrix @foxtrotmarket 🎉 congrats!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 37] 1443012053535531014 223739217 elyktrix       0 0 1 0 0   en  
1443051720104316934 swyx 33521530 2021-09-29T03:15:15+00:00 @fortelabs you managed to squeeze a book into that subtitle huh that said, the pple following you here are likely to buy your book or just know your deal already; you may want to discount our opinions to reach the really mass market who dont know you from adam.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 262] 1442970778157281282 1909232666 fortelabs       0 0 7 0 0   en  
1443052316815290372 swyx 33521530 2021-09-29T03:17:37+00:00 @QuinenceHQ @serverless @jeremy_daly @mavi888uy @dynamodb so much infra engineering obsoleted by a good runtime       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [58, 111] 1443025649266880516 1204002279759630338 QuinenceHQ       0 0 2 0 0   en  
1443053999377117188 swyx 33521530 2021-09-29T03:24:18+00:00 One piece of writing advice I took from @patio11 goes something like “everyone writes the “101” intro, but there’s near infinite demand and no supply for 201-level stuff” and somehow thats become my entire writing M.O. Go deep! It’s not popular, but it’s badly needed! https://twitter.com/RandallKanna/status/1442870467950374912   1442870467950374912 1442870467950374912   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 269]             1 43 439 0 0 0 en  
1443057317470081029 swyx 33521530 2021-09-29T03:37:29+00:00 @brianleroux i saw jeremy casually log out of the @goserverless CLI and log back in like it was nothing on this live stream (early on like 5ish mins in) and mind was fcking blown. i dont recall it ever being that smooth at @netlify https://twitter.com/swyx/status/1443024483170729989   1443024483170729989 1443024483170729989   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 231] 1443012651039133698 676363 brianleroux       1 0 6 0 0 0 en  
1443081095231131653 swyx 33521530 2021-09-29T05:11:58+00:00 @pushmatrix i kiiinda want to join Shopify just to play this god damn       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 69] 1442839002432802818 91908253 pushmatrix       0 0 21 0 0   en  
1443083429864636416 swyx 33521530 2021-09-29T05:21:15+00:00 @linuz90 @mailbrew @frankdilo @albigiu just got the email! brave move. tbh wasnt reading my brews enough so not going to sign up. so i was a mere cost center to you. kudos and keep making your customers happy 💪       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [39, 210] 1442907673297514498 17650681 linuz90       0 0 5 0 0   en  
1443088918455328769 swyx 33521530 2021-09-29T05:43:04+00:00 @vladchers sir this is a Wendys       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 31] 1443079225032990723 1260923246926594048 vladchers       0 0 4 0 0   en  
1443093060473090051 swyx 33521530 2021-09-29T05:59:31+00:00 It’s been incredible to watch @nutlope’s career grow ever since he joined webdev twitter in college! He’s been a daily positive presence in the @Coding_Career discord and I feel lucky to have met him before he was “famous” Great hire by @leeerob and @rauchg — only the beginning! https://twitter.com/Nutlope/status/1442926717635477504   1442926717635477504 1442926717635477504   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             1 2 30 0 0 0 en  
1443094813398626306 swyx 33521530 2021-09-29T06:06:29+00:00 @arvidkahl came for the feedback panda story, stayed for the earnest support of other indiehackers 💪🏽 congrats arvid!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 117] 1442956133275103232 343990983 arvidkahl       0 0 2 0 0   en  
1443112139976179714 swyx 33521530 2021-09-29T07:15:20+00:00 @spitleaf emphasizing performance over substance. lots of motivation to get started, but no viral loop to keep people coming back. am biased but like seeing “communities of practice” form on @Discord and @circleapp where the focus is work over profiles       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 253] 1442950472848089088 357427736 spitleaf       0 0 4 0 0   en  
1443112267483017220 swyx 33521530 2021-09-29T07:15:50+00:00 @stephsmithio amazing!!!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 25] 1442878012995907591 626691391 stephsmithio       0 0 1 0 0   en  
1443112483670032402 swyx 33521530 2021-09-29T07:16:42+00:00 @ritakozlov_ buy Netlify pls thx       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 32] 1442979853054058508 232076816 ritakozlov_       0 0 3 0 0   en  
1443129037854019589 Tella 1253031308957290497 2021-09-29T08:22:29+00:00 ✨TELLAVISION✨ episode 5 has arrived. Featuring... 💜 Fullscreen purple gradients ✂️ Our new trim mode 🔘 The backstory of buttons ✍️ Recapping our latest writing https://tella.video/tellavision-ep05-6pkx       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 185]             0 1 9 0 0 0 en  
1443233639882375172 swyx 33521530 2021-09-29T15:18:08+00:00 Jeff Bezos bragging about a feature that *reduces* sales in 2002. Great example of being customer centric https://twitter.com/swyx/status/1443233639882375172/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 105]             0 28 346 0 0 0 en  
1443236911254884362 swyx 33521530 2021-09-29T15:31:08+00:00 @shaundai yea it cuts both ways! at least in 2002 it net-reduced sales but probably increased lifetime value       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 108] 1443236206897209349 1004483816 shaundai       0 0 6 0 0   en  
1443242219650142209 Walt Mossberg 5746452 2021-09-29T15:52:13+00:00 Here’s another great episode of ⁦@Recode⁩’s podcast series about @Apple. ⁦@pkafka⁩ does a great job documenting “How Apple Got Its Groove Back” starting in 1997. A really worthwhile listen. https://podcasts.apple.com/us/podcast/land-of-the-giants/id1465767420?i=1000536965880       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 214]             0 15 93 0 0 0 en  
1443265084470427650 Tyler McGinnis 380724965 2021-09-29T17:23:05+00:00 An interesting change Chrome recently made. You can now redeclare const variables in the console. Avoids the "Uncaught SyntaxError: redeclaration of const X" error. https://twitter.com/tylermcginnis/status/1443265084470427650/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 165]             0 176 1415 0 0 0 en  
1443269476464664584 Gleb Posobin in NYC, let's meet! 227724772 2021-09-29T17:40:32+00:00 (3/6) @ampie_app surfaces the connections to you as you browse. It's a powerful sidebar for the browser: go to any page, and if there are connections for it, the sidebar will peek out on the right side. Like this: https://twitter.com/posobin/status/1443269476464664584/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 213] 1443269466486362113 227724772 posobin       0 7 34 0 1 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  
1443311835629895686 Kevin Kwok 169791252 2021-09-29T20:28:51+00:00 New essay up. Narrative Distillation - modern IPO env is about owning marketing, not pricing - increasing impt of narrative leverage as accounting too backwards facing - product market fit as one facet of narrative distillation - founder led narratives https://kwokchain.com/2021/09/29/narrative-distillation-1/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278]             0 57 394 0 1 0 en  
1443315478395383808 swyx 33521530 2021-09-29T20:43:20+00:00 @tylermcginnis the only constant is change       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 42] 1443265084470427650 380724965 tylermcginnis       0 1 112 0 0   en  
1443316970523226114 swyx 33521530 2021-09-29T20:49:15+00:00 JavaScript developers: "Nooooo use `let` if you mean something will change, and `const` if it won't, it was designed into ES6 ffs" Chrome: "Reality can be whatever I want" https://twitter.com/tylermcginnis/status/1443265084470427650   1443265084470427650 1443265084470427650   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 172]             1 88 725 0 0 0 en  
1443320968684785664 swyx 33521530 2021-09-29T21:05:09+00:00 RT @posobin: (3/6) @ampie_app surfaces the connections to you as you browse. It's a powerful sidebar for the browser: go to any page, and i… 1443269476464664584 1443269476464664584     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 7 0 0 1   en  
1443323735696494596 swyx 33521530 2021-09-29T21:16:08+00:00 @WingofaGriffin i used all 3 in a talk once and nobody complained! https://twitter.com/rwieruch/status/1151520943963070465   1151520943963070465 1151520943963070465   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 90] 1443322424431288320 909101327539736576 WingofaGriffin       1 0 2 0 0 0 en  
1443343607541370882 swyx 33521530 2021-09-29T22:35:06+00:00 @SeaRyanC just to be clear i jest with love, totally get why chrome did it :)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 77] 1443339609627258886 1177182800 SeaRyanC       0 0 1 0 0   en  
1443315520749510658 swyx 33521530 2021-09-29T20:43:30+00:00 @tylermcginnis @_jayphelps few       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 30] 1443313666024112132 380724965 tylermcginnis       0 0 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]);