tweets
291 rows where favorited = 1 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: source, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweeted, lang, created_at (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||
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 | |||||||||||
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 | ||||||||||
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 | ||||||||
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 | |||||||||
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 | ||||||||||
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 | |||||||||||
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 | |||||||||||
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 | ||||||||||
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 | ||||||||||
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 | |||||||||
1472776118696837120 | swyx 33521530 | 2021-12-20T03:49:24+00:00 | RT @b0rk: I built a new tool where you can experiment with DNS called Mess With DNS! It's at https://messwithdns.net. I made this with @om… | 1471158826288226306 1471158826288226306 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 732 | 0 | 1 | 1 | 0 | en | |||||||||
1472629089164951554 | swyx 33521530 | 2021-12-19T18:05:09+00:00 | RT @balajis: Ok, @levie proposed a space on web3 so let’s try it. Cc @joshelman @zachweinberg https://twitter.com/i/spaces/1yoKMWObkVkJQ | 1472622049554100226 1472622049554100226 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 118] | 0 | 53 | 0 | 1 | 1 | 0 | en | |||||||||
1472622049554100226 | Balaji Srinivasan 2178012643 | 2021-12-19T17:37:11+00:00 | Ok, @levie proposed a space on web3 so let’s try it. Cc @joshelman @zachweinberg https://twitter.com/i/spaces/1yoKMWObkVkJQ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 105] | 0 | 53 | 274 | 1 | 1 | 0 | en | ||||||||||
1472471158926630913 | swyx 33521530 | 2021-12-19T07:37:36+00:00 | RT @solarpunkgirl: https://twitter.com/solarpunkgirl/status/1472230116281491464/video/1 | 1472230116281491464 1472230116281491464 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 42] | 0 | 456 | 0 | 1 | 1 | 0 | und | |||||||||
1472230116281491464 | ∆V🌻 890230529659949056 | 2021-12-18T15:39:47+00:00 | https://twitter.com/solarpunkgirl/status/1472230116281491464/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 0] | 0 | 456 | 2370 | 1 | 1 | 0 | und | ||||||||||
1472033075865563137 | swyx 33521530 | 2021-12-18T02:36:48+00:00 | RT @JeffMorhous: So I just finished reading “The Coding Career Handbook” by @swyx - it was a really great read and I can’t wait to re-refer… | 1471993625231773700 1471993625231773700 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | en | ||||||||||
1471993625231773700 | Jeff Morhous 🎄🎁🍪 633360612 | 2021-12-18T00:00:03+00:00 | So I just finished reading “The Coding Career Handbook” by @swyx - it was a really great read and I can’t wait to re-reference it over the years. Some tips really stuck out to me, especially as someone pretty early in my career | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 228] | 0 | 2 | 39 | 1 | 1 | en | |||||||||||
1471581447962038273 | swyx 33521530 | 2021-12-16T20:42:12+00:00 | RT @lynnandtonic: December is for shipping! ✨ My annual portfolio refresh https://lynnandtonic.com A bit more fun with a browser you can r… | 1471522091044200448 1471522091044200448 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 112 | 0 | 1 | 1 | 0 | en | |||||||||
1471522091044200448 | Lynn Fisher 27965538 | 2021-12-16T16:46:20+00:00 | December is for shipping! ✨ My annual portfolio refresh https://lynnandtonic.com A bit more fun with a browser you can resize. Firefox and Edge seem to handle this best, but you do you. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 186] | 0 | 112 | 618 | 1 | 1 | 0 | en | ||||||||||
1471356847902756866 | swyx 33521530 | 2021-12-16T05:49:43+00:00 | RT @_brohrer_: War stories please. What’s the jankiest piece of tech you’ve seen a company depend on? | 1471112859400687627 1471112859400687627 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 102] | 0 | 510 | 0 | 1 | 1 | en | ||||||||||
1471331938707271681 | swyx 33521530 | 2021-12-16T04:10:44+00:00 | RT @flantz: Babble Royale is now live in early access! I think it's the funnest game I've ever worked on. Come see for yourself. https://t… | 1471192145453215745 1471192145453215745 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 572 | 0 | 1 | 1 | en | ||||||||||
1471290912856690691 | swyx 33521530 | 2021-12-16T01:27:43+00:00 | RT @stubbornella: Utility classes: I'm not in a mood to be erased today. I was experimenting with utility classes in large production sites… | 1471213109767405568 1471213109767405568 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 1 | 135 | 0 | 1 | 1 | en | ||||||||||
1471213109767405568 | Nicole Sullivan 15629200 | 2021-12-15T20:18:33+00:00 | Utility classes: I'm not in a mood to be erased today. I was experimenting with utility classes in large production sites starting in ~2004. In 2009, I got brave and shared! I have receipts.✍🏻 Others released similar things in 2011-2014. https://twitter.com/zachleat/status/1470775386611011590 | 1470775386611011590 1470775386611011590 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 238] | 1 | 135 | 588 | 1 | 1 | 0 | en | |||||||||
1471192145453215745 | Frank Lantz 47207321 | 2021-12-15T18:55:15+00:00 | Babble Royale is now live in early access! I think it's the funnest game I've ever worked on. Come see for yourself. https://store.steampowered.com/app/1759440/Babble_Royale/ https://twitter.com/flantz/status/1471192145453215745/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 141] | 0 | 572 | 2242 | 1 | 1 | 0 | en | ||||||||||
1471158826288226306 | 🔎Julia Evans🔍 6603532 | 2021-12-15T16:42:51+00:00 | I built a new tool where you can experiment with DNS called Mess With DNS! It's at https://messwithdns.net. I made this with @omarieclaire, and there's a blog post about how we built it here: https://jvns.ca/blog/2021/12/15/mess-with-dns/. Here's a gif: https://twitter.com/b0rk/status/1471158826288226306/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 231] | 0 | 732 | 2853 | 1 | 1 | 0 | en | ||||||||||
1471112859400687627 | Brandon Rohrer 731279155 | 2021-12-15T13:40:12+00:00 | War stories please. What’s the jankiest piece of tech you’ve seen a company depend on? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 87] | 0 | 510 | 2519 | 1 | 1 | 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 | ||||||||
1470900644055711747 | swyx 33521530 | 2021-12-14T23:36:56+00:00 | RT @beyang: The amazing thing about @swyx is he got into programming not too long ago after making a big career pivot from finance. It's aw… | 1470874194283884545 1470874194283884545 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 1 | 0 | 1 | 1 | en | ||||||||||
1470874194283884545 | Beyang Liu 16520821 | 2021-12-14T21:51:50+00:00 | The amazing thing about @swyx is he got into programming not too long ago after making a big career pivot from finance. It's awesome the way he has shared his journey and learnings from diving into @sveltejs, @reactjs, and now @temporalio. Thanks for coming on the show! https://twitter.com/swyx/status/1470864435015151618 | 1470864435015151618 1470864435015151618 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 270] | 1 | 1 | 16 | 1 | 1 | 0 | en | |||||||||
1470795050225307655 | swyx 33521530 | 2021-12-14T16:37:20+00:00 | Prediction: @vercel to acquire @codesandbox | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 43] | 1470791843222753280 | 33521530 | swyx | 0 | 0 | 149 | 1 | 0 | en | ||||||||
1470791843222753280 | swyx 33521530 | 2021-12-14T16:24:36+00:00 | Everybody making @vercel comparisons to avengers is thinking too small Vercel Class of 2021 looks more like https://twitter.com/swyx/status/1470791843222753280/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 108] | 1470789190417719303 | 33521530 | swyx | 0 | 11 | 158 | 1 | 0 | 0 | en | |||||||
1470789190417719303 | swyx 33521530 | 2021-12-14T16:14:03+00:00 | The same consolidation play Microsoft made for developer tools, @Vercel is now making for developers | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 100] | 1470788640846462979 | 33521530 | swyx | 0 | 4 | 87 | 1 | 0 | en | ||||||||
1470788640846462979 | swyx 33521530 | 2021-12-14T16:11:52+00:00 | Imagine accidentally holding a JSConf in your daily standup | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 59] | 1470787094750449665 | 33521530 | swyx | 0 | 28 | 362 | 1 | 0 | en | ||||||||
1470787094750449665 | swyx 33521530 | 2021-12-14T16:05:43+00:00 | At this point they might as well rename Vercel’s slack to VC39 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 62] | 1470786647788765201 | 33521530 | swyx | 0 | 2 | 128 | 1 | 0 | en | ||||||||
1470786647788765201 | swyx 33521530 | 2021-12-14T16:03:57+00:00 | The Great Resignation to @Vercel pipeline | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 41] | 0 | 14 | 447 | 1 | 0 | en | |||||||||||
1470782577615245327 | swyx 33521530 | 2021-12-14T15:47:46+00:00 | RT @dan_abramov: a hundred things i learned working on the react team @threadapalooza | 1470613731071696896 1470613731071696896 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 85] | 0 | 852 | 0 | 1 | 1 | en | ||||||||||
1470613731071696896 | Dan 70345946 | 2021-12-14T04:36:50+00:00 | a hundred things i learned working on the react team @threadapalooza | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 68] | 0 | 852 | 3516 | 1 | 1 | en | |||||||||||
1470489620639006721 | swyx 33521530 | 2021-12-13T20:23:40+00:00 | RT @arthurwuhoo: What makes Gmail performant is different than what makes Instagram performant. In "Application Holotypes", @_developit m… | 1470489155725578262 1470489155725578262 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 15 | 0 | 1 | 1 | en | ||||||||||
1470489155725578262 | Arthur Wu 🍊 2477624389 | 2021-12-13T20:21:49+00:00 | What makes Gmail performant is different than what makes Instagram performant. In "Application Holotypes", @_developit made a starting taxonomy of web app types and good architecture traits for each one. Many cite it as an impt read, and I've made it more visual 🧵: https://twitter.com/arthurwuhoo/status/1470489155725578262/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 0 | 15 | 69 | 1 | 1 | 0 | en | ||||||||||
1470487931332792324 | swyx 33521530 | 2021-12-13T20:16:57+00:00 | RT @jasonlaster11: This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It d… | 1470487534132154378 1470487534132154378 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | 0 | en | |||||||||
1470487534132154378 | Jason Laster 312750384 | 2021-12-13T20:15:23+00:00 | This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It doesn't matter if you're technically support, success, product, qa, leadership, or dev, if you care about quality, we want to talk to you! 🐛👋 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 260] | 0 | 2 | 4 | 1 | 1 | 0 | en | ||||||||||
1470335838349238272 | swyx 33521530 | 2021-12-13T10:12:36+00:00 | RT @danluu: How I think about writing https://danluu.com/writing-non-advice/ https://twitter.com/danluu/status/1470330844896059394/photo/1 | 1470330844896059394 1470330844896059394 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 86] | 0 | 39 | 0 | 1 | 1 | 0 | en | |||||||||
1470330844896059394 | Dan Luu 18275645 | 2021-12-13T09:52:45+00:00 | How I think about writing https://danluu.com/writing-non-advice/ https://twitter.com/danluu/status/1470330844896059394/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 50] | 0 | 39 | 259 | 1 | 1 | 0 | en | ||||||||||
1469801943019110401 | swyx 33521530 | 2021-12-11T22:51:05+00:00 | RT @JoshWComeau: I had a bill recently go from $20/month to $660/month because I exceeded a magic threshold. My actual usage increased mayb… | 1469313115598860293 1469313115598860293 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 1 | 4 | 0 | 1 | 1 | en | ||||||||||
1469727766308286473 | swyx 33521530 | 2021-12-11T17:56:20+00:00 | RT @rahulnpadalkar: Was searching for videos that explain React Hooks. Came across @swyx 's "Getting Closure on React Hooks", from @jsconfa… | 1469677279315959810 1469677279315959810 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
1469677279315959810 | Rahul Padalkar 1939826354 | 2021-12-11T14:35:43+00:00 | Was searching for videos that explain React Hooks. Came across @swyx 's "Getting Closure on React Hooks", from @jsconfasia 2019. Such an awesome talk. Highly recommended! Tried it myself and here's the repl link 👇 https://replit.com/@RahulPadalkar/AmpleSpitefulExtension#index.js Talk 👉 https://www.youtube.com/watch?v=KJP1E-Y-xyo | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 272] | 0 | 1 | 14 | 1 | 1 | 0 | en | ||||||||||
1469574836162760704 | swyx 33521530 | 2021-12-11T07:48:38+00:00 | RT @deekaymotion: Curious about how I make animations? Watch this. https://twitter.com/deekaymotion/status/1468943525840449539/video/1 | 1468943525840449539 1468943525840449539 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 90] | 0 | 15952 | 0 | 1 | 1 | 0 | en | |||||||||
1469313115598860293 | Josh W. Comeau 2308474213 | 2021-12-10T14:28:39+00:00 | I had a bill recently go from $20/month to $660/month because I exceeded a magic threshold. My actual usage increased maybe 20% 😬 https://twitter.com/swyx/status/1469092201376354305 | 1469092201376354305 1469092201376354305 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 129] | 1 | 4 | 71 | 1 | 1 | 0 | en | |||||||||
1469205711125049345 | swyx 33521530 | 2021-12-10T07:21:52+00:00 | RT @amasad: An essay I wrote at the time to battle with the idea of becoming an entrepreneur https://amasad.me/kierkegaard | 1467258399381340162 1467258399381340162 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 116] | 0 | 24 | 0 | 1 | 1 | 0 | en | |||||||||
1469121735576342528 | swyx 33521530 | 2021-12-10T01:48:11+00:00 | RT @tailwindcss: Tailwind CSS v3.0 is here — bringing incredible performance gains, huge workflow improvements, and a seriously ridiculous… | 1469011539302694914 1469011539302694914 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 139] | 0 | 394 | 0 | 1 | 1 | en | ||||||||||
1469092201376354305 | swyx 33521530 | 2021-12-09T23:50:49+00:00 | Hardest part of having a dual “bottom-up” + “top-down” pricing strategy is minding the sharp edges. Just spent an hour today patiently explaining to a vendor why it doesnt make sense for my monthly bill to go from $150 for a team of 6 to $3000 for a team of 7. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 261] | 0 | 13 | 211 | 1 | 0 | en | |||||||||||
1469011539302694914 | Tailwind CSS 895273477711769600 | 2021-12-09T18:30:18+00:00 | Tailwind CSS v3.0 is here — bringing incredible performance gains, huge workflow improvements, and a seriously ridiculous number of new features. Read the announcement post for all the details 👉 https://tailwindcss.com/blog/tailwindcss-v3 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 220] | 1469011535569821702 | 895273477711769600 | tailwindcss | 0 | 394 | 1203 | 1 | 1 | 0 | en | |||||||
1468943525840449539 | DeeKay 993595279545982976 | 2021-12-09T14:00:02+00:00 | Curious about how I make animations? Watch this. https://twitter.com/deekaymotion/status/1468943525840449539/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 48] | 0 | 15952 | 75639 | 1 | 1 | 0 | en | ||||||||||
1468710357472452608 | swyx 33521530 | 2021-12-08T22:33:31+00:00 | RT @rblalock: Quote of the day goes to @swyx : "You can learn a lot on the internet for the low low price of your ego" 🔥 https://t.co/jZXKx… | 1468703734062624773 1468703734062624773 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
1468703734062624773 | Rick Blalock 9083902 | 2021-12-08T22:07:12+00:00 | Quote of the day goes to @swyx : "You can learn a lot on the internet for the low low price of your ego" 🔥 https://mongodb.libsyn.com/ep-93-swyx-learn-in-public-and-temporal | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 130] | 0 | 1 | 17 | 1 | 1 | 0 | en | ||||||||||
1468530757379395587 | swyx 33521530 | 2021-12-08T10:39:51+00:00 | RT @david_perell: If you want to save the thread, here's a screenshot. https://twitter.com/david_perell/status/1462778265706405894/photo/1 | 1462778265706405894 1462778265706405894 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 94] | 0 | 47 | 0 | 1 | 1 | 0 | en | |||||||||
1468292823443070983 | swyx 33521530 | 2021-12-07T18:54:23+00:00 | The nature of UX bugs is that they are low priority in the short term (minor inconvenience), and high priority in the long term (evidence of lack of polish; persistent friction). If your issue prioritization doesn't include issue age you are almost certainly missing this. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 273] | 0 | 21 | 130 | 1 | 0 | en | |||||||||||
1468282142048206851 | swyx 33521530 | 2021-12-07T18:11:56+00:00 | RT @jhooks: these 20 awesome courses are free for the month https://egghead.io/20-days | 1467892371480186886 1467892371480186886 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 83] | 0 | 66 | 0 | 1 | 1 | 0 | en | |||||||||
1467958083007565826 | swyx 33521530 | 2021-12-06T20:44:14+00:00 | RT @jasonlaster11: http://Replay.io just shipped a new Outline View that can easily show ~50k functions in a file 🚀 If you’re looki… | 1467947006911864832 1467947006911864832 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 5 | 0 | 1 | 1 | 0 | en | |||||||||
1467947006911864832 | Jason Laster 312750384 | 2021-12-06T20:00:14+00:00 | http://Replay.io just shipped a new Outline View that can easily show ~50k functions in a file 🚀 If you’re looking to add a print statement in a file, the Outline View is your friend! 1/3 https://twitter.com/jasonlaster11/status/1467947006911864832/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 196] | 0 | 5 | 73 | 1 | 1 | 0 | en | ||||||||||
1467892371480186886 | joel ⛈ 12087242 | 2021-12-06T16:23:08+00:00 | these 20 awesome courses are free for the month https://egghead.io/20-days | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 71] | 0 | 66 | 193 | 1 | 1 | 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 | ||||||||||
1467347814686416898 | swyx 33521530 | 2021-12-05T04:19:15+00:00 | RT @acemarke: I'm not a frequent podcast listener, but I am _loving_ these deep-dive discussions that Swyx is recording. Great guests, thor… | 1467343720936792071 1467343720936792071 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 1 | 5 | 0 | 1 | 1 | en | ||||||||||
1467343720936792071 | Mark Erikson 727704217012604928 | 2021-12-05T04:02:59+00:00 | I'm not a frequent podcast listener, but I am _loving_ these deep-dive discussions that Swyx is recording. Great guests, thorough discussion of meaningful topics, and some really good insight into the state of our industry. https://twitter.com/swyx/status/1467304180003917824 | 1467304180003917824 1467304180003917824 | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [0, 223] | 1 | 5 | 45 | 1 | 1 | 0 | en | |||||||||
1467343666473623557 | swyx 33521530 | 2021-12-05T04:02:46+00:00 | RT @swyx: 🎙️ My latest podcast is with @argyleink! *Complexity Cliffs, DX, and the Disruption of Web Design* https://www.youtube.com/watch?v=xEyJ6LY7DKI - U… | 1467304180003917824 1467304180003917824 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 14 | 0 | 1 | 1 | 0 | en | |||||||||
1467304180003917824 | swyx 33521530 | 2021-12-05T01:25:52+00:00 | 🎙️ My latest podcast is with @argyleink! *Complexity Cliffs, DX, and the Disruption of Web Design* https://www.youtube.com/watch?v=xEyJ6LY7DKI - UI Complexity Cliffs - Open UI - UX vs DX - @Adobe vs @Figma vs @Webflow - Thoughtleading for Good - @dalmaer - and of course: How to Learn CSS! https://twitter.com/swyx/status/1451667101412954114 https://twitter.com/swyx/status/1467304180003917824/video/1 | 1451667101412954114 1451667101412954114 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 297] | 1 | 14 | 120 | 1 | 1 | 0 | en | |||||||||
1467258399381340162 | Amjad Masad ⠕ 166138615 | 2021-12-04T22:23:57+00:00 | An essay I wrote at the time to battle with the idea of becoming an entrepreneur https://amasad.me/kierkegaard | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 104] | 1467258397305147393 | 166138615 | amasad | 0 | 24 | 363 | 1 | 1 | 0 | en | |||||||
1467249786604584961 | swyx 33521530 | 2021-12-04T21:49:43+00:00 | What's the best way to be confident without being overconfident? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 64] | 0 | 9 | 91 | 1 | 0 | en | |||||||||||
1466984868319928325 | swyx 33521530 | 2021-12-04T04:17:02+00:00 | RT @turborepo: We think these kinds of packages are only getting more and more popular as we continue toward the next generation of JS buil… | 1466091140868886536 1466091140868886536 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
1466847530872762370 | swyx 33521530 | 2021-12-03T19:11:18+00:00 | RT @corecursive: A great list to be a part of! 🏆 | 1466846573078487043 1466846573078487043 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 48] | 1 | 3 | 0 | 1 | 1 | en | ||||||||||
1466846573078487043 | CoRecursive Podcast 947150325424803840 | 2021-12-03T19:07:30+00:00 | A great list to be a part of! 🏆 https://twitter.com/swyx/status/1466447829149237249 | 1466447829149237249 1466447829149237249 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 31] | 1 | 3 | 18 | 1 | 1 | 0 | en | |||||||||
1466659029715853315 | swyx 33521530 | 2021-12-03T06:42:16+00:00 | RT @swyx: 🆕 For my third year in a row, I've compiled my list of favorite new podcasts to feature up-and-comers and my favorite episodes o… | 1466447823801491458 1466447823801491458 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 4 | 0 | 1 | 1 | en | ||||||||||
1466641806007812098 | swyx 33521530 | 2021-12-03T05:33:50+00:00 | I think I have a memory leak on my machine. It slows down more and more every single day I let it "sleep" instead of shutting down. This is the first time it's been so obvious but I dont know the cause since its been slowly deteriorating. Any tips for identifying memory leaks? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 32 | 1 | 0 | en | |||||||||||
1466548802886635524 | swyx 33521530 | 2021-12-02T23:24:16+00:00 | RT @jasonlaster11: Would you like to help scale the craziest backend I’ve ever seen? http://Replay.io's tech stack is TS, EC2, K8S,… | 1466544085041233922 1466544085041233922 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 21 | 0 | 1 | 1 | 0 | en | |||||||||
1466544085041233922 | Jason Laster 312750384 | 2021-12-02T23:05:31+00:00 | Would you like to help scale the craziest backend I’ve ever seen? http://Replay.io's tech stack is TS, EC2, K8S, and Pulumi, but what makes it fun is that one debugging session can be anywhere from one to one hundred browsers co-located across several instances. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 270] | 0 | 21 | 49 | 1 | 1 | 0 | en | ||||||||||
1466497627155939330 | swyx 33521530 | 2021-12-02T20:00:55+00:00 | RT @codesandbox: We're thrilled to announce and open source Sandpack! 🎉 Sandpack is a toolkit for building live coding experiences that ru… | 1466428912087576587 1466428912087576587 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 271 | 0 | 1 | 1 | en | ||||||||||
1466475039054708737 | swyx 33521530 | 2021-12-02T18:31:09+00:00 | RT @temporalio: Our monthly meetup recording is up! Featuring: - Temporalite @Datadog - Temporal @TypeScript SDK - Temporal + XState @BDev… | 1466473939543199756 1466473939543199756 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 5 | 0 | 1 | 1 | en | ||||||||||
1466473939543199756 | Temporal 1204202807298969600 | 2021-12-02T18:26:47+00:00 | Our monthly meetup recording is up! Featuring: - Temporalite @Datadog - Temporal @TypeScript SDK - Temporal + XState @BDevessier @StatelyAI - Building @FlightControlHQ with Temporal! @abadir_ A packed hour of fun and distributed systems! https://youtu.be/GpbOkDjpeYU | Agorapulse app 86e9766d5e36b5847fe04f82904117b15d8fde9c | 0 | [0, 263] | 0 | 5 | 26 | 1 | 1 | 0 | en | ||||||||||
1466447823801491458 | swyx 33521530 | 2021-12-02T16:43:01+00:00 | 🆕 For my third year in a row, I've compiled my list of favorite new podcasts to feature up-and-comers and my favorite episodes of each. Presenting: Favorite New Podcasts of 2021! https://www.swyx.io/fave-podcasts-2021 | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 207] | 0 | 4 | 24 | 1 | 1 | 0 | en | ||||||||||
1466430676136300552 | swyx 33521530 | 2021-12-02T15:34:52+00:00 | RT @sseraphini: Learn in Public é minha religião https://twitter.com/sseraphini/status/1466386204346175493/photo/1 | 1466386204346175493 1466386204346175493 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 72] | 0 | 3 | 0 | 1 | 1 | 0 | pt | |||||||||
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 | ||||||||||
1466386204346175493 | Sibelius Seraphini 2313873457 | 2021-12-02T12:38:09+00:00 | Learn in Public é minha religião https://twitter.com/sseraphini/status/1466386204346175493/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 32] | 0 | 3 | 33 | 1 | 1 | 0 | pt | ||||||||||
1466251630400061442 | swyx 33521530 | 2021-12-02T03:43:24+00:00 | RT @atomiksdev: Introducing Floating UI — a new, low-level JavaScript positioning library for floating elements like tooltips, popovers, an… | 1466106700583243779 1466106700583243779 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 287 | 0 | 1 | 1 | en | ||||||||||
1466106700583243779 | James 604296890 | 2021-12-01T18:07:31+00:00 | Introducing Floating UI — a new, low-level JavaScript positioning library for floating elements like tooltips, popovers, and dropdowns ✅ Tiny 0.6 kB core ✅ Functional, pure, extensible ✅ Platform-agnostic (React Native support) ⌛ Future components https://floating-ui.com https://twitter.com/atomiksdev/status/1466106700583243779/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 273] | 0 | 287 | 1713 | 1 | 1 | 0 | en | ||||||||||
1466104198018191362 | swyx 33521530 | 2021-12-01T17:57:34+00:00 | RT @temporalio: Ever find a race condition bug and then look again, only to see that it is gone? 😱 This exact thing happened to @christoom… | 1465439478269493258 1465439478269493258 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 4 | 0 | 1 | 1 | en | ||||||||||
1466091140868886536 | Turborepo 1346129485024911360 | 2021-12-01T17:05:41+00:00 | We think these kinds of packages are only getting more and more popular as we continue toward the next generation of JS build tools. So that's why we want them to be first class citizens. https://www.swyx.io/js-third-age/ https://leerob.io/blog/rust | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 236] | 1466091140013346817 | 1346129485024911360 | turborepo | 0 | 1 | 4 | 1 | 1 | 0 | en | |||||||
1465908308716363779 | swyx 33521530 | 2021-12-01T04:59:10+00:00 | RT @steveklabnik: If you've been wondering what I've been up to at @oxidecomputer, wonder no more: https://oxide.computer/blog/hubris-and-humility Super glad that… | 1465689502060535808 1465689502060535808 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 210 | 0 | 1 | 1 | 0 | en | |||||||||
1465905924338434048 | swyx 33521530 | 2021-12-01T04:49:42+00:00 | RT @patak_js: 📜 New blog post! ⚡️ The Vite Ecosystem, an exploration of the projects, teams, and individuals collaborating to push the DX… | 1465625407890280452 1465625407890280452 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 139] | 0 | 88 | 0 | 1 | 1 | en | ||||||||||
1465823027497607171 | swyx 33521530 | 2021-11-30T23:20:18+00:00 | RT @thomaspaulmann: Today is a big day for @raycastapp! We're thrilled to announce our $15m Series A and release our Extensions Store and A… | 1465601156449804290 1465601156449804290 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 8 | 0 | 1 | 1 | en | ||||||||||
1465689502060535808 | steveklabnik 22386062 | 2021-11-30T14:29:43+00:00 | If you've been wondering what I've been up to at @oxidecomputer, wonder no more: https://oxide.computer/blog/hubris-and-humility Super glad that this is finally open source, so I can sing my co-workers' praises in public and not private 😀 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 215] | 0 | 210 | 1128 | 1 | 1 | 0 | en | ||||||||||
1465625407890280452 | patak 1300773350533459968 | 2021-11-30T10:15:01+00:00 | 📜 New blog post! ⚡️ The Vite Ecosystem, an exploration of the projects, teams, and individuals collaborating to push the DX of our frontend tooling forward I hope it helps to showcase how much the ecosystem has grown in this past year 💚 https://patak.dev/vite/ecosystem.html | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 262] | 0 | 88 | 300 | 1 | 1 | 0 | en | ||||||||||
1465601156449804290 | Thomas Paul Mann 3322693991 | 2021-11-30T08:38:39+00:00 | Today is a big day for @raycastapp! We're thrilled to announce our $15m Series A and release our Extensions Store and API. Read more about it here: https://www.raycast.com/blog/series-a/ Also, we're on @ProductHunt today: https://www.producthunt.com/posts/raycast-api-and-store https://twitter.com/raycastapp/status/1465599554913550340 | 1465599554913550340 1465599554913550340 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 231] | 1 | 8 | 190 | 1 | 1 | 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 | |||||||||||
1465444016179146752 | swyx 33521530 | 2021-11-29T22:14:14+00:00 | RT @CommonRoomHQ: It's time! Welcome to the 13 Days of Community, a two-week adventure celebrating our favorite content covering growth, en… | 1465442383294652420 1465442383294652420 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | 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 | |||||||
1465439478269493258 | Temporal 1204202807298969600 | 2021-11-29T21:56:12+00:00 | Ever find a race condition bug and then look again, only to see that it is gone? 😱 This exact thing happened to @christoomey of the @_bikeshed recently, and we recorded a great followup discussion with Sidekiq and Temporal experts! ft. @ANTstorm @mfateev https://www.youtube.com/watch?v=Rr4DnHmy6eE | Agorapulse app 86e9766d5e36b5847fe04f82904117b15d8fde9c | 0 | [0, 279] | 0 | 4 | 13 | 1 | 1 | 0 | en | ||||||||||
1465437441687371776 | swyx 33521530 | 2021-11-29T21:48:07+00:00 | RT @JoshuaKGoldberg: I've been playing around with @temporalio for a couple of weeks now and have to say I'm *thoroughly* impressed. There… | 1464876415153803268 1464876415153803268 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 139] | 0 | 4 | 0 | 1 | 1 | 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]);