home / twitter

tweets

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

48 rows where retweet_count = 6 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorite_count, favorited, retweeted

created_at (date) 40 ✖

  • 2021-08-11 3
  • 2021-07-27 2
  • 2021-09-04 2
  • 2021-11-05 2
  • 2021-11-17 2
  • 2021-11-20 2
  • 2021-11-22 2
  • 2019-10-30 1
  • 2020-07-02 1
  • 2021-02-12 1
  • 2021-07-28 1
  • 2021-08-10 1
  • 2021-08-12 1
  • 2021-08-16 1
  • 2021-08-17 1
  • 2021-08-25 1
  • 2021-08-29 1
  • 2021-09-12 1
  • 2021-09-21 1
  • 2021-09-27 1
  • 2021-09-29 1
  • 2021-10-03 1
  • 2021-10-11 1
  • 2021-10-13 1
  • 2021-10-20 1
  • 2021-10-28 1
  • 2021-10-30 1
  • 2021-11-11 1
  • 2021-11-12 1
  • 2021-11-16 1
  • 2021-11-24 1
  • 2021-11-25 1
  • 2021-11-29 1
  • 2021-12-04 1
  • 2021-12-06 1
  • 2021-12-07 1
  • 2021-12-12 1
  • 2021-12-15 1
  • 2021-12-19 1
  • 2021-12-26 1

user 13 ✖

  • swyx 36
  • Tom Preston-Werner 1
  • Feross 1
  • Aliza Aufrichtig 1
  • Cindy Sridharan 1
  • Pier 1
  • Joe Previte 1
  • React Summit 🗓 June 17 & 21, 2022 1
  • Altalogy 1
  • Svelte Society 🧡 1
  • Temporal 1
  • Coding Career Community 1
  • Alex Zdanov 1

retweet_count 1 ✖

  • 6 · 48 ✖
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
1189555830544355330 swyx 33521530 2019-10-30T14:53:05+00:00 Levels of Impostor Syndrome working at @Netlify: 😍Seeing Coworkers 😱😱Representing the company in public 🤯🤯🤯Seeing the people applying to work here       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 149]             0 6 207 0 0   en  
1278665379544350720 swyx 33521530 2020-07-02T12:22:37+00:00 Something I didn't appreciate until I was a tool maker for while: - Scalability is a feature AND a cost - Tools designed to make small things should work very differently from tools designed to make big things - But you can design for graceful & *reversible* "eject"       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 271]             0 6 53 0 0   en  
1360316059987808256 swyx 33521530 2021-02-12T19:53:16+00:00 🆕 quick post: The Simple Magic of Prefixed URLs https://dev.to/swyx/the-simple-magic-of-prefixed-urls-46l1 It's amazing that you can enhance the open web by just accepting URLs and doing something interesting with it!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 184]             0 6 45 0 0 0 en  
1420135785987117060 Cindy Sridharan 161667651 2021-07-27T21:35:30+00:00 Instant buy!! The first edition is one of my all time favorite books! Everyone writing software should read it! Even if the second edition just had minor typo fixes, I’d buy it and read it all over again! https://twitter.com/JohnOusterhout/status/1420053240717086721   1420053240717086721 1420053240717086721   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 207]             1 6 86 0 1 0 en  
1420136685472342016 swyx 33521530 2021-07-27T21:39:05+00:00 RT @copyconstruct: Instant buy!! The first edition is one of my all time favorite books! Everyone writing software should read it! Even… 1420135785987117060 1420135785987117060     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             1 6 0 0 1   en  
1420471522703986688 Feross 15692193 2021-07-28T19:49:36+00:00 "Apple's web engine consistently trails others in both compatibility and features, resulting in a large and persistent gap with Apple's native platform." Progress Delayed Is Progress Denied https://infrequently.org/2021/04/progress-delayed/ @slightlylate       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 229]             0 6 26 0 1 0 en  
1425204981804650496 swyx 33521530 2021-08-10T21:18:41+00:00 Need research help: What is the best job scheduling/cronjob system you've used and what's one thing you LOVE about it?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 118]             0 6 99 0 0   en  
1425487171172044815 React Summit 🗓 June 17 & 21, 2022 3023155108 2021-08-11T16:00:00+00:00 There was a time before #ReactJS, and there will be life after. If you tie yourself too closely to any tech, you might trap yourself. @swyx zooms out from the state management library du jour to see what timeless lessons we can learn from #ReactJS: https://buff.ly/37tzisJ       Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 0 [0, 274]             0 6 11 0 1 0 en  
1425503610213785600 swyx 33521530 2021-08-11T17:05:19+00:00 RT @ReactSummit: There was a time before #ReactJS, and there will be life after. If you tie yourself too closely to any tech, you might tra… 1425487171172044815 1425487171172044815     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 6 0 0 1   en  
1425556759435898882 swyx 33521530 2021-08-11T20:36:31+00:00 @vercel nextjs 12 is gonna build your app before you write it       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 61] 1425503907019730956 4686835494 vercel       0 6 347 0 0   en  
1425889455643119616 swyx 33521530 2021-08-12T18:38:32+00:00 No Apple, I don't have any music on iTunes. No Apple, I don't run my email on Apple Mail. No Apple, I don't need to look up the meaning of a word I accidentally selected and force clicked.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 190]             0 6 87 0 0   en  
1427373400616407051 swyx 33521530 2021-08-16T20:55:12+00:00 RT @feross: "Apple's web engine consistently trails others in both compatibility and features, resulting in a large and persistent gap with… 1420471522703986688 1420471522703986688     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 6 0 0 1   en  
1427457113463300106 swyx 33521530 2021-08-17T02:27:51+00:00 Are we stuck with 5 star rating systems forever? A single irate customer can total someone’s livelihood with a 1 and there’s no meaningful difference between a 4.6 and a 4.7. Is anyone working on a viable alternative to the tyranny of Black Mirror style rating systems?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 270]             0 6 130 0 0   en  
1430388488923324417 swyx 33521530 2021-08-25T04:36:05+00:00 @mikeal i worked at AWS and supabase is outshipping teams 10x their size and funding. i dont know whats in the water there but @kiwicopple and team have got it. https://twitter.com/swyx/status/1424586713490358275?s=21   1424586713490358275 1424586713490358275   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 185] 1430193529565839368 668423 mikeal       1 6 82 0 0 0 en  
1432108101440733184 swyx 33521530 2021-08-29T22:29:13+00:00 DevOps theory: We wanted Devs to do more Ops We got Ops being forced into Dev       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 79]             0 6 101 0 0   en  
1434183926868635648 swyx 33521530 2021-09-04T15:57:48+00:00 Just got a preview of @IncredibleDevHQ from @jerriclynsjohn. If you want an integrated, collaborative platform for dev video content, hit him up for a demo! Related tools in dev/video space: @loom, @TellaHQ, @mmhmmapp, @replayio, @usebubbles, @GetShareX, @birdeatsbug, @iterspace https://twitter.com/swyx/status/1434183926868635648/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 6 26 0 0 0 en  
1434237502982815745 swyx 33521530 2021-09-04T19:30:42+00:00 Update: if you want to try self-provisioning runtimes, these are the top 3 so far: - http://Serverless.com/cloud contact @jeremy_daly and @dougmoscrop - http://CloudCompiler.run contact @AlaShiban - http://Lambdragon.com contact @aldonline All need serious design partners! https://twitter.com/swyx/status/1432864028842356736   1432864028842356736 1432864028842356736   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 275]             1 6 25 0 0 0 en  
1437109166334783494 swyx 33521530 2021-09-12T17:41:40+00:00 👀 Working on next post: "Why do webdevs keep trying to kill REST?" This one's been baking for a while - ever since I saw the innovation in @Reactjs Server Components and Rails Hotwire. Subscribe if you'd like to read a draft tonight! https://swyx.io/subscribe 🙏🏽 https://twitter.com/swyx/status/1437109166334783494/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 263]             0 6 186 0 0 0 en  
1440267058340634624 swyx 33521530 2021-09-21T10:50:00+00:00 TIL about the "DeWitt Clause": https://en.wikipedia.org/wiki/David_DeWitt#DeWitt_Clause Has there ever been a pettier mofo in tech than Larry Ellison? https://twitter.com/swyx/status/1440267058340634624/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 118]             0 6 28 0 0 0 en  
1442610193846603777 swyx 33521530 2021-09-27T22:00:47+00:00 "Let user group by business logic instead of force them to fit to your lifecycle method" is still the single most important lesson in API design I've ever learned. Used this exact diagram today in the design of @temporalio's JS SDK and so happy with the result. https://twitter.com/threepointone/status/1056594421079261185   1056594421079261185 1056594421079261185   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 262]             1 6 77 0 0 0 en  
1443289480606015490 Joe Previte 1567529924 2021-09-29T19:00:01+00:00 Indie Hacking Resources 📚 If you're new to indie hacking, these are a couple resources I'd start with: - https://www.indiehackers.com/start - https://joeprevite.com/launching-first-product - https://github.com/sw-yx/launch-cheatsheet - https://www.indiehackers.com/growth-bites       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 209]             0 6 13 0 0 0 en  
1444542756647419909 Coding Career Community 1249002899897647105 2021-10-03T06:00:06+00:00 "This career feels like a few key hours every year with a few near mandatory year-long cool-down periods in between where what you do barely matters." 😬 Who else has felt like this and what did you do about it? https://old.reddit.com/r/cscareerquestions/comments/pzofk7/this_career_feels_like_a_few_key_hours_every_year/ https://twitter.com/Coding_Career/status/1444542756647419909/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 236]             0 6 36 0 0 0 en  
1447389381384282112 swyx 33521530 2021-10-11T02:31:34+00:00 This is an excellent read from @hosseeb and clearly articulates the problem with “we’re X, but decentralized” startups. Lots of first principles here: https://haseebq.com/why-decentralization-isnt-as-important-as-you-think/ The fact that it comes from a card carrying member of the community makes this impossible to dismiss. https://twitter.com/swyx/status/1447389381384282112/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 278]             0 6 55 0 0 0 en  
1448361227306946561 Temporal 1204202807298969600 2021-10-13T18:53:20+00:00 We are having a #kubecon2021 happy hour sponsored by Temporal. Our founders @mfateev and @samarabbas77 will be there along with some members of our awesome team. Invite details: https://lu.ma/temporalkubecon       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 202]             0 6 9 0 0 0 en  
1450740609656901639 swyx 33521530 2021-10-20T08:28:09+00:00 Signal boost to the interesting work that Nicole and team are doing at Chrome with http://open-ui.org! imagine having alll these built in to the browser, its like Christmas morning https://twitter.com/stubbornella/status/1450702539347750917?s=21 https://twitter.com/swyx/status/1450740609656901639/photo/1   1450702539347750917 1450702539347750917   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 210] 1450406508559101959 33521530 swyx       1 6 28 0 0 0 en  
1453795383109324800 swyx 33521530 2021-10-28T18:46:44+00:00 @wongmjane poor Microsoft with 2.4 trillion market cap still waiting for senpais to notice them       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 95] 1453794889091588100 337119125 wongmjane       0 6 360 0 0   en  
1454491471436926985 swyx 33521530 2021-10-30T16:52:44+00:00 @dan_abramov i think @JessTelford is trying that with http://cete.io! just really hard to compete in mindshare with a company literally called meetup dot com :(       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [13, 170] 1454489160820174862 70345946 dan_abramov       0 6 16 0 0 0 en  
1456668099739111424 Aliza Aufrichtig 49150150 2021-11-05T17:01:53+00:00 Tune in today at 2pm ET / 11am PT to hear @Rich_Harris and me talk with my dear old pal @jeanqasaur on #PLTalk about the journey from JavaScript to TypeScript on the NYT coronavirus tracker, amongst other fun topics. Just one hour away! https://www.twitch.tv/jeanqasaur       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 264]             0 6 38 1 1 0 en  
1456682921620688902 swyx 33521530 2021-11-05T18:00:47+00:00 RT @alizauf: Tune in today at 2pm ET / 11am PT to hear @Rich_Harris and me talk with my dear old pal @jeanqasaur on #PLTalk about the journ… 1456668099739111424 1456668099739111424     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 6 0 1 1   en  
1458878468150620181 Tom Preston-Werner 5502392 2021-11-11T19:25:06+00:00 When I was interviewed on Live TV by Fox News after the big GitHub Series A, they got the investor wrong, spelled "repository" wrong, did abominal things to em dashes, mis-capitalized GitHub, and called pull requests "e-notes". QED. https://twitter.com/mojombo/status/1458878468150620181/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 232] 1458878458319171592 5502392 mojombo       0 6 131 1 1 0 en  
1459249053586255873 swyx 33521530 2021-11-12T19:57:40+00:00 It's been a fun few years, but today was my last day of the week. Excited to announce that I'm staying put eating my feelings watching everyone switch jobs for ridiculous amounts of money!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 188]             0 6 409 0 0   en  
1460670147799044096 swyx 33521530 2021-11-16T18:04:35+00:00 Super excited to see @Budibase launch: https://www.producthunt.com/posts/budibase ✅ Low code ✅ SSO+RBAC ✅ Open Source ✅ Mobile friendly ✅ Built with @Sveltejs ✅ Connects with *everything* Why ever handwrite internal tooling again? Used by Amazon, Google, Microsoft, IBM, P&G #ProudInvestor https://twitter.com/budibase/status/1460519255573766147 https://twitter.com/swyx/status/1460670147799044096/video/1   1460519255573766147 1460519255573766147   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 302]             1 6 27 0 0 0 en  
1460785448876331010 Svelte Society 🧡 1176969867733479424 2021-11-17T01:42:45+00:00 Svelte Summit viewing parties are springing up all over! Organize here or on Discord! NYC 🗽 @swyx Mainz 🇩🇪@einbuhrmi Zagreb 🇭🇷 @letourpowerscombine on Discord Barcelona 🇪🇸@stefanmaric on Discord Chicago 🍕@kennethkunz👇 https://twitter.com/kennethkunz/status/1460725443133415424   1460725443133415424 1460725443133415424   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 219]             1 6 31 1 1 0 en  
1460785490282483718 swyx 33521530 2021-11-17T01:42:55+00:00 RT @SvelteSociety: Svelte Summit viewing parties are springing up all over! Organize here or on Discord! NYC 🗽 @swyx Mainz 🇩🇪@einbuhrmi Z… 1460785448876331010 1460785448876331010     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 6 0 1 1   en  
1462108361621745664 Pier 1360839410 2021-11-20T17:19:32+00:00 @sveltejs @vercel seems to be going all in with Svelte which makes me very happy 😍 - Hired @Rich_Harris to work on it full time - Sponsored #SvelteSummit - First speaker is a Vercel dev rel basically selling Svelte - @rauchg travelled to NYC It feels like something big is coming!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 283] 1462101412431777797 1360839410 PierB       0 6 44 1 1   en  
1462128844719247364 swyx 33521530 2021-11-20T18:40:56+00:00 RT @PierB: @sveltejs @vercel seems to be going all in with Svelte which makes me very happy 😍 - Hired @Rich_Harris to work on it full time… 1462108361621745664 1462108361621745664     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 6 0 1 1   en  
1462843985970425857 Alex Zdanov 1455586383901331462 2021-11-22T18:02:39+00:00 How I apply @swyx's priority list: Systems > Goals Discipline > Motivation Trust > Distrust Principles > Tactics Writing > Reading Vulnerability > Confidence North Stars > Low Hanging Fruit Trends > News Habits > Sprints Questions > Answers Problems > Solutions People > Projects       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 315]             0 6 52 1 1   en  
1462850627801731072 swyx 33521530 2021-11-22T18:29:02+00:00 RT @AByteOfCodeAlex: How I apply @swyx's priority list: Systems > Goals Discipline > Motivation Trust > Distrust Principles > Tactics Writi… 1462843985970425857 1462843985970425857     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 152]             0 6 0 1 1   en  
1463612122026450946 Altalogy 1055044667320995843 2021-11-24T20:54:57+00:00 Black Friday deals? We prefer giveaways🥰 How about a $5,000 worth design sprint to tweak your landing page or product? To enter, quote tweet this with a short company desc. We'll announce the lucky winner on Mon, 29th. You have to be following us so we can DM you if you win!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 6 17 1 1   en  
1463940387223982080 swyx 33521530 2021-11-25T18:39:21+00:00 RT @altalogy: Black Friday deals? We prefer giveaways🥰 How about a $5,000 worth design sprint to tweak your landing page or product? To e… 1463612122026450946 1463612122026450946     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 6 0 1 1   en  
1465230968143237124 swyx 33521530 2021-11-29T08:07:40+00:00 Every so often I realize someone hasn't tweeted in a while, check their profile and realize they've become disillusioned with social media and just peaced out. On one hand, I'm happy for them. On the other, I miss them. On my third hand, I wonder when it will be my turn.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 274]             0 6 133 0 0   en  
1467001291893194753 swyx 33521530 2021-12-04T05:22:18+00:00 Both @Cloudflare and @Supabase are pioneering a new playbook in launch week marketing — absolutely gobsmacking to watch. Turning followers into fans by creating buzz for devtools launches as intensely as appointment television. The moat: eng + product have to align! https://twitter.com/kiwicopple/status/1466801873373986819   1466801873373986819 1466801873373986819   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 268]             1 6 99 0 0 0 en  
1467666370988965888 swyx 33521530 2021-12-06T01:25:05+00:00 RT @mojombo: When I was interviewed on Live TV by Fox News after the big GitHub Series A, they got the investor wrong, spelled "repository"… 1458878468150620181 1458878468150620181     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 6 0 1 1   en  
1468156417248923650 swyx 33521530 2021-12-07T09:52:21+00:00 Excellent answer from @yongfook on why too many people “building an audience first” w/o making anything of substance on @IndieHackers. Like most writers, I also don’t have a problem with the audience first approach. But it’s easy to overdo the “in public” and forget the “build”. https://twitter.com/jakobgreenfeld/status/1468143869426606081 https://twitter.com/swyx/status/1468156417248923650/photo/1   1468143869426606081 1468143869426606081   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 304]             1 6 35 0 0 0 en  
1469826858652880896 swyx 33521530 2021-12-12T00:30:05+00:00 "If you were a character in a book, what would your readers be yelling at you to do?" Fave thought exercise of mine, from @ESYudkowsky.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 136]             0 6 47 0 0   en  
1471004012971323392 swyx 33521530 2021-12-15T06:27:41+00:00 jQuery won the battle but Mootools won the war       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 46] 1470795050225307655 33521530 swyx       0 6 61 1 0   en  
1472495199322624003 swyx 33521530 2021-12-19T09:13:07+00:00 I am back in Singapore 🇸🇬 Never spending another winter in a cold country again. Come visit when it’s safe, it will change what you think a city can be. https://twitter.com/swyx/status/1137356384796794880   1137356384796794880 1137356384796794880   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 154]             1 6 433 0 0 0 en  
1475105975518765063 swyx 33521530 2021-12-26T14:07:25+00:00 Imagine if those "Career Days" they do for kids came with honest guidance on probability of success: Actor - 90% luck, 5% talent, 5% hard work Doctor - 10% luck, 10% talent, 80% hard work Fireman - 5% luck, 10% talent, 85% hard work Founder - 30% luck, 20% talent, 50% hard work       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 6 98 1 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]);
Powered by Datasette · Queries took 1126.889ms