tweets

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

16 rows where "created_at" is on date 2021-08-10, retweeted = 0, source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" and user = 33521530 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, retweet_count, favorite_count

user 1 ✖

  • swyx · 16 ✖

source 1 ✖

  • Twitter Web App · 16 ✖

is_quote_status 1 ✖

  • 0 16

created_at (date) 1 ✖

  • 2021-08-10 · 16 ✖
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
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  
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  
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  

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]);