tweets

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

34 rows where "created_at" is on date 2021-08-12 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, retweeted, lang

created_at (date) 1 ✖

  • 2021-08-12 · 34 ✖
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
1425618222787686404 swyx 33521530 2021-08-12T00:40:45+00:00 @betterbomb @vercel By 14 my father will finally get his pack of cigarettes and come back       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [20, 89] 1425608082353115140 127461367 betterbomb       0 1 20 0 0   en  
1425624206524379136 swyx 33521530 2021-08-12T01:04:32+00:00 @temporalio something we debated at work that @martinfowler's Event Sourcing article leaves unclear: does Event Sourcing require you to fully reapply each function, or is it enough to just "dedupe" and restore state? https://news.ycombinator.com/item?id=28140598       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 242] 1422424339589189633 33521530 swyx       0 0 2 0 0 0 en  
1425634237361754117 swyx 33521530 2021-08-12T01:44:23+00:00 @rachelnabors this piece by @wes_kao nails how the CBC trend solves for completion https://future.a16z.com/cohort-based-courses/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 106] 1425505298337370112 9550352 rachelnabors       0 0 6 0 0 0 en  
1425648105647607812 swyx 33521530 2021-08-12T02:39:30+00:00 @LinkofHyrule89 @dalmaer @slightlylate i tried building a small IDE with the filesystem API and immediately ran into this: https://github.com/WICG/file-system-access/issues/301 unfortunately i think the security priorities of the browser trump the UX we have come to expect from an Electron app with access to Node.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [39, 286] 1425640090533982213 290147834 LinkofHyrule89       0 0 4 0 0 0 en  
1425648784738983937 swyx 33521530 2021-08-12T02:42:12+00:00 @mjasay @deltajulyhotel “easy to gauge that” severely underestimates how hard it is to assess and attribute output.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [24, 115] 1425613270732267524 7617702 mjasay       0 0 2 0 0   en  
1425654856862167043 swyx 33521530 2021-08-12T03:06:19+00:00 @StringStory @TrungTPhan thats cause he part of the Trung T Fam       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 63] 1425650012415954947 220496287 StringStory       0 0 1 0 0   en  
1425663937014501377 swyx 33521530 2021-08-12T03:42:24+00:00 @simonswiss @tailwindcss weakass punk how are they ever going to learn tailwind with that attitude       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 98] 1425660853420847108 70713547 simonswiss       0 1 3 0 0   en  
1425673473108504576 swyx 33521530 2021-08-12T04:20:18+00:00 RT @eggheadio: Go deep with @supabase In this new course from @signalnerve you'll: 📀 Create a Postgres database 🔐 Authorize users with G… 1425514852999745547 1425514852999745547     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 28 0 0 1   en  
1425677272644677633 swyx 33521530 2021-08-12T04:35:24+00:00 At what point did we stop having fires in fireside chats and when do we get them back       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 85]             0 0 39 0 0   en  
1425684712542982147 swyx 33521530 2021-08-12T05:04:58+00:00 @SoccerMomTrades where were you when i was deep in the ZH rabbit hole in 2011       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [17, 77] 1425683479304491013 1116467354643255296 SoccerMomTrades       0 0 1 0 0   en  
1425685372793618437 swyx 33521530 2021-08-12T05:07:35+00:00 @codechaos_io @github i think it will happen slowly and then quickly. this is the most aggressive move ive seen in a while, remains to be seen if others will jump in with github. habits shift slowly. likely will be generational as well, the younger kids may only ever code on their ipads       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 287] 1425544006163832834 930147194056867842 codechaos_io       0 0 3 0 0   en  
1425689351913021444 swyx 33521530 2021-08-12T05:23:24+00:00 @kwuchu daaaaaamn what a flex       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 29] 1425655874794754058 291911739 kwuchu       0 0 1 0 0   en  
1425706688607260681 swyx 33521530 2021-08-12T06:32:17+00:00 @drikerf @coreyhainesco side note its pretty cool that your URL unfurls to a video!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 83] 1425702492596224002 1227758149 drikerf       0 0 2 0 0   en  
1425707376414392321 swyx 33521530 2021-08-12T06:35:01+00:00 @visakanv @boop Tech specific media sequence for the uninitiated https://medium.com/backchannel/how-the-tech-press-forces-a-narrative-on-companies-it-covers-5f89fdb7793e       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 90] 1425490068274225155 16884623 visakanv       0 0 3 0 0 0 en  
1425707553929908238 swyx 33521530 2021-08-12T06:35:43+00:00 @boop oh so you make product demo videos? Name a background musical instrument that isn't the ukelele       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 101] 1425565963986952193 14782048 boop       0 0 19 0 0   en  
1425711567392317444 swyx 33521530 2021-08-12T06:51:40+00:00 RT @TrungTPhan: 12/ Quick video cut of @elonmusk breaking down SpaceX’s 5-Step design and manufacturing process: https://twitter.com/TrungTPhan/status/1425476793327259651/video/1 1425476793327259651 1425476793327259651     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 136]             0 439 0 0 1 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  
1425739640040947712 swyx 33521530 2021-08-12T08:43:13+00:00 @microsleeep @vorcigernix @vercel markov chain based generation of a single word?! how does this thing work 👀       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [34, 109] 1425738626487435264 2980522001 microsleeep       0 0 0 0 0   en  
1425825423837974545 ppk 🇪🇺 887251 2021-08-12T14:24:06+00:00 Breaking the web forward https://www.quirksmode.org/blog/archives/2021/08/breaking_the_we.html       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 49]             0 45 75 0 1 0 en  
1425825714788503552 James Long 14615235 2021-08-12T14:25:15+00:00 🎉 It's finally ready! I've been hacking on something for the past couple months and it's absurdly great. It's time for more powerful web apps. Announcing "A future for SQL on the web": https://jlongster.com/future-sql-web       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 209]             0 566 2316 0 1 0 en  
1425835851146088460 swyx 33521530 2021-08-12T15:05:32+00:00 @rafahari you are amazing 😻 keep it up!!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 41] 1425814260865658905 42387965 rafahari       0 0 1 0 0   en  
1425838034725969921 swyx 33521530 2021-08-12T15:14:12+00:00 RT @jlongster: 🎉 It's finally ready! I've been hacking on something for the past couple months and it's absurdly great. It's time for more… 1425825714788503552 1425825714788503552     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             0 566 0 0 1   en  
1425853831775129601 honeycomb 4710974593 2021-08-12T16:16:59+00:00 Alex Vondrak unpacks distributed column stores, what they are, how they work, and why they're an absolutely essential requirement for enabling observability. https://go.hny.co/3jJIPSo       HubSpot d78b4a9b46e06ba0d2837568fe022315819e1c30 0 [0, 182]             0 39 245 0 0 0 en  
1425868308708999176 Rob Richardson 18905413 2021-08-12T17:14:30+00:00 https://dev.to/swyx/an-annotated-guide-to-the-react-server-components-demo-2a83 - a look at the #React #Server #Components announcement. Nice tl;dr analysis @swyx       Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 0 [0, 106]             0 4 10 0 1 0 en  
1425877361011027977 swyx 33521530 2021-08-12T17:50:29+00:00 RT @rob_rich: https://dev.to/swyx/an-annotated-guide-to-the-react-server-components-demo-2a83 - a look at the #React #Server #Components announcement. Nice tl;dr analysis @swyx 1425868308708999176 1425868308708999176     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 120]             0 4 0 0 1 0 en  
1425877825165221889 swyx 33521530 2021-08-12T17:52:19+00:00 @trivikram @reactjs @sveltejs @solid_js its great. its supporters get very mad when i say anything else       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [40, 103] 1425865149085224965 21297217 trivikram       0 0 9 0 0   en  
1425889455643119616 swyx 33521530 2021-08-12T18:38:32+00:00 No Apple, I don't have any music on iTunes. No Apple, I don't run my email on Apple Mail. No Apple, I don't need to look up the meaning of a word I accidentally selected and force clicked.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 190]             0 6 87 0 0   en  
1425892922717704192 swyx 33521530 2021-08-12T18:52:19+00:00 Fixes for each: 🚫 iTunes: https://krausefx.com/blog/introducing-overkill-dont-let-itunes-interrupt-your-workflow 🚫 Mail: https://discussions.apple.com/thread/1856375 🚫 Dictionary: https://apple.stackexchange.com/questions/245592/el-capitan-how-to-disable-force-click-dictionary-pop-ups-in-chrome 💁🏽‍♂️ https://twitter.com/swyx/status/1425892922717704192/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 129] 1425889455643119616 33521530 swyx       0 1 31 0 0 0 en  
1425894798477594626 swyx 33521530 2021-08-12T18:59:46+00:00 @QuinnyPig @dabit3 @undef_obj ayy this podcast finally happened!!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 66] 1344467557428809728 97114171 QuinnyPig       0 0 0 0 0   en  
1425924210602352640 swyx 33521530 2021-08-12T20:56:38+00:00 @mscccc i tried it but it seemed too inconvenient to keep standing up and going round to wake it up every time i wanted to webcam. did i do it wrong? does your iphone just always stay on?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 187] 1425917300570460160 99121168 mscccc       0 0 2 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  
1425650503615008777 swyx 33521530 2021-08-12T02:49:02+00:00 @DavidWells @bcomnes https://twitter.com/swyx/status/1425650503615008777/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [20, 20] 1425645160457641986 13638932 DavidWells       0 0 1 0 0 0 und  
1425654648895991811 swyx 33521530 2021-08-12T03:05:30+00:00 @simonswiss @tailwindcss #100DaysOfCode       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 39] 1425585151178776579 70713547 simonswiss       0 1 1 0 0   und  
1425714540159791105 swyx 33521530 2021-08-12T07:03:29+00:00 @mrmrs_ ooh @JoshWComeau       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 24] 1425595423469752327 316589445 mrmrs_       0 0 1 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]);