home / twitter

tweets

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

53 rows where favorite_count = 9 and is_quote_status = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, retweet_count, retweeted, lang

created_at (date) >30 ✖

  • 2021-07-30 2
  • 2021-09-15 2
  • 2021-09-22 2
  • 2021-09-30 2
  • 2021-10-13 2
  • 2021-10-27 2
  • 2021-11-03 2
  • 2021-11-05 2
  • 2021-11-10 2
  • 2021-12-02 2
  • 2021-07-28 1
  • 2021-08-03 1
  • 2021-08-12 1
  • 2021-08-13 1
  • 2021-08-23 1
  • 2021-08-28 1
  • 2021-08-29 1
  • 2021-08-31 1
  • 2021-09-01 1
  • 2021-09-02 1
  • 2021-09-04 1
  • 2021-09-05 1
  • 2021-09-07 1
  • 2021-09-10 1
  • 2021-09-11 1
  • 2021-09-14 1
  • 2021-09-28 1
  • 2021-09-29 1
  • 2021-10-05 1
  • 2021-10-12 1
  • …

favorited 2 ✖

  • 0 52
  • 1 1

is_quote_status 1 ✖

  • - · 53 ✖

favorite_count 1 ✖

  • 9 · 53 ✖
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
1420473325667586050 swyx 33521530 2021-07-28T19:56:46+00:00 @andrewingram @cassidoo when you have to compare bigco vs startup comp, you have to, because startups can only offer so much cash and can't offer you RSU's       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 155] 1420426030133694464 9164512 andrewingram       0 0 9 0 0   en  
1421095739195756549 Tj 115513801 2021-07-30T13:10:01+00:00 This talk on Growing a Meta-Language by @swyx is just amazing! He goes in depth into talking about the how the trifecta of language+flavour+tools help each other. https://www.youtube.com/watch?v=18F5v1diO_A Playing around with @rails, I see the same kind of magic that makes it charming to use!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 276]             0 2 9 0 1 0 en  
1421220603197939713 swyx 33521530 2021-07-30T21:26:11+00:00 @b0rk @reactjs oh yay I get to introduce you to this idea! React uses fixtures heavily to reproduce browser bugs and offer starting points for some APIs that require a lot of setup: https://github.com/facebook/react/tree/main/fixtures @stevekinney and I are stealing this idea for @temporalio https://github.com/temporalio/samples-go/tree/master/temporal-fixtures       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 289] 1421209766236405763 6603532 b0rk       0 0 9 0 0 0 en  
1422424339589189633 swyx 33521530 2021-08-03T05:09:24+00:00 My answer to "Has anyone fully embraced an event-driven architecture?" - interpreted through the lens of @temporalio: https://news.ycombinator.com/item?id=28034882 Temporal doesn't identify as EDA, but certainly some concerns and difficulties are elegantly solved by it instead of hand-writing EDA.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278]             0 2 9 0 0 0 en  
1425877825165221889 swyx 33521530 2021-08-12T17:52:19+00:00 @trivikram @reactjs @sveltejs @solid_js its great. its supporters get very mad when i say anything else       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [40, 103] 1425865149085224965 21297217 trivikram       0 0 9 0 0   en  
1429725966335713281 Nebojsa (Cookie Duster) 1055736485830451200 2021-08-23T08:43:28+00:00 Another awesome read from @swyx https://www.swyx.io/measuring-devrel/ Best bit: Traditional marketing advice says people have to hear about you at least 7 times before they decide to buy; for developer tools, Matt Biilmann from Netlify says it's more like 14.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 246]             0 1 9 0 1 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  
1431889441447022593 swyx 33521530 2021-08-29T08:00:20+00:00 nice breakdown of Packy so far here from @jakesing_ https://theflywheel.substack.com/p/not-boring-packy-m incidentally this is inspiring me toward taking editorial newsletters far, far more seriously than I have been doing.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 195] 1431486611296964611 33521530 swyx       0 0 9 0 0 0 en  
1432533812500578304 swyx 33521530 2021-08-31T02:40:50+00:00 I confess I wasn't pumped about the @ShangChi movie initially. First Asian Marvel hero and his power is... kung fu? Really thats the best we could do? This trailer singlehandedly changed my mind. @SimuLiu wielding those 10 rings like a #NextLevel badass. https://www.youtube.com/watch?v=EU9q6lb4eKI       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 0 9 0 0 0 en  
1432864045133008899 swyx 33521530 2021-09-01T00:33:04+00:00 "Are you ignoring Heroku?" Heroku was so right so early - and then stagnated. We can do a lot more at build time, and at runtime. Among the platforms innovating on this: @begin, @vercel, @netlify, @PulumiCorp, @goserverless, @WaspLang! There's a tangible movement building. https://twitter.com/swyx/status/1432864045133008899/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278] 1432864042343813120 33521530 swyx       0 2 9 0 0 0 en  
1433494442346876945 swyx 33521530 2021-09-02T18:18:02+00:00 @threepointone @jkup does your team call themselves Workers workers or are you normal       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [21, 85] 1433424896395075587 1593171 threepointone       0 0 9 0 0   en  
1434206574055022592 swyx 33521530 2021-09-04T17:27:48+00:00 The Strategy: 1. Start a Swipe File 2. Collect examples 3. Offer newsletter signup 4. Offer login + faving 5. Build a Community 6. Hit the Media Circuit 7. Make Generators 8: Monetize - Ads - Workshop - Book - Course https://youtu.be/2r7fSeMCcK8       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258] 1434206572608049156 33521530 swyx       0 1 9 0 0 0 en  
1434435957659422720 swyx 33521530 2021-09-05T08:39:17+00:00 @CompSciDrew @reactjs not really a hot take or anything.. for the record anyone should know that i owe everything to React and still use it for part of my work. but nothing lasts forever. React will be relevant for a very long time, but it’s subject to the same laws of gravity we all are.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 290] 1434430555882278913 1352336244382920705 CompSciDrew       0 1 9 0 0   en  
1435183531630661633 swyx 33521530 2021-09-07T10:09:53+00:00 @thekitze @kentcdodds @dhh rocking the 360 stage! https://twitter.com/swyx/status/1435183531630661633/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [27, 49] 1435132205290905600 50339173 thekitze       0 0 9 0 0 0 en  
1436410434211483648 swyx 33521530 2021-09-10T19:25:09+00:00 @buildsghost Smaller than 50 devs? sure. I'd honestly maybe draw the line at 20 devs but just splitting hairs at that point. I notice you left out "prod -> dev" productivity. Observability, monitoring, alerting. worthwhile category even at small sizes?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 256] 1436404964541145091 1175464650395111424 buildsghost       0 0 9 0 0   en  
1436602844216500227 swyx 33521530 2021-09-11T08:09:43+00:00 Enjoying @corywilkerson’s explanation of “.dev” on @changelog https://changelog.com/podcast/459 they dont quite go into whether there was any internal resistance to the shortcut (@ 40mins in), but loved learning about the Github Computer Club and the minor tips (dotfiles, linking vscode)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280] 1436594934002458626 33521530 swyx       0 0 9 0 0 0 en  
1437795215444779008 swyx 33521530 2021-09-14T15:07:46+00:00 @sarah_edo whoa congrats Sarah!! Beam’s expression is so funny, its like “why is this camera in my face”       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 104] 1437763088845983745 813333008 sarah_edo       0 0 9 0 0   en  
1437945494119096322 swyx 33521530 2021-09-15T01:04:56+00:00 @stolinski so in my latest tests i tried both fitbit and apple watch and i think fitbit is the best combo of form and function. just gotta find a band that doesnt wreck my skin…       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 177] 1437944993130426368 18727585 stolinski       0 0 9 0 0   en  
1438163663249186822 Tihomir Surdilovic 57854378 2021-09-15T15:31:51+00:00 Happy to be presenting at the @BrightTALK : The 360 Cloud Landscape on September 21st. Topic: How to deal with failures in polyglot #microservices architectures using @temporalio. Sign up link: https://www.brighttalk.com/webinar/dealing-with-failures-in-polyglot-microservices-architectures/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 219]             0 7 9 0 1 0 en  
1440545613267955712 swyx 33521530 2021-09-22T05:16:52+00:00 @daniel_levine 😝 im so unprepared i am still looking for a solution that is looking for a problem       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 97] 1440534305436946437 14989226 daniel_levine       0 0 9 0 0   en  
1440712894958628874 lambdragon 1425932440388861952 2021-09-22T16:21:35+00:00 Watch @aldonline + @swyx discuss @thelambdragon, self-provisioning runtimes, and why the future of programming is all about "pure code" development https://www.youtube.com/watch?v=eUgKGIcrhE0       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 172]             0 5 9 0 1 0 en  
1442772008127795205 swyx 33521530 2021-09-28T08:43:46+00:00 @ASpittel i was just there!!! https://twitter.com/swyx/status/1442772008127795205/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 29] 1442585801603235844 3092104835 ASpittel       0 0 9 0 0 0 en  
1443129037854019589 Tella 1253031308957290497 2021-09-29T08:22:29+00:00 ✨TELLAVISION✨ episode 5 has arrived. Featuring... 💜 Fullscreen purple gradients ✂️ Our new trim mode 🔘 The backstory of buttons ✍️ Recapping our latest writing https://tella.video/tellavision-ep05-6pkx       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 185]             0 1 9 0 0 0 en  
1443367124047593473 swyx 33521530 2021-09-30T00:08:33+00:00 @jsjoeio @Julian @Nutlope you sonavabitch i'm in       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 48] 1443358529947987974 1567529924 jsjoeio       0 0 9 0 0   en  
1443449499817447427 swyx 33521530 2021-09-30T05:35:53+00:00 @dabit3 @jkup nader’s magic internet money is no more real than my pretend shares in startup equity, respect (actually arguably more real since he can sell it whenever he wants and i have to wait for exit, however, another way to look at it, i have legally enforced diamond hands)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 281] 1443448390671650816 17189394 dabit3       0 0 9 0 0   en  
1445344404076564481 swyx 33521530 2021-10-05T11:05:33+00:00 @PierreDeWulf got to love those pricing pages with no prices       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 60] 1445319466963939330 2700578436 PierreDeWulf       0 0 9 0 0   en  
1448027262121496578 swyx 33521530 2021-10-12T20:46:16+00:00 To put Temporal inside of Netflix's "paved road", they needed every part of the stack to adapt to their needs, from Fast Properties (config store) to Chaos Monkey (fault injection) to Metatron (certs) to Wall-E (authn) to Gandalf (authz) to their own flavor of gRPC. https://twitter.com/swyx/status/1448027262121496578/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 266] 1448024109389008896 33521530 swyx       0 0 9 0 0 0 en  
1448358282632962048 swyx 33521530 2021-10-13T18:41:38+00:00 @threepointone @RozenMD that, and ending every line with semicolons, going by my code reviews feedback recently       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [24, 111] 1448338082072248324 1593171 threepointone       0 0 9 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  
1450748944976424989 Alex Ilchenko 18936221 2021-10-20T09:01:16+00:00 Nice article about pros (a lot) and cons (some) of Tailwind by @swyx https://www.swyx.io/why-tailwind       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 92]             0 1 9 0 1 0 en  
1451316889360089110 swyx 33521530 2021-10-21T22:38:05+00:00 @Eli_White @lord_sherlock developers who work on migration tooling walk so that the rest of us can run       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 102] 1451209762004111360 19206244 Eli_White       0 1 9 0 0   en  
1453406516036259840 swyx 33521530 2021-10-27T17:01:31+00:00 React Conf 2021 https://conf.reactjs.org/tickets/sw-yx       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 39]             0 1 9 0 0 0 en  
1453409173870243844 swyx 33521530 2021-10-27T17:12:04+00:00 Feedback/suggestions here! https://github.community/c/command-palette/71 thanks to @emilybrick, @edokoa, @MaximeDeGreve, @strackoverflow, @jnraine, @BenEmdon, @madebygak, @adnamalin, @koddsson and everyone else who worked on this! I previously wrote about Keyboard First UX: https://swyx.io/keyboard-first/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278] 1453404264416485379 33521530 swyx       0 2 9 0 0 0 en  
1453581980247855105 swyx 33521530 2021-10-28T04:38:44+00:00 @TurnerNovak @VandelayIndust9 @EddyElfenbein we live in an economy       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [45, 66] 1453538971942858753 35647451 TurnerNovak       0 0 9 0 0   en  
1455958506561888256 swyx 33521530 2021-11-03T18:02:13+00:00 @dan_abramov aww i didnt know you have a cat!!! he looks very comfy!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 68] 1455954702299017216 70345946 dan_abramov       0 0 9 0 0   en  
1456005651834945540 swyx 33521530 2021-11-03T21:09:33+00:00 @shanselman i may have limited keystrokes in my hands but 20% of them are Ctrl+S no matter what!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 96] 1455971016274972675 5676102 shanselman       0 0 9 0 0   en  
1456480617965580290 swyx 33521530 2021-11-05T04:36:54+00:00 Prev_Startup’s rounds were “pre emptive”, which is industry lingo for: “I want in, but just fyi you don’t deserve it yet.” Took me years to process what this means: Money’s easier, but the # of builders ~the same. Premium on execution merely went *vertical*. ITS TIME TO BUILD.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             0 0 9 0 0   en  
1456502482285174790 swyx 33521530 2021-11-05T06:03:46+00:00 @_developit ah, forgot the classic promo strategy of inserting sleep(100ms) so you can remove it in a future version!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 117] 1456343163795296259 16495353 _developit       0 0 9 0 0   en  
1458248761906368519 swyx 33521530 2021-11-10T01:42:52+00:00 @brianleroux @seldo @trevnorris @andrestaltz ruined js promises for me forever https://staltz.com/promises-are-not-neutral-enough.html       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [32, 102] 1458248186611441667 676363 brianleroux       0 0 9 0 0 0 en  
1459615705762914304 swyx 33521530 2021-11-13T20:14:37+00:00 Dunno who needs to hear this but the Sesame Street gang all tweet in character! The MVPs - @Elmo - @BigBird - @OscarTheGrouch Handles squatted: - @SesameErnie - @BertSesame - @AbbyCadabbySST Made it work anyway: - @CountVonCount - @MeCookieMonster Too cool for this: Rosita https://twitter.com/swyx/status/1459615705762914304/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 0 9 0 0 0 en  
1461219136789377029 swyx 33521530 2021-11-18T06:26:05+00:00 @threepointone much is made of copilot for comments -> code, but what if code -> comments/docs       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 100] 1461076952970895370 1593171 threepointone       0 1 9 0 0   en  
1461501989775294466 swyx 33521530 2021-11-19T01:10:02+00:00 @amyngyn come join @temporalio and solve the distributed systems murder mystery! https://youtu.be/Crkcr1S-NSc       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 105] 1461406340174077952 961861063 amyngyn       0 1 9 0 0 0 en  
1464724371038040065 swyx 33521530 2021-11-27T22:34:37+00:00 @shreyas also has a whiff of taking credit and not acknowledging others who worked hard to solve this emergency without making noise about it. part of good PMing is giving recognition.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 185] 1464721736109203460 2048741 shreyas       0 0 9 0 0   en  
1465523933512232963 swyx 33521530 2021-11-30T03:31:48+00:00 If you had to choose, would you want your favorite writers/content creators to put their best stuff: - behind a $15 monthly subscription, - into a $99-299 onetime sale, or - make it free ($0) but with ads? Remember - you WANT to support their work - but what format is best?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278]             0 1 9 1 0   en  
1466198865061707776 swyx 33521530 2021-12-02T00:13:44+00:00 @litcapital instant unfollow for not listening to @TheStalwart and @tracyalloway's Odd Lots       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 91] 1466198086473166852 932630991298007041 litcapital       0 0 9 0 0   en  
1466268980558000130 swyx 33521530 2021-12-02T04:52:21+00:00 @jeremy_daly @dynamodb @houlihan_rick please take a meme photo with Rick with a ridiculous number of things stuffed on one table we can use that to power dynamodb meme fuel for the next year       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 190] 1466252852813185028 25995622 jeremy_daly       0 0 9 0 0   en  
1466678884540186626 swyx 33521530 2021-12-03T08:01:10+00:00 Dear all @TransistorFM users, please for the love of god customize your Transistor websites! They all look the same! Here's how: https://dev.to/swyx/how-to-customize-your-transistorfm-website-with-js-and-css-3afc https://twitter.com/swyx/status/1466678884540186626/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 154]             0 0 9 0 0 0 en  
1470896428184596482 swyx 33521530 2021-12-14T23:20:11+00:00 👋🏽 Anyone in San Diego - want to catch #SpiderManNoWayHome on Thursday afternoon?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 81]             0 0 9 0 0   en  
1471953869005410305 swyx 33521530 2021-12-17T21:22:04+00:00 @stolinski @c_pick wow this is a hot take i like, is there a video on it yet?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [19, 77] 1471952713630031872 18727585 stolinski       0 0 9 0 0   en  
1473027662658813953 swyx 33521530 2021-12-20T20:28:56+00:00 @techgirl1908 whoaaaa huge move. congrats Angie!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 48] 1472962220501913607 2932738834 techgirl1908       0 0 9 0 0   en  
1474275047271706626 swyx 33521530 2021-12-24T07:05:36+00:00 example of what i mean by the target/js code i wrote source: https://github.com/sw-yx/codingcareer.com/blob/master/src/components/FAQ.svelte#L101-L110 see it in action as an FAQ: https://www.learninpublic.org/#team-pricing       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 137] 1474271524110491649 33521530 swyx       0 1 9 0 0 0 en  
1458453691493597184 swyx 33521530 2021-11-10T15:17:11+00:00 Calendar Morghulis       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 18] 1458156097622007809 33521530 swyx       0 1 9 0 0   in  
1426324886264303616 swyx 33521530 2021-08-13T23:28:47+00:00 @stevekinney @chantastic https://twitter.com/swyx/status/1426324886264303616/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 24] 1426318751608102912 2118841 stevekinney       0 0 9 0 0 0 und  

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 2328.485ms