tweets
3,837 rows sorted by in_reply_to_user_id descending
This data as json, CSV (advanced)
Suggested facets: place, 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
- …
source 27 ✖
- Twitter Web App 2,046
- Twitter for iPhone 1,548
- Twitter for iPad 86
- TweetDeck 39
- Typefully 21
- Twitter for Android 20
- Buffer 19
- Twitter Web Client 17
- Sprout Social 5
- Tweetbot for Mac 4
- Planable 4
- Revue 3
- LaterMedia 3
- Twitter for Mac 3
- FeedHive.io 2
- Tweetbot for iΟS 2
- Agorapulse app 2
- HubSpot 2
- WordPress.com 2
- Twitter for Advertisers 2
- Hypefury 1
- Echofon 1
- AWS Cwoud Weweases 1
- SocialFlow 1
- Typeshare 1
- FeedPress Publisher 1
- Stuff F 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1468157229664591875 | swyx 33521530 | 2021-12-07T09:55:35+00:00 | @nextjs thank god how long did it take you to get this handle lmao from now on only OG nextjs users remember searching for nextjs twitter handle and coming up blank and dejectedly settling for #nextjs | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 202] | 1468044361082580995 | 1467726470533754880 | nextjs | 0 | 0 | 73 | 0 | 0 | en | ||||||||
1460920753835044864 | swyx 33521530 | 2021-11-17T10:40:24+00:00 | @AByteOfCodeAlex @dvassallo and opportunism is antifragile. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [28, 59] | 1460919698812391425 | 1455586383901331462 | AByteOfCodeAlex | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1462847286770237444 | swyx 33521530 | 2021-11-22T18:15:46+00:00 | @AByteOfCodeAlex very nice elaboration! you totally get it 🤜 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [17, 60] | 1462844012126109699 | 1455586383901331462 | AByteOfCodeAlex | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1464882363616223233 | swyx 33521530 | 2021-11-28T09:02:26+00:00 | @AByteOfCodeAlex you're not doing this for you. not doing this for your "audience". you're doing this for the people who love you, including your family, spouse, and you-30-years-from now. those people dont care about filters. think about how much meaning shitty childhood home videos have. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [17, 290] | 1464879866977808385 | 1455586383901331462 | AByteOfCodeAlex | 0 | 2 | 23 | 0 | 0 | en | ||||||||
1459053207364124675 | swyx 33521530 | 2021-11-12T06:59:27+00:00 | @philward_io @freeCodeCamp that's so awesome! I really loved that podcast too, @ossia just has a nose for really good stories. fun fact: i recorded that podcast in a small motel in Mexico, where I was halfway through my digital nomad phase at Netlify 😹 got tired of it decided to settle down eventually | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [27, 303] | 1458876855281459209 | 1452923707035369474 | philward_io | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1457412996733423616 | swyx 33521530 | 2021-11-07T18:21:50+00:00 | @dejavucoder @audacitus @BrandonHexsel ship more tends to humble you very very quickly | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [39, 87] | 1457412337212669954 | 1446445479068241923 | dejavucoder | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1461534174615986179 | swyx 33521530 | 2021-11-19T03:17:55+00:00 | @FriskyVideoChat i mean yes im boring but hell no lol | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 53] | 1445403124823433230 | 1445019621040480256 | FriskyVideoChat | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1472626052656603137 | swyx 33521530 | 2021-12-19T17:53:05+00:00 | @anthonycook https://youtu.be/M6S8MMI9lko | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 36] | 1472583261964668941 | 1435674938313170944 | anthonycook | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
1465437074849361923 | swyx 33521530 | 2021-11-29T21:46:39+00:00 | @LeighNeys thanks Leigh! yeah part time isn't easy but it is so rewarding when done well! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 89] | 1465432143375577098 | 1435354155674128391 | LeighNeys | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1442904924493279232 | swyx 33521530 | 2021-09-28T17:31:56+00:00 | @protsaq thank you, really appreciate it! yeah when i set out to do this i felt like understanding the layers was a MAJOR breakthrough in understanding how different devs’ experiences differ! | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [9, 192] | 1442885004284026893 | 1428836868129439752 | afadadolar | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1438984931728756736 | swyx 33521530 | 2021-09-17T21:55:17+00:00 | @Jesus40410 @temporalio what language are you most comfortable with and what usecase are you considering? i can probably route you to something more useful | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [24, 155] | 1438948411659669505 | 1426341649702129668 | Jesus40410 | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1456032869135093760 | Doug Colkitt (🐊,🐊) 1423817598618292225 | 2021-11-03T22:57:42+00:00 | 10/ Behind every order is a thinking, breathing shark. A shark with mouths to feed and a mortgage to pay. A shark who's likely smarter than you. Definitely more ruthless. You're swimming in shark-infested waters, treating apex predators like specks of geometric Brownian dust | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 1456032867469963265 | 1423817598618292225 | 0xdoug | 0 | 63 | 595 | 1 | 1 | en | ||||||||
1465602795734634497 | swyx 33521530 | 2021-11-30T08:45:10+00:00 | @remotion_dev Hi! I checked you out today and was very impressed by the examples, however felt a huge gap between the starting point and the end result. maybe im just bad at this but more open source examples to copy from would be helpful! not really useful to just have the video. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 281] | 1465229912474894340 | 1422895361178447878 | remotion_dev | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1439751662802030595 | swyx 33521530 | 2021-09-20T00:42:00+00:00 | @codingwithjamie she just slays at everything i am simultaneously inspired and depressed by her success 😂 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 105] | 1439358450455040003 | 1422621826186842115 | codingwithjamie | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1442513417248460806 | swyx 33521530 | 2021-09-27T15:36:13+00:00 | @andrewkrisyudha hey! yeah i need to figure out the magic incantations to put into Route53 with @ryan. thanks for the push.. it has been like this for a while because life got busy but i really should tackle this better | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [17, 219] | 1442507319057604612 | 1422210868666769409 | andrewkrisyudha | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1465776961892978692 | swyx 33521530 | 2021-11-30T20:17:15+00:00 | @sohcfst yup! just finished | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 27] | 1465745926513840129 | 1413675741019926531 | sohcfst | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1436960825005252610 | swyx 33521530 | 2021-09-12T07:52:12+00:00 | @maninak_ 43mb! i hope they were building photoshop or something. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 65] | 1436959270285815809 | 1408407818558918666 | maninak_ | 0 | 1 | 5 | 0 | 0 | en | ||||||||
1435486802152939521 | swyx 33521530 | 2021-09-08T06:14:58+00:00 | @aninferiorcoder @QwikDev webdev is an infinite rabbit hole 😂 but dont feel FOMO, you dont need to know everything to be successful | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 131] | 1435251911200935937 | 1407203188877402120 | aninferiorcoder | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1453894452435513348 | swyx 33521530 | 2021-10-29T01:20:24+00:00 | @ReactMiamiConf 👀 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 17] | 1453737749450612746 | 1394306514282848260 | ReactMiamiConf | 0 | 0 | 3 | 0 | 0 | und | ||||||||
1465905692561195010 | swyx 33521530 | 2021-12-01T04:48:46+00:00 | @ReactMiamiConf finally submitted! so hyped! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 44] | 1465753658285596674 | 1394306514282848260 | ReactMiamiConf | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1465908886972469250 | swyx 33521530 | 2021-12-01T05:01:28+00:00 | @ReactMiamiConf oh man this would be perfect for @ken_wheeler to finally do his MR WORLDWIDE cameo | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 98] | 1465907922765029380 | 1394306514282848260 | ReactMiamiConf | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1465500077426835463 | swyx 33521530 | 2021-11-30T01:57:00+00:00 | @baggerholder1 -60% :sus: https://twitter.com/swyx/status/1465500077426835463/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 25] | 1402152638087536653 | 1391625634611224578 | baggerholder1 | 0 | 0 | 0 | 0 | 0 | 0 | und | |||||||
1436422919983407104 | swyx 33521530 | 2021-09-10T20:14:46+00:00 | @DevtoolsFM i had so much fun! thanks for having me! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 52] | 1436363534913327108 | 1389094644328271872 | DevtoolsFM | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1431712417336250370 | swyx 33521530 | 2021-08-28T20:16:54+00:00 | @RealNeilC @temporalio oh awesome! we dont have any govt certifications so cant host your workload but happy to have someone speak for your client to get them comfortable with it! and TS SDK launching soon, would appreciate feedback on API design 🙏 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 249] | 1431694156481667080 | 1388591018505904134 | RealNeilC | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1431715428045295618 | swyx 33521530 | 2021-08-28T20:28:52+00:00 | @RealNeilC @temporalio you know where to find us if you need us! 🙏 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 66] | 1431714808856993797 | 1388591018505904134 | RealNeilC | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1423563198662250496 | swyx 33521530 | 2021-08-06T08:34:49+00:00 | @TheProtegeMovie Nikita was greatly underrated but also I’m ready for Maggie Q to explore new characters than the same one she’s played for like 15 years | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 153] | 1421174056770883588 | 1386839088792100866 | TheProtegeMovie | 0 | 1 | 2 | 0 | 0 | en | ||||||||
1422821819975823367 | swyx 33521530 | 2021-08-04T07:28:51+00:00 | @PodRocketpod @thecodercoder lol hi @bnevilleoneill yes, think in 10 year arcs! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [29, 79] | 1422589293248253966 | 1372248310904455178 | PodRocketpod | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1449325335615455232 | swyx 33521530 | 2021-10-16T10:44:21+00:00 | @PodRocketpod @DavidKPiano great episode! idk if you’ve considered doing @ycombinator but they have rolling admissions right now and you could prob get a bunch of recs to get on the top of the heap | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 197] | 1449043573031194625 | 1372248310904455178 | PodRocketpod | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1469092781066842113 | swyx 33521530 | 2021-12-09T23:53:08+00:00 | @itslelahjones you got this!! congrats! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 39] | 1468763070713540612 | 1363881475012255745 | itslelahjones | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1427305084472360961 | swyx 33521530 | 2021-08-16T16:23:44+00:00 | @emquex aw thanks for the shoutout!! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 36] | 1427243422834909185 | 1360617219974119425 | emquex | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1468479086603366402 | swyx 33521530 | 2021-12-08T07:14:31+00:00 | @aseemthakar_ i made this jar filling analogy once following from our feedback ladder system at netlify https://twitter.com/swyx/status/1468479086603366402/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 103] | 1468410731951362052 | 1360437535407710213 | aseemthakar_ | 0 | 1 | 4 | 0 | 0 | 0 | en | |||||||
1463577714045063178 | swyx 33521530 | 2021-11-24T18:38:13+00:00 | @chloe_alabama @seldo The Avengers are 7-0 in battles that include Hawkeye. They are 0-4 in battles either against him or without him. If you are a data analyst you have to conclude Hawkeye is statistically the most valuable avenger | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 232] | 1463552770871595023 | 1359199546346270728 | chloe_alabama | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1464855722999496704 | swyx 33521530 | 2021-11-28T07:16:34+00:00 | @john_comments @Asclepius____ @VCBrags those two are orthogonal, doubleclick on the higher order bit | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [39, 100] | 1463565749960720392 | 1357314033305681923 | john_comments | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1434495196369195008 | swyx 33521530 | 2021-09-05T12:34:41+00:00 | @aceCourtBot @gaylittlekookie @shuriismysister @zerryferd @S2VpdGgA @hateskurapika @FernandoTomina @Brankz4 @splankatang @itsmangoochie we dont deserve this bot | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [136, 160] | 1434355254129274880 | 1354046596862894080 | aceCourtBot | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1461076647822512128 | swyx 33521530 | 2021-11-17T20:59:52+00:00 | @trybeehiiv very cool! i took a quick glance on your landing page and didnt see it so gotta ask - do you support custom domains? because i dont wanna tie my subscribers/internet traffic to your domain thanks to @jsjoeio for pointing me to you | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 243] | 1460971897592582154 | 1352439395903791106 | beehiiv | 0 | 0 | 3 | 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 | ||||||||
1440054339481964551 | swyx 33521530 | 2021-09-20T20:44:44+00:00 | @_Arnoldho yay i'm glad you enjoyed it!!! thank you! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 52] | 1440052933555417092 | 1347260005460934657 | _Arnoldho | 0 | 0 | 1 | 0 | 0 | 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 | |||||||
1440768215529914372 | swyx 33521530 | 2021-09-22T20:01:25+00:00 | @macrocephalopod @ConejoCapital wait isn't that buying, not selling skew | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [32, 72] | 1440736372185202690 | 1341087029048827904 | macrocephalopod | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1440095507867701248 | swyx 33521530 | 2021-09-20T23:28:19+00:00 | @AprilynneA i am currently 0 for 0 on asking people to marry me so there’s that | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [12, 79] | 1439998576633921538 | 1341045582664589312 | AprilynneA | 0 | 0 | 34 | 0 | 0 | en | ||||||||
1423326514393669632 | swyx 33521530 | 2021-08-05T16:54:19+00:00 | @biantris_ thank you! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 21] | 1423314547847409677 | 1338510819743719424 | biantris_ | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1449254218821341187 | swyx 33521530 | 2021-10-16T06:01:46+00:00 | @brian_tran_dev haha great hanging out!! i’m really looking forward to you talking semis with @FoolAllTheTime someday! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 118] | 1449198995130048512 | 1335998147844161538 | _briantran_ | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1468163148809048069 | swyx 33521530 | 2021-12-07T10:19:06+00:00 | @naz_avo @jakobgreenfeld evidently not true going by gumroad gmv probably more like ppl have caught on that shipping > talking https://twitter.com/swyx/status/1468163148809048069/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 130] | 1468162122387447811 | 1335444805241896961 | naz_avo | 0 | 0 | 5 | 0 | 0 | 0 | en | |||||||
1433840748588195841 | swyx 33521530 | 2021-09-03T17:14:08+00:00 | @NHeinDev @AngelaRiggs_ seconded. @freeCodeCamp let me dip my toe in the water before deciding on my career change. https://medium.com/hackernoon/no-zero-days-my-path-from-code-newbie-to-full-stack-developer-in-12-months-214122a8948f | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [24, 140] | 1433840277505052675 | 1333059155154907138 | NHeinDev | 0 | 0 | 3 | 0 | 0 | 0 | en | |||||||
1436723434659237894 | swyx 33521530 | 2021-09-11T16:08:54+00:00 | @NHeinDev twitter search :) https://twitter.com/search?q=from%3Aswyx%20narrow%20interests&src=typed_query | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 51] | 1436721662704107522 | 1333059155154907138 | NHeinDev | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1445874223726010376 | swyx 33521530 | 2021-10-06T22:10:52+00:00 | @NHeinDev @MiamiJS how damn that beard is looking good on you | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 61] | 1445873531879886852 | 1333059155154907138 | NHeinDev | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1456746712467337220 | swyx 33521530 | 2021-11-05T22:14:15+00:00 | @NHeinDev its been great getting to know you! you are really good on twitter spaces btw, do more | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 96] | 1456746553750790144 | 1333059155154907138 | NHeinDev | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1460403317343850500 | swyx 33521530 | 2021-11-16T00:24:18+00:00 | @NHeinDev web3 is my backup plan | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 32] | 1460401882942353417 | 1333059155154907138 | NHeinDev | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1460411597889826823 | swyx 33521530 | 2021-11-16T00:57:12+00:00 | @NHeinDev yeah no doubt! glad it helped. i think of it this way - its higher value for me to reap seeds i sowed 3 years ago than to constantly keep running around throwing seeds and never staying put long enough to see something of substance result. it’ll still be early days in 4 years. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 287] | 1460410040687509505 | 1333059155154907138 | NHeinDev | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1463717308505808898 | swyx 33521530 | 2021-11-25T03:52:55+00:00 | @NHeinDev @developer_dao what kind of projects? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 47] | 1463690278468997121 | 1333059155154907138 | NHeinDev | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1470333857257824256 | swyx 33521530 | 2021-12-13T10:04:43+00:00 | @NHeinDev i mean like the replies here are evidence, plus i think a lot of @RandallKanna's boldness and originality comes from her homeschooling but was also just reflecting on homeschooled people i know from college and have heard on podcasts. I think i'd be keen to do it for my kids. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 287] | 1470202973481582605 | 1333059155154907138 | NHeinDev | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1422753866357952513 | swyx 33521530 | 2021-08-04T02:58:49+00:00 | @saviomartin7 @hashnode this is so well done, congrats!!! may want to steal some generation ideas from @components_ai👀 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [24, 119] | 1420663531653926912 | 1331060842494758913 | saviomartin7 | 0 | 1 | 4 | 0 | 0 | en | ||||||||
1460306053451505670 | swyx 33521530 | 2021-11-15T17:57:48+00:00 | @CommonRoomHQ @mary_grace @Camunda i'll throw a question in! How do you think about the Business Value of Sending DevRels to In-Person Conferences? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [35, 149] | 1460299077413838853 | 1331053779341348864 | CommonRoomHQ | 0 | 1 | 1 | 0 | 0 | en | ||||||||
1465442383294652420 | Common Room 1331053779341348864 | 2021-11-29T22:07:45+00:00 | It's time! Welcome to the 13 Days of Community, a two-week adventure celebrating our favorite content covering growth, engagement, and all the good bits in between. Up first? DevRel expert @swyx, of course, talking "Why You Should Get Good at Events" 🔥 https://www.commonroom.io/uncommon/blog/community-heat/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 1465069236188024847 | 1331053779341348864 | CommonRoomHQ | 0 | 1 | 2 | 1 | 1 | 0 | en | |||||||
1425573389331169286 | swyx 33521530 | 2021-08-11T21:42:36+00:00 | @KennethCassel luck!! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 21] | 1425442750833610760 | 1319269656264409088 | KennethCassel | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1431897054381424643 | swyx 33521530 | 2021-08-29T08:30:35+00:00 | @KennethCassel congrats!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 25] | 1431760121231720448 | 1319269656264409088 | KennethCassel | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1432732200273793027 | swyx 33521530 | 2021-08-31T15:49:10+00:00 | @KennethCassel break a leg! also get a fatigue mat, costs like $10 and much better for your feet/standing | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 105] | 1432711585982734337 | 1319269656264409088 | KennethCassel | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1437112843757891593 | swyx 33521530 | 2021-09-12T17:56:16+00:00 | @KennethCassel @reactjs haha ty. supabase gets a mention! altho i honestly dont have a strong view on whether supabase is best used on client or server side. you'd be a good person to ask - where do you make your supabase sdk calls? | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [24, 232] | 1437111897887752196 | 1319269656264409088 | KennethCassel | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1437113679233916934 | swyx 33521530 | 2021-09-12T17:59:36+00:00 | @KennethCassel @reactjs yeah gotcha. i figured! thats where i put supabase too. | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [24, 79] | 1437113333732331522 | 1319269656264409088 | KennethCassel | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1437116007026499587 | swyx 33521530 | 2021-09-12T18:08:51+00:00 | @KennethCassel @reactjs ironic that your more secure calls are done clientside, whereas general calls are serverside. not what i would have expected! i'd love to read an analysis of RLS vs other authz methods you considered, i'm not well versed enough to decide | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [24, 262] | 1437113888093442050 | 1319269656264409088 | KennethCassel | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1437117701428744197 | swyx 33521530 | 2021-09-12T18:15:35+00:00 | @KennethCassel @reactjs tyvm for that! | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [24, 38] | 1437117593014374402 | 1319269656264409088 | KennethCassel | 0 | 0 | 1 | 0 | 0 | sv | ||||||||
1438247379015192577 | swyx 33521530 | 2021-09-15T21:04:31+00:00 | @KennethCassel how much you reckon a domain like cal dot com costs? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 67] | 1438244327516356615 | 1319269656264409088 | KennethCassel | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1438249806082686976 | swyx 33521530 | 2021-09-15T21:14:09+00:00 | @KennethCassel @brianleroux got a guesstimate for an on-brand 3 letter dot com domain? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 86] | 1438248517957419009 | 1319269656264409088 | KennethCassel | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1451333295409491971 | swyx 33521530 | 2021-10-21T23:43:16+00:00 | @KennethCassel f yes this is incredible. well done. hey @supabase @flutterflow take note | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 88] | 1451229925395030021 | 1319269656264409088 | KennethCassel | 0 | 0 | 8 | 0 | 0 | en | ||||||||
1454210028374614016 | swyx 33521530 | 2021-10-29T22:14:23+00:00 | @KennethCassel well that seems like an easy fix!... i hope | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 58] | 1454209766612406275 | 1319269656264409088 | KennethCassel | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1470466078790729729 | swyx 33521530 | 2021-12-13T18:50:07+00:00 | @KennethCassel @SlipApp brave move and still kudos for all the incredible building in public along the way!! still somewhat hoping for at least WIP blogposts for Advanced @Supabase Techniques someday :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [24, 202] | 1470438097284390916 | 1319269656264409088 | KennethCassel | 0 | 0 | 11 | 0 | 0 | en | ||||||||
1455019078616190980 | swyx 33521530 | 2021-11-01T03:49:15+00:00 | @danBamikiya @evanderkoogh yes i actually also read this from @adamgordonbell recently which was nice! https://earthly.dev/blog/awk-examples/ for this specific example I didn't actually need awk but yeah i need someone to make sed/grep/find as accessible too heheh | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [27, 250] | 1455009896743723016 | 1319013132258390021 | danBamikiya | 0 | 0 | 3 | 0 | 0 | 0 | en | |||||||
1422582662401650690 | swyx 33521530 | 2021-08-03T15:38:31+00:00 | @knocklabs nice post! seems very tied to auth system. perhaps the flip side of these 3 is security notifications - new login, new device, changed password. Is there such a thing as "blocking notifications"? - like how Apple makes you confirm on another Apple device when logging in | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 283] | 1422580553954512900 | 1317913795726106625 | knocklabs | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1431302874026242051 | swyx 33521530 | 2021-08-27T17:09:32+00:00 | @CopyEzekiel @jessievbreugel thanks for the shout out! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [29, 54] | 1431256776171687938 | 1317895022021242880 | CopyEzekiel | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1448896200132812801 | swyx 33521530 | 2021-10-15T06:19:07+00:00 | @MarkLeuchter i feel like @david_perell would have something to say to your students! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 85] | 1448429055557218309 | 1315999090925281280 | MarkLeuchter | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1471242253012062208 | swyx 33521530 | 2021-12-15T22:14:22+00:00 | @elliotclydenz @0xKFN https://twitter.com/swyx/status/1193817952593707008?s=20 | 1193817952593707008 1193817952593707008 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 45] | 1471029674092359680 | 1315039343686287360 | elliotclydenz | 1 | 0 | 2 | 0 | 0 | 0 | und | ||||||
1442967686787436561 | swyx 33521530 | 2021-09-28T21:41:20+00:00 | @DicksonWuML nice! do it 💪 i think @eugeneyan's blog is a stellar example of how to do it really, really well https://eugeneyan.com/writing/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 134] | 1442957337925341187 | 1313267011670151169 | DicksonWuML | 0 | 0 | 3 | 0 | 0 | 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 | ||||||||
1456742254140293120 | swyx 33521530 | 2021-11-05T21:56:33+00:00 | @breiding_j yes definitely the moment i have some time and mood is right will switch | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 84] | 1456741864246185989 | 1308234654734979074 | breiding_j | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1435729110232403971 | swyx 33521530 | 2021-09-08T22:17:49+00:00 | @getupnext @readwiseio nice work 👏! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 35] | 1435697205235445761 | 1306704425654915073 | getupnext | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1440096790615715854 | swyx 33521530 | 2021-09-20T23:33:25+00:00 | @getupnext @radjay love the gif! easy to understand | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [19, 51] | 1440093451396141069 | 1306704425654915073 | getupnext | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1436017409538854913 | swyx 33521530 | 2021-09-09T17:23:25+00:00 | @_phosphoricons @mhevery @QwikDev @InfobipShift here is React saying the opposite: https://twitter.com/acdlite/status/977291318324948992?s=21 the real problem is taking for granted that “X is slow” everywhere in all contexts. performance is relative and conditional. if you arent clear on your assumptions you won’t know when your conclusions are invalid. | 977291318324948992 977291318324948992 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [48, 321] | 1436016082347872257 | 1305300579804119046 | _phosphoricons | 1 | 0 | 3 | 0 | 0 | 0 | en | ||||||
1424282103127019521 | swyx 33521530 | 2021-08-08T08:11:29+00:00 | @SRuhleder thanks Sebastian :) yeah i try to introduce stuff from my Chinese heritage where i can. Western folks usually enjoy it as they have never heard this stuff that has been around for like 4000 years | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 206] | 1424278395739910145 | 1298880717749997570 | SRuhleder | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1460489833160142848 | swyx 33521530 | 2021-11-16T06:08:05+00:00 | @YairDev @JoshWComeau @csswizardry's article changed the way i think about margins forever: https://csswizardry.com/2012/06/single-direction-margin-declarations/ knowing about collapse is good, but having rules so that you dont even think about it 99% of the time can be better (altho i like layout components too) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 268] | 1459780398741864448 | 1297737445404966913 | YairDev | 0 | 1 | 7 | 0 | 0 | 0 | en | |||||||
1422633636772270081 | swyx 33521530 | 2021-08-03T19:01:04+00:00 | @TikTokInvestors @closenowbro TikTokInvestors is long chaos, direction agnostic | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [30, 79] | 1422588355036925957 | 1295428909538906115 | TikTokInvestors | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1424283657049579523 | swyx 33521530 | 2021-08-08T08:17:40+00:00 | @TikTokInvestors @BillSPACman pet rock was the original nft craze | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [30, 65] | 1424114476169768962 | 1295428909538906115 | TikTokInvestors | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1435796785323200516 | swyx 33521530 | 2021-09-09T02:46:44+00:00 | @TikTokInvestors he said he was just gonna check the price, ended up levering up at the highs, he done fucked up. intervention time IMO | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 135] | 1435746451347234816 | 1295428909538906115 | TikTokInvestors | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1459038192535937030 | swyx 33521530 | 2021-11-12T05:59:47+00:00 | @TikTokInvestors still. obsessed. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [17, 33] | 1356311976067166208 | 1295428909538906115 | TikTokInvestors | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1454211768192958467 | swyx 33521530 | 2021-10-29T22:21:18+00:00 | @Jennabot5000 all bugs are equally feared in this house no worries | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 66] | 1454211279682510856 | 1293902268979445761 | Jennabot5000 | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1444737301611827202 | swyx 33521530 | 2021-10-03T18:53:09+00:00 | @SoftwareSocPod you two have amazing chemistry and are both working on interesting projects! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 92] | 1444312230162534401 | 1288427219786891265 | SoftwareSocPod | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1468154498761650177 | swyx 33521530 | 2021-12-07T09:44:44+00:00 | @jakobgreenfeld got a chart for this but for product hunt? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 58] | 1468143869426606081 | 1285142519525892098 | jakobgreenfeld | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1468156519808131075 | swyx 33521530 | 2021-12-07T09:52:46+00:00 | @jakobgreenfeld ☠️ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 18] | 1468155042813419520 | 1285142519525892098 | jakobgreenfeld | 0 | 0 | 1 | 0 | 0 | und | ||||||||
1468158323992059904 | swyx 33521530 | 2021-12-07T09:59:56+00:00 | @jakobgreenfeld that's some pretty damn quick number crunching skills there! i have another fun metric for you to try: Number of PH #1 of the day winners that now 404. it was roughly 10-15% when i checked 2017's winners in 2018 https://twitter.com/swyx/status/970106789189636098?s=20 | 970106789189636098 970106789189636098 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 253] | 1468157620741722121 | 1285142519525892098 | jakobgreenfeld | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1468159004132052992 | swyx 33521530 | 2021-12-07T10:02:38+00:00 | @jakobgreenfeld https://twitter.com/swyx/status/1468159004132052992/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 15] | 1468154599290949638 | 1285142519525892098 | jakobgreenfeld | 0 | 0 | 2 | 0 | 0 | 0 | und | |||||||
1468161588540547074 | swyx 33521530 | 2021-12-07T10:12:54+00:00 | @jakobgreenfeld dude today i was writing a DSL interpreter and it predicted this shit. wasnt accurate but was pretty close. meaning it understands AST traversal/language interpreter type stuff 🤯 https://twitter.com/swyx/status/1468161588540547074/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 195] | 1468159751305449475 | 1285142519525892098 | jakobgreenfeld | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1468168056983592963 | swyx 33521530 | 2021-12-07T10:38:36+00:00 | @jakobgreenfeld the fact that ~2% of 2021's winners are already dead... | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 71] | 1468165838318538758 | 1285142519525892098 | jakobgreenfeld | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1468168672602583040 | swyx 33521530 | 2021-12-07T10:41:03+00:00 | @jakobgreenfeld or the charitable explanation is that 7-8% bitrot is "normal" baseline, and vintages 2015-2018 have more age and therefore more bitrot or maybe around 2018 people started realizing that even if the project is dead they should at least 302 it to the next thing | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 276] | 1468167107569455107 | 1285142519525892098 | jakobgreenfeld | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1424146086663393283 | swyx 33521530 | 2021-08-07T23:11:01+00:00 | @fig not alphabetical, clearly fake! /s | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [5, 39] | 1423712335663833089 | 1274458723948195840 | fig | 0 | 0 | 11 | 0 | 0 | en | ||||||||
1423392137257775105 | swyx 33521530 | 2021-08-05T21:15:05+00:00 | @TheEhsanSarshar yes very easily there are a few ways to do it | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 62] | 1423389685410320384 | 1269951243272806401 | TheEhsanSarshar | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1443448964737486848 | swyx 33521530 | 2021-09-30T05:33:45+00:00 | @TheEhsanSarshar it would break the comparison with the poll i did last year which is the main point of asking again this year :) 1 year ago nobody was considering anything but btc | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 180] | 1443448568996581376 | 1269951243272806401 | TheEhsanSarshar | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1428103782810873859 | swyx 33521530 | 2021-08-18T21:17:29+00:00 | @mozzius @reactjs @jquery https://twitter.com/swyx/status/1093200303254466561 | 1093200303254466561 1093200303254466561 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [26, 49] | 1428103288537354241 | 1266850963429752832 | mozzius | 1 | 0 | 4 | 0 | 0 | 0 | und | ||||||
1451460947449573378 | swyx 33521530 | 2021-10-22T08:10:31+00:00 | @mozzius @nocashirl yea and i was a junior trader too. i think seniors got 32. thats like 2 months of the year not working lol | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [20, 126] | 1451460372200927235 | 1266850963429752832 | mozzius | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1420174513824620546 | swyx 33521530 | 2021-07-28T00:09:24+00:00 | @monicalimco look at my blog analytics lol | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 42] | 1419848153428234248 | 1265436714136297473 | monicalimco | 0 | 0 | 22 | 0 | 0 | en | ||||||||
1441597202959421441 | swyx 33521530 | 2021-09-25T02:55:31+00:00 | @monicalimco music. wanna perform in a bar band before i die | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 60] | 1441579301262872581 | 1265436714136297473 | monicalimco | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1439765227512369154 | swyx 33521530 | 2021-09-20T01:35:54+00:00 | @ananbatra @ListnrInc holy shit, congrats! have you done any interviews or blogposts on your origin story/why you started working on Listnr? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 141] | 1439565177179959301 | 1264520152508481537 | ananbatra | 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]);