tweets
3,837 rows sorted by created_at descending
This data as json, CSV (advanced)
Suggested facets: source, favorited, retweeted, possibly_sensitive, lang
created_at (date) >30 ✖
- 2021-12-07 58
- 2021-08-17 51
- 2021-09-15 50
- 2021-09-01 49
- 2021-08-31 46
- 2021-08-18 44
- 2021-11-23 43
- 2021-09-05 41
- 2021-09-10 41
- 2021-08-08 40
- 2021-10-18 40
- 2021-11-30 40
- 2021-08-16 39
- 2021-08-03 38
- 2021-08-11 38
- 2021-09-20 37
- 2021-09-23 37
- 2021-09-29 37
- 2021-10-22 37
- 2021-10-27 37
- 2021-12-10 37
- 2021-09-11 36
- 2021-11-03 36
- 2021-11-17 36
- 2021-09-24 35
- 2021-08-12 34
- 2021-10-21 34
- 2021-12-02 34
- 2021-09-12 33
- 2021-09-22 33
- …
place 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1475149420962656256 | swyx 33521530 | 2021-12-26T17:00:03+00:00 | @missingfaktor https://en.wikipedia.org/wiki/Real_options_valuation | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 38] | 1475139372458647562 | 56127471 | missingfaktor | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
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 | ||||||||
1475137021014605825 | swyx 33521530 | 2021-12-26T16:10:47+00:00 | @calcsam @Rich_Harris bit specific, people want to play in the NBA, no matter the position. Steph Curry is 6'2. that aside, to the extent that "talent" is innate and "luck" is exogenous/stochastic, i do like the characterisation of NBA careers as high-talent low-luck | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 268] | 1475135726060589063 | 788059556 | calcsam | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1475130741654802432 | swyx 33521530 | 2021-12-26T15:45:50+00:00 | @DavidKPiano @nnajiabraham @Rich_Harris yeah luck is not 0 of course but the music world seems uniquely setup to identify and nurture child prodigies more so than almost any other field - helps talent (and hard work) be a far bigger component of overall success. i imagine luck is actually #3 in relative terms. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [40, 311] | 1475123665670971392 | 992126114 | DavidKPiano | 0 | 0 | 4 | 0 | 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 | ||||||||
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 | |||||||||||
1475056475651203074 | swyx 33521530 | 2021-12-26T10:50:43+00:00 | @atomiksdev put it this way: what makes you so sure that the React team are the most qualified/best possible people to teach React? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 131] | 1475056044984307717 | 604296890 | atomiksdev | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1475055088359985153 | swyx 33521530 | 2021-12-26T10:45:12+00:00 | @atomiksdev the reality is that what works for one audience wont work for another. this docs writing team has an impossible task writing the One True Explanation for an audience of millions at all experience levels. but its ok - the people who dont resonate with it will go to other resources | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 292] | 1474946634383380480 | 604296890 | atomiksdev | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1475054044972417024 | swyx 33521530 | 2021-12-26T10:41:04+00:00 | @Ollytheninja @emarticor nice AND affordable, which always involves a whole lot more innovation than engineers get credit for | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 125] | 1475053188591984641 | 43270140 | Ollytheninja | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1475053345710960643 | swyx 33521530 | 2021-12-26T10:38:17+00:00 | @jhooks did i miss something or did Quiet Place suddenly become a Christmas movie? https://twitter.com/swyx/status/1475053345710960643/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 82] | 1474654416712048644 | 12087242 | jhooks | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1474943492757458946 | swyx 33521530 | 2021-12-26T03:21:46+00:00 | @dcedrych @arvidkahl @businessbarista https://twitter.com/swyx/status/1381242204379701252?s=21 | 1381242204379701252 1381242204379701252 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [38, 61] | 1474878557163823110 | 2437435208 | dcedrych | 1 | 0 | 2 | 0 | 0 | 0 | und | ||||||
1474787579585511429 | swyx 33521530 | 2021-12-25T17:02:13+00:00 | 🎄 Discovered that @googlearts's Blob Opera project has a Christmas easter egg!! Enjoy 4 webgl blobs synthesizing carols and Merry Christmas to all who celebrate🎅 https://artsandculture.google.com/experiment/blob-opera/AAHWrq360NcGbw?cp=e30. https://twitter.com/swyx/status/1474787579585511429/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 188] | 0 | 1 | 24 | 0 | 0 | 0 | en | ||||||||||
1474771722494615555 | swyx 33521530 | 2021-12-25T15:59:13+00:00 | @izs the fun game of counterfactual history: did the tool shape history or did history shape the tool? (aka would something like github have eventually existed if TPW didn’t make the specific early choices/bets he did) personally i believe strong path dependence on the 10-100yr scale | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [5, 285] | 1474762336883785731 | 8038312 | izs | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1474697989713059841 | swyx 33521530 | 2021-12-25T11:06:13+00:00 | Sometimes wonder what would’ve happened to software if GitHub didn’t exist: - Pull requests would not exist - Most code would not be open source by default - Harder to learn ~everything without search - No ⭐️ system to skew tech choices - Git may not have won version control | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 276] | 0 | 49 | 701 | 1 | 0 | en | |||||||||||
1474628922004623360 | swyx 33521530 | 2021-12-25T06:31:46+00:00 | @ken_wheeler https://twitter.com/swyx/status/1474628922004623360/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 12] | 1474394277077831686 | 167193309 | ken_wheeler | 0 | 0 | 4 | 0 | 0 | 0 | und | |||||||
1474609683658854400 | swyx 33521530 | 2021-12-25T05:15:20+00:00 | @KMAC2042 @samselikoff you sound fun at parties | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 47] | 1474608013361258502 | 739050944 | KMAC2042 | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1474603724001611777 | swyx 33521530 | 2021-12-25T04:51:39+00:00 | @kelseyhightower reported this asshole and Twitter acknowledged, however i still dont see this account suspended. how much more clear cut can this be, @TwitterSafety ? https://twitter.com/swyx/status/1474603724001611777/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 167] | 1473216615852433418 | 159822053 | kelseyhightower | 0 | 0 | 0 | 0 | 0 | 0 | en | |||||||
1474584385894567940 | swyx 33521530 | 2021-12-25T03:34:48+00:00 | @ShaneaLeven @gwenshap very mind of you Shanea! im taking topic requests for the next one! 🙂 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 92] | 1474552981286789124 | 89629801 | ShaneaLeven | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1474583795282022400 | swyx 33521530 | 2021-12-25T03:32:27+00:00 | @01Blows wow that IS pretty cool! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 33] | 1474577588253122560 | 815325836 | 01Blows | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1474458850686160896 | swyx 33521530 | 2021-12-24T19:15:58+00:00 | @simonw trading volume != market value but yeah. 🦗 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 50] | 1474222983417794562 | 12497 | simonw | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1474447267004174336 | swyx 33521530 | 2021-12-24T18:29:57+00:00 | @lewisvrobinson til! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 20] | 1474366604368482305 | 413206572 | lewisvrobinson | 0 | 0 | 0 | 0 | 0 | und | ||||||||
1474447132513878017 | swyx 33521530 | 2021-12-24T18:29:24+00:00 | @erikras @floydophone what if you could do it in friend groups tho | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 66] | 1474429483251863571 | 7618412 | erikras | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1474446755521466368 | swyx 33521530 | 2021-12-24T18:27:55+00:00 | @jim_ej @BrandonByars @temporalio 💯 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [34, 35] | 1474444594234499072 | 65615053 | jim_ej | 0 | 0 | 0 | 0 | 0 | und | ||||||||
1474433436400033794 | swyx 33521530 | 2021-12-24T17:34:59+00:00 | @vcarl_ 🔥 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 9] | 1474373249848983592 | 72621018 | vcarl_ | 0 | 0 | 1 | 0 | 0 | und | ||||||||
1474433287909036037 | swyx 33521530 | 2021-12-24T17:34:24+00:00 | @leewarrickjr pure css lightbox! 🤯 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 34] | 1474379655490715678 | 15953440 | leewarrickjr | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1474432675645513738 | swyx 33521530 | 2021-12-24T17:31:58+00:00 | @rememberlenny @temporalio @ANTStorm ah super cool! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [37, 51] | 1474395515513184263 | 1003869794 | rememberlenny | 0 | 0 | 1 | 0 | 0 | fr | ||||||||
1474432353602732035 | swyx 33521530 | 2021-12-24T17:30:41+00:00 | @darinwf @Neeva havent, its on my todo list. hows the quality of results overall? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 81] | 1474409789249646599 | 29407210 | darinwf | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1474432139449958400 | swyx 33521530 | 2021-12-24T17:29:50+00:00 | @trun222 https://twitter.com/swyx/status/1210295490853490688?s=21 | 1210295490853490688 1210295490853490688 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 32] | 1474412488435253249 | 3080674485 | trun222 | 1 | 0 | 2 | 0 | 0 | 0 | und | ||||||
1474359647658147843 | swyx 33521530 | 2021-12-24T12:41:46+00:00 | @gwenshap @jkup concentric circles out. have a good product, then make content to show it off, then groom a community around your early adopters. it’s an infinite game so this is a continuous cycle but you can imagine a 80/15/5 split for early stage companies and 5/35/60 for mature ones | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 287] | 1474356324213399595 | 9462812 | gwenshap | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1474349637943238657 | swyx 33521530 | 2021-12-24T12:02:00+00:00 | Free startup idea / Request for startup: Google, but with up/downvote and block buttons for domains that are low quality SEO bait. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 131] | 0 | 27 | 670 | 0 | 0 | en | |||||||||||
1474330055467667461 | swyx 33521530 | 2021-12-24T10:44:11+00:00 | @gwenshap @jkup followup questions very welcome.. need to be pushed to write this stuff since i dont like to pretend i am an expert, so i much rather try to just write something with a specific person’s question in mind and then generalize | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 239] | 1474329561697599526 | 9462812 | gwenshap | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1474324670329409543 | swyx 33521530 | 2021-12-24T10:22:47+00:00 | @gwenshap wow very kind words! continually humbled by the response, literally word vomited this stuff just for friends like @jkup who were about to enter devrel for the first time 😅 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 181] | 1474316991645245441 | 9462812 | gwenshap | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1474324452234072064 | swyx 33521530 | 2021-12-24T10:21:55+00:00 | RT @gwenshap: “Your North Star metric is ‘monthly active developers’”. https://pocket.co/xhme3G @swyx is laying down the law for DevRel. L… | 1474316991645245441 1474316991645245441 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 17 | 0 | 1 | 1 | 0 | en | |||||||||
1474316991645245441 | Gwen (Chen) Shapira 9462812 | 2021-12-24T09:52:16+00:00 | “Your North Star metric is ‘monthly active developers’”. https://pocket.co/xhme3G @swyx is laying down the law for DevRel. Love the bold clarity. | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 146] | 0 | 17 | 84 | 1 | 1 | 0 | en | ||||||||||
1474297110598422530 | swyx 33521530 | 2021-12-24T08:33:16+00:00 | @mxstbr @calcsam @magicbell_io @ClerkDev @liveblocks #MaxStack | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [53, 62] | 1474295510777409536 | 2451223458 | mxstbr | 0 | 0 | 3 | 0 | 0 | und | ||||||||
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 | |||||||
1474273233750814725 | swyx 33521530 | 2021-12-24T06:58:24+00:00 | @t3dotgg spaces are a great twitter growth hack but a terrible listener experience and an even worse speaker experience :) respect to you for hosting them | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 154] | 1474272430625411072 | 786375418685165568 | t3dotgg | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1474272125338804228 | swyx 33521530 | 2021-12-24T06:53:59+00:00 | @t3dotgg why am i everybody’s outer circle | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 42] | 1474108080547786757 | 786375418685165568 | t3dotgg | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1474271770567843842 | swyx 33521530 | 2021-12-24T06:52:35+00:00 | @BenLesh ayy i made the cut | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 27] | 1474180010525310990 | 23795212 | BenLesh | 0 | 0 | 1 | 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 | ||||||||
1474269022195634176 | swyx 33521530 | 2021-12-24T06:41:40+00:00 | @Rich_Harris @united is this a web 3 sub tweet | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [21, 46] | 1474196154221047808 | 19487837 | Rich_Harris | 0 | 0 | 29 | 0 | 0 | en | ||||||||
1474267015334752257 | swyx 33521530 | 2021-12-24T06:33:41+00:00 | Embarrassed to learn about the :target pseudoselector so late in my webdev journey. I've written JS code to implement this exact feature when I could've just #useThePlatform'ed it 🤦🏽♂️ https://twitter.com/css/status/1354887812676546560 https://twitter.com/swyx/status/1474267015334752257/photo/1 | 1354887812676546560 1354887812676546560 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 209] | 1 | 23 | 255 | 1 | 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 | ||||||||||
1474225956504031235 | swyx 33521530 | 2021-12-24T03:50:32+00:00 | @dan_abramov 🥲 i promise i still really do love React | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 53] | 1473699470307217413 | 70345946 | dan_abramov | 0 | 0 | 15 | 0 | 0 | en | ||||||||
1474222541191499779 | swyx 33521530 | 2021-12-24T03:36:58+00:00 | RT @swyx: Updating @KentBeck's law of Software Development: Make it work Make it right Make it fast Make it low-code* *configurable, exte… | 1474082755550257152 1474082755550257152 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 8 | 0 | 1 | 1 | en | ||||||||||
1474222314095005701 | swyx 33521530 | 2021-12-24T03:36:04+00:00 | @mscccc recommended resources? just docs? good blogposts and videos? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 68] | 1474106394504843266 | 99121168 | mscccc | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1474155775069024268 | swyx 33521530 | 2021-12-23T23:11:39+00:00 | @he_zhenghao nicely done! 👏 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 27] | 1474146842967359495 | 908461644665069568 | he_zhenghao | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1474104042754240525 | swyx 33521530 | 2021-12-23T19:46:05+00:00 | @wongmjane seems buggy, im only in 7th circle!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 47] | 1474102491054686209 | 337119125 | wongmjane | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1474103628918972417 | swyx 33521530 | 2021-12-23T19:44:27+00:00 | @anildash not that i have any practical experience with this tech but ive found it surprising that many companies that start out with CRDT end up rewriting to OT for a variety of implementation reasons. specific cases elude me right now but just wanted to flag in case you have an opinion | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 288] | 1474086639915909121 | 36823 | anildash | 0 | 1 | 4 | 0 | 0 | en | ||||||||
1474102328844185600 | swyx 33521530 | 2021-12-23T19:39:17+00:00 | @hayatrachi @threepointone @jevakallio put a mic between then and hit record pls 🙏 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [39, 82] | 1474069459811852291 | 424959867 | hayatrachi | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1474098278988128256 | swyx 33521530 | 2021-12-23T19:23:11+00:00 | @marcoacierno @temporalio on the way... meanwhile lmk if i can help at all with TypeScript! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [26, 91] | 1473806569301286923 | 334185931 | marcoacierno | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1474097799491112960 | swyx 33521530 | 2021-12-23T19:21:17+00:00 | Extremely impressed by @AirbyteHQ's 2021: Mar: 5m Seed @Accel May: 26m Series A @Benchmark Dec: 150m Series B @altcap + Coatue Took 1 yr to get to 1/4 of Fivetran (founded 2012) 🤯 Was only tipped off by @roopakv + case study with @temporalio, but have to pay close attn now. https://twitter.com/MichelTricot/status/1474055955734319112 https://twitter.com/swyx/status/1474097799491112960/photo/1 | 1474055955734319112 1474055955734319112 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 302] | 1 | 1 | 14 | 0 | 0 | 0 | en | |||||||||
1474086428334522368 | swyx 33521530 | 2021-12-23T18:36:06+00:00 | @KyleSamani like this? https://www.listennotes.com/search/?q=sam%20bankman-fried&sort_by_date=0&scope=episode&offset=0&language=Any%20language&len_min=0 cc @ListenNotes | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 62] | 1474077661727100930 | 46332443 | KyleSamani | 0 | 0 | 3 | 0 | 0 | 0 | en | |||||||
1474082755550257152 | swyx 33521530 | 2021-12-23T18:21:30+00:00 | Updating @KentBeck's law of Software Development: Make it work Make it right Make it fast Make it low-code* *configurable, extensible, and programmable by end users, whether or not they are developers | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 202] | 0 | 8 | 76 | 1 | 1 | en | |||||||||||
1474064373823856643 | swyx 33521530 | 2021-12-23T17:08:28+00:00 | @BronGondwana @nick_beauchamp @drewtoothpaste https://twitter.com/nick_beauchamp/status/1473695980604305409 | 1473695980604305409 1473695980604305409 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [46, 69] | 1473609584514199554 | 624472937 | BronGondwana | 1 | 0 | 0 | 0 | 0 | 0 | und | ||||||
1474061085330198552 | swyx 33521530 | 2021-12-23T16:55:24+00:00 | @seanaguinaga i think in the large this is true, but locally you find pockets of mistruth, like with rockets, mrna, or personal diagnostics (@levels). your statement is antireflexive - much like the efficient market hypothesis, the more people believe it is true, the less true it becomes. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 289] | 1474060292220801026 | 1040241213612277761 | seanaguinaga | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1474055955734319112 | Michel Tricot 75116574 | 2021-12-23T16:35:01+00:00 | We started talking with Christine Hall early 2021, and it was clear to us she had a great understanding of what we were trying to accomplish, in addition to being a thought leader on #opensource. Her in-depth article on Airbyte is a great proof of that 👉 https://fossforce.com/2021/12/airbyte-the-money-and-licensing-of-software-plumbing/ | Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 | 0 | [0, 278] | 0 | 4 | 8 | 0 | 0 | 0 | en | ||||||||||
1474047155610734598 | swyx 33521530 | 2021-12-23T16:00:03+00:00 | @juliechentweets @retool it is one of those "retrospectively obvious" ideas... come to think of it i have no idea why the norm is big splashy jumpy raises! congrats! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [25, 165] | 1473697154510336008 | 1225624346917580800 | juliechentweets | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1474023148626481153 | swyx 33521530 | 2021-12-23T14:24:39+00:00 | @evyataral @codechips @SvelteSociety @sveltejs i joined the community and it was already like that. just did my part to help it grow :) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [47, 135] | 1474015201402011649 | 859389598413332480 | evyataral | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1473995097205198851 | swyx 33521530 | 2021-12-23T12:33:11+00:00 | @levelsio @IndieHackers @csallen tell the behind the scenes of Rebase! also longtime followers know your post it note productivity system, i believe that can always use wider exposure as its a wake up call for people who habitually overcomplicate their lives | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [33, 259] | 1473993933277601799 | 1577241403 | levelsio | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1473994450254790657 | swyx 33521530 | 2021-12-23T12:30:37+00:00 | @its_aniruddh @BrittneyPostma @Coding_Career beat me to it! ty | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [45, 62] | 1473993833356529665 | 1175852456657346560 | its_aniruddh | 0 | 0 | 1 | 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 | |||||||||
1473982705893515265 | swyx 33521530 | 2021-12-23T11:43:57+00:00 | @th_clarence thanks very much! and glad you figured out how to load it on Kindle, i also use Kindle so i spent some time doublechecking that one haha | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 149] | 1473962147965112320 | 1228336168892170241 | th_clarence | 0 | 0 | 1 | 0 | 0 | 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 | ||||||||||
1473914907665993728 | swyx 33521530 | 2021-12-23T07:14:32+00:00 | @levelsio being blocked by pmarca is the new verified | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 53] | 1473750845585977344 | 1577241403 | levelsio | 0 | 0 | 19 | 0 | 0 | en | ||||||||
1473914314897563651 | swyx 33521530 | 2021-12-23T07:12:11+00:00 | @LynxCreations its a reference to a reference https://www.google.com/search?q=i+saw+the+brightest+minds+of+my+generation+clicking+ads&client=firefox-b-1-m&ei=0AjEYe2jOczA3LUPscSPyA0&oq=i+saw+the+brightest+minds+of+my+generation+clicking+ads&gs_lcp=ChNtb2JpbGUtZ3dzLXdpei1zZXJwEAMyBQghEKABMgUIIRCgATIFCCEQoAEyBQghEKABMgUIIRCgAToHCAAQRxCwAzoGCAAQFhAeOgcIIRAKEKABOggIIRAWEB0QHkoECEEYAFDXCFi8JWD3JWgBcAF4AIABxgGIAYMJkgEDOS4zmAEAoAEByAEIwAEB&sclient=mobile-gws-wiz-serp#sbfbu=1&pi=i%20saw%20the%20brightest%20minds%20of%20my%20generation%20clicking%20ads | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 69] | 1473909951332597763 | 1168591556305215489 | LynxCreations | 0 | 0 | 3 | 0 | 0 | 0 | en | |||||||
1473895021321482242 | swyx 33521530 | 2021-12-23T05:55:31+00:00 | @kevinakwok oof you said the thing i didnt dare say | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 51] | 1473891723973701635 | 169791252 | kevinakwok | 0 | 0 | 14 | 0 | 0 | en | ||||||||
1473889021718073347 | swyx 33521530 | 2021-12-23T05:31:40+00:00 | The best minds of my generation are throwing themselves into virtual currencies, virtual realities, and virtual machines. Are future historians going to look back on this time and wonder who was left building for the real world? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 229] | 0 | 35 | 451 | 1 | 0 | en | |||||||||||
1473763346126340097 | swyx 33521530 | 2021-12-22T21:12:17+00:00 | @theDevBee congrats! every office should have dogs!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 52] | 1473081449855303680 | 1309615935532261377 | theDevBee | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1473761201968812032 | swyx 33521530 | 2021-12-22T21:03:46+00:00 | https://twitter.com/netlify/status/1473751452225003521?s=21 https://twitter.com/swyx/status/1473761201968812032/photo/1 | 1473751452225003521 1473751452225003521 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 23] | 1173754563351973888 | 33521530 | swyx | 1 | 0 | 7 | 0 | 0 | 0 | und | ||||||
1473751452225003521 | Netlify 2571501973 | 2021-12-22T20:25:01+00:00 | Navigate through the Netlify UI faster than ever before with our new Command Palette! 🧪 Available now in Netlify Labs. https://ntl.fyi/cmdk-readme https://twitter.com/Netlify/status/1473751452225003521/photo/1 | Sprout Social 2feaa4497dbf2f5efce3ede84518b1db6517855c | 0 | [0, 146] | 0 | 13 | 106 | 0 | 0 | 0 | en | ||||||||||
1473747284286644224 | swyx 33521530 | 2021-12-22T20:08:28+00:00 | @wesley83 @rosiesherry I have similar in my bio :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [23, 50] | 1473651128608952328 | 8925602 | wesley83 | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1473716828862132226 | swyx 33521530 | 2021-12-22T18:07:26+00:00 | @yongfook honestly this reads like a google problem. sure, a very all set of sites will serve different content based on the slash, but google should follow what users experience on their browsers, no? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 201] | 1473580970204827649 | 7895442 | yongfook | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1473712907351650304 | swyx 33521530 | 2021-12-22T17:51:52+00:00 | @nirajtolia @gwenshap appreciate the shoutout! :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 49] | 1473703057041072130 | 24314051 | nirajtolia | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1473712841278779396 | swyx 33521530 | 2021-12-22T17:51:36+00:00 | @JoshWComeau @FrontendHorse omg @trostcodes your video quality is amazing + all the animations!!! idk how you do it! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [28, 116] | 1473692320042258437 | 2308474213 | JoshWComeau | 0 | 1 | 6 | 0 | 0 | en | ||||||||
1473695980604305409 | Nick Beauchamp 594048820 | 2021-12-22T16:44:36+00:00 | @drewtoothpaste Btw, I wouldn't take this too seriously. Even looking at percentages, there seems to be a seasonal surge in "no smell" each winter. The recent Covid surges are larger, and the first wave is possibly visible as well, but this is also sensitive to how you smooth the data. https://twitter.com/nick_beauchamp/status/1473695980604305409/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 286] | 1473555762110767109 | 594048820 | nick_beauchamp | 0 | 66 | 607 | 0 | 0 | 0 | en | |||||||
1473501367432286211 | swyx 33521530 | 2021-12-22T03:51:16+00:00 | @_powellmark1 what? they're not? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 32] | 1435493972911144961 | 1097577939745394690 | _powellmark1 | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1473485957940740101 | swyx 33521530 | 2021-12-22T02:50:03+00:00 | @geddski @Shopify ahhh what a perfect fit!! congrats! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 53] | 1473323626925596687 | 39607761 | geddski | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1473423312386928640 | swyx 33521530 | 2021-12-21T22:41:07+00:00 | i think there were 2 causes - Descript's offline helpers were eating up craptons of memory, and also i had a large cursor for accessibility https://twitter.com/dolohov/status/1469853240791642113 | 1469853240791642113 1469853240791642113 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 165] | 1466641806007812098 | 33521530 | swyx | 1 | 0 | 3 | 0 | 0 | 0 | en | ||||||
1473395963696140288 | swyx 33521530 | 2021-12-21T20:52:26+00:00 | @dvassallo @circle they released group chat, which is good but needs to be for "rooms" than individuals. then the hard part is overcoming network effect of Discord. even then, may be strategically the wrong move if the bet is just to be extremely good at async community. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 272] | 1473355746385412096 | 24179991 | dvassallo | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1473395523923374082 | swyx 33521530 | 2021-12-21T20:50:41+00:00 | @jsjoeio haha. none of the people involved in that chain work in the same jobs anymore lol | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 90] | 1473363310493929473 | 1567529924 | jsjoeio | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1473395130011099136 | swyx 33521530 | 2021-12-21T20:49:08+00:00 | @flybayer @calcsam @temporalio cosign. we need to bring it down but for now the minimum resource bar/devops skill required is high. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [31, 131] | 1473392887744323585 | 2826554209 | flybayer | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1473347036036886528 | swyx 33521530 | 2021-12-21T17:38:01+00:00 | @OnePageLove @robhope @DenisJeliazkov gorgeous! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [38, 47] | 1473329691872448517 | 15132819 | OnePageLove | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1473344467646414849 | swyx 33521530 | 2021-12-21T17:27:49+00:00 | @zernonia @supabase @PostgreSQL nice job!! wondering if you checked out Supabase Workflows for your usecase, instead of using a cronjob? https://supabase.com/blog/2021/04/02/supabase-workflows | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [32, 160] | 1470947865174310919 | 4798109946 | zernonia | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1473343859279396864 | swyx 33521530 | 2021-12-21T17:25:24+00:00 | @supabase @zernonia fyi getting this error right now https://twitter.com/swyx/status/1473343859279396864/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [20, 52] | 1473322587472244747 | 1219566488325017602 | supabase | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1473343069819142144 | swyx 33521530 | 2021-12-21T17:22:15+00:00 | RT @Coding_Career: "The best places to grow are not the places where everything is peachy. It's the places where there's pressure on you to… | 1473316076893081602 1473316076893081602 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 4 | 0 | 1 | 1 | en | ||||||||||
1473342134891982852 | swyx 33521530 | 2021-12-21T17:18:32+00:00 | @EmmaBostian mental image of swedish boyfriend https://twitter.com/swyx/status/1473342134891982852/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 46] | 1473331804350341129 | 491821358 | EmmaBostian | 0 | 0 | 30 | 0 | 0 | 0 | en | |||||||
1473341710571048960 | swyx 33521530 | 2021-12-21T17:16:51+00:00 | @briansowards thanks for sharing it Brian! any comments/feedback welcome :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 75] | 1472731566732414979 | 15054324 | briansowards | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1473336492575846402 | swyx 33521530 | 2021-12-21T16:56:07+00:00 | @jonbretman 💯 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 13] | 1473327040568905736 | 482366126 | jonbretman | 0 | 0 | 0 | 0 | 0 | und | ||||||||
1473336454801952768 | swyx 33521530 | 2021-12-21T16:55:58+00:00 | @CSSWeekly thanks!! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 19] | 1473318855380541441 | 522552762 | CSSWeekly | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1473316076893081602 | Coding Career Community 1249002899897647105 | 2021-12-21T15:35:00+00:00 | "The best places to grow are not the places where everything is peachy. It's the places where there's pressure on you to perform, and there is space for your performance to really make an impact." @li_haoyi with some gold career advice on where to work: https://www.lihaoyi.com/post/ReflectingonFourYearsatDatabricks.html https://twitter.com/Coding_Career/status/1473316076893081602/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 0 | 4 | 17 | 1 | 1 | 0 | en | ||||||||||
1473264922439995392 | swyx 33521530 | 2021-12-21T12:11:44+00:00 | @dvassallo “live” energy is hard to beat. i hope that @circle figures out how to help creators maintain that active community feel! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 131] | 1473104064644718592 | 24179991 | dvassallo | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1473218830210330627 | swyx 33521530 | 2021-12-21T09:08:34+00:00 | If Web3 merely stood for "yes we accept all cookies from now til the end of time" it would have been adopted yesterday | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 118] | 0 | 8 | 177 | 0 | 0 | en | |||||||||||
1473210422383632386 | swyx 33521530 | 2021-12-21T08:35:10+00:00 | @HipsterSmoothie @DescriptApp honestly hope theres movement to improve the app performance, i had to uninstall it after finding out the background helpers were killing my cpu | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [30, 174] | 1473169072187535360 | 7547562 | HipsterSmoothie | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1473209969046482945 | swyx 33521530 | 2021-12-21T08:33:22+00:00 | @realKunalAShah where do i sign up | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 34] | 1472867131150774272 | 1020394087 | realKunalAShah | 0 | 0 | 0 | 0 | 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 | ||||||||||
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 | |||||||||
1473190888499458049 | swyx 33521530 | 2021-12-21T07:17:33+00:00 | @amasad that sounds like The Future According to Frontend Devs but i think there are some genuinely interesting things going on in the data (@getdbt) lowcode (@webflow, @flutterflow), PaaS (@flydotio, @cloudflare) and orchestration (@temporalio) world. too small for Next Big Thing? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 282] | 1473181494508097542 | 166138615 | amasad | 0 | 3 | 23 | 0 | 0 | en | ||||||||
1473188422873325568 | swyx 33521530 | 2021-12-21T07:07:45+00:00 | @NirantK @AirbyteHQ @HevoData bring it up, its a good question | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [30, 62] | 1473186344826331136 | 1028185370 | NirantK | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1473178528355028998 | swyx 33521530 | 2021-12-21T06:28:26+00:00 | @rzen isnt it? Open Standards > Open Source. brilliant. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 58] | 1473142741215420423 | 14686197 | rzen | 0 | 0 | 2 | 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]);