tweets

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

154 rows where retweet_count = 2 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

retweeted 2 ✖

  • 0 28
  • 1 26

retweet_count 1 ✖

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
1453508738241814533 swyx 33521530 2021-10-27T23:47:42+00:00 For Developer Experience peeps: I met @Silassao at KubeCon recently and he was thinking thru a lot of the same problems at @DataStax. We had a recorded conversation today about how we're using feature mapping to harmonize the DX for @Temporalio! https://youtu.be/ddKDPikKbNk       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 272]             0 2 11 1 0 0 en  
1453804507385634817 swyx 33521530 2021-10-28T19:22:59+00:00 Zuck ES Modules 🤝 putting everything in meta       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 79]             0 2 61 0 0   en  
1454251874849202185 swyx 33521530 2021-10-30T01:00:40+00:00 Cloudflare rounding up the Jobs to Be Done of Cloud (i have a separate post on that) https://twitter.com/cloudflaredev/status/1454092772177235972   1454092772177235972 1454092772177235972   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 109] 1450539279973699586 33521530 swyx       1 2 19 0 0 0 en  
1455648587459612674 swyx 33521530 2021-11-02T21:30:42+00:00 *and REWARDED. Reward aligned ownership please! can't believe i left that out 🤦‍♂️ also i am somewhat making fun of myself because my weakness really *is* that I care too much i guess what i'm saying is @paparoach has a standing offer to work with us https://www.youtube.com/watch?v=eHbNU9WuVgw       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1455632170312089601 33521530 swyx       0 2 33 0 0 0 en  
1456035423231242240 swyx 33521530 2021-11-03T23:07:51+00:00 @JoshuaKGoldberg @CascadiaJS amazing talk!! and nice #LearnInPublic shoutout!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [29, 77] 1455708121104621574 2551208653 JoshuaKGoldberg       0 2 3 0 0   en  
1456915351241990145 Lou ☁️ 👨‍💻🏋️‍♂️🎸🚴🏻‍♂️🏍 1290693397 2021-11-06T09:24:22+00:00 In some senses, I do think he's right ✅ @swyx did a good job of outlining the problem. When we're new to content and/or tech it feels natural to write "beginner content" or sometimes meta-content (content about content—wait, that's *this thread* 😱 😆) https://www.swyx.io/meta-creator-ceiling/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 276] 1456915349639680008 1290693397 loujaybee       0 2 6 1 1 0 en  
1457002741113319430 swyx 33521530 2021-11-06T15:11:37+00:00 RT @loujaybee: In some senses, I do think he's right ✅ @swyx did a good job of outlining the problem. When we're new to content and/or tec… 1456915351241990145 1456915351241990145     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             0 2 0 1 1   en  
1457466032365445120 Zev Averbach 38199764 2021-11-07T21:52:35+00:00 gratitude to @swyx for his excellent, usually bite-sized podcast: https://swyx.transistor.fm/ always amazed by his prolificity, but the value he crams into these 10-minute episodes is 🔥       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 183]             0 2 13 1 1 0 en  
1457471762258546691 swyx 33521530 2021-11-07T22:15:21+00:00 RT @zevav: gratitude to @swyx for his excellent, usually bite-sized podcast: https://swyx.transistor.fm/ always amazed by his prolificity, bu… 1457466032365445120 1457466032365445120     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 2 0 1 1 0 en  
1457535446674718725 Mark Erikson 727704217012604928 2021-11-08T02:28:24+00:00 I spent the afternoon hacking on the experimental RTK "action listener middleware" API. After applying multiple suggestions, I'm excited to report that: **it now has support for long-running async workflows!** Changelog, discussion, and "docs" here: https://github.com/reduxjs/redux-toolkit/discussions/1648#discussioncomment-1603347       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 277]             0 2 32 1 1 0 en  
1457543817964392458 swyx 33521530 2021-11-08T03:01:40+00:00 RT @acemarke: I spent the afternoon hacking on the experimental RTK "action listener middleware" API. After applying multiple suggestions,… 1457535446674718725 1457535446674718725     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             0 2 0 1 1   en  
1457803089230974983 Changelog 90286855 2021-11-08T20:11:55+00:00 📢 We had @swyx on The Changelog! 1️⃣ Why learn in public 2️⃣ The dark side of the #API economy 3️⃣ @Cloudflare's Go game vs @awscloud's Chess 4️⃣ The #frontend pay ceiling & his move to the back 5️⃣ What @temporalio is about This is a good one! http://changelog.fm/467       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 274]             0 2 7 1 1 0 en  
1457804131762991104 swyx 33521530 2021-11-08T20:16:04+00:00 RT @changelog: 📢 We had @swyx on The Changelog! 1️⃣ Why learn in public 2️⃣ The dark side of the #API economy 3️⃣ @Cloudflare's Go game vs… 1457803089230974983 1457803089230974983     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 2 0 1 1   en  
1458630426709442562 Mark Erikson 727704217012604928 2021-11-11T02:59:28+00:00 In the spirit of "working in public", but also "I'm human" and "ARGH THIS IS BROKEN SOMEONE HELP ME": I've spent the last few days trying to rewrite the new RTK middleware types. Thus far I have completely failed. The _horribly_ hacked-up code is here: https://github.com/reduxjs/redux-toolkit/commits/feature/listener-middleware-fixes       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 280]             0 2 20 1 1 0 en  
1458653534212132864 swyx 33521530 2021-11-11T04:31:17+00:00 RT @acemarke: In the spirit of "working in public", but also "I'm human" and "ARGH THIS IS BROKEN SOMEONE HELP ME": I've spent the last fe… 1458630426709442562 1458630426709442562     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 2 0 1 1   en  
1458684981954244608 swyx 33521530 2021-11-11T06:36:15+00:00 Devtools pride is seeing users casually taking our API designs, docs, and error messages for granted having no idea how much *worse* they used to be       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 148] 1458682064908161027 33521530 swyx       0 2 42 0 0   en  
1458693704764383241 swyx 33521530 2021-11-11T07:10:55+00:00 somehow missed that @Netilfy hired an official Technical Community Builder! 🚀 https://twitter.com/domitriusclark/status/1447988170293923841?s=20   1447988170293923841 1447988170293923841   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 102] 1397912340893294598 33521530 swyx       1 2 11 0 0 0 en  
1459327954794647556 swyx 33521530 2021-11-13T01:11:12+00:00 Huge shout out @BrittneyPostma for #FollowFriday! On top of running a podcast, blog, merch, and her own freelance dev/design business, she's led the creation of @SvelteSirens and galvanized the @SvelteSociety in a whole new way with her talents. Follow @BrittneyPostma!! https://twitter.com/BrittneyPostma/status/1412032180465831939 https://twitter.com/swyx/status/1459327954794647556/photo/1   1412032180465831939 1412032180465831939   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 296]             1 2 19 0 0 0 en  
1459667585272713218 swyx 33521530 2021-11-13T23:40:46+00:00 🗽 Just booked a giant AirBnB for next week's NYC Svelte Summit (https://lu.ma/sveltenyc)! If any out of towners are considering flying in for #SvelteSummit, we have 1-2 beds left in the SvelteShack. DM to join! If you're local and interested in the future of the Web, join us:       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 2 33 1 0 0 en  
1461046537224527877 swyx 33521530 2021-11-17T19:00:14+00:00 @Netlify My previous post on the Series B -> C transition is here: https://dev.to/swyx/working-at-a-startup-from-series-b-to-c-445p I wonder if anyone's written about what its like from C -> D, would love to read. Am hoping to write the A -> B experience someday :)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 235] 1461043514641305600 33521530 swyx       0 2 29 0 0 0 en  
1461748429764239361 Andrew Culver 11467732 2021-11-19T17:29:18+00:00 Ooh, I had already forgotten: One of my favorite parts of this article is that it gave me an opportunity to highlight @swyx's recent post which I think is one of the most important things written in software development in the last ten years. https://twitter.com/andrewculver/status/1461748429764239361/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 242] 1461746021306830852 11467732 andrewculver       0 2 10 1 1 0 en  
1461750746072899586 swyx 33521530 2021-11-19T17:38:30+00:00 RT @andrewculver: Ooh, I had already forgotten: One of my favorite parts of this article is that it gave me an opportunity to highlight @sw… 1461748429764239361 1461748429764239361     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 2 0 1 1   en  
1461898243294515205 swyx 33521530 2021-11-20T03:24:36+00:00 Preemptive apologies for @SvelteSociety taking over Tech Twitter tomorrow, the excitement is off the charts 🧡       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 109]             0 2 57 0 0   en  
1462110266536124425 Pier 1360839410 2021-11-20T17:27:06+00:00 @sveltejs @vercel @Rich_Harris @rauchg @steph_dietz from Vercel just said publicly: "Svelte is the future of web development" 🔥🔥🔥🔥🔥🔥🔥       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [39, 135] 1462108361621745664 1360839410 PierB       0 2 16 1 1   en  
1462123489914245121 Thilo Maier 226148486 2021-11-20T18:19:39+00:00 Dream team @Rich_Harris and @rauchg at #SvelteSummit NYC. https://twitter.com/maiertech/status/1462123489914245121/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 57]             0 2 46 1 1 0 en  
1462128820325077003 swyx 33521530 2021-11-20T18:40:50+00:00 RT @maiertech: Dream team @Rich_Harris and @rauchg at #SvelteSummit NYC. https://twitter.com/maiertech/status/1462123489914245121/photo/1 1462123489914245121 1462123489914245121     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 96]             0 2 0 1 1 0 en  
1462128832266313736 swyx 33521530 2021-11-20T18:40:53+00:00 RT @PierB: @sveltejs @vercel @Rich_Harris @rauchg @steph_dietz from Vercel just said publicly: "Svelte is the future of web development"… 1462110266536124425 1462110266536124425     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 138]             0 2 0 1 1   en  
1462223074946863110 Marc Anthony Card 19242083 2021-11-21T00:55:22+00:00 Glad I was able to stumble upon @swyx’s tweet for the #SvelteSummit NYC watch party. My first tech meetup but surely not my last. Met so many interesting people with a variety of backgrounds in software development. https://twitter.com/Marcard/status/1462223074946863110/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 217]             0 2 38 1 1 0 en  
1462229776295469057 swyx 33521530 2021-11-21T01:22:00+00:00 RT @Marcard: Glad I was able to stumble upon @swyx’s tweet for the #SvelteSummit NYC watch party. My first tech meetup but surely not my… 1462223074946863110 1462223074946863110     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             0 2 0 1 1   en  
1462249320221233152 Gen Ashley 32330308 2021-11-21T02:39:39+00:00 At the #SvelteSummit After Party, after the After Party, after the New York Watch Party - We know how the party!n 😄 @SvelteSociety @SvelteSirens @sveltejs #sveltejs https://twitter.com/coderinheels/status/1462249320221233152/photo/1       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 165]             0 2 20 1 1 0 en  
1462276996596174850 swyx 33521530 2021-11-21T04:29:38+00:00 RT @coderinheels: At the #SvelteSummit After Party, after the After Party, after the New York Watch Party - We know how the party!n 😄 @Sve… 1462249320221233152 1462249320221233152     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 2 0 1 1   en  
1462975159548088332 swyx 33521530 2021-11-23T02:43:53+00:00 P.S. if you want to see the latest in JS reinvention come join the @temporalio meetup tomorrow where we are launching our new TypeScript SDK in beta! https://twitter.com/temporalio/status/1462970544379162627   1462970544379162627 1462970544379162627   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 149] 1462923803189645315 33521530 swyx       1 2 15 0 0 0 en  
1463394455617097730 swyx 33521530 2021-11-24T06:30:01+00:00 Incredible @liveoverflow video that starts out about XSS, but really is a deeper lesson about how clickbait gets more attention than insightful content, and how to spot it: https://www.youtube.com/watch?v=eQFbG6CwwdI&list=WL&index=42       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 198]             0 2 10 0 0 0 en  
1463691217078607875 swyx 33521530 2021-11-25T02:09:14+00:00 @johnlindquist @typescript this also works in javascript! https://twitter.com/swyx/status/1172604337366941697   1172604337366941697 1172604337366941697   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [27, 57] 1463576962891276298 15430177 johnlindquist       1 2 32 0 0 0 en  
1464882363616223233 swyx 33521530 2021-11-28T09:02:26+00:00 @AByteOfCodeAlex you're not doing this for you. not doing this for your "audience". you're doing this for the people who love you, including your family, spouse, and you-30-years-from now. those people dont care about filters. think about how much meaning shitty childhood home videos have.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [17, 290] 1464879866977808385 1455586383901331462 AByteOfCodeAlex       0 2 23 0 0   en  
1465056155936313347 swyx 33521530 2021-11-28T20:33:01+00:00 @SvelteSociety @JesseSkinner pls make this the thumbnail https://twitter.com/swyx/status/1465056155936313347/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [29, 56] 1464942403245248519 1176969867733479424 SvelteSociety       0 2 32 0 0 0 en  
1465445082308349959 swyx 33521530 2021-11-29T22:18:28+00:00 @kapehe_ok Finance was zero sum. Tech is positive sum. World of difference even at a psychological level.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 105] 1465355637487910922 913527939177652224 kapehe_ok       0 2 147 0 0   en  
1469093401203150848 swyx 33521530 2021-12-09T23:55:35+00:00 @moseeds see also: http://sso.tax       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 42] 1469093196860837888 33521530 swyx       0 2 21 0 0 0 en  
1469853240791642113 John P. Murphy 17050897 2021-12-12T02:14:55+00:00 For the past few weeks I've been seeing ridiculous memory usage warnings, and today I finally found the cause: I'd changed the color of my mouse cursor. https://www.techrepublic.com/article/macos-monterey-has-a-serious-memory-leak-problem-and-the-cause-has-been-found/ https://twitter.com/dolohov/status/1469853240791642113/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 177]             0 2 11 0 0 0 en  
1470462000001994754 swyx 33521530 2021-12-13T18:33:55+00:00 Free startup idea / Request for startup: Eco-friendly cable disposal 1. Let anyone mail their “big box of cables” to you. 2. You keep them for 1 year and ship back equivalent cables on demand. 3. Sell/responsibly recycle the rest. 4. Donate 20% proceeds to #TeamTrees       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 269]             0 2 44 0 0   en  
1470487534132154378 Jason Laster 312750384 2021-12-13T20:15:23+00:00 This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It doesn't matter if you're technically support, success, product, qa, leadership, or dev, if you care about quality, we want to talk to you! 🐛👋       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 260]             0 2 4 1 1 0 en  
1470487931332792324 swyx 33521530 2021-12-13T20:16:57+00:00 RT @jasonlaster11: This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It d… 1470487534132154378 1470487534132154378     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 2 0 1 1 0 en  
1470775386611011590 Zach Leatherman 96383 2021-12-14T15:19:12+00:00 Has anyone wrote a blog post detailing the history of using Utility Classes when authoring CSS? Interested in reading more about the origin story (*looks in @jay_hoffmann’s general direction*)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 193]             0 2 49 0 0   en  
1470787094750449665 swyx 33521530 2021-12-14T16:05:43+00:00 At this point they might as well rename Vercel’s slack to VC39       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 62] 1470786647788765201 33521530 swyx       0 2 128 1 0   en  
1471580713946214402 swyx 33521530 2021-12-16T20:39:17+00:00 an unqualified, low effort “it depends” isn’t wisdom. it’s lazy and nihilistic. here’s how to give a great “it depends”: https://twitter.com/swyx/status/1100275989622505472   1100275989622505472 1100275989622505472   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 121] 1202207460292988929 33521530 swyx       1 2 10 0 0 0 en  
1471993625231773700 Jeff Morhous 🎄🎁🍪 633360612 2021-12-18T00:00:03+00:00 So I just finished reading “The Coding Career Handbook” by @swyx - it was a really great read and I can’t wait to re-reference it over the years. Some tips really stuck out to me, especially as someone pretty early in my career       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 228]             0 2 39 1 1   en  
1472033075865563137 swyx 33521530 2021-12-18T02:36:48+00:00 RT @JeffMorhous: So I just finished reading “The Coding Career Handbook” by @swyx - it was a really great read and I can’t wait to re-refer… 1471993625231773700 1471993625231773700     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 2 0 1 1   en  
1473192929414070273 Nina 1354787371494084612 2021-12-21T07:25:39+00:00 Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "what we're really talking about here is turning fixed costs to variable costs which makes sense for a startup getting off the ground." https://twitter.com/briansowards/status/1472731566732414979   1472731566732414979 1472731566732414979   Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 255]             1 2 12 1 1 0 en  
1473206717403959297 swyx 33521530 2021-12-21T08:20:26+00:00 RT @Nina_Ledid: Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "wh… 1473192929414070273 1473192929414070273     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 2 0 1 1   en  
1473962147965112320 Theodorus Clarence 1228336168892170241 2021-12-23T10:22:15+00:00 + opinions about tailwindcss 👀 awesome book by the way @swyx https://twitter.com/th_clarence/status/1473962147965112320/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 61]             0 2 14 0 0 0 en  
1473991924285538304 swyx 33521530 2021-12-23T12:20:34+00:00 I wrote down my personal “rules of Twitter” in my @Coding_Career book and love it when newcomers find it useful! Twitter can be so confusing with the firehose of hot takes, petty squabbles, and serious announcements, but it’s a career hack for dev networking when done right. https://twitter.com/th_clarence/status/1473962147965112320   1473962147965112320 1473962147965112320   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 277]             1 2 33 0 0 0 en  
1474249859490521089 swyx 33521530 2021-12-24T05:25:31+00:00 Great article by @brandonbyars on when to go declarative/low code, and when to go imperative/general purpose https://martinfowler.com/articles/cant-buy-integration.html from Shannon on the @temporalio slack       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 172]             0 2 33 0 0 0 en  
1474271524110491649 swyx 33521530 2021-12-24T06:51:36+00:00 Strong Opinions on heading tags in HTML (h1, h2, h3, etc): - should all have id’s set - should all have discoverable anchor links (see: github markdown, or my blogposts) - (when appropriate) highlight link target, eg when one item in a multiple column layout (using :target)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 275] 1474267015334752257 33521530 swyx       0 2 25 1 0   en  
1475112373283598346 swyx 33521530 2021-12-26T14:32:50+00:00 For those who understand optionality, there's also an implicit life career strategy involved here: 1. go for high luck careers first to try your luck 2. try a few high talent careers to discover if you have it 3. fall back to high hard work careers as they're available to anyone       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280] 1475105975518765063 33521530 swyx       0 2 49 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]);