tweets
20 rows where "created_at" is on date 2021-09-11 and possibly_sensitive = 0
This data as json, CSV (advanced)
Suggested facets: user, quoted_status, source, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1436520685778530307 | AWS Weweases Made Howwibwe 1436382868591165445 | 2021-09-11T02:43:15+00:00 | AWS PawawwewCwustew nyow suppowts cwustew manyagement thwough Amazon API Gateway Amazon PawawwewCwustew is a fuwwy suppowted and maintainyed open souwce cwustew manyagement toow that makes it easiew fow scientists, weseawchews, and IT adminyist... https://aws.amazon.com/about-aws/whats-new/2021/09/aws-parallelcluster-cluster-management-api-gateway/ | AWS Cwoud Weweases 7a22e1ca18d57e07b81ea13350e2b9f2cade0008 | 0 | [0, 272] | 0 | 1 | 5 | 0 | 0 | 0 | en | ||||||||||
| 1436594934002458626 | swyx 33521530 | 2021-09-11T07:38:17+00:00 | I’d really love to hear behind the scenes on GitHub’s decision to launch this shortcut. The obvious downside: launching an expensive action on a single keypress may negatively surprise users. The upside: the barrier to using Codespaces can’t be lower. I use it once a day now. https://twitter.com/github/status/1425505817827151872 | 1425505817827151872 1425505817827151872 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 278] | 1 | 1 | 80 | 0 | 0 | 0 | en | |||||||||
| 1436602844216500227 | swyx 33521530 | 2021-09-11T08:09:43+00:00 | Enjoying @corywilkerson’s explanation of “.dev” on @changelog https://changelog.com/podcast/459 they dont quite go into whether there was any internal resistance to the shortcut (@ 40mins in), but loved learning about the Github Computer Club and the minor tips (dotfiles, linking vscode) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1436594934002458626 | 33521530 | swyx | 0 | 0 | 9 | 0 | 0 | 0 | en | |||||||
| 1436603173133770752 | swyx 33521530 | 2021-09-11T08:11:01+00:00 | @simonw swap URLs to swap UIs/apps! i’ve enjoyed documenting some of these in the past, mostly userland: https://twitter.com/swyx/status/1360316059987808256?s=21 | 1360316059987808256 1360316059987808256 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 129] | 1436597379101118466 | 12497 | simonw | 1 | 0 | 6 | 0 | 0 | 0 | en | ||||||
| 1436628297039982592 | swyx 33521530 | 2021-09-11T09:50:51+00:00 | Incredible discussion of platform economics and YouTube optimization by @veritasium: https://www.youtube.com/watch?v=S2xHZPH5Sng Non-obvious conflict: subscriptions (follows) vs recommendations (feed). Every ad supported platform wants to maximize time on site, which means the feed eventually wins. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 3 | 29 | 0 | 0 | 0 | en | ||||||||||
| 1436643604085235714 | swyx 33521530 | 2021-09-11T10:51:41+00:00 | @smc90 tries to get @BillCarr89 to defend "Are Right A Lot" in this podcast/blogpost on Future dot com and i'm sorry but blaming your direct reports for letting you ignore them is pretty damn toxic wtf https://future.a16z.com/podcasts/working-backwards-amazon-bezos-memos-releases-narratives/ https://twitter.com/swyx/status/1436643604085235714/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 226] | 1390439828571922432 | 33521530 | swyx | 0 | 0 | 11 | 0 | 0 | 0 | en | |||||||
| 1436660689892872192 | swyx 33521530 | 2021-09-11T11:59:34+00:00 | @DavidKPiano @Zephraph 👀 https://twitter.com/davidkpiano/status/1200507988529860609?s=21 | 1200507988529860609 1200507988529860609 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 48] | 1436651833448075265 | 992126114 | DavidKPiano | 1 | 0 | 2 | 0 | 0 | 0 | und | ||||||
| 1436671026797027339 | swyx 33521530 | 2021-09-11T12:40:39+00:00 | @peer_rich @vercel @awscloud haaave you met @begin? open source, deploy on your account or theirs. http://begin.com | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [29, 122] | 1436624637828509698 | 1004742187 | peer_rich | 0 | 0 | 20 | 0 | 0 | 0 | en | |||||||
| 1436689311315890177 | swyx 33521530 | 2021-09-11T13:53:18+00:00 | Never thought I would see a frontend eng team celebrate shipping a static marketing site with 847kb of JS. Until I saw what it used to be… https://www.notion.so/blog/migrating-notion-marketing-to-next-js https://twitter.com/swyx/status/1436689311315890177/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 164] | 0 | 166 | 1501 | 0 | 0 | 0 | en | ||||||||||
| 1436698456416931843 | swyx 33521530 | 2021-09-11T14:29:39+00:00 | @MaOberlehner @leeerob did you have 3g on? thats maybe why? i feel like there are enough claims being made here that http://notion.so/product may warrant a good ol’ @slightlylate audit | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 184] | 1436697499104915458 | 334873854 | MaOberlehner | 0 | 0 | 0 | 0 | 0 | 0 | en | |||||||
| 1436708762115473411 | Alex Russell 229237555 | 2021-09-11T15:10:36+00:00 | @swyx <but_why.gif> https://twitter.com/slightlylate/status/1436708762115473411/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 25] | 1436707990933958657 | 229237555 | slightlylate | 0 | 3 | 38 | 0 | 0 | 0 | en | |||||||
| 1436709370457436162 | swyx 33521530 | 2021-09-11T15:13:01+00:00 | @slightlylate i was wondering how closely or casually this statement was made (usually its just the HIPPO) and if i can send them my brochure saying otherwise https://twitter.com/swyx/status/1317635707838496768?s=21 | 1317635707838496768 1317635707838496768 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 182] | 1436708762115473411 | 229237555 | slightlylate | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
| 1436712591292829697 | swyx 33521530 | 2021-09-11T15:25:49+00:00 | Since @QwikDev serializes all its state onto HTML, the question arises what to do with unserializable state. Chanced upon Dan’s comment today: “This is what doomed ASP .NET WebForms, and we'd like to learn from their mistakes rather than repeat them.” https://github.com/reactjs/rfcs/pull/188#issuecomment-824139957 https://twitter.com/swyx/status/1436712591292829697/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 277] | 1435223333398843397 | 33521530 | swyx | 0 | 0 | 4 | 0 | 0 | 0 | en | |||||||
| 1436716037202980868 | swyx 33521530 | 2021-09-11T15:39:30+00:00 | @simonw i genuinely think this one assumption made many remaining decisions for them: https://twitter.com/slightlylate/status/1436708762115473411?s=20 I hear unexamined assumptions like these a lot and people don't realize these are far weightier decisions than they seem at first glance. Rhyme shortcircuits reason. | 1436708762115473411 1436708762115473411 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 276] | 1436710644045152262 | 12497 | simonw | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
| 1436720513049669632 | swyx 33521530 | 2021-09-11T15:57:17+00:00 | I'm no perf expert or perf shamer (let he who is without sin...) But here's what I do believe: 1. local Lighthouse runs are not credible. Use webpagetest or http://web.dev/measure. 2. you do NOT have to use the same tech for app and site! :) https://twitter.com/swyx/status/1317635707838496768?lang=en | 1317635707838496768 1317635707838496768 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 1436689311315890177 | 33521530 | swyx | 1 | 10 | 159 | 0 | 0 | 0 | en | ||||||
| 1436723434659237894 | swyx 33521530 | 2021-09-11T16:08:54+00:00 | @NHeinDev twitter search :) https://twitter.com/search?q=from%3Aswyx%20narrow%20interests&src=typed_query | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 51] | 1436721662704107522 | 1333059155154907138 | NHeinDev | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
| 1436732249110614018 | swyx 33521530 | 2021-09-11T16:43:56+00:00 | @TayTayTrey go thru the past speaker lists of https://perfnow.nl/ and @estellevw’s https://perfmattersconf.com/ and follow the speakers who speak to you. @smashingmag also has good authors/speakers and probably a book or three. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 226] | 1436722732079595524 | 890053290 | TayTayTrey | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
| 1436736035698921475 | swyx 33521530 | 2021-09-11T16:58:58+00:00 | @spitleaf ayy great minds https://twitter.com/swyx/status/1436733804174008321?s=21 that said you have to admit React is a convenient honeypot/scapegoat for sloppy webdevs who really should know better. this is what i take alex russell to mean when he says the problem is cultural. | 1436733804174008321 1436733804174008321 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 248] | 1436734568313335808 | 357427736 | spitleaf | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
| 1436776365823598595 | swyx 33521530 | 2021-09-11T19:39:14+00:00 | Lighthouse is great but the fact that you can get such wildly different results on the exact same site is just actively counterproductive. The default experience has you “holding it wrong” and none of the impt info is in the screenshot. Dear @ChromeDevTools, you CAN fix this. https://twitter.com/swyx/status/1436776365823598595/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 277] | 1436733804174008321 | 33521530 | swyx | 0 | 1 | 38 | 0 | 0 | 0 | en | |||||||
| 1436777099608666122 | swyx 33521530 | 2021-09-11T19:42:09+00:00 | @adriendenat https://developers.google.com/web/tools/chrome-user-experience-report https://web.dev/vitals/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 61] | 1436775019619700754 | 45521599 | adriendenat | 0 | 0 | 2 | 0 | 0 | 0 | und |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);