tweets
1,355 rows where retweeted = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20"
This data as json, CSV (advanced)
Suggested facets: place, is_quote_status, favorited, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
923374215041912833 | Netflix UI Engineers 3018765357 | 2017-10-26T02:22:22+00:00 | Removing client-side React.js (but keeping it on the server) resulted in a 50% performance improvement on our landing page https://twitter.com/NetflixUIE/status/923374215041912833/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 122] | 0 | 2788 | 5358 | 0 | 0 | 0 | en | ||||||||||
1030130810588819456 | swyx 33521530 | 2018-08-16T16:34:58+00:00 | Flashing Lights https://twitter.com/swyx/status/1030130810588819456/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 16] | 1030109644075687936 | 33521530 | swyx | 0 | 0 | 25 | 0 | 0 | 0 | en | |||||||
1039165996676739072 | Sarah Drasner 813333008 | 2018-09-10T14:57:35+00:00 | 🎋The CLI tool I was making is finished! It’s called the project explorer! You can feed it the directory of any repo/project you’re working on and it will give you - a visualization of the tree structure - an ability to annotate files with notes https://sdras.github.io/project-explorer-site/ https://twitter.com/sarah_edo/status/1039165996676739072/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 269] | 0 | 305 | 1743 | 0 | 0 | 0 | en | ||||||||||
1050091276715077632 | swyx 33521530 | 2018-10-10T18:30:44+00:00 | Apollo Engine is the killer app of @apollographql. Never got it until today. This is money 💰 - analytics per field - schema insights - client aware, devtools this is how to “decouple” APIs but reconstitute loose vertical integration through other means, shifting value to them https://twitter.com/swyx/status/1050091276715077632/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 279] | 1050086016676179969 | 33521530 | swyx | 0 | 9 | 34 | 0 | 0 | 0 | en | |||||||
1082513275265310720 | swyx 33521530 | 2019-01-08T05:44:11+00:00 | @cvitullo @tannerlinsley ideally we would be able to publish hooks that arent tied to react. like common hook spec that is shared between frameworks. absolutely no reason to duplicate hooks between frameworks imo. (i realize this is just an ideal...) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 251] | 1082402780332081152 | 72621018 | vcarl_ | 0 | 1 | 6 | 0 | 0 | en | ||||||||
1093670844495089664 | swyx 33521530 | 2019-02-08T00:40:23+00:00 | So so good to have @AirbnbEng open sourcing all their tools and lessons from converting to @typescriptlang! 38% of AirBnb code errors couldve been avoided @reactjs proptypes to typescript utility: https://gist.github.com/brieb/48698aca8565310db4453b9ff875dee3 JScodeshift codemod to convert to TS to be released!! https://twitter.com/swyx/status/1093670844495089664/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 278] | 0 | 76 | 241 | 0 | 0 | 0 | en | ||||||||||
1100275989622505472 | swyx 33521530 | 2019-02-26T06:06:52+00:00 | “It depends” is the answer to most things, but not all “it depends” are created equal. You can - acknowledge the base case - give contrasting examples - explain why the minority thinks they are right - offer (subjective!) predictions Contention is not a license for Equivocation | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 0 | 7 | 41 | 0 | 0 | en | |||||||||||
1113478881086988288 | swyx 33521530 | 2019-04-03T16:30:27+00:00 | @peggyrayzis @ReactAmsterdam - fast - good defaults - incrementally adoptable - timely dev-mode warnings - no excess logs or warnings - considerate of other existing tooling - small API/config surface area - learn once and reuse forever - remembers and adapts to *you* (more: https://gist.github.com/sw-yx/6f97b9d7f3efbfad4c8e5b8a14b5bd27) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [29, 300] | 1113475439601836039 | 711729626482081792 | peggyrayzis | 0 | 3 | 35 | 0 | 0 | 0 | en | |||||||
1134311153960534016 | Lee Byron 14904098 | 2019-05-31T04:10:28+00:00 | Super curious to see how this works out. Historically I’ve been very skeptical of schema federation and the costs it incurs on an org, so I’m hoping to learn from the community on what works and doesn’t work from this new attempt. https://twitter.com/apollographql/status/1134086759489384449 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 230] | 1 | 11 | 82 | 0 | 0 | 0 | en | ||||||||||
1158920626272268289 | joel ⛈ 12087242 | 2019-08-07T01:59:43+00:00 | @swyx Make 5 millionaires. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 26] | 1158902677289472001 | 33521530 | swyx | 0 | 1 | 24 | 0 | 0 | en | ||||||||
1165416075028246528 | swyx 33521530 | 2019-08-25T00:10:19+00:00 | Who are your favorite developer @Instagram follows? just found @thecodercoder via the @IndieHackers podcast. and ofc @lydiahallie is a superstar everywhere she goes. Who else? I feel so out of touch on insta 😂 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 213] | 0 | 1 | 28 | 0 | 0 | en | |||||||||||
1231455889019699200 | Shreyas Doshi 2048741 | 2020-02-23T05:48:57+00:00 | I’m starting to call these the “apple pie positions” => the personal risk of pushing back is so high that almost everyone nods “yes”, even though it is rarely the right answer for the team / company / user. Great example in the quoted Tweet. Will add more in the thread below: https://twitter.com/can/status/1231244204359053312 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 279] | 1 | 241 | 1279 | 0 | 0 | 0 | en | ||||||||||
1360373746897326081 | swyx 33521530 | 2021-02-12T23:42:30+00:00 | re: techronym for “coveted bigco jobs” 🙅🏽♂️ Instead of: FAANG 💁🏻♀️ I submit: MANGA | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 86] | 0 | 0 | 68 | 0 | 0 | en | |||||||||||
1361712610593316866 | swyx 33521530 | 2021-02-16T16:22:40+00:00 | My copy of @ddprrt’s TypeScript in 50 Lessons just arrived! can I just say @smashingmag did a SMASHING job making the book match up to the content?!? This thing is a work of art. Belongs on every @TypeScript-er’s bookshelf. P.S. check out the acknowledgments 😉 https://twitter.com/swyx/status/1361712610593316866/video/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 263] | 0 | 18 | 167 | 0 | 0 | 0 | en | ||||||||||
1372013877731368961 | swyx 33521530 | 2021-03-17T02:36:13+00:00 | their power is growing the singularity approaches https://twitter.com/swyx/status/1372013877731368961/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 50] | 0 | 62 | 984 | 0 | 0 | 0 | en | ||||||||||
1374247809730318336 | Dan Rowden ⚡️ 5264 | 2021-03-23T06:33:04+00:00 | Automate your MRR-in-profile 😄 https://twitter.com/jsjoeio/status/1374212336693641217 | Republic of Mauritius ee9d992aa12a6fa0 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 30] | 1 | 0 | 13 | 0 | 0 | 0 | en | |||||||||
1381242204379701252 | swyx 33521530 | 2021-04-11T13:46:18+00:00 | I’ve tried: Spreaker, Audacy, Player FM, Acast, Airr, Amazon Music, Soundcloud, Podomatic, Apple Podcast, Castbox, Spotify, The Podcast App, Stitcher, Anchor, iHeartRadio, Podbean, Pandora So far @pocketcasts is the least worst of the bunch. listen history isnt searchable :( | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 278] | 1381242202525855745 | 33521530 | swyx | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1393966359197933568 | Austin Rief ☕️ 158610400 | 2021-05-16T16:27:33+00:00 | Paid subscriptions are overrated. As more tools are created to help creators monetize, we’ll find that putting your best content behind a paywall is almost always suboptimal. https://twitter.com/JayCoDon/status/1393958167286095873 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 176] | 1 | 18 | 292 | 0 | 0 | 0 | en | ||||||||||
1418435083237687311 | swyx 33521530 | 2021-07-23T04:57:31+00:00 | Listening to @yishan talk about Terraformation on @jjacobs2’s @mcjpod has me more techno-optimistic than I’ve been in a long time. This man is out here literally taking the VC exponential growth playbook to planting trees to solve climate change. https://my-climate-journey.simplecast.com/episodes/startup-series-terraformation | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 273] | 0 | 2 | 12 | 0 | 0 | 0 | en | ||||||||||
1419128271799656449 | swyx 33521530 | 2021-07-25T02:52:00+00:00 | Has anyone commented on how @LokiOfficial shares so many elements with George Orwell’s 1984? - omniscient central power - free will is a crime - government authority tending… - …a sacred timeline - lead character caught and tortured in special room it’s just missing jet-skis | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 277] | 0 | 0 | 30 | 0 | 0 | en | |||||||||||
1419434119319093250 | swyx 33521530 | 2021-07-25T23:07:20+00:00 | @jgrahamc @threepointone followup question if you will entertain it - at what point do you set aside 2 days to chase down an intermittent bug? because we all have those sitting around somewhere but are never sure if it is a good use of time to tear everything apart like you did. any guidelines? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 297] | 1419369666846330889 | 16402446 | jgrahamc | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1419685851773116418 | swyx 33521530 | 2021-07-26T15:47:38+00:00 | @andrewingram @threepointone @lorendsr haha the “work loop cron job”. i’ve ended up having to pitch that one too many times. why didn’t you trust their scheduled tasks? anything i can dig into there? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [39, 200] | 1419684896428154887 | 9164512 | andrewingram | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1419686460127547397 | swyx 33521530 | 2021-07-26T15:50:03+00:00 | @DavidKPiano @threepointone (our CTO designed Azure’s Durable Task Framework before he left Msft, which is why it’s similar) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [28, 124] | 1419638696844873736 | 992126114 | DavidKPiano | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1419836176681213952 | swyx 33521530 | 2021-07-27T01:44:58+00:00 | Suddenly reminded of this @bcantrill talk: https://youtu.be/30jNsCVLpAE and I think I have my answer - If it takes you 2 days to chase down an intermittent bug, perhaps that *IS* the bug. Even though this talk is 4 years old but feels like @mipsytipsy is beating the same drum today. https://twitter.com/swyx/status/1419434119319093250 | 1419434119319093250 1419434119319093250 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 3 | 15 | 0 | 0 | 0 | en | |||||||||
1420012738412220425 | Amanda Goetz 23698119 | 2021-07-27T13:26:34+00:00 | Things I know at 35, I wish I had known at 25. 🧵/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 52] | 0 | 8283 | 34444 | 0 | 0 | en | |||||||||||
1420118742898380801 | swyx 33521530 | 2021-07-27T20:27:47+00:00 | @BenLesh github follows > twitter follows, this is straight facts | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 68] | 1420065552505114628 | 23795212 | BenLesh | 0 | 0 | 40 | 0 | 0 | en | ||||||||
1420119069324300291 | swyx 33521530 | 2021-07-27T20:29:05+00:00 | @willklein_ i need question prompts for a blogpost! esp from new dev advocates like @Nutlope @kevmodrome and @jkup. what are your nonobvious concerns and questions! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 164] | 1420099879481667584 | 17496447 | willklein_ | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1420126851314323456 | swyx 33521530 | 2021-07-27T21:00:00+00:00 | @DavidAMaier @temporalio awesome!! @code_barbarian is ramping up more samples and docs on our Node SDK, perhaps a good opportunity to make sure our stuff speaks to your usecases. Join the slack (http://temporal.io/slack) and give feedback anytime! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 246] | 1420120479428399110 | 1200337361734946817 | DavidAMaier | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1420136958416678912 | swyx 33521530 | 2021-07-27T21:40:10+00:00 | @zpao ooh you doing much CNCF work? we’ve just joined at the startup tier… trying to figure out how to navigate this behemoth ecosystem | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 135] | 1420136460087218180 | 764166 | zpao | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1420174513824620546 | swyx 33521530 | 2021-07-28T00:09:24+00:00 | @monicalimco look at my blog analytics lol | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 42] | 1419848153428234248 | 1265436714136297473 | monicalimco | 0 | 0 | 22 | 0 | 0 | en | ||||||||
1420211877276049408 | swyx 33521530 | 2021-07-28T02:37:52+00:00 | @matiasfha @Rich_Harris @stolinski @gndx Svelte also has one way data flow under the hood, but uses binding and syntax sugar to simulate LOCAL two way data flow. its not that different. data propagation with stores vs context however are very different. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [41, 255] | 1420201456108441603 | 12816182 | matiasfha | 0 | 2 | 24 | 0 | 0 | en | ||||||||
1420235876483813378 | swyx 33521530 | 2021-07-28T04:13:14+00:00 | @lesliecdubs @tiberriver256 wow what a well written blogpost | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [28, 60] | 1420188172726771714 | 22217773 | lesliecdubs | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1420309857895272456 | swyx 33521530 | 2021-07-28T09:07:12+00:00 | @Andy_W_Farrell @maxlynch @benedictfritz and yet. any company large enough is not homogeneous. they can use multiple frameworks in different apps. willing to bet that react is majority of greenfield. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [41, 199] | 1420167119337967620 | 17500142 | Andy_W_Farrell | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1420538889102495744 | swyx 33521530 | 2021-07-29T00:17:18+00:00 | @lmatteis how will Storybook make money from their great market share? 🤔 @domyen keen on how you monetize this, i think its super challenging but potentially huge if done right | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 176] | 1420298810266370048 | 281950081 | lmatteis | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1420614194265686017 | swyx 33521530 | 2021-07-29T05:16:32+00:00 | Met @Aella_Girl today and experienced that rare feeling when someone collects better questions than I do. It was unnerving and exciting at the same time. Check hers out: https://www.askhole.io The right question at the right time in your life can be a Nexus event. https://twitter.com/swyx/status/1349271110492196870 | 1349271110492196870 1349271110492196870 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 268] | 1 | 0 | 13 | 0 | 0 | 0 | en | |||||||||
1420642639037091841 | swyx 33521530 | 2021-07-29T07:09:34+00:00 | Reflections on 10 years of Containers, from Bryan Cantrill some history at the start https://youtu.be/xXWaECk9XqM | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 110] | 1381331610319036416 | 33521530 | swyx | 0 | 0 | 6 | 0 | 0 | 0 | en | |||||||
1420794468379226121 | swyx 33521530 | 2021-07-29T17:12:53+00:00 | @domyen @CodyBontecou @lmatteis @chromaui @storybookjs ayyy secret master plan! i love it | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [55, 89] | 1420784518118641668 | 274703970 | domyen | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1421138057940529156 | swyx 33521530 | 2021-07-30T15:58:11+00:00 | @txase can i enquire more about what the lambda triggers? is this for a “work loop”? have you explored Step Functions? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 118] | 1421122672054788101 | 112043917 | txase | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1421140683021164558 | swyx 33521530 | 2021-07-30T16:08:37+00:00 | I think this was the second last React talk I ever gave. Still pretty happy with it, check it out if you’re interested in how “linguistics” and developer experience cross paths (and explain the trends in our evolving tooling) https://twitter.com/iBakasura/status/1421095739195756549 | 1421095739195756549 1421095739195756549 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 226] | 1 | 0 | 2 | 0 | 0 | 0 | en | |||||||||
1421144382283993089 | swyx 33521530 | 2021-07-30T16:23:18+00:00 | @dalmaer but was it cheeky | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 26] | 1420982293498269696 | 4216361 | dalmaer | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1421190477571710978 | swyx 33521530 | 2021-07-30T19:26:28+00:00 | this is incredible to watch. I thought that Flippa/Empire Flippers had cornered this sleepy market, but Andrew is shaking it up with his infectious energy and focus. Building a credible “Zestimate for SaaS” is going to set this thing on 🔥 https://twitter.com/agazdecki/status/1421069160973434880 | 1421069160973434880 1421069160973434880 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 239] | 1 | 2 | 31 | 0 | 0 | 0 | en | |||||||||
1421229372581634048 | swyx 33521530 | 2021-07-30T22:01:02+00:00 | @threepointone thank u next | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 27] | 1421133866446827530 | 1593171 | threepointone | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1421229828636774400 | swyx 33521530 | 2021-07-30T22:02:50+00:00 | @acdlite @reactjs gotcha, ok will not emphasize their relationship to testing going forward, thank you | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 102] | 1421226595994456065 | 21782915 | acdlite | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1421234899181215751 | swyx 33521530 | 2021-07-30T22:22:59+00:00 | @acdlite @reactjs yes this does make sense! fixtures that don’t work bc they are out of date are just dead weight. continuous e2e on them is a great principle. and no i totally get that you just want to offer the right perspective since, well, you work on the team 😂 so it is hugely appreciated | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 295] | 1421234029983059972 | 21782915 | acdlite | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1421235379533877248 | swyx 33521530 | 2021-07-30T22:24:54+00:00 | @acdlite @reactjs my main agenda is I think more OSS projects should adopt/offer fixtures to improve the quality of bug reports, since minimal repros always help (and was the main thing @b0rk was asking in the original thread) so just offered up React the best known example I knew | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 282] | 1421234899181215751 | 33521530 | swyx | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1421397550678958087 | swyx 33521530 | 2021-07-31T09:09:19+00:00 | @jeronevw @code @stolinski i dont think this one can do that but its open source if you wanna fork and add | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 106] | 1421343066087112706 | 7609652 | jeronevw | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1421507359285805061 | swyx 33521530 | 2021-07-31T16:25:39+00:00 | Just finished #SpiderManPS5: Miles Morales. This game is still a work of art. Stealth elements from Batman, Parkour from Assassin’s Creed, and the exaggerated swagger of a black teen. https://twitter.com/swyx/status/1421507359285805061/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 183] | 0 | 0 | 55 | 0 | 0 | 0 | en | ||||||||||
1421507508384923650 | swyx 33521530 | 2021-07-31T16:26:14+00:00 | @ericpgreen2 my youtube is now just recommending his greatest hits lol | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 70] | 1421397701908959234 | 623904970 | ericpgreen2 | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1421508501990350848 | swyx 33521530 | 2021-07-31T16:30:11+00:00 | @rickhanlonii @b0rk @reactjs @stevekinney @temporalio ah yeah Andrew offered a lot more context in the other thread. I was mainly thinking of the DOM fixture https://github.com/facebook/react/tree/main/fixtures/dom which I was pretty inspired by when I saw it. Definitely got too excited and shouldnt overstate the role of fixtures in your process! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [54, 318] | 1421443276717109253 | 244965762 | rickhanlonii | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1421693652225589254 | swyx 33521530 | 2021-08-01T04:45:55+00:00 | @Nutlope 7guis is explicitly frontend focused, you’re more going for full stack so make your own eg in @alexbdebrie’s book he has 4 increasingly harder projects finishing in building a github clone | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 198] | 1421687846428020737 | 3246815913 | Nutlope | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1421693817523105792 | swyx 33521530 | 2021-08-01T04:46:34+00:00 | @ritakozlov_ CAT. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 17] | 1421489656827301896 | 232076816 | ritakozlov_ | 0 | 0 | 4 | 0 | 0 | und | ||||||||
1421989921766576129 | swyx 33521530 | 2021-08-02T00:23:11+00:00 | @mjg59 i am not familar with your work; can you define coherent? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 64] | 1421762581186760705 | 229502009 | mjg59 | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1421990195281334274 | swyx 33521530 | 2021-08-02T00:24:16+00:00 | @mjg59 (in the context of free software and your assertion that the younger generation is not coherent) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 103] | 1421989921766576129 | 33521530 | swyx | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1422290513269428246 | swyx 33521530 | 2021-08-02T20:17:37+00:00 | @petecodes @Coding_Career @IndieHackers real, automated email | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [40, 61] | 1422287229217656836 | 2930544074 | petecodes | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1422372693827985409 | Svelte Society 🧡 1176969867733479424 | 2021-08-03T01:44:11+00:00 | 🧡🧡🧡 ICYMI: @Sveltejs was just voted the most loved framework at the 2021 @StackOverflow developer survey! https://insights.stackoverflow.com/survey/2021 🧡🧡🧡 https://twitter.com/SvelteSociety/status/1422372693827985409/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 136] | 0 | 39 | 182 | 0 | 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 | ||||||||
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 | ||||||||
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 | ||||||||
1422642885162242048 | swyx 33521530 | 2021-08-03T19:37:49+00:00 | Holy shit. @Sveltejs rocketed to the top of the @StackOverflow survey this year (and I wasnt even aware of the survey so I didnt vote/promote it) https://twitter.com/SvelteSociety/status/1422372693827985409 | 1422372693827985409 1422372693827985409 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 145] | 1414617653386178563 | 33521530 | swyx | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
1422645006385352709 | swyx 33521530 | 2021-08-03T19:46:15+00:00 | Periodic reminder that if you run a podcast or blog I’d love to join you and talk about @Temporalio! Just get in touch, either DM or email (in bio) https://twitter.com/ejames_c/status/1422430127212744704 | 1422430127212744704 1422430127212744704 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 149] | 1 | 0 | 1 | 0 | 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 | ||||||||
1422797562235424770 | swyx 33521530 | 2021-08-04T05:52:27+00:00 | @boop @Duderichy 60-600 feral hogs 600000 tomatoes | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 50] | 1422652951152132097 | 14782048 | boop | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1422818721349857284 | swyx 33521530 | 2021-08-04T07:16:32+00:00 | @Rich_Harris @ctjlewis let us see the list of features that didnt make the cut!!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 81] | 1422754771941928962 | 19487837 | Rich_Harris | 0 | 0 | 22 | 0 | 0 | en | ||||||||
1422935724135915522 | swyx 33521530 | 2021-08-04T15:01:28+00:00 | @theburningmonk ya exactly. i left out any commentary because i thought itd be funnier to just reply with an image but the complexity of AWS charts often comes from putting a logo on every function that used to be on the same machine. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 234] | 1422896044057190410 | 245821992 | theburningmonk | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1422964616099815424 | swyx 33521530 | 2021-08-04T16:56:16+00:00 | @RandallKanna congrats and so happy for you two! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 48] | 1422771476864798722 | 206918128 | RandallKanna | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1423078718633766913 | swyx 33521530 | 2021-08-05T00:29:40+00:00 | @RandallKanna you dropped this 👑 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 32] | 1423005314803138562 | 206918128 | RandallKanna | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1423079363289878535 | swyx 33521530 | 2021-08-05T00:32:14+00:00 | @ashleymayer @akageleiry sounds like a job for that highest of literary art forms: 🧵👇 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 85] | 1422975926921437184 | 18994034 | ashleymayer | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1423309470227075073 | swyx 33521530 | 2021-08-05T15:46:36+00:00 | @brian_lovin loll cheeky @graphcdn plug there | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 45] | 1423003865247408136 | 465068802 | brian_lovin | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1423392137257775105 | swyx 33521530 | 2021-08-05T21:15:05+00:00 | @TheEhsanSarshar yes very easily there are a few ways to do it | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 62] | 1423389685410320384 | 1269951243272806401 | TheEhsanSarshar | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1423489319247880193 | swyx 33521530 | 2021-08-06T03:41:15+00:00 | @Nutlope @designkojo yup its probably what you were gonna do anyway but giving yourself explicit permission to f around 20% of the time helps quieten your mind the remaining 80% | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [21, 177] | 1423485414246010880 | 3246815913 | Nutlope | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1423563198662250496 | swyx 33521530 | 2021-08-06T08:34:49+00:00 | @TheProtegeMovie Nikita was greatly underrated but also I’m ready for Maggie Q to explore new characters than the same one she’s played for like 15 years | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 153] | 1421174056770883588 | 1386839088792100866 | TheProtegeMovie | 0 | 1 | 2 | 0 | 0 | en | ||||||||
1423583340356018181 | swyx 33521530 | 2021-08-06T09:54:51+00:00 | @geoffreylitt he makes the odd podcast appearance btw https://overcast.fm/+FhW-ynXUE always a good listen | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 98] | 1423410924803743744 | 221658618 | geoffreylitt | 0 | 0 | 0 | 0 | 0 | 0 | en | |||||||
1423774651965087755 | swyx 33521530 | 2021-08-06T22:35:04+00:00 | @ajones55555 @arahansen thats what China is for, no? (j/k, but also kinda) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 76] | 1423772014108684298 | 1238346507973246976 | ajones55555 | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1423774845972615168 | swyx 33521530 | 2021-08-06T22:35:50+00:00 | @cassidoo @ania_kubow @MikeJudeLarocca @jamesqquick @DThompsonDev @designcoursecom @KevinJPowell @codeSTACKr @DevSimplified @PizzaPokerGuy @ErikCH @selfteachme @thecodercoder @traversymedia @developedbyed @AnnaJMcDougall @simpleprogrammr ayyy shall we start a TV show together | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [238, 276] | 1423703611494830083 | 400286802 | cassidoo | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1423895862166523906 | swyx 33521530 | 2021-08-07T06:36:42+00:00 | @supabase ↪️⬇️4️⃣ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 17] | 1423876852632989699 | 1219566488325017602 | supabase | 0 | 0 | 2 | 0 | 0 | und | ||||||||
1423896261749395459 | swyx 33521530 | 2021-08-07T06:38:18+00:00 | @jeanqasaur haha wow you have a lot of FP fans in the house | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 59] | 1423740761162477572 | 271516623 | jeanqasaur | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1423896518440804355 | swyx 33521530 | 2021-08-07T06:39:19+00:00 | @anildash if you go to the dark side it might even cost you an arm and a leg | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 76] | 1423878718695563267 | 36823 | anildash | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1423896593342730245 | swyx 33521530 | 2021-08-07T06:39:37+00:00 | @cherthedev hai | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 15] | 1423893422776016896 | 15790639 | cherthedev | 0 | 0 | 8 | 0 | 0 | und | ||||||||
1423897482279329800 | swyx 33521530 | 2021-08-07T06:43:09+00:00 | omg heres the latest IETF spec with tons more all professionally analyzed! https://www.ietf.org/id/draft-peabody-dispatch-new-uuid-format-01.html https://twitter.com/swyx/status/1423897482279329800/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 99] | 1352579686581190656 | 33521530 | swyx | 0 | 1 | 23 | 0 | 0 | 0 | en | |||||||
1424173432539811845 | swyx 33521530 | 2021-08-08T00:59:40+00:00 | @KentonVarda @DavidKPiano @threepointone @sergeybykov yes i thought very Black Mirror-ey but seems to have caught on | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [54, 116] | 1424170425102307331 | 17459118 | KentonVarda | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1424198548720029698 | swyx 33521530 | 2021-08-08T02:39:29+00:00 | useful taxonomy of approaches to naming things: - Functional / Descriptive (BMW) - Invented (eg Agilent) - Experiential (eg Infoseek) - Evocative (eg Uber) With the same note on Apple https://www.igorinternational.com/process/i/Igor-naming-guide-AugustP-1-2021.pdf https://twitter.com/swyx/status/1424198548720029698/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 211] | 1418034673150685185 | 33521530 | swyx | 0 | 0 | 7 | 0 | 0 | 0 | en | |||||||
1424199362024931328 | swyx 33521530 | 2021-08-08T02:42:42+00:00 | i really like the “Name Evaluation” and “Happy Idiot” sections of this guide. https://twitter.com/swyx/status/1424198548720029698 https://twitter.com/swyx/status/1424199362024931328/photo/1 | 1424198548720029698 1424198548720029698 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 101] | 1383881255264034820 | 33521530 | swyx | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
1424275234555715589 | swyx 33521530 | 2021-08-08T07:44:12+00:00 | @FredKSchott instant bucket list addition | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 41] | 1424050022505582595 | 1308732128 | FredKSchott | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1424282103127019521 | swyx 33521530 | 2021-08-08T08:11:29+00:00 | @SRuhleder thanks Sebastian :) yeah i try to introduce stuff from my Chinese heritage where i can. Western folks usually enjoy it as they have never heard this stuff that has been around for like 4000 years | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 206] | 1424278395739910145 | 1298880717749997570 | SRuhleder | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1424282248396697606 | swyx 33521530 | 2021-08-08T08:12:04+00:00 | @SRuhleder another concept if you are interested https://twitter.com/suolaric/status/1333068794881859585 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 48] | 1424282103127019521 | 33521530 | swyx | 1 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1424283657049579523 | swyx 33521530 | 2021-08-08T08:17:40+00:00 | @TikTokInvestors @BillSPACman pet rock was the original nft craze | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [30, 65] | 1424114476169768962 | 1295428909538906115 | TikTokInvestors | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1424284656074039296 | swyx 33521530 | 2021-08-08T08:21:38+00:00 | @stephsmithio Otter - live closed captioning + notetaking @excalidraw - collaborative virtual whiteboard @streamyardapp - superimpose banners, highlight comments, stream to other social platforms | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 197] | 1424063610402185219 | 626691391 | stephsmithio | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1424310472350654464 | swyx 33521530 | 2021-08-08T10:04:13+00:00 | @simonw tragedy of the critical bug commons: if everyone waits a few weeks before upgrades then the purpose of waiting a few weeks before upgrades is defeated! optimal - round robin upgrades to share bug discovery load? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 220] | 1424078556406042625 | 12497 | simonw | 0 | 1 | 3 | 0 | 0 | en | ||||||||
1424310756678402053 | swyx 33521530 | 2021-08-08T10:05:21+00:00 | @dabit3 @ken_wheeler https://twitter.com/swyx/status/1424310756678402053/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [20, 20] | 1424099739176521735 | 17189394 | dabit3 | 0 | 0 | 0 | 0 | 0 | 0 | und | |||||||
1424563731376218112 | swyx 33521530 | 2021-08-09T02:50:35+00:00 | @BenAPatton have kids? 😅 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 24] | 1424545214438465540 | 999866712739676160 | BenAPatton | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1424606257298636805 | swyx 33521530 | 2021-08-09T05:39:34+00:00 | @ShaanVP ah this is right up my alley. you ever look at @budibase? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 66] | 1424504804282302464 | 101354595 | ShaanVP | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1424606536878366720 | swyx 33521530 | 2021-08-09T05:40:40+00:00 | @benmlevy being specific on the startup would help as i have no idea what it is… | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 80] | 1409691967332646917 | 192452506 | benmlevy | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1424606662137053184 | swyx 33521530 | 2021-08-09T05:41:10+00:00 | @ejames_c got it last week. only mild weakness on day 1. hang in there | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 70] | 1424382463124525071 | 14243237 | ejames_c | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1424607897191809026 | swyx 33521530 | 2021-08-09T05:46:05+00:00 | @tmcw weekend bloggers are the real ones | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 40] | 1424513663592017929 | 1458271 | tmcw | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1424608160355024900 | swyx 33521530 | 2021-08-09T05:47:08+00:00 | @thecodercoder can you do this but put a big WASTED gta style and fade to black | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 79] | 1424370059342802947 | 881161050011430912 | thecodercoder | 0 | 0 | 19 | 0 | 0 | en | ||||||||
1424615710517460996 | swyx 33521530 | 2021-08-09T06:17:08+00:00 | @obfuscurity @Netlify yay congrats! 🔥🐥 (you’ll get this eventually) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 67] | 1424401542178869249 | 66432490 | obfuscurity | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1424619085824806916 | swyx 33521530 | 2021-08-09T06:30:32+00:00 | @BenLesh @buildsghost @threepointone relevant quote about the “God” object created by 10x programmers, from a @tef_ebooks talk i recently saw https://twitter.com/coding_career/status/1424175453376376834?s=21 | 1424175453376376834 1424175453376376834 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [37, 165] | 1424379521525035010 | 23795212 | BenLesh | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
1424751510995406850 | Gergely Orosz 30192824 | 2021-08-09T15:16:45+00:00 | While EU companies are pondering if €80K/year for a senior engineer is too much or not, more (US) VC-funded ones are starting to offer €120K ($140-150K) and up *plus* equity for seniors in Europe. Here’s an example with @RevenueCat, who pay location independent. https://twitter.com/GergelyOrosz/status/1424751510995406850/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 263] | 0 | 75 | 588 | 0 | 0 | 0 | en |
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]);