tweets

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

28 rows where "created_at" is on date 2021-08-03, is_quote_status = 0 and retweet_count = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, source, in_reply_to_status_id, in_reply_to_user_id, in_reply_to_screen_name, favorite_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
1422416105226657792 swyx 33521530 2021-08-03T04:36:41+00:00 My favorite #MilesMoralesPS4 easter egg - if you wear the right suit and do this enough, Spider-Cat comes out and deals the final blow in your finishing move!!! I love 🕷️🐈 so much https://twitter.com/swyx/status/1422416105226657792/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 180] 1421507359285805061 33521530 swyx       0 0 27 0 0 0 en  
1422419304096485384 swyx 33521530 2021-08-03T04:49:24+00:00 @sgrove @temporalio you mean CPS? continuation passing? if so then no... just `await` an `async` workflow and the framework handles the "blocking"       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [20, 146] 1422418903381078021 14435843 sgrove       0 0 0 0 0   en  
1422419942129901574 swyx 33521530 2021-08-03T04:51:56+00:00 @yash_kr_verma i think this could be a good answer but i dont like discussing this thing without numbers. if the delay is <10ms i really don't care. especially if i'm serving API requests, not web pages.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 206] 1422418499343831043 3112402897 yash_kr_verma       0 0 0 0 0   en  
1422426258676195328 swyx 33521530 2021-08-03T05:17:02+00:00 @sgrove @ejames_c @temporalio Ah. I couldnt find a very good definition of CSP in Go (the go docs are way too brief) but yes - we have Signals and Queries https://docs.temporal.io/docs/go/signals/ i was also referring to "synchronous" started workflows, which solve a concern people had for queue-first systems like i proposed       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 309] 1422423624682655748 14435843 sgrove       0 0 1 0 0 0 en  
1422427493710012416 swyx 33521530 2021-08-03T05:21:56+00:00 @ASpittel @AWSAmplify Amplify DataStore + Auth is just 👩🏽‍🍳😘 in this kind of use case! great tutorial, especially with a full video walkthrough, just amazing work! one thing i'd add here is a callout to Selective Sync - you dont want datastore to sync down private info from other users!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [22, 288] 1422207113036804101 3092104835 ASpittel       0 0 7 0 0   en  
1422429666866987012 swyx 33521530 2021-08-03T05:30:34+00:00 @dimfeld @sgrove @ejames_c @temporalio yup thats it, and save every step to sharded persistence. i imagine its exactly what you'd have to do if you needed your CSPs to survive any downtime or network failure.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [39, 210] 1422428669339860992 5647302 dimfeld       0 0 1 0 0   en  
1422430127212744704 Cedric Chin 14243237 2021-08-03T05:32:24+00:00 @swyx @dimfeld @sgrove @temporalio Basically what this tweet thread is telling me is to go check out temporal ;-) (I was obsessed with the CSP paper, and the lit around it for a few years in uni). This is *fascinating* stuff.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [35, 227] 1422429666866987012 33521530 swyx       0 0 1 0 0   en  
1422431411634507777 swyx 33521530 2021-08-03T05:37:30+00:00 @ThisIsMissEm - i think pqueue as source of truth (with compute being secondary) can make a lot of sense, as opposed to the norm of compute-first and adding persistence/queueing as afterthought - depends what kind of routing - you have to route things to the right queue at least       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 279] 1422429638740135936 14063149 ThisIsMissEm       0 0 0 0 0   en  
1422436468631347202 swyx 33521530 2021-08-03T05:57:36+00:00 @ThisIsMissEm ya i hear you on not everything needing persistence. i wouldnt do this for a CDN or web server, for instance. but could be great for job runner/workflow engine fun fact, @netlify can offer *backfillable* analytics because it logs anonymous visitor statistics for every request.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 293] 1422433377668452370 14063149 ThisIsMissEm       0 0 0 0 0   en  
1422438456353951750 swyx 33521530 2021-08-03T06:05:30+00:00 @ThisIsMissEm @Netlify i mean i did say anonymous. Netlify was well aware of GDPR when launching this thing. lmk if any specifics alarm you and i'd be happy to dig in further as i have some interest in what potential problems there may be https://www.netlify.com/gdpr-ccpa/ https://www.netlify.com/products/analytics/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 287] 1422437143713042439 14063149 ThisIsMissEm       0 0 0 0 0 0 en  
1422438939432869888 swyx 33521530 2021-08-03T06:07:25+00:00 @ThisIsMissEm @Netlify yes schema evolution was a concern in the thread i responded to today (https://news.ycombinator.com/item?id=28034882) which prompted revival of this tweet :) bottom line is frameworks can help with coding hygiene and i'm trying to frame @temporalio as a framework to help (https://www.youtube.com/watch?v=kkP899WxgzY)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 299] 1422437929071300611 14063149 ThisIsMissEm       0 0 0 0 0 0 en  
1422442377491279872 swyx 33521530 2021-08-03T06:21:05+00:00 @ThisIsMissEm @Netlify ah the beauty of unilateral global regulation: distributes all the compliance costs, centralizes all the fines.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 134] 1422441506221215763 14063149 ThisIsMissEm       0 0 0 0 0   en  
1422443301223886848 swyx 33521530 2021-08-03T06:24:45+00:00 @falconets @martinkl saving straight to watch queue (heh) - thank you!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [21, 70] 1422442772276006914 73880804 falconets       0 0 2 0 0   en  
1422450052102967297 swyx 33521530 2021-08-03T06:51:34+00:00 @boop just checked yours out and uh.. wow i've been missing out haha. RIP fleets       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 80] 1422448693962108929 14782048 boop       0 0 1 0 0   en  
1422452854237786113 swyx 33521530 2021-08-03T07:02:43+00:00 @AndreiVreja @silentworks @supabase done! good luck https://twitter.com/swyx/status/1422452854237786113/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [36, 51] 1422148851167793152 906184402052554752 AndreiVreja       0 0 2 0 0 0 en  
1422557069081825282 swyx 33521530 2021-08-03T13:56:49+00:00 @threepointone dynamically relocating strongly consistent memory 🤯 that accidentally also solves the data locality compliance problem       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 133] 1422553404333871115 1593171 threepointone       0 0 3 0 0   en  
1422567771682983937 swyx 33521530 2021-08-03T14:39:21+00:00 @ASpittel @AWSAmplify !!!!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [22, 27] 1422556120527298565 3092104835 ASpittel       0 0 1 0 0   und  
1422569044348080133 swyx 33521530 2021-08-03T14:44:24+00:00 @jdnoc @freeCodeCamp yes! FCC helped me validate that I could career switch with $0 upfront cost. Changed my life. This is why I'm kicking in my $5 every month for the rest of my life + did two big oneoff donations to pay them back.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [21, 232] 1422541585703702529 3355146352 jdnoc       0 0 3 0 0   en  
1422580099199602688 swyx 33521530 2021-08-03T15:28:20+00:00 @_2c2c @temporalio @tef_ebooks is an all-round great dev blogger + follow his twitter for crow pics       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 99] 1422577505685282818 2461201788 _2c2c       0 0 0 0 0   en  
1422582662401650690 swyx 33521530 2021-08-03T15:38:31+00:00 @knocklabs nice post! seems very tied to auth system. perhaps the flip side of these 3 is security notifications - new login, new device, changed password. Is there such a thing as "blocking notifications"? - like how Apple makes you confirm on another Apple device when logging in       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 283] 1422580553954512900 1317913795726106625 knocklabs       0 0 3 0 0   en  
1422589948318818306 swyx 33521530 2021-08-03T16:07:28+00:00 @samseely @knocklabs yeah its just 2FA i guess haha. but it pops up unprompted whereas you have to open an app for other kinds of 2FA       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 133] 1422588284987973634 29101388 samseely       0 0 1 0 0   en  
1422590292075499531 swyx 33521530 2021-08-03T16:08:50+00:00 @seerutkchawla such incredible range!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 37] 1422586639591804929 1554622124 seerutkchawla       0 0 7 0 0   en  
1422629085101006848 swyx 33521530 2021-08-03T18:42:59+00:00 @sgrove @ejames_c @temporalio Tracked it down for those following along: https://www.cs.cmu.edu/~crary/819-f09/Hoare78.pdf       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 96] 1422583140845903876 14435843 sgrove       0 0 0 0 0 0 en  
1422633636772270081 swyx 33521530 2021-08-03T19:01:04+00:00 @TikTokInvestors @closenowbro TikTokInvestors is long chaos, direction agnostic       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [30, 79] 1422588355036925957 1295428909538906115 TikTokInvestors       0 0 1 0 0   en  
1422637915637616644 swyx 33521530 2021-08-03T19:18:05+00:00 @mjwhansen @thedailyem i appreciate finely tuned high performance systems whether natural or man made       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 101] 1422636537783754752 21612095 mjwhansen       0 0 3 0 0   en  
1422686539725697024 swyx 33521530 2021-08-03T22:31:17+00:00 @pablankley @brianleroux honestly i have little experience w/ serverless on this scale. just shared the image cause I saw it recently - would defer to @theburningmonk whose image it is, and has ACTUALLY put this into prod there are local mock solutions but nothing on the whole-system level unfortunately       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 305] 1422680823086542848 1148790367862632448 pablankley       0 0 7 0 0   en  
1422694051283828741 swyx 33521530 2021-08-03T23:01:08+00:00 @pablankley @brianleroux (and yes the change-redeploy “dev cycle” is freaking brutal and i didnt figure out a workaround before i left AWS)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 139] 1422680823086542848 1148790367862632448 pablankley       0 0 19 0 0   en  
1422696227968151552 swyx 33521530 2021-08-03T23:09:47+00:00 @cmiller__ @pablankley @brianleroux @theburningmonk @zackkanter dev-staging questions aside, probably worth collecting all your questions and joining @theburningmonk's https://www.productionreadyserverless.com/ which is starting again on aug 26th (i went thru the first cohort so content may have changed some)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [64, 291] 1422694252849598480 4467569955 cmiller__       0 0 8 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]);