tweets

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

29 rows where "created_at" is on date 2021-08-10 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, is_quote_status, retweet_count, retweeted

lang 2 ✖

created_at (date) 1 ✖

  • 2021-08-10 · 29 ✖
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
1424951893864816644 swyx 33521530 2021-08-10T04:33:00+00:00 This diagram stood out in an essay I was reading: https://moretothat.com/money/ When locked in a zero sum debate, add a dimension to find the way out. https://twitter.com/swyx/status/1424951893864816644/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 145]             0 88 243 0 0 0 en  
1424953927426928646 swyx 33521530 2021-08-10T04:41:05+00:00 @moretothat’s unification of the power and money divides into a single bell curve dimension is indirectly an incredible rebuttal of the Michael Scott Theory of Social Class - arguing FOR being peak Michael Scott! https://twitter.com/alex_danco/status/1352701338833072135?s=21 https://twitter.com/swyx/status/1424953927426928646/photo/1   1352701338833072135 1352701338833072135   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 237] 1424951893864816644 33521530 swyx       1 4 24 0 0 0 en  
1424970485721309186 swyx 33521530 2021-08-10T05:46:53+00:00 @ashleymcnamara 👋 changed careers at 30. would love to be a part!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 65] 1424861717478076435 14137772 ashleymcnamara       0 0 8 0 0   en  
1425099638491783183 Rich Harris 19487837 2021-08-10T14:20:05+00:00 god help me i wrote about alert() https://dev.to/richharris/stay-alert-d       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 57]             0 309 1147 0 1 0 en  
1425125459008704513 swyx 33521530 2021-08-10T16:02:41+00:00 RT @Rich_Harris: god help me i wrote about alert() https://dev.to/richharris/stay-alert-d 1425099638491783183 1425099638491783183     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 74]             0 309 0 0 1 0 en  
1425166770273284098 swyx 33521530 2021-08-10T18:46:51+00:00 @leeb delicious and delightful!       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [6, 31] 1425164338344517632 14904098 leeb       0 0 1 0 0   en  
1425169044227850244 swyx 33521530 2021-08-10T18:55:53+00:00 🔥 Quick tip on docs - if you have a list of points with long text, give a bolded 2-3 word summary upfront. https://twitter.com/swyx/status/1425169044227850244/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 106]             0 38 309 0 0 0 en  
1425175777000136706 swyx 33521530 2021-08-10T19:22:38+00:00 RT @swyx: One thing I've consistently had to relearn in developer marketing: "Talk benefits, not features" doesn't work! Developers are s… 1361279902889086980 1361279902889086980     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 105 0 0 1   en  
1425185575645024256 Sharif Shameem 107186366 2021-08-10T20:01:34+00:00 Here I am generating ~20 versions of a web app by describing what I want in just 1 sentence to @DebuildHQ. Debuild uses GPT-3 + Codex to: - Generate a product spec - Generate the data model - Write the SQL queries - Generate the React UI - Deploy it in 1 click https://twitter.com/sharifshameem/status/1425185575645024256/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 261]             0 119 670 0 0 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  
1425207317935452161 swyx 33521530 2021-08-10T21:27:58+00:00 @berenguel what do you hate most?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 33] 1425205298676092934 17534675 berenguel       0 0 1 0 0   en  
1425208387147419648 swyx 33521530 2021-08-10T21:32:13+00:00 @venkey_ariv yeah i am looking into usability mainly. thank you! need to research Splunk. looking to standardize terminology about scheduled runs: - Overlap Policy: SKIP, BUFFER_ONE, BUFFER_ALL, ALLOW_ALL to control what happens if a job runs over into the next window       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 270] 1425206384199536645 1010918910 venkey_ariv       0 0 0 0 0   en  
1425208911787806725 swyx 33521530 2021-08-10T21:34:18+00:00 @venkey_ariv - Catchup Window: if system goes down, how far back we look to pick up scheduled jobs - Pause After Failure: if one a job "fails", do we pause all future jobs - Delayed start - Run limit (for finite runs) - Jitter (uniform random starts) - Exclusions (avoid weekends)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 281] 1425208387147419648 33521530 swyx       0 0 1 0 0   en  
1425210442134089732 swyx 33521530 2021-08-10T21:40:23+00:00 @brianleroux whats an underappreciated thing it does well?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 58] 1425209754117345284 676363 brianleroux       0 0 0 0 0   en  
1425210747668160515 swyx 33521530 2021-08-10T21:41:36+00:00 @janbhwilhelm @flybayer @skn0tt yea it does look pretty sweet! Does it offer an API to "backfill" i.e. manually retry jobs that failed or didnt start because the system was down?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [32, 178] 1425207824322371585 958043149275934720 janbhwilhelm       0 0 5 0 0   en  
1425211431104835585 swyx 33521530 2021-08-10T21:44:18+00:00 @gr2m its great! but it is very flaky: https://github.com/sw-yx/gh-action-data-scraping/actions?query=is%3Afailure 2 failures in the last day alone       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 96] 1425210809555177472 11754732 gr2m       0 0 7 0 0 0 en  
1425211636554506246 swyx 33521530 2021-08-10T21:45:07+00:00 @brianleroux serverless IaC, you are nothing if not consistent       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 62] 1425210927008321542 676363 brianleroux       0 0 1 0 0   en  
1425212750666498052 swyx 33521530 2021-08-10T21:49:33+00:00 @brianleroux that said the right meme usually gets up and running way faster than the original creators ever intend https://newsletter.banklesshq.com/p/the-history-of-ultra-sound-money-db5       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 139] 1425211761976819716 676363 brianleroux       0 0 1 0 0 0 en  
1425212958460633089 swyx 33521530 2021-08-10T21:50:23+00:00 @gr2m and version controlled!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 29] 1425212570424668162 11754732 gr2m       0 0 3 0 0   en  
1425213339769073666 swyx 33521530 2021-08-10T21:51:54+00:00 @brianleroux would be fun to build a little cost estimator thing into that arc transpiler tool: "given some load assumptions and this arc file, whats the ballpark cost?"       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 169] 1425212085185744896 676363 brianleroux       0 0 0 0 0   en  
1425217481480695811 swyx 33521530 2021-08-10T22:08:21+00:00 @ryanlevander @getAkiflow @being_skyler @readwiseio i'm a few days into this thing and i think its actually sticking. i'm getting through the tasks i plan for myself! could be honeymoon period but very promising       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [52, 211] 1423463867510779905 339520646 ryanlevander       0 0 2 0 0   en  
1425218091479289863 swyx 33521530 2021-08-10T22:10:46+00:00 @betterbomb @PostgreSQL @supabase a fantastic solution as well :) but needs extra work to backfill failed/missed jobs, manually trigger them, or control overlap for long running jobs       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [34, 182] 1425217961854324738 127461367 betterbomb       0 0 3 0 0   en  
1425219679203651587 swyx 33521530 2021-08-10T22:17:05+00:00 @betterbomb @PostgreSQL @supabase haha well i'm one level below that, i'm working on a redesign of our scheduled workflow capability       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [34, 132] 1425219365058670605 127461367 betterbomb       0 0 2 0 0   en  
1425224399121117186 swyx 33521530 2021-08-10T22:35:50+00:00 @venkey_ariv retries and timeouts are our bread and butter @temporalio       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [13, 70] 1425221481076723712 1010918910 venkey_ariv       0 0 1 0 0   en  
1425224645771362309 swyx 33521530 2021-08-10T22:36:49+00:00 @evntdrvn excellent thank you! you didnt use it personally?       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [10, 59] 1425222470739582977 23587474 evntdrvn       0 0 1 0 0   en  
1425224923459383297 swyx 33521530 2021-08-10T22:37:55+00:00 @coreyhainesco thought it was a very honest reflection :) at the same time i also think tech is too lucrative and fun so would be surprised to see you leave       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [15, 156] 1425166764036460555 2480319486 coreyhainesco       0 0 3 0 0   en  
1425233830869274624 swyx 33521530 2021-08-10T23:13:19+00:00 @Lucid_Dan yes! we call this our overlap policy (exact names TBD) https://twitter.com/swyx/status/1425233830869274624/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 65] 1425231281059635201 945098033124950016 Lucid_Dan       0 0 4 0 0 0 en  
1424932215624962049 swyx 33521530 2021-08-10T03:14:48+00:00 @jsjoeio https://github.com/sw-yx/spark-joy#sound       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 32] 1424914603885006850 1567529924 jsjoeio       0 0 10 0 0 0 und  
1425123109032513549 swyx 33521530 2021-08-10T15:53:21+00:00 @chaseadamsio @rothgar @vercel @darklang       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [31, 40] 1425121027562999812 20705255 chaseadamsio       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]);