tweets

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

44 rows where display_text_range = "[0, 277]" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, retweeted

display_text_range 1 ✖

  • [0, 277] · 44 ✖
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
1013626221601738754 Ryan Caldbeck 3408272428 2018-07-02T03:31:38+00:00 1/ I recently learned a way of framing trust – I don’t know who originally created this equation but I learned separately from @jorgestubbs and LifeLabs. Trust = Credibility x Reliability x Vulnerability Let’s talk about components of equation and I’ll explain why I love it.       Twitter Web Client 887710c0899816dfe9fb0176eb05d760cbe15732 0 [0, 277]             0 146 520 0 0   en  
1201528574236217345 swyx 33521530 2019-12-02T15:48:30+00:00 One thing I wish I learned way earlier in my JS journey is Node Streams and child processes. We use them *all the time* in our tools but because this isn't in introductory material it seems "advanced". Two helpful articles: - https://medium.com/edge-coders/node-js-child-processes-everything-you-need-to-know-e69498fe970a - https://2ality.com/2018/05/child-process-streams.html       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 75 311 0 1 0 en  
1287798586651049985 Gergely Orosz 30192824 2020-07-27T17:14:43+00:00 Mind blown on how well-read @swyx is in the Coding Career Handbook (https://www.learninpublic.org/?a=uguka). He mentions almost all sources I would - like @Lethain on systems thinking or @mipsytipsy on tech risk profiles. I'm also learning tons of new dev stories (e.g. the "MooTools mafia"). https://twitter.com/GergelyOrosz/status/1287798586651049985/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 10 111 0 0 0 en  
1341122002866749440 swyx 33521530 2020-12-21T20:42:56+00:00 Ok I'm probably going to livestream playing around with React Server Components in an hour (as a non-expert non-FB non-Google non-millionaire). Have read thru the 2 RFCs, now watching @sugarpirate_'s demo (https://www.youtube.com/watch?v=TQQPAU21ZUw), here are my timestamps annotated in thread:       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 27 190 0 0 0 en  
1387487111964626945 swyx 33521530 2021-04-28T19:21:20+00:00 🆕 80/20 is the new Half-Ass https://swyx.io/8020/ Don't spend your life exerting 20% effort... hoping for 80% results... only to look back and wonder why you never hit 100% on anything. a response to @ShaanVP and @stephsmithio who are my inspirations (really, I mean it)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 5 71 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  
1420043000344768517 Supabase 1219566488325017602 2021-07-27T15:26:49+00:00 #supalaunchweek Day 2: 🔥 Supabase Storage is now in Beta 🔥 https://supabase.io/blog/2021/07/27/storage-beta - Streaming Media - Public Buckets - NodeJS support - Storage supported in Local Emulator - Upload folders - Updated Policy editor - Performance improvements to handle recursive cat uploads 😹       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 32 204 0 1 0 en  
1421686377670856704 4 9 s 2351378232 2021-08-01T04:17:00+00:00 “It is always going to be a truth that the more you know, the more you also learn about that stuff that you didn’t know that you didn’t know. So if you are doing it right at all you are going to feel like you are terrible at what you are doing…” — @swyx https://link.medium.com/KUqnxq1Ybib       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 1 15 0 1 0 en  
1426027634270654467 Jim OShaughnessy 28369153 2021-08-13T03:47:36+00:00 1/ Why You Should Write Letters to Your Kids as They Grow--A thread I've noticed a lot of FinTwiters having babies. Congratulations! I'd like to recommend you get into a habit early, and start writing letters to them that you can give them at some milestone, like turning 21.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 251 1860 0 1   en  
1427019802430754819 swyx 33521530 2021-08-15T21:30:08+00:00 This week's newsletter will have a preview of my next post: "Measuring Developer Relations" https://www.swyx.io/subscribe/ I started out writing an "Advice for New Devrels" article for @willjohnsonio, @jkup, @kevmodrome, @Nutlope and others but it just blew up into a whole series 😅 https://twitter.com/swyx/status/1427019802430754819/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 3 27 0 0 0 en  
1427577933074505728 James Ellis-Jones 65615053 2021-08-17T10:27:57+00:00 Brilliant talk brought to me by @swyx: https://swyx.transistor.fm/episodes/weekend-drop-what-we-know-we-dont-know-hillel-wayne. What we know about coding based on evidence. TDD is no better than any other testing, Code Review is more effective at removing defects than any kind of testing, many other things we get told to do have no effect.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 2 6 0 1 0 en  
1428130743381762055 swyx 33521530 2021-08-18T23:04:37+00:00 Just got reminded its the 3 year anniversary of my first conf talk: https://www.youtube.com/watch?v=nyFHR0dDZo0 I remember being so nervous, just 1 year out of bootcamp talking React in front of my heroes @ReactRally. Never regretted it. If you can, speak at a conference. Will change your life. https://twitter.com/swyx/status/1030130810588819456   1030130810588819456 1030130810588819456   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             1 1 71 0 0 0 en  
1431046098223779844 swyx 33521530 2021-08-27T00:09:12+00:00 What amazes me about Streamyard is that it wasn’t… *great*. The onscreen graphics were limited and the streaming wasn’t high quality. But it was easier to use than OBS, and scaled fine thru the pandemic. I hope both founders made $100m, and I hope someone makes a competitor! https://twitter.com/nathanbarry/status/1430995711575793667   1430995711575793667 1430995711575793667   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 277]             1 2 22 0 0 0 en  
1431454426175352837 swyx 33521530 2021-08-28T03:11:44+00:00 👀 Time to Preview Change Anyone can do a 15 min redeploy to see results of a change. Great DX reduces that 1-3 orders of magnitude: - Fast local preview of changes (eg HMR or good tests) - Cached rerun of results (eg @Observablehq) - Instantly deployable changes (eg @Replit)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1431454424153604098 33521530 swyx       0 0 9 0 0   en  
1432864028842356736 swyx 33521530 2021-09-01T00:33:00+00:00 My latest piece: https://www.swyx.io/self-provisioning-runtime/ Advancements in two fields — programming languages and cloud infrastructure — will converge in a single paradigm: where all resources used by a program will be automatically provisioned by the environment that runs it. TLDR in thread:       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 24 109 0 0 0 en  
1432864036241088513 swyx 33521530 2021-09-01T00:33:02+00:00 At the same time, infrastructure engineers increasingly embracing higher and higher abstractions to solve their problems. The DevOps movement is not so much "Devs doing Ops" as it is Ops doing Dev. As platforms develop, we are learning the chores that can be cleanly delegated. https://twitter.com/swyx/status/1432864036241088513/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1432864032235540480 33521530 swyx       0 2 7 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  
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  
1437048380958679042 swyx 33521530 2021-09-12T13:40:07+00:00 Valuable peek into what it is like to debate syntax inside @TC39, from someone who was actively involved but no longer is. This sort of thing is above my paygrade, but standards work affects us all, and I’m glad people this passionate have a voice in the future of JavaScript. https://twitter.com/BenLesh/status/1436890184449236994   1436890184449236994 1436890184449236994   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 277]             1 1 33 0 0 0 en  
1439966955570618376 swyx 33521530 2021-09-20T14:57:30+00:00 🆕 post: Why do Webdevs keep trying to kill REST? https://dev.to/swyx/why-do-webdevs-keep-trying-to-kill-rest-j2j My unifying mental model for - REST vs @GraphQL - Apollo, React Query, Firebase, Amplify Appsync vs... - Phoenix Liveview, Rails Hotwire, React Server Components - shoutouts to @remix_run and @supabase       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 85 435 0 1 0 en  
1443467407352205312 swyx 33521530 2021-09-30T06:47:02+00:00 It really is a tall order to retell the Apple origin story in an engaging way, when so much of it is well known. So I really mean it when I say @pkafka has done the best ~40 minute recap of the story from Homebrew to iPhone I've ever heard. Recommend. https://www.listennotes.com/podcasts/land-of-the-giants/how-apple-got-its-groove-back-vTYLIF5XaSD/ https://twitter.com/waltmossberg/status/1443242219650142209   1443242219650142209 1443242219650142209   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             1 3 18 0 0 0 en  
1444122755880787970 swyx 33521530 2021-10-02T02:11:10+00:00 Sep 2021: 139k+12k views, 37k uniques A really good month! Two big hits: - Self Provisioning Runtime: https://twitter.com/swyx/status/1432864028842356736?s=20 - Smart Clients vs Smart Servers: https://twitter.com/swyx/status/1439966955570618376 I also crossed 5k followers on @ThePracticalDev. Ironically I didn't feel very productive. https://twitter.com/swyx/status/1444122755880787970/photo/1   1439966955570618376 1439966955570618376   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1433716826660167680 33521530 swyx       1 0 6 0 0 0 en  
1448162617973825541 swyx 33521530 2021-10-13T05:44:08+00:00 correction from @sogrady on store-brand licenses - i was aware of some but secretly hoping the industry would settle on SSPL - instead, Elastic seems to have gone and made its own license! :( further cements my belief in @joshsimmons' OSI™ open source https://twitter.com/sogrady/status/1448143582695677953?s=20   1448143582695677953 1448143582695677953   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1448053408393428996 33521530 swyx       1 0 8 0 0 0 en  
1450148471718043652 swyx 33521530 2021-10-18T17:15:12+00:00 Look ma my @Cloudflare post finally made it on HN! #NothingButNET https://news.ycombinator.com/item?id=28903982 whoooah the traffic spike 🧡 maybe my biggest single traffic day in the last 2 years... and it comes 2 weeks after I thought the post ran out of steam. Thanks for submitting @pimterry! https://twitter.com/swyx/status/1450148471718043652/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 2 92 0 0 0 en  
1450202214664921088 Gatsby 3227338044 2021-10-18T20:48:46+00:00 "The following is my conversation with @AbhiAiyer and @wardpeet, two lead engineers behind Gatsby Cloud and the recently announced Gatsby v4, which is at the forefront of what I think is the most significant change in the Jamstack landscape in the past 2 years. "- Shawn 🍿 🔥 🚀 https://twitter.com/swyx/status/1449912418071580672   1449912418071580672 1449912418071580672   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             1 5 15 0 1 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  
1456032869135093760 Doug Colkitt (🐊,🐊) 1423817598618292225 2021-11-03T22:57:42+00:00 10/ Behind every order is a thinking, breathing shark. A shark with mouths to feed and a mortgage to pay. A shark who's likely smarter than you. Definitely more ruthless. You're swimming in shark-infested waters, treating apex predators like specks of geometric Brownian dust       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1456032867469963265 1423817598618292225 0xdoug       0 63 595 1 1   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  
1457831229819027460 swyx 33521530 2021-11-08T22:03:45+00:00 Got schooled in #a11y today by @JoshuaKGoldberg! Could not be happier to merge an external PR: https://github.com/temporalio/temporaldotio/pull/56 If you're interested in common accessibility mistakes, have a look at mine. Definitely makes it realer when it's mistakes *I* made vs a hypothetical one...       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 3 41 0 0 0 en  
1458822051263823875 Rich Harris 19487837 2021-11-11T15:40:55+00:00 today is a big day for @sveltejs: i've joined @vercel to work on it full time! so happy about what this means for svelte's future. it'll be the same independent, pluralistic project as before, but with Vercel's backing we can get ✨ a m b i t i o u s ✨ https://vercel.com/blog/vercel-welcomes-rich-harris-creator-of-svelte       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 1088 9259 1 1 0 en  
1458868196329492480 swyx 33521530 2021-11-11T18:44:17+00:00 Super excited for Rich, Svelte, and my friends at Vercel! Sign up for Svelte Summit 🏔️ (in 9 days! 😱 https://sveltesummit.com/) where you can catch up on the latest! 🗽 NYC party (with Rich, team Vercel, and myself): https://lu.ma/sveltenyc 🇩🇪 Mainz: https://lu.ma/sveltesummit-2021-mainz 🧡 https://twitter.com/Rich_Harris/status/1458822051263823875   1458822051263823875 1458822051263823875   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             1 3 62 0 0 0 en  
1463282463333965826 swyx 33521530 2021-11-23T23:05:00+00:00 Building community is so underrated. The "product" is the friends we made along the way! But when it gets ugly it can get really ugly. Higher highs, lower lows. People are messy. 3 main tools to manage this: - Code of Conduct - Mission, Vision, Values - Accountability/Checks       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 4 64 0 0   en  
1464013496639655937 swyx 33521530 2021-11-25T23:29:52+00:00 Open source knowledge is an enormously powerful form of #LearnInPublic. Eugene started a list last year and it snowballed into 17k stars -> *only then* is he turning it into a site + newsletter! Genius. And entirely replicable on whatever you learn. https://twitter.com/eugeneyan/status/1463666344147120132?s=20   1463666344147120132 1463666344147120132   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1375853465923022856 33521530 swyx       1 1 5 0 0 0 en  
1464423478950457344 swyx 33521530 2021-11-27T02:38:59+00:00 AWS responds: https://aws.amazon.com/about-aws/whats-new/2021/11/aws-price-reduction-data-transfers-internet/ Each month: - First TB: Free - First 10m requests: Free - First 2m functions: Free - Applies to Year 2+ "All AWS customers will benefit from these pricing changes, and millions of customers will see no data transfer charges as a result."       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1454251874849202185 33521530 swyx       0 4 38 0 0 0 en  
1464738098806358020 swyx 33521530 2021-11-27T23:29:10+00:00 I can't decide if @goEnjoy is overrated or a stroke of genius. Their whole thing is that "the store comes to you." When I ordered my new iPhone, I could either wait 2-3 weeks, or it could be hand-delivered - with setup - for free, **the next day**. Guess which button I hit. https://twitter.com/swyx/status/1464738098806358020/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 0 13 0 0 0 en  
1465442383294652420 Common Room 1331053779341348864 2021-11-29T22:07:45+00:00 It's time! Welcome to the 13 Days of Community, a two-week adventure celebrating our favorite content covering growth, engagement, and all the good bits in between. Up first? DevRel expert @swyx, of course, talking "Why You Should Get Good at Events" 🔥 https://www.commonroom.io/uncommon/blog/community-heat/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1465069236188024847 1331053779341348864 CommonRoomHQ       0 1 2 1 1 0 en  
1466428912087576587 CodeSandbox 878680180050579457 2021-12-02T15:27:52+00:00 We're thrilled to announce and open source Sandpack! 🎉 Sandpack is a toolkit for building live coding experiences that run fully in the browser. 👩‍💻 Full-featured editor experience ⚡️ Lightning-fast browser bundler 📦 Direct CodeSandbox integration https://codesandbox.io/post/sandpack-announcement https://twitter.com/codesandbox/status/1466428912087576587/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 271 1230 1 1 0 en  
1469145149162676224 swyx 33521530 2021-12-10T03:21:13+00:00 When you need to do API design, call a frontend developer. The upside of the competitiveness in frontend tooling and bikeshedding on frameworks and libraries is you get a fine sense for good DX. Loving @_jstejada's explanation of React in this light: https://youtu.be/FZ0cG47msEk?t=535       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 1 61 0 0 0 en  
1469166647562756099 swyx 33521530 2021-12-10T04:46:39+00:00 omg this is the first talk I've ever seen by @delba_oliveira and my mind is blown 🤯 So much packed into this 9 minute overview of the State of the Art in Interactive Playgrounds - @worrydream would be proud! and... The examples The backdrop THE BABY https://youtu.be/zL8cz2W0z34       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1469163411531513857 33521530 swyx       0 3 33 0 0 0 en  
1469212999713845249 swyx 33521530 2021-12-10T07:50:50+00:00 Imma let you finish but @simonswiss’ new Tailwind 3.0 walkthru is one of the best CSS tutorial + major version launches of all time. OF ALL TIME!! https://youtu.be/mSC6GwizOag If you only have 3 minutes skip ahead to the 20:50 mark and check out the arbitrary properties feature 🤯       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 277]             0 23 147 0 0 0 en  
1469466996848824322 swyx 33521530 2021-12-11T00:40:08+00:00 (The sheer ambition/pace of the @vite_js ecosystem just put this thought in my head, i havent really thought it through, and ofc i hugely respect both teams) The competition is heating up, ultimately users will win. Frankly this is the most exciting time to be in JS devtools!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1469466620812619776 33521530 swyx       0 0 41 0 0   en  
1472273864340115456 swyx 33521530 2021-12-18T18:33:37+00:00 Oh man, @tailwindcss is making Christmas come early this year! first Tailwind 3.0, then this new Typography update that fixed *every issue I’ve ever whined about* in a single update: - Dark mode - Local Undo - Inline customization thanks @simonswiss! https://youtu.be/GEYkwfYytAM       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 277]             0 9 146 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  
1475138273899323393 swyx 33521530 2021-12-26T16:15:45+00:00 For those who like economics: High luck industries have a huge amount of deadweight loss from all the people trying their luck (call it search/friction cost). Who's working on better models of industrial organization that more quickly identifies talent and incentivizes work?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1475112373283598346 33521530 swyx       0 0 5 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]);