tweets
3,837 rows sorted by coordinates
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1427636302325981188 | swyx 33521530 | 2021-08-17T14:19:53+00:00 | RT @jim_ej: Brilliant talk brought to me by @swyx: https://swyx.transistor.fm/episodes/weekend-drop-what-we-know-we-dont-know-hillel-wayne. What we know about coding based on evidence. TDD is no better t… | 1427577933074505728 1427577933074505728 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 0 | 1 | 0 | en | |||||||||
1427640108950466570 | swyx 33521530 | 2021-08-17T14:35:00+00:00 | @peggyrayzis woww huge! congrats to you and your team!!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 56] | 1427625528031387652 | 711729626482081792 | peggyrayzis | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427640343034482704 | swyx 33521530 | 2021-08-17T14:35:56+00:00 | @fortelabs i thought this might have been a Succession parody | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 61] | 1427357032609304587 | 1909232666 | fortelabs | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1427644236472766468 | swyx 33521530 | 2021-08-17T14:51:24+00:00 | Apollo becomes the first GraphQL devtool unicorn, 10 years after graduating from YC as Meteor. Huge validation step for those who bet on Apollo, but curiously no mention of commercial offerings in this blogpost. How does @apollographql make money and any estimates how much? 👀 https://twitter.com/apollographql/status/1427616423824797698 | 1427616423824797698 1427616423824797698 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 278] | 1 | 18 | 185 | 0 | 0 | 0 | en | |||||||||
1427648315416485888 | swyx 33521530 | 2021-08-17T15:07:37+00:00 | @NicR_ spotify collaborative filtering | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [7, 38] | 1427644494934069267 | 19419379 | NicR_ | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1427651244907134980 | swyx 33521530 | 2021-08-17T15:19:15+00:00 | @peggyrayzis @apollographql ahhh "and enterprise annual recurring revenue (ARR) nearly tripled over the last 12 months" excellent | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [28, 129] | 1427648571206144000 | 711729626482081792 | peggyrayzis | 0 | 0 | 10 | 0 | 0 | en | ||||||||
1427652102864523266 | swyx 33521530 | 2021-08-17T15:22:40+00:00 | @graysonhicks @apollographql thanks! thats a pretty solid differentiation between the free tier and team plan. I wonder how many companies are actually paying the sticker price of $49/seat. ballpark multiples 100-200x so they are making something like $7.5m-$15m ARR? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [29, 268] | 1427645788998492165 | 316209864 | graysonhicks | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1427656945528233984 | swyx 33521530 | 2021-08-17T15:41:55+00:00 | @Hicksyfern @apollographql yeah i got quite excited about Engine 3 years ago! https://twitter.com/swyx/status/1050091276715077632?s=20 good to see it still lives on, i admit i was more excited about it than it turned out haha. i wonder why they backed off the Engine branding. what changed from the original vision? | 1050091276715077632 1050091276715077632 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [27, 282] | 1427656370103410699 | 154248263 | Hicksyfern | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
1427664421308878853 | swyx 33521530 | 2021-08-17T16:11:37+00:00 | @flybayer @ThePracticalDev if Hacker News was overrun with "10 Free Tools that Will Save You 10 Hours a Week!!" listicles | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [27, 121] | 1427655238652137475 | 2826554209 | flybayer | 0 | 0 | 20 | 0 | 0 | en | ||||||||
1427664583993352192 | swyx 33521530 | 2021-08-17T16:12:16+00:00 | @kmelve thanks! let me know what you think/disagree with! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 57] | 1427662879793295365 | 798123 | kmelve | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427665920835477504 | swyx 33521530 | 2021-08-17T16:17:34+00:00 | @kmelve hahah. what was the outcome? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 36] | 1427664884259491849 | 798123 | kmelve | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1427668288075558913 | swyx 33521530 | 2021-08-17T16:26:59+00:00 | @pmccrann @circleapp thats awesome!! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [21, 36] | 1427604146140729373 | 12220692 | pmccrann | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427668507500507141 | swyx 33521530 | 2021-08-17T16:27:51+00:00 | @aronkor @NoCodeConf "Code is Lava" where you offer hilarious and extreme examples of people doing stuff without code | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [21, 117] | 1427644016997326861 | 292090863 | aronkor | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1427669027913015300 | swyx 33521530 | 2021-08-17T16:29:55+00:00 | @andrewingram @_philpl i have historically underestimated how crazy things can get but my sense is this would not be feasible given how Apollo relies on interop with the rest of the GraphQL ecosystem. More likely that they define a proprietary superset, which effectively each vendor needs to do anyway. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [23, 303] | 1427667480139403265 | 9164512 | andrewingram | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1427670290167865347 | swyx 33521530 | 2021-08-17T16:34:56+00:00 | @andrewingram its also an interesting name collision with @edgeandnode's @graphprotocol, also called The Graph everyone trying to build the One Graph to rule them all 👀 (and ofc @onegraphio is already all the way there) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 220] | 1427654400814862354 | 9164512 | andrewingram | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1427673244358774786 | Jamund Ferguson 119903601 | 2021-08-17T16:46:40+00:00 | Been learning more about dev-rel lately and this article from @swyx was incredible! https://www.swyx.io/measuring-devrel | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 107] | 0 | 2 | 4 | 0 | 1 | 0 | en | ||||||||||
1427673966949277697 | swyx 33521530 | 2021-08-17T16:49:33+00:00 | @andrewingram @apollographql i mean, paying them money/developing with them is betting on them. Relay may have the hearts of individual developers but they dont have an enterprise sales team and coordinated marketing/devrel effort. not saying that's required (see: React) but it surely helps | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [29, 292] | 1427645962860875786 | 9164512 | andrewingram | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1427674041335181314 | swyx 33521530 | 2021-08-17T16:49:51+00:00 | RT @xjamundx: Been learning more about dev-rel lately and this article from @swyx was incredible! https://www.swyx.io/measuring-devrel | 1427673244358774786 1427673244358774786 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 121] | 0 | 2 | 0 | 0 | 1 | 0 | en | |||||||||
1427674081843826691 | swyx 33521530 | 2021-08-17T16:50:00+00:00 | @xjamundx thanks man, written in part with you in mind!! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 56] | 1427673244358774786 | 119903601 | xjamundx | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1427687345780793345 | swyx 33521530 | 2021-08-17T17:42:43+00:00 | @erikras @httpJunkie @apollographql @honeypotio Knowledge of useful things is power. Knowledge of all things is distraction. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [48, 124] | 1427685460239867909 | 7618412 | erikras | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1427703308760752132 | swyx 33521530 | 2021-08-17T18:46:08+00:00 | @erinfoox amazing 😍 would you reinvest it in the company if you could? you'd be saving a bunch in taxes | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 103] | 1427702880950099971 | 259171305 | erinfoox | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1427704526178381828 | swyx 33521530 | 2021-08-17T18:50:59+00:00 | @arvidkahl Finding Excuses to Tweet | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 35] | 1427613028346912771 | 343990983 | arvidkahl | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1427709213287981056 | swyx 33521530 | 2021-08-17T19:09:36+00:00 | This is an incredible landing page: https://imba.io/ Huge congrats to @sindreaars and the entire @scrimba team 👏🏽 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 121] | 0 | 15 | 118 | 0 | 0 | 0 | en | ||||||||||
1427725779509518337 | swyx 33521530 | 2021-08-17T20:15:26+00:00 | @geddski @Netlify i'm just waiting for it to get out of beta 👀 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [18, 62] | 1427724176614301696 | 39607761 | geddski | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1427736439316307969 | swyx 33521530 | 2021-08-17T20:57:47+00:00 | @juzbo @apollographql in a way its just trivia, though it’d make for an inspiring story of perservering through challenges | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 122] | 1427680891548098564 | 13256302 | juzbo | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427737083339186177 | swyx 33521530 | 2021-08-17T21:00:21+00:00 | @rstacruz @marckohlbrugge i could’ve sworn this used to be fully built out! did you change it somehow? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 102] | 1427594190515367938 | 9513832 | rstacruz | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1427766366191316997 | swyx 33521530 | 2021-08-17T22:56:42+00:00 | @StartuptoLast sorry to see you end but it was great while it lasted! thank you and enjoy the new job! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 102] | 1427757070397411331 | 1154528612554399745 | StartuptoLast | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1427770886912761856 | swyx 33521530 | 2021-08-17T23:14:40+00:00 | @texastoland @alanmynah @sindreaars @scrimba the first language of the web is html. imba is clearly a great solution for scrimba but to go for mass adoption it will face the same challenges Elm did. (fuly aware i may eat my words here so what do i know) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [45, 254] | 1427768524794056704 | 1003839292773367810 | texastoland | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1427773012577701889 | swyx 33521530 | 2021-08-17T23:23:07+00:00 | @0xca0a where do i look up info on their proposal or info? this is unfamiliar syntax to me | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 90] | 1427732215732051973 | 835209520200699909 | 0xca0a | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1427775806223257600 | swyx 33521530 | 2021-08-17T23:34:13+00:00 | @clemmihai and doing it so well 👏 you make it look easy even tho i know it couldnt be easy. come so far from your @fullstack days! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 130] | 1427732369876807687 | 4796832195 | clemmihai | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1427776791762984967 | swyx 33521530 | 2021-08-17T23:38:08+00:00 | @EugeneNg_VCap ambition and vision is good and all but i really wish he had talked about serving customers or community instead of being so fixated on valuation. down that path lies a lot of corpses of companies ruined by giant egos putting money over people. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 259] | 1427734201017589763 | 915576521129041920 | EugeneNg_VCap | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1427783827120816132 | swyx 33521530 | 2021-08-18T00:06:05+00:00 | @EugeneNg_VCap nice save :) | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [15, 27] | 1427782927715209226 | 915576521129041920 | EugeneNg_VCap | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427787386080034823 | swyx 33521530 | 2021-08-18T00:20:14+00:00 | @clemmihai @fullstack podcast is still cached in some services if you ever need it! i think i offered it to David to take it over when i left but no momentum on their end | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 170] | 1427786239378223107 | 4796832195 | clemmihai | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1427791147728920576 | swyx 33521530 | 2021-08-18T00:35:11+00:00 | @BrantApps @Hicksyfern @JustEatUK hmm so.. was the 6th star a failure? is it still in place today? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [34, 98] | 1427790695960559624 | 345246419 | BrantApps | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1427792224859746305 | swyx 33521530 | 2021-08-18T00:39:28+00:00 | There’s a significant “it just works” premium built into everything from Apple. Every time I try to leave the Apple ecosystem in some way the thesis is invariably some version of “you get the same for less”. Every time I crawl back to Apple because the extra $ is worth it. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 275] | 0 | 7 | 155 | 0 | 0 | en | |||||||||||
1427792566922010626 | swyx 33521530 | 2021-08-18T00:40:49+00:00 | @BrantApps @Hicksyfern @JustEatUK add one star per year, simple | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [34, 63] | 1427792321970638850 | 345246419 | BrantApps | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427794159520256002 | swyx 33521530 | 2021-08-18T00:47:09+00:00 | I’ve been wearing fitness trackers for years. First night of wearing it, my $229 @fitbit Versa 3 did this to my hand. also music controls were just buggy (pause, cant restart). watchface doesnt activate when i raise my hand. headed back in for the $329 Apple Watch. https://twitter.com/swyx/status/1427794159520256002/video/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 267] | 1427792224859746305 | 33521530 | swyx | 0 | 0 | 24 | 0 | 0 | 0 | en | |||||||
1427794789508939778 | swyx 33521530 | 2021-08-18T00:49:39+00:00 | @Swizec @Chris2Brooks but Apple doesnt make webcams? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 52] | 1427793494857244672 | 15353121 | Swizec | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427795748842733568 | swyx 33521530 | 2021-08-18T00:53:28+00:00 | @jdeisenberg i was purely on windows til 2015 so there’s a strong familiarity bias there. the one time i tried ubuntu i struggled too much with device drivers and some basic programs i was used to didnt have a Linux port | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 220] | 1427794095825510401 | 14947707 | jdeisenberg | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1427798652018257923 | swyx 33521530 | 2021-08-18T01:05:00+00:00 | @chriscoyier the people who get this spend too much time online and should call their parents more often | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 104] | 1427798104422723591 | 793830 | chriscoyier | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1427804453462110222 | swyx 33521530 | 2021-08-18T01:28:03+00:00 | @ferreiracoder @RegalizDev 🤗 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 28] | 1427803823444217863 | 1255874155792216070 | ferreiracoder | 0 | 0 | 1 | 0 | 0 | und | ||||||||
1427810778283794439 | swyx 33521530 | 2021-08-18T01:53:11+00:00 | @taddeusz2002 @AdamRackis there are a surprising amount of iPhone-Android marriages in the replies | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 98] | 1427809121764528130 | 35821019 | taddeusz2002 | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427859671130406914 | swyx 33521530 | 2021-08-18T05:07:28+00:00 | @jtmthf @andrewingram @apollographql what are you basing your perception of slowness on? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [37, 88] | 1427846414705496064 | 785719431183802369 | jtmthf | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1427862892976611333 | swyx 33521530 | 2021-08-18T05:20:16+00:00 | When you visit @stephsmithio's Doing Content Right, you'll notice the unusual book pricing: raising prices every 30 copies. This is a stroke of *GENIUS*, and on today's mixtape I analyze it via @RobertCialdini's advice on Social Proof and Scarcity: https://share.transistor.fm/s/fe762816 🔥 https://twitter.com/swyx/status/1427862892976611333/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 276] | 0 | 2 | 47 | 0 | 0 | 0 | en | ||||||||||
1427866714482429961 | swyx 33521530 | 2021-08-18T05:35:27+00:00 | Snorkel is now a unicorn! https://twitter.com/SnorkelAI/status/1424724444048658436 | 1424724444048658436 1424724444048658436 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 25] | 1417746151411879938 | 33521530 | swyx | 1 | 0 | 2 | 0 | 0 | 0 | en | ||||||
1427871806879199232 | swyx 33521530 | 2021-08-18T05:55:41+00:00 | @tarungangwani tuning in to the recording now but yeah how the heck do you have a Metaverse podcast without the guy who wrote the definitive Metaverse blog series | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 162] | 1423033413213167620 | 23854138 | tarungangwani | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1427882841791111175 | swyx 33521530 | 2021-08-18T06:39:32+00:00 | @youyuxi @0xca0a @Rich_Harris @rauschma i think i understand your concern but i gotta ask - whats the most reasonable alternative to github discussions? mailing list? twitter? closed committee where corporations buy seats? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [40, 222] | 1427755853944348674 | 182821975 | youyuxi | 0 | 0 | 10 | 0 | 0 | en | ||||||||
1427909000285200386 | swyx 33521530 | 2021-08-18T08:23:29+00:00 | @avaitla16 what even is the source of this beef? feel like Sam is responding to something i didnt see | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 101] | 1427745539848818688 | 859749975999127552 | avaitla16 | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427988073292476418 | Emelia 👸🏻 14063149 | 2021-08-18T13:37:42+00:00 | @JessTelford JWTs for external use tend not to solve the problems people think they do; for internal use, or cross authorisation boundaries, they can be good because then you can assert using public/private key cryptography that the token your presented really came from the authorising server | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 293] | 1427986367905161221 | 14063149 | ThisIsMissEm | 0 | 1 | 14 | 0 | 0 | en | ||||||||
1428016338371452930 | Tina 1167502098898018305 | 2021-08-18T15:30:00+00:00 | We just launched our public beta: - Brand new dashboard - Media Manager with @cloudinary - Command line quickstart - And much more! Visual editing has arrived! https://tina.io/ https://twitter.com/tina_cms/status/1428016338371452930/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 189] | 0 | 52 | 247 | 0 | 1 | 0 | en | ||||||||||
1428020323098656769 | swyx 33521530 | 2021-08-18T15:45:51+00:00 | @oliviamdh @zkwentz haha thanks and hi! i mostly write for developers but also in developer marketing. | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [20, 102] | 1428012113973452800 | 64942879 | oliviamdh | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1428025214588366848 | Jakub Smetanka 🇸🇰☕ 757480803307753472 | 2021-08-18T16:05:17+00:00 | What was the last book you have read, or you are reading ? I have already finnished The @Coding_Career Handbook by Shawn Swyx Wang and I really like it. #books #CodeNewbies #Career | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 180] | 0 | 3 | 11 | 0 | 1 | en | |||||||||||
1428028645755416589 | swyx 33521530 | 2021-08-18T16:18:55+00:00 | RT @tina_cms: We just launched our public beta: - Brand new dashboard - Media Manager with @cloudinary - Command line quickstart - And mu… | 1428016338371452930 1428016338371452930 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 52 | 0 | 0 | 1 | en | ||||||||||
1428047358441320451 | swyx 33521530 | 2021-08-18T17:33:16+00:00 | @Swizec more british than what I would say but directionally correct | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 68] | 1428043156231135239 | 15353121 | Swizec | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1428047544140009476 | swyx 33521530 | 2021-08-18T17:34:01+00:00 | @Rich_Harris @SteveALee @oplik0 @youyuxi @0xca0a @rauschma @TheASF @w3c No standardization without consultation!! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [72, 113] | 1428046385597779973 | 19487837 | Rich_Harris | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1428048895850942471 | swyx 33521530 | 2021-08-18T17:39:23+00:00 | Advice for coworker new to @savvycal_: There's an unspoken etiquette to scheduling links. It can seem rude as it requires the other side to fit to your schedule Preempt it: “I’d be happy to book a meeting if you have a calendar link, or I can send you mine” and link if hypertext | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 1 | 19 | 0 | 0 | en | |||||||||||
1428048972803805187 | swyx 33521530 | 2021-08-18T17:39:41+00:00 | @bcomnes shit. you feeling ok? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 30] | 1428040875800764416 | 2149850018 | bcomnes | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1428061205902630916 | Lauren Tan 2832427459 | 2021-08-18T18:28:18+00:00 | I'm sorta back from a long twitter break! I've been spending my free time slowly getting through @thorstenball's excellent "Writing A Compiler In Go" in Rust (https://github.com/poteto/monkers), and also started playing FFXIV again lol. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 226] | 0 | 4 | 97 | 0 | 1 | 0 | en | ||||||||||
1428064822940164099 | swyx 33521530 | 2021-08-18T18:42:40+00:00 | @luisotravz thanks Luis! glad to see you are enjoying ship30! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 61] | 1428038491276025857 | 54321491 | luisotravz | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1428067590920761349 | swyx 33521530 | 2021-08-18T18:53:40+00:00 | PSA: I'm noticing a rise in unsolicited emails from @Github email scraping recently. This was the most egregious one so far. looked like a GitHub link but was actually a phishing site. https://github.com/medusajs/medusa/issues/344 I should know better than clicking on links in emails but i'm a chump https://twitter.com/swyx/status/1428067590920761349/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 26 | 0 | 0 | 0 | en | ||||||||||
1428069457415397377 | swyx 33521530 | 2021-08-18T19:01:05+00:00 | @github screen shot of admission before they delete https://twitter.com/swyx/status/1428069457415397377/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 51] | 1428067590920761349 | 33521530 | swyx | 0 | 0 | 4 | 0 | 0 | 0 | en | |||||||
1428094040482877443 | swyx 33521530 | 2021-08-18T20:38:46+00:00 | @gerardketuma ayyy lol | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 22] | 1428093852531974149 | 177109652 | gerardketuma | 0 | 0 | 0 | 0 | 0 | ht | ||||||||
1428094708899745793 | swyx 33521530 | 2021-08-18T20:41:25+00:00 | 2 years on... nice explanation and discussion of JWTs here, and I pretty much am exactly where Emelia is at https://twitter.com/ThisIsMissEm/status/1427988073292476418?s=20 | 1427988073292476418 1427988073292476418 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 132] | 1133780714988736512 | 33521530 | swyx | 1 | 1 | 10 | 0 | 0 | 0 | en | ||||||
1428097815255736325 | swyx 33521530 | 2021-08-18T20:53:46+00:00 | @ErikCH @savvycal_ its the gesture that counts! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 47] | 1428097230930591755 | 14961381 | ErikCH | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1428100847712423938 | swyx 33521530 | 2021-08-18T21:05:49+00:00 | 👀👀👀👀👀👀👀👀👀👀 https://twitter.com/swyx/status/1428100847712423938/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 10] | 1428097711383871489 | 33521530 | swyx | 0 | 0 | 12 | 0 | 0 | 0 | und | |||||||
1428100952200859648 | swyx 33521530 | 2021-08-18T21:06:14+00:00 | @xjamundx how about "we now use both React and jQuery screw it" https://twitter.com/swyx/status/1428100847712423938?s=20 | 1428100847712423938 1428100847712423938 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 88] | 1428098541671518208 | 119903601 | xjamundx | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
1428102298241159172 | swyx 33521530 | 2021-08-18T21:11:35+00:00 | Very surprised to see Netflix apparently now uses BOTH @Reactjs and @jQuery on Netflix dot com, 4 years after being celebrated for ripping out React. What in the world is going on in there?? 👀 https://twitter.com/NetflixUIE/status/923374215041912833 https://twitter.com/swyx/status/1428102298241159172/photo/1 | 923374215041912833 923374215041912833 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 217] | 1 | 33 | 299 | 0 | 0 | 0 | en | |||||||||
1428103577164075013 | swyx 33521530 | 2021-08-18T21:16:40+00:00 | @VictorPontis @reactjs @jquery my shitpost game was better back then | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [31, 68] | 1428102760956841987 | 186993579 | VictorPontis | 0 | 0 | 26 | 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 | ||||||
1428113221236363267 | swyx 33521530 | 2021-08-18T21:54:59+00:00 | @lillichoung gotta look at who is doing the recommending. JWT is very convenient for serverless and vendors. meanwhile everyone running rails and django set up sessions, send httponly cookies and carry on with their day. the only vendor who does it right is @begin https://twitter.com/swyx/status/1254871936514969600?s=21 | 1254871936514969600 1254871936514969600 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 289] | 1428111899502288902 | 2336043613 | lillichoung | 1 | 0 | 3 | 0 | 0 | 0 | en | ||||||
1428114812249071618 | swyx 33521530 | 2021-08-18T22:01:18+00:00 | RT @sugarpirate_: I'm sorta back from a long twitter break! I've been spending my free time slowly getting through @thorstenball's excellen… | 1428061205902630916 1428061205902630916 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 4 | 0 | 0 | 1 | en | ||||||||||
1428130743381762055 | swyx 33521530 | 2021-08-18T23:04:37+00:00 | Just got reminded its the 3 year anniversary of my first conf talk: https://www.youtube.com/watch?v=nyFHR0dDZo0 I remember being so nervous, just 1 year out of bootcamp talking React in front of my heroes @ReactRally. Never regretted it. If you can, speak at a conference. Will change your life. https://twitter.com/swyx/status/1030130810588819456 | 1030130810588819456 1030130810588819456 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 1 | 1 | 71 | 0 | 0 | 0 | en | |||||||||
1428133615574130690 | Frederick Weiss 🫀 70805899 | 2021-08-18T23:16:02+00:00 | Especially enlightening episode on The @swyx Mixtape today. Social Proof and Scarcity, and the Principles of #influence https://swyx.transistor.fm/episodes/social-proof-and-scarcity-robert-cialdini | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 143] | 0 | 2 | 5 | 0 | 1 | 0 | en | ||||||||||
1428139798871433218 | swyx 33521530 | 2021-08-18T23:40:36+00:00 | RT @FrederickWeiss: Especially enlightening episode on The @swyx Mixtape today. Social Proof and Scarcity, and the Principles of #influence… | 1428133615574130690 1428133615574130690 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 2 | 0 | 0 | 1 | en | ||||||||||
1428140893605818371 | swyx 33521530 | 2021-08-18T23:44:57+00:00 | @tedwards947 @reactjs @jquery haha all good! i'm not the kind to judge when i dont have all the facts. was randomly reminded of it by @TwemexApp. i'm sure y'all watch your metrics like a hawk and dont need twitter busybodies 🧡 that said, happy to talk to anyone about trying @Sveltejs for netflix.com :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [30, 305] | 1428136848417824774 | 334914120 | tedwards947 | 0 | 0 | 10 | 0 | 0 | en | ||||||||
1428149223850012673 | swyx 33521530 | 2021-08-19T00:18:03+00:00 | ⚛️ Using MDX to progressively upgrade Docs Links with @reactjs https://youtu.be/LbC4WZoyinI Perhaps a fun @docusaurus hack - you can swizzle MDX components and write your own custom HTML elements that enhance user experience. #extendThePlatform? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 242] | 0 | 2 | 24 | 0 | 0 | 0 | en | ||||||||||
1428210178424406019 | swyx 33521530 | 2021-08-19T04:20:16+00:00 | @AyushCodes @ReactRally @Rich_Harris that is some lofty comparison! thanks for watching and glad you liked it 🤗 | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [37, 111] | 1428206538708033541 | 1261649364184956929 | AyushCodes | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1428222649721712646 | swyx 33521530 | 2021-08-19T05:09:49+00:00 | @farzad_yz @ReactRally haha on the livestream? amazing. thank you 🙏🏽 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [23, 68] | 1428216444450390022 | 304289713 | farzad_yz | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1428236014082924548 | swyx 33521530 | 2021-08-19T06:02:55+00:00 | @KajetanSw @ReactRally good luck! dont rush like i did, make sure to grab attention when starting (have high energy, joke, poll, video clip, story, whatever), slow down your words (because of nervousness) and, if presenting code, ENLARGE THE FONT! if prerecorded, tips here https://twitter.com/swyx/status/1363110323268374530 | 1363110323268374530 1363110323268374530 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [23, 298] | 1428234170812321802 | 1069315566375264261 | KajetanSw | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
1428241684798664706 | swyx 33521530 | 2021-08-19T06:25:27+00:00 | RT @jakub_smetanka: What was the last book you have read, or you are reading ? I have already finnished The @Coding_Career Handbook by Shaw… | 1428025214588366848 1428025214588366848 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 3 | 0 | 0 | 1 | en | ||||||||||
1428241827862257664 | swyx 33521530 | 2021-08-19T06:26:01+00:00 | @jakub_smetanka @Coding_Career oh awesome news!! I'd love to read more about what really resonated with you! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [31, 108] | 1428025214588366848 | 757480803307753472 | smetankajakub_ | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1428242133710934018 | Kajetan Świątek 1069315566375264261 | 2021-08-19T06:27:14+00:00 | @swyx @ReactRally Thanks! Those are perfect tips. Rushing is definitely something I do when I'm nervous. I'll try to mitigate that when rehearsing. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [18, 148] | 1428236014082924548 | 33521530 | swyx | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1428246127464259585 | swyx 33521530 | 2021-08-19T06:43:06+00:00 | Speaking tip - it's not about quantity! Don't rush! Two helpful techniques: - Pause. In a world of nonstop noise... Silence stands out. - Repeat. Repetition consciously underlines the important. Recap your points every 5-7 minutes. You'll naturally calm down. https://twitter.com/KajetanSw/status/1428242133710934018 | 1428242133710934018 1428242133710934018 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 261] | 1 | 2 | 26 | 0 | 0 | 0 | en | |||||||||
1428254686138621953 | swyx 33521530 | 2021-08-19T07:17:07+00:00 | @stephsmithio @RobertCialdini Today's clip follows up to this with a much more underappreciated principle: Consistency and Commitment! https://share.transistor.fm/s/434ac6e2 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [30, 159] | 1427862892976611333 | 33521530 | swyx | 0 | 0 | 0 | 0 | 0 | 0 | en | |||||||
1428263984755396624 | swyx 33521530 | 2021-08-19T07:54:04+00:00 | @petersuhm @savvycal_ yknow i may be weird but i never use the personalize feature. people im friends with dont need it, and people who are distant i do the “ask for their link and heres mine” trick anyway. i wonder if @derrickreimer has stats on how much it’s ACTUALLY used in practice. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 287] | 1428260724942549001 | 21908850 | petersuhm | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1428264197998092293 | swyx 33521530 | 2021-08-19T07:54:55+00:00 | @mxstbr @sjwhitworth may also want to check out @louisnicholls_ sales for founders course | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [21, 89] | 1428259621257494532 | 2451223458 | mxstbr | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1428264391317721093 | swyx 33521530 | 2021-08-19T07:55:41+00:00 | @NadavKeyson amazing. @kevmodrome worth checking out? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 53] | 1428254746704551936 | 146781335 | NadavKeyson | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1428266802174332930 | swyx 33521530 | 2021-08-19T08:05:16+00:00 | @sebastienlorber @docusaurus thank you!! yeah the real challenge is TWO WAY linking… (aka destination page also gets a list of pages that link to it) i think it is possible but need to hack into the classic theme even further. in gatsby this is easy bc of the data pipeline but here im less familiar | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [29, 299] | 1428265486274514947 | 40663578 | sebastienlorber | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1428267482867933191 | swyx 33521530 | 2021-08-19T08:07:58+00:00 | @sebastienlorber @reactjs @docusaurus code is here! https://github.com/sw-yx/demo-docusaurus-mdx-preview-poc/blob/ec326366710577162500b78ced31a4734b47b101/src/theme/MDXComponents/index.js#L63 idk if its possible to enable by default, it requires the weird importing and extra metadata for rendering the short description. but i’d love to see if u have ideas. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [38, 243] | 1428266511580508164 | 40663578 | sebastienlorber | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1428267871528919042 | swyx 33521530 | 2021-08-19T08:09:31+00:00 | @sebastienlorber @reactjs @docusaurus ah makes sense. perhaps worth inserting a “you may not need to swizzle! try wrapping instead!” when someone uses the swizzle —danger flag | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [38, 175] | 1428267010291601408 | 40663578 | sebastienlorber | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1428268334257037313 | swyx 33521530 | 2021-08-19T08:11:21+00:00 | @sebastienlorber @reactjs @docusaurus got u. my thinking on this one is someday i might want to display an excerpt derived from the markdown itself so i can offer rich text in the preview. but no idea how to cut it off automatically/manually. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [38, 243] | 1428267246477090820 | 40663578 | sebastienlorber | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1428269886883581952 | swyx 33521530 | 2021-08-19T08:17:31+00:00 | @sebastienlorber @docusaurus 🔥 one nuance to handle here is you may also want to track which section links to the page, so in the backlink you can use the #anchor tag to send readers directly to the linked text. mad science bonus goal: include surrounding text | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [29, 264] | 1428268180972216323 | 40663578 | sebastienlorber | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1428270277956231169 | swyx 33521530 | 2021-08-19T08:19:04+00:00 | @andrewingram @docusaurus yes that was my plan originally. but i think i will want to add options in future. much cleaner to just use a special tag throughout so i can clearly search n replace in future if need be | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 213] | 1428268895006298112 | 9164512 | andrewingram | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1428270697105612802 | swyx 33521530 | 2021-08-19T08:20:44+00:00 | @sebastienlorber @reactjs @docusaurus i think also would be no problem rendering iframe since same origin, no screenshot needed. yeah ok so we’ll just go with simple metadata for now ♥️ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [38, 187] | 1428269843199971332 | 40663578 | sebastienlorber | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1428397753827172353 | swyx 33521530 | 2021-08-19T16:45:37+00:00 | @samseely @knocklabs @WorkOS nice!! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [29, 35] | 1428396736259702798 | 29101388 | samseely | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1428398804932259852 | swyx 33521530 | 2021-08-19T16:49:48+00:00 | @fortelabs checks out (chinese names often work best in groups of 4, i might market test 打造二脑 to see how people react. 打造外脑 might be more self evident at the cost of compromising "Second" for "External") https://twitter.com/swyx/status/1428398804932259852/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 204] | 1428397878154698752 | 1909232666 | fortelabs | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1428402268550754304 | Beyang Liu 16520821 | 2021-08-19T17:03:33+00:00 | Super happy that a lot of these efforts are now well under way. Especially excited about indexing the entire world of open source and making it searchable in one place! https://venturebeat.com/2021/08/19/sourcegraph-plans-to-index-the-entire-open-source-web https://twitter.com/beyang/status/1346652236378566657 | 1346652236378566657 1346652236378566657 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 192] | 1 | 4 | 26 | 0 | 1 | 0 | en | |||||||||
1428402450839457800 | swyx 33521530 | 2021-08-19T17:04:17+00:00 | RT @beyang: Super happy that a lot of these efforts are now well under way. Especially excited about indexing the entire world of open sour… | 1428402268550754304 1428402268550754304 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 4 | 0 | 0 | 1 | en | ||||||||||
1428403597717368833 | swyx 33521530 | 2021-08-19T17:08:50+00:00 | @slightlylate I genuinely struggle with how much to care about standards. Standards are obviously extremely important. but 99.999% of us will never even be involved, much less have meta opinions on the process of rulemaking. yet we (and eventually our users) are all impacted eventually. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 287] | 1428401349574623235 | 229237555 | slightlylate | 0 | 0 | 10 | 0 | 0 | en | ||||||||
1428409475229118468 | swyx 33521530 | 2021-08-19T17:32:12+00:00 | @JustGage @sotak 🙏 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [17, 18] | 1428409299953274882 | 17006530 | JustGage | 0 | 0 | 1 | 0 | 0 | und |
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]);