tweets
3,342 rows where is_quote_status = 0 sorted by in_reply_to_user_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1424751510995406850 | Gergely Orosz 30192824 | 2021-08-09T15:16:45+00:00 | While EU companies are pondering if €80K/year for a senior engineer is too much or not, more (US) VC-funded ones are starting to offer €120K ($140-150K) and up *plus* equity for seniors in Europe. Here’s an example with @RevenueCat, who pay location independent. https://twitter.com/GergelyOrosz/status/1424751510995406850/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 263] | 0 | 75 | 588 | 0 | 0 | 0 | en | ||||||||||
1424769790107820032 | james.com 714203117663948802 | 2021-08-09T16:29:23+00:00 | Very excited to finally share what @richardfreling, @vinayyala, and I are working on @CommandBar adds a magical "command k" widget to any web app - Let users search to discover any feature - Blazingly fast CLI for your power users - De-bloat your UI https://techcrunch.com/2021/08/09/commandbar-raises-4-8m-to-make-web-based-apps-searchable/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 34 | 191 | 0 | 0 | 0 | en | ||||||||||
1424816422216028160 | Temporal 1204202807298969600 | 2021-08-09T19:34:41+00:00 | Our CEO @mfateev was recently on the @OssStartup podcast and had a great discussion about open source and @temporalio. https://docs.temporal.io/blog/oss-startups-podcast/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 144] | 0 | 9 | 20 | 0 | 0 | 0 | en | ||||||||||
1424951893864816644 | swyx 33521530 | 2021-08-10T04:33:00+00:00 | This diagram stood out in an essay I was reading: https://moretothat.com/money/ When locked in a zero sum debate, add a dimension to find the way out. https://twitter.com/swyx/status/1424951893864816644/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 145] | 0 | 88 | 243 | 0 | 0 | 0 | en | ||||||||||
1425099638491783183 | Rich Harris 19487837 | 2021-08-10T14:20:05+00:00 | god help me i wrote about alert() https://dev.to/richharris/stay-alert-d | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 57] | 0 | 309 | 1147 | 0 | 1 | 0 | en | ||||||||||
1425125459008704513 | swyx 33521530 | 2021-08-10T16:02:41+00:00 | RT @Rich_Harris: god help me i wrote about alert() https://dev.to/richharris/stay-alert-d | 1425099638491783183 1425099638491783183 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 74] | 0 | 309 | 0 | 0 | 1 | 0 | en | |||||||||
1425169044227850244 | swyx 33521530 | 2021-08-10T18:55:53+00:00 | 🔥 Quick tip on docs - if you have a list of points with long text, give a bolded 2-3 word summary upfront. https://twitter.com/swyx/status/1425169044227850244/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 106] | 0 | 38 | 309 | 0 | 0 | 0 | en | ||||||||||
1425175777000136706 | swyx 33521530 | 2021-08-10T19:22:38+00:00 | RT @swyx: One thing I've consistently had to relearn in developer marketing: "Talk benefits, not features" doesn't work! Developers are s… | 1361279902889086980 1361279902889086980 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 105 | 0 | 0 | 1 | en | ||||||||||
1425185575645024256 | Sharif Shameem 107186366 | 2021-08-10T20:01:34+00:00 | Here I am generating ~20 versions of a web app by describing what I want in just 1 sentence to @DebuildHQ. Debuild uses GPT-3 + Codex to: - Generate a product spec - Generate the data model - Write the SQL queries - Generate the React UI - Deploy it in 1 click https://twitter.com/sharifshameem/status/1425185575645024256/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 261] | 0 | 119 | 670 | 0 | 0 | 0 | en | ||||||||||
1425204981804650496 | swyx 33521530 | 2021-08-10T21:18:41+00:00 | Need research help: What is the best job scheduling/cronjob system you've used and what's one thing you LOVE about it? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 118] | 0 | 6 | 99 | 0 | 0 | en | |||||||||||
1425487171172044815 | React Summit 🗓 June 17 & 21, 2022 3023155108 | 2021-08-11T16:00:00+00:00 | There was a time before #ReactJS, and there will be life after. If you tie yourself too closely to any tech, you might trap yourself. @swyx zooms out from the state management library du jour to see what timeless lessons we can learn from #ReactJS: https://buff.ly/37tzisJ | Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 | 0 | [0, 274] | 0 | 6 | 11 | 0 | 1 | 0 | en | ||||||||||
1425503610213785600 | swyx 33521530 | 2021-08-11T17:05:19+00:00 | RT @ReactSummit: There was a time before #ReactJS, and there will be life after. If you tie yourself too closely to any tech, you might tra… | 1425487171172044815 1425487171172044815 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 6 | 0 | 0 | 1 | en | ||||||||||
1425505817827151872 | GitHub 13334762 | 2021-08-11T17:14:06+00:00 | 🤫 New shortcut: Press . on any GitHub repo. https://twitter.com/github/status/1425505817827151872/video/1 | Sprout Social 2feaa4497dbf2f5efce3ede84518b1db6517855c | 0 | [0, 44] | 0 | 5013 | 17116 | 0 | 0 | 0 | en | ||||||||||
1425514852999745547 | egghead.io 921398240 | 2021-08-11T17:50:00+00:00 | Go deep with @supabase In this new course from @signalnerve you'll: 📀 Create a Postgres database 🔐 Authorize users with GitHub 🔌 Set up real-time data 🌩 Deploy to Cloudlflare Pages Build a real-time chat app with Next and Supabase https://bit.ly/3AsYhJh | Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 | 0 | [0, 260] | 0 | 28 | 128 | 0 | 1 | 0 | en | ||||||||||
1425529550377684996 | swyx 33521530 | 2021-08-11T18:48:24+00:00 | This move by @GitHub is bold and inspiring. https://github.blog/2021-08-11-githubs-engineering-team-moved-codespaces/ With GitHub aggressively dogfooding Codespaces, cloud dev environments just went from "haha cute toy" to "OK this has serious enterprise investment". You're also now using Azure without knowing it. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 266] | 0 | 62 | 368 | 0 | 0 | 0 | en | ||||||||||
1425673473108504576 | swyx 33521530 | 2021-08-12T04:20:18+00:00 | RT @eggheadio: Go deep with @supabase In this new course from @signalnerve you'll: 📀 Create a Postgres database 🔐 Authorize users with G… | 1425514852999745547 1425514852999745547 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 28 | 0 | 0 | 1 | en | ||||||||||
1425677272644677633 | swyx 33521530 | 2021-08-12T04:35:24+00:00 | At what point did we stop having fires in fireside chats and when do we get them back | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 85] | 0 | 0 | 39 | 0 | 0 | en | |||||||||||
1425711567392317444 | swyx 33521530 | 2021-08-12T06:51:40+00:00 | RT @TrungTPhan: 12/ Quick video cut of @elonmusk breaking down SpaceX’s 5-Step design and manufacturing process: https://twitter.com/TrungTPhan/status/1425476793327259651/video/1 | 1425476793327259651 1425476793327259651 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 136] | 0 | 439 | 0 | 0 | 1 | 0 | en | |||||||||
1425716946977185793 | swyx 33521530 | 2021-08-12T07:13:03+00:00 | Every few months I marvel at the perfect timing of the releases of AWS Lambda (max lock in) and Kubernetes (min lock in) and how they make total sense given each cloud’s position. Behind the scenes tech strategists are playing a giant game of 4D chess and we are the pawns. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 274] | 0 | 0 | 15 | 0 | 0 | en | |||||||||||
1425825423837974545 | ppk 🇪🇺 887251 | 2021-08-12T14:24:06+00:00 | Breaking the web forward https://www.quirksmode.org/blog/archives/2021/08/breaking_the_we.html | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 49] | 0 | 45 | 75 | 0 | 1 | 0 | en | ||||||||||
1425825714788503552 | James Long 14615235 | 2021-08-12T14:25:15+00:00 | 🎉 It's finally ready! I've been hacking on something for the past couple months and it's absurdly great. It's time for more powerful web apps. Announcing "A future for SQL on the web": https://jlongster.com/future-sql-web | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 209] | 0 | 566 | 2316 | 0 | 1 | 0 | en | ||||||||||
1425838034725969921 | swyx 33521530 | 2021-08-12T15:14:12+00:00 | RT @jlongster: 🎉 It's finally ready! I've been hacking on something for the past couple months and it's absurdly great. It's time for more… | 1425825714788503552 1425825714788503552 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 139] | 0 | 566 | 0 | 0 | 1 | en | ||||||||||
1425853831775129601 | honeycomb 4710974593 | 2021-08-12T16:16:59+00:00 | Alex Vondrak unpacks distributed column stores, what they are, how they work, and why they're an absolutely essential requirement for enabling observability. https://go.hny.co/3jJIPSo | HubSpot d78b4a9b46e06ba0d2837568fe022315819e1c30 | 0 | [0, 182] | 0 | 39 | 245 | 0 | 0 | 0 | en | ||||||||||
1425868308708999176 | Rob Richardson 18905413 | 2021-08-12T17:14:30+00:00 | https://dev.to/swyx/an-annotated-guide-to-the-react-server-components-demo-2a83 - a look at the #React #Server #Components announcement. Nice tl;dr analysis @swyx | Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 | 0 | [0, 106] | 0 | 4 | 10 | 0 | 1 | 0 | en | ||||||||||
1425877361011027977 | swyx 33521530 | 2021-08-12T17:50:29+00:00 | RT @rob_rich: https://dev.to/swyx/an-annotated-guide-to-the-react-server-components-demo-2a83 - a look at the #React #Server #Components announcement. Nice tl;dr analysis @swyx | 1425868308708999176 1425868308708999176 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 120] | 0 | 4 | 0 | 0 | 1 | 0 | en | |||||||||
1425889455643119616 | swyx 33521530 | 2021-08-12T18:38:32+00:00 | No Apple, I don't have any music on iTunes. No Apple, I don't run my email on Apple Mail. No Apple, I don't need to look up the meaning of a word I accidentally selected and force clicked. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 190] | 0 | 6 | 87 | 0 | 0 | en | |||||||||||
1426027634270654467 | Jim OShaughnessy 28369153 | 2021-08-13T03:47:36+00:00 | 1/ Why You Should Write Letters to Your Kids as They Grow--A thread I've noticed a lot of FinTwiters having babies. Congratulations! I'd like to recommend you get into a habit early, and start writing letters to them that you can give them at some milestone, like turning 21. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 0 | 251 | 1860 | 0 | 1 | en | |||||||||||
1426069279674232836 | Rahul Sawant 749556404 | 2021-08-13T06:33:06+00:00 | I like @swyx Mixtape, especially Fridays..🎶 https://swyx.transistor.fm/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 67] | 0 | 1 | 4 | 0 | 1 | 0 | en | ||||||||||
1426075900441874438 | swyx 33521530 | 2021-08-13T06:59:24+00:00 | RT @Raalzz: I like @swyx Mixtape, especially Fridays..🎶 https://swyx.transistor.fm/ | 1426069279674232836 1426069279674232836 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 79] | 0 | 1 | 0 | 0 | 1 | 0 | en | |||||||||
1426279632479744004 | swyx 33521530 | 2021-08-13T20:28:58+00:00 | RT @jposhaughnessy: 1/ Why You Should Write Letters to Your Kids as They Grow--A thread I've noticed a lot of FinTwiters having babies. C… | 1426027634270654467 1426027634270654467 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 251 | 0 | 0 | 1 | en | ||||||||||
1426318522242588675 | Chanta Clause 🧑🎄 12745092 | 2021-08-13T23:03:30+00:00 | i’m on sveltejs hype | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 20] | 0 | 8 | 189 | 0 | 0 | da | |||||||||||
1426537001868685314 | Rajat Gupta 1297539457696980994 | 2021-08-14T13:31:39+00:00 | If you mugged up the rules of React Hooks like me - watch this. Great explanation of the internals by @swyx https://youtu.be/KJP1E-Y-xyo | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 133] | 0 | 10 | 49 | 0 | 1 | 0 | en | ||||||||||
1426600484773662724 | swyx 33521530 | 2021-08-14T17:43:55+00:00 | RT @rajatetc: If you mugged up the rules of React Hooks like me - watch this. Great explanation of the internals by @swyx https://t.co/ix… | 1426537001868685314 1426537001868685314 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 10 | 0 | 0 | 1 | en | ||||||||||
1426672482975551490 | swyx 33521530 | 2021-08-14T22:30:00+00:00 | Passwordless no code low code creator economy cohort based buy now pay later mRNA CRISPR lab grown space blockchain | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 115] | 0 | 40 | 522 | 0 | 0 | en | |||||||||||
1426730661721776134 | swyx 33521530 | 2021-08-15T02:21:11+00:00 | RT @ppk: Breaking the web forward https://www.quirksmode.org/blog/archives/2021/08/breaking_the_we.html | 1425825423837974545 1425825423837974545 | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 58] | 0 | 45 | 0 | 0 | 1 | 0 | en | |||||||||
1426749508524797952 | swyx 33521530 | 2021-08-15T03:36:05+00:00 | Random idea: “Information Dietician” Studies the difference between what you consume and what you want to produce and gives you a plan for diet change, with weekly group checkins. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 180] | 0 | 3 | 74 | 0 | 0 | en | |||||||||||
1426918866052132870 | Big Tech Alert 1042038539800731650 | 2021-08-15T14:49:03+00:00 | 👥 @uber is now following @ponyheadson | Stuff F e5f554c6214aad6e1c1eda8f85df8098e77da7c3 | 0 | [0, 37] | 0 | 0 | 3 | 0 | 0 | en | |||||||||||
1426944198519885824 | swyx 33521530 | 2021-08-15T16:29:42+00:00 | RT @Mappletons: @swyx 17. This collection has now matured into a full grown essay documenting the history of "digital gardening" as an etho… | 1426937335460114441 1426937335460114441 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 16 | 0 | 0 | 1 | en | ||||||||||
1427019802430754819 | swyx 33521530 | 2021-08-15T21:30:08+00:00 | This week's newsletter will have a preview of my next post: "Measuring Developer Relations" https://www.swyx.io/subscribe/ I started out writing an "Advice for New Devrels" article for @willjohnsonio, @jkup, @kevmodrome, @Nutlope and others but it just blew up into a whole series 😅 https://twitter.com/swyx/status/1427019802430754819/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 0 | 3 | 27 | 0 | 0 | 0 | en | ||||||||||
1427085098986315779 | swyx 33521530 | 2021-08-16T01:49:36+00:00 | Everyone uses @Discord for community now, but not enough talking about Discord as Second Brain: - World class xplatform app - Unlimited history search - People can discuss realtime - Mature bot automation Amazing platform for @andy_matuschak "working with the garage door up". | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 0 | 4 | 46 | 0 | 0 | en | |||||||||||
1427149449105534976 | swyx 33521530 | 2021-08-16T06:05:18+00:00 | Ah time for the weekly passive aggressive attack from my iPad https://twitter.com/swyx/status/1427149449105534976/photo/1 | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 61] | 0 | 1 | 81 | 0 | 0 | 0 | en | ||||||||||
1427351638872772633 | swyx 33521530 | 2021-08-16T19:28:44+00:00 | 🆕 Measuring Developer Relations https://www.swyx.io/measuring-devrel/ How you measure DevRel = what you think effective DevRel *is* + your philosophy on lagging vs leading metrics for a creative, unattributable, human endeavor. Here are some thoughts for friends entering the industry: | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 24 | 93 | 0 | 1 | 0 | en | ||||||||||
1427363684037369866 | Will Lawrence ⭕️ 840115172 | 2021-08-16T20:16:36+00:00 | Still in love with this piece by @swyx. I feel like creating + working is a good mix for me. My work informs my writing and my writing helps me be better in my job. The challenge is managing scope creep when creating. Timeboxing helps here ☺️ https://www.swyx.io/part-time-creator-manifesto/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 0 | 2 | 25 | 0 | 1 | 0 | en | ||||||||||
1427365094938202112 | swyx 33521530 | 2021-08-16T20:22:12+00:00 | RT @will_lawrenceTO: Still in love with this piece by @swyx. I feel like creating + working is a good mix for me. My work informs my writ… | 1427363684037369866 1427363684037369866 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 2 | 0 | 0 | 1 | en | ||||||||||
1427373400616407051 | swyx 33521530 | 2021-08-16T20:55:12+00:00 | RT @feross: "Apple's web engine consistently trails others in both compatibility and features, resulting in a large and persistent gap with… | 1420471522703986688 1420471522703986688 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 6 | 0 | 0 | 1 | en | ||||||||||
1427417904643928079 | swyx 33521530 | 2021-08-16T23:52:03+00:00 | RT @swyx: 🆕 Measuring Developer Relations https://www.swyx.io/measuring-devrel/ How you measure DevRel = what you think effective DevRel *is* + your p… | 1427351638872772633 1427351638872772633 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 24 | 0 | 0 | 1 | 0 | en | |||||||||
1427457113463300106 | swyx 33521530 | 2021-08-17T02:27:51+00:00 | Are we stuck with 5 star rating systems forever? A single irate customer can total someone’s livelihood with a 1 and there’s no meaningful difference between a 4.6 and a 4.7. Is anyone working on a viable alternative to the tyranny of Black Mirror style rating systems? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 270] | 0 | 6 | 130 | 0 | 0 | en | |||||||||||
1427577933074505728 | James Ellis-Jones 65615053 | 2021-08-17T10:27:57+00:00 | 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 than any other testing, Code Review is more effective at removing defects than any kind of testing, many other things we get told to do have no effect. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 0 | 2 | 6 | 0 | 1 | 0 | en | ||||||||||
1427616423824797698 | Apollo 4918589052 | 2021-08-17T13:00:53+00:00 | Today, we're happy to announce our $130 million Series D, valuing Apollo at over $1.5 billion. Many thanks to the Apollo community and team for helping us achieve this incredible milestone! 🚀 https://twitter.com/apollographql/status/1427616423824797698/video/1 | Sprout Social 2feaa4497dbf2f5efce3ede84518b1db6517855c | 0 | [0, 192] | 0 | 130 | 795 | 0 | 0 | 0 | en | ||||||||||
1427618325232771076 | Ben Greenberg 16190869 | 2021-08-17T13:08:27+00:00 | This post by @swyx should be mandatory reading for anyone trying to think through how to measure effectively the bit ambiguous field of #devrel https://dev.to/dx/measuring-developer-relations-ie8 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 169] | 0 | 5 | 16 | 0 | 1 | 0 | en | ||||||||||
1427636024881074195 | swyx 33521530 | 2021-08-17T14:18:47+00:00 | RT @RabbiGreenberg: This post by @swyx should be mandatory reading for anyone trying to think through how to measure effectively the bit am… | 1427618325232771076 1427618325232771076 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 5 | 0 | 0 | 1 | en | ||||||||||
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 | |||||||||
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 | ||||||||||
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 | |||||||||
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 | ||||||||||
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 | |||||||||||
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 | ||||||||||
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 | ||||||||||
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 | ||||||||||
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 | |||||||||||
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 | ||||||||||
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 | ||||||||||
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 | ||||||||||
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 | ||||||||||
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 | ||||||||||
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 | ||||||||||
1428470276426289161 | Shit User Story 1351114532408668163 | 2021-08-19T21:33:48+00:00 | As a… – remote worker I want to… – give facebook access to four cameras strapped to my head so that… – I can simulate an in-person meeting that could have been an email https://twitter.com/ShitUserStory/status/1428470276426289161/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 168] | 0 | 1136 | 5795 | 0 | 1 | 0 | en | ||||||||||
1428472408139132961 | swyx 33521530 | 2021-08-19T21:42:16+00:00 | It pisses me off how poorly developers are taught to validate/parse inputs. Bad assumptions -> bad errors -> bad UX. That simple. If every dev spent 1 hour learning how to validate/parse their inputs properly we'd have dramatically more usable software for the rest of our lives | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 286] | 0 | 22 | 292 | 0 | 0 | en | |||||||||||
1428549842817601538 | Jay 1122531494025674754 | 2021-08-20T02:49:58+00:00 | . @highlightrun hangout with the all-mighty @swyx 💪 https://twitter.com/theJayKhatri/status/1428549842817601538/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 51] | 0 | 0 | 27 | 0 | 0 | 0 | en | ||||||||||
1428567896033095686 | swyx 33521530 | 2021-08-20T04:01:42+00:00 | RT @ShitUserStory: As a… – remote worker I want to… – give facebook access to four cameras strapped to my head so that… – I can simulate an… | 1428470276426289161 1428470276426289161 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1136 | 0 | 0 | 1 | en | ||||||||||
1428582154800275458 | swyx 33521530 | 2021-08-20T04:58:22+00:00 | RT @react_india: 🚨Nominate Speakers 🚨 If you know someone who has something great to talk about, nominate them. Join @GantLaborde @swyx… | 1428580204088373252 1428580204088373252 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 3 | 0 | 0 | 1 | en | ||||||||||
1428740355994767369 | swyx 33521530 | 2021-08-20T15:27:00+00:00 | I finally finished my Developer Marketing Bingo Card https://twitter.com/swyx/status/1428740355994767369/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 52] | 0 | 46 | 297 | 0 | 0 | 0 | en | ||||||||||
1428771895936049158 | Ava 3127370223 | 2021-08-20T17:32:19+00:00 | most people think they want optionality but actually just want reassurance that they’ve made the Right Choice | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 109] | 0 | 104 | 1152 | 0 | 0 | en | |||||||||||
1428861510164520960 | swyx 33521530 | 2021-08-20T23:28:25+00:00 | I got Gigabit internet ("up to 1000 Mbps") and TIL how much antennae affect internet speeds as measured by fast.com: Plugged in Ethernet: 780mbps iPad on 5G: 200mbps iPhone on 5G: 120mbps iPad on 2G: 80mbps iPhone on 2G: 60mbps | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 1 | 47 | 0 | 0 | en | |||||||||||
1428933561835421696 | swyx 33521530 | 2021-08-21T04:14:44+00:00 | Connected with a clinical psychologist over our mutual suspicion of Enneagrams today TIL that there are more developed alternatives to the Big 5 OCEAN Personality traits: MMPI: ~500 questions https://en.wikipedia.org/wiki/Minnesota_Multiphasic_Personality_Inventory MCMI: ~200 questions https://en.wikipedia.org/wiki/Millon_Clinical_Multiaxial_Inventory fascinating! https://twitter.com/swyx/status/1428933561835421696/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 276] | 0 | 0 | 7 | 0 | 0 | 0 | en | ||||||||||
1429120212687736837 | swyx 33521530 | 2021-08-21T16:36:25+00:00 | I get qtns from “lurkers” who ask about my Twitter/newsletter/podcast strategy and are surprised to hear I have no strategy. Just principles. 1. Write about stuff that fascinates you 2. Find others who share your interests 3. Keep going thats the infinite game of #LearnInPublic | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 0 | 4 | 52 | 0 | 0 | en | |||||||||||
1429536652196651012 | swyx 33521530 | 2021-08-22T20:11:12+00:00 | forgot who said this: There are two schools of thought in tech vs humanity. The Zuckerberg school: “Done FOR you”, Algorithm is king, Data wins debate. The Jobs school: “Done WITH you”, Tech is a “bicycle for the mind”, Intuitiveness wins debate. I hope we remember the latter. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 0 | 8 | 121 | 0 | 0 | en | |||||||||||
1429608015057981446 | Ben Thompson 40273 | 2021-08-23T00:54:46+00:00 | If I could convince everyone in the world to read and understand one article about COVID it would be this one. FWIW it very closely tracks the understanding I’ve developed over many months now, and explains all of the twists and turns to date. https://cspicenter.org/blog/waronscience/why-covid-19-is-here-to-stay-and-why-you-shouldnt-worry-about-it/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 269] | 0 | 295 | 1430 | 0 | 1 | 0 | en | ||||||||||
1429649362594852868 | swyx 33521530 | 2021-08-23T03:39:04+00:00 | I am in Denver for the week! Thinking of organizing a social dinner on Friday. anyone in? any other events going on this week? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 127] | 0 | 0 | 19 | 0 | 0 | en | |||||||||||
1429649523769372676 | swyx 33521530 | 2021-08-23T03:39:42+00:00 | RT @benthompson: If I could convince everyone in the world to read and understand one article about COVID it would be this one. FWIW it ver… | 1429608015057981446 1429608015057981446 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 295 | 0 | 0 | 1 | en | ||||||||||
1429725966335713281 | Nebojsa (Cookie Duster) 1055736485830451200 | 2021-08-23T08:43:28+00:00 | Another awesome read from @swyx https://www.swyx.io/measuring-devrel/ Best bit: Traditional marketing advice says people have to hear about you at least 7 times before they decide to buy; for developer tools, Matt Biilmann from Netlify says it's more like 14. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 246] | 0 | 1 | 9 | 0 | 1 | 0 | en | ||||||||||
1429727373503524864 | swyx 33521530 | 2021-08-23T08:49:03+00:00 | RT @CookieDuster_N: Another awesome read from @swyx https://www.swyx.io/measuring-devrel/ Best bit: Traditional marketing advice says people have to hea… | 1429725966335713281 1429725966335713281 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1 | 0 | 0 | 1 | 0 | en | |||||||||
1429888354192019476 | swyx 33521530 | 2021-08-23T19:28:44+00:00 | 🆕 Blog: Why Isn't Usage Based Billing A Bigger Category? https://dev.to/swyx/why-isn-t-usage-based-billing-a-bigger-category-m8b | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 81] | 0 | 2 | 29 | 0 | 0 | 0 | en | ||||||||||
1430018964764069892 | swyx 33521530 | 2021-08-24T04:07:44+00:00 | RT @SlamsFist: @SpiderManMovie https://twitter.com/SlamsFist/status/1429981875259514883/photo/1 | 1429981875259514883 1429981875259514883 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 54] | 0 | 839 | 0 | 0 | 1 | 0 | und | |||||||||
1430165281205325837 | Zack Kanter 466880049 | 2021-08-24T13:49:08+00:00 | Bezos interviewed by @om (2008) on the origins on AWS: "We were finding we were spending too much time on fine-grained coordination between our network engineering groups and our applications programming groups...we decided to build a hardened interface between those two layers." https://twitter.com/zackkanter/status/1430165281205325837/video/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 0 | 85 | 493 | 0 | 1 | 0 | en | ||||||||||
1430179658088263685 | swyx 33521530 | 2021-08-24T14:46:16+00:00 | RT @swyx: Write Errors that Don’t Make Me Think https://www.swyx.io/write-errors-that-don-t-make-me-think-24hg/ Error messages and Error pages (see @RozenMD’s https://t.co/uaPH3… | 1430179632637218821 1430179632637218821 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 5 | 0 | 0 | 1 | 0 | en | |||||||||
1430222201588895745 | swyx 33521530 | 2021-08-24T17:35:19+00:00 | 🚵🏽♂️ If you're in Denver, I'm in town with the UI team from @temporalio for an offsite and will be hosting a small group dinner tomorrow! we'll be talking @sveltejs, microservices, design, webdev, startups, whatever else @stolinski and @mdharrington_ are up to! DM if interested | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 281] | 0 | 2 | 31 | 0 | 0 | en | |||||||||||
1430258542523551746 | swyx 33521530 | 2021-08-24T19:59:44+00:00 | RT @arahansen: @Madisonkanna I like @swyx's take on the topic https://www.swyx.io/why-tailwind/ | 1430254888869502977 1430254888869502977 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 85] | 0 | 1 | 0 | 0 | 1 | 0 | en | |||||||||
1430370226550448132 | swyx 33521530 | 2021-08-25T03:23:31+00:00 | RT @zackkanter: Bezos interviewed by @om (2008) on the origins on AWS: "We were finding we were spending too much time on fine-grained coor… | 1430165281205325837 1430165281205325837 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 85 | 0 | 0 | 1 | en | ||||||||||
1430587772889223175 | Dion Almaer 4216361 | 2021-08-25T17:47:58+00:00 | ★ New Job! Arming Developers @ Shopify I am excited to share the news that, after a lovely summer post-Google, I have taken a new job at Shopify. My mission focuses on helping developers succeed at delivering amazing, diverse commerce experiences. https://blog.almaer.com/new-job-arming-developers-shopify/ 🧵 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 276] | 0 | 13 | 404 | 0 | 1 | 0 | en | ||||||||||
1430609058885636098 | swyx 33521530 | 2021-08-25T19:12:33+00:00 | RT @dalmaer: ★ New Job! Arming Developers @ Shopify I am excited to share the news that, after a lovely summer post-Google, I have taken a… | 1430587772889223175 1430587772889223175 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 13 | 0 | 0 | 1 | en | ||||||||||
1430638980169568256 | swyx 33521530 | 2021-08-25T21:11:27+00:00 | Today I made a suggestion for "DivOps Engineer" to be an official job title at work, wondering if this term is going to catch on @kylewelch @jcreamer898 :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 155] | 0 | 2 | 43 | 0 | 0 | en | |||||||||||
1430678607014162435 | Danielle Baskin 55662470 | 2021-08-25T23:48:55+00:00 | I made a game called Cofounder Quest to find a new collaborator! I'm hiding the game on floppy disks all over the city in places where a software engineer is likely to stumble into it. ⚡️ Enjoy, http://cofounder.quest https://twitter.com/djbaskin/status/1430678607014162435/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 219] | 0 | 287 | 2387 | 0 | 1 | 0 | en | ||||||||||
1430685599258734592 | Madison Kanna 1087957969915006976 | 2021-08-26T00:16:42+00:00 | Good article by @swyx on why he changed his mind about Tailwind https://www.swyx.io/why-tailwind | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 88] | 0 | 3 | 25 | 0 | 1 | 0 | en | ||||||||||
1430729757767868421 | swyx 33521530 | 2021-08-26T03:12:10+00:00 | RT @Madisonkanna: Good article by @swyx on why he changed his mind about Tailwind https://www.swyx.io/why-tailwind | 1430685599258734592 1430685599258734592 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 106] | 0 | 3 | 0 | 0 | 1 | 0 | en | |||||||||
1430741775350603781 | swyx 33521530 | 2021-08-26T03:59:55+00:00 | RT @djbaskin: I made a game called Cofounder Quest to find a new collaborator! I'm hiding the game on floppy disks all over the city in pla… | 1430678607014162435 1430678607014162435 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 287 | 0 | 0 | 1 | en | ||||||||||
1430865774034489360 | nader dabit (🧱, 🚀) | sha.eth | nader.sol 17189394 | 2021-08-26T12:12:39+00:00 | I just published "The New Creator Economy - DAOs, Community Ownership, & Cryptoeconomics" This is the favorite thing I've ever written, mainly because I was able to explore a lot of ideas that I'm really interested in right now. Hope you enjoy! 🤲 (1/3) https://dev.to/dabit3/the-new-creator-economy-daos-community-ownership-and-cryptoeconomics-lnl | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 282] | 0 | 45 | 296 | 0 | 1 | 0 | en | ||||||||||
1430880791316373512 | Forrest Brazeal 3239330680 | 2021-08-26T13:12:19+00:00 | The Cloud Resume Challenge Book has officially LAUNCHED! 🚀First 100 sales are 15% off with this link - move fast. https://forrestbrazeal.gumroad.com/l/cloud-resume-challenge-book/launch-deal But I haven't even told you the best part yet. Here is Cool Announcement #2 of the week: | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 227] | 0 | 14 | 93 | 0 | 1 | 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]);