tweets

This is data scraped from swyx's timeline! See blog post

53 rows where retweet_count = 5 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, in_reply_to_user_id, is_quote_status, favorited, retweeted

retweet_count 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
1142025639744008194 swyx 33521530 2019-06-21T11:05:04+00:00 @AdamRackis @afontcu_ the developer arrogance mantra: Everything that came before me sucked Everything that comes after me is unnecessary Everything I use right now is PERFECT DONT FUCKING TOUCH IT       Twitter Web Client 887710c0899816dfe9fb0176eb05d760cbe15732 0 [22, 200] 1142024335567273987 68567860 AdamRackis       0 5 43 0 0   en  
1240747430141988864 swyx 33521530 2020-03-19T21:10:13+00:00 ✍️What You Can Do with Netlify Build Plugins https://www.swyx.io/writing/netlify-build-plugins I've spent some time dabbling with @netlify Build Plugins. Here's some ideas! - Notifiers - Cache/Asset Optimization - Deploy Blockers - Generate Source Files - Generate Build Artefacts - Weird Combos       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 272]             0 5 41 0 0 0 en  
1255515906953719808 swyx 33521530 2020-04-29T15:14:53+00:00 Me: conference talks are hard and they're all cancelled Them: we'll have talks at home Conference talks at home: https://twitter.com/swyx/status/1255515906953719808/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 114]             0 5 52 0 0 0 en  
1318608931938131968 swyx 33521530 2020-10-20T17:44:02+00:00 Lastly - I officially left the /r/reactjs mod team today. Here are some reflections on the entire process in case it helps others! https://dev.to/swyx/moderating-a-220k-developer-community-3doj       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 157] 1318558184836091905 33521530 swyx       0 5 62 0 1 0 en  
1326786181447766019 swyx 33521530 2020-11-12T07:17:30+00:00 Java has been consistently falling in adoption from the most popular language in the world in the 2000s to falling under Python for the first time this year. https://www.tiobe.com/tiobe-index/ Wondering if by 2030 it might someday fall below C#. https://twitter.com/swyx/status/1326786181447766019/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 236]             0 5 57 0 0 0 en  
1349271110492196870 swyx 33521530 2021-01-13T08:24:35+00:00 @krtierney @mipsytipsy I collect questions as a hobby. one of my dreams is to build a search engine for better questions instead of better answers. we have too many answers. we're not being trained to ask the right questions.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 226] 1349270238399905793 33521530 swyx       0 5 45 0 0   en  
1387487111964626945 swyx 33521530 2021-04-28T19:21:20+00:00 🆕 80/20 is the new Half-Ass https://swyx.io/8020/ Don't spend your life exerting 20% effort... hoping for 80% results... only to look back and wonder why you never hit 100% on anything. a response to @ShaanVP and @stephsmithio who are my inspirations (really, I mean it)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 5 71 0 0 0 en  
1395172543565344770 swyx 33521530 2021-05-20T00:20:30+00:00 🆕 How to Optimize for Change My first post on the @freeCodeCamp blog in a while! 2 years ago, @dan_abramov told us *why* to optimize for change. Ever since then, I've been exploring the obvious next question: How? https://www.freecodecamp.org/news/how-to-optimize-for-change-software-development/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 243]             0 5 64 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  
1430179632637218821 swyx 33521530 2021-08-24T14:46:10+00:00 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://onlineornot.com/what-fastly-outage-can-teach-about-writing-error-messages) are part of the developer experience!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 173] 1340107415434379264 33521530 swyx       0 5 38 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  
1432402513337085955 swyx 33521530 2021-08-30T17:59:06+00:00 wtf, i dont know when this happened but TIL @Github Actions can show lint warnings inline as you review PRs 🤯 https://github.com/temporalio/sdk-node/pull/215/files https://twitter.com/swyx/status/1432402513337085955/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 134]             0 5 119 0 0 0 en  
1432469865785352192 Jai Bhagat 896059763129298953 2021-08-30T22:26:44+00:00 My CFP for EmberFest was accepted!!! Thank you @swyx for giving me multiple rounds of review. My man is really trying to make @Coding_Career a place where career’s takeoff! To pay it forward, I’ll buy 1 fellow junior engineer a Community Package. Just RT this. #learninpublic       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             0 5 7 0 1   en  
1432471599312113664 swyx 33521530 2021-08-30T22:33:37+00:00 RT @imShahrukhDon: My CFP for EmberFest was accepted!!! Thank you @swyx for giving me multiple rounds of review. My man is really trying t… 1432469865785352192 1432469865785352192     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 5 0 0 1   en  
1432977957388120064 swyx 33521530 2021-09-01T08:05:43+00:00 Sometimes it can be super frustrating when the machine just refuses to do what you want despite trying everything. But eventually you see that you just didn't understand the machine well enough. Humans made that machine, and there's always something you can do to take it apart.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279] 1432977956259778565 33521530 swyx       0 5 68 0 0   en  
1433117669591433216 swyx 33521530 2021-09-01T17:20:53+00:00 This is why I also dislike the term “self taught” - it diminishes the hard work of docs writers, bloggers, YouTubers, and community volunteers who pave the way for you without expecting anything in return. No dev is an island.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 227] 1433117668156928004 33521530 swyx       0 5 45 0 0   en  
1436016314158616581 swyx 33521530 2021-09-09T17:19:03+00:00 I saw the best minds of my generation destroyed by FOMO shallow, excitable, distracted feverishly refreshing at dawn looking for the next hotness angel-investing hipsters swapping universe for metaverse creation for metacreation social for parasocial       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 256]             0 5 110 0 0   en  
1440712894958628874 lambdragon 1425932440388861952 2021-09-22T16:21:35+00:00 Watch @aldonline + @swyx discuss @thelambdragon, self-provisioning runtimes, and why the future of programming is all about "pure code" development https://www.youtube.com/watch?v=eUgKGIcrhE0       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 172]             0 5 9 0 1 0 en  
1440722557313847308 swyx 33521530 2021-09-22T16:59:59+00:00 RT @thelambdragon: Watch @aldonline + @swyx discuss @thelambdragon, self-provisioning runtimes, and why the future of programming is all ab… 1440712894958628874 1440712894958628874     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 5 0 0 1   en  
1440737677909770240 swyx 33521530 2021-09-22T18:00:04+00:00 the "pls sign NDA so you don't steal my startup idea" to "how do I reach more people" pipeline       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 94]             0 5 119 0 0   en  
1445091864244207618 Temporal 1204202807298969600 2021-10-04T18:22:03+00:00 Last week we had a great monthly meetup. Special thanks to our friend @rizza from @netflix for a stellar presentation. The full recording is now available. https://youtu.be/JQ6FRTnQWFI       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 180]             0 5 13 0 0 0 en  
1446268135078699012 Common Room 1331053779341348864 2021-10-08T00:16:08+00:00 It's @swyx! Head of Developer Experience at @temporalio and tech meetup connoisseur. We asked Shawn everything from his favorite part of working in community (it's an "infinite game") to advice he'd give now, and none of the answers disappoint. https://www.commonroom.io/uncommon/blog/the-rise-of-the-community-leader-meet-shawn-wang/?utm_medium=social&utm_source=twitter&utm_campaign=TL&utm_content=rise-of-the-community-leader       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 269]             0 5 18 0 1 0 en  
1446318406865547271 swyx 33521530 2021-10-08T03:35:54+00:00 RT @CommonRoomHQ: It's @swyx! Head of Developer Experience at @temporalio and tech meetup connoisseur. We asked Shawn everything from his… 1446268135078699012 1446268135078699012     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             0 5 0 0 1   en  
1448337156057882627 swyx 33521530 2021-10-13T17:17:41+00:00 Serverless Cloud follows @begin’s footsteps in full stack serverless DX. Why have @netlify and @vercel waited so long to add datastore and scheduled functions? #Jamstack space is heating up 🔥 when I wrote Self Provisioning Runtimes I had no idea people were way ahead of me 👏 https://twitter.com/goserverless/status/1448313005331005443   1448313005331005443 1448313005331005443   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 276]             1 5 50 0 0 0 en  
1449481919675056128 swyx 33521530 2021-10-16T21:06:34+00:00 @danluu @stylebot Blogged with explanations: https://dev.to/swyx/100-bytes-of-css-to-look-great-everywhere-19pd       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [18, 68] 1449472712720601088 33521530 swyx       0 5 73 0 1 0 en  
1449800818840928261 swyx 33521530 2021-10-17T18:13:45+00:00 RT @swyx: @danluu @stylebot Blogged with explanations: https://dev.to/swyx/100-bytes-of-css-to-look-great-everywhere-19pd 1449481919675056128 1449481919675056128     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 78]             0 5 0 0 1 0 en  
1450202214664921088 Gatsby 3227338044 2021-10-18T20:48:46+00:00 "The following is my conversation with @AbhiAiyer and @wardpeet, two lead engineers behind Gatsby Cloud and the recently announced Gatsby v4, which is at the forefront of what I think is the most significant change in the Jamstack landscape in the past 2 years. "- Shawn 🍿 🔥 🚀 https://twitter.com/swyx/status/1449912418071580672   1449912418071580672 1449912418071580672   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             1 5 15 0 1 0 en  
1450203732956758016 swyx 33521530 2021-10-18T20:54:48+00:00 RT @GatsbyJS: "The following is my conversation with @AbhiAiyer and @wardpeet, two lead engineers behind Gatsby Cloud and the recently anno… 1450202214664921088 1450202214664921088     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 5 0 0 1   en  
1450940383010045952 swyx 33521530 2021-10-20T21:41:59+00:00 RT @swyx: Lastly - I officially left the /r/reactjs mod team today. Here are some reflections on the entire process in case it helps othe… 1318608931938131968 1318608931938131968     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 5 0 0 1   en  
1452772699512524800 swyx 33521530 2021-10-25T23:02:57+00:00 Looking forward to host the 7th @temporalio meetup tomorrow at 9am PT! Presenting: 💰 Temporal at @Stripe 🗺️ Temporal Feature Map 🎉 2 Year Anniversary Q&A Signup at https://temporal.io/meetup!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 196]             0 5 15 0 0 0 en  
1453546267116703745 emnul.eth 1379874346005635074 2021-10-28T02:16:50+00:00 Every single software team with a SDK needs to watch this video by @swyx . Wow!! So many insights. https://youtu.be/ddKDPikKbNk       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 122]             0 5 10 1 1 0 en  
1453644616461271041 swyx 33521530 2021-10-28T08:47:38+00:00 RT @emanuel__sol: Every single software team with a SDK needs to watch this video by @swyx . Wow!! So many insights. https://youtu.be/ddKDPikKbNk 1453546267116703745 1453546267116703745     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 5 0 1 1 0 en  
1455955781317132295 Lucas Minter 1215752268160499712 2021-11-03T17:51:23+00:00 @swyx has inspired me to make a public commitment: Next Friday, I'm going to kick off a book club with friends. We are going to read the @Coding_Career Handbook. We will meet once a week over zoom to discuss our takeaways. If anyone wants to join, send me a dm.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 264]   33521530 swyx       0 5 25 1 1   en  
1455957502697213956 swyx 33521530 2021-11-03T17:58:13+00:00 RT @LucasMinter2: @swyx has inspired me to make a public commitment: Next Friday, I'm going to kick off a book club with friends. We are g… 1455955781317132295 1455955781317132295     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 5 0 1 1   en  
1456712851104559105 swyx 33521530 2021-11-05T19:59:42+00:00 I had a wonderful time talking through this blogpost with @adamstac and @jerodsanto on The Changelog! Life achievement unlocked ✅ https://twitter.com/changelog/status/1456689893694976006?s=20   1456689893694976006 1456689893694976006   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 154] 1326558340541939712 33521530 swyx       1 5 20 1 1 0 en  
1457037645570199555 swyx 33521530 2021-11-06T17:30:19+00:00 RT @swyx: I had a wonderful time talking through this blogpost with @adamstac and @jerodsanto on The Changelog! Life achievement unlocked ✅… 1456712851104559105 1456712851104559105     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 5 0 1 1   en  
1457887975115612164 Chris DiBona 44423 2021-11-09T01:49:14+00:00 Hey, I did a thing. I'm about to hate listen to myself and be super judgemental. Gotta lance that boil! It's the only way to get better..... https://twitter.com/thenewstack/status/1457830540011245572       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 140]             1 5 45 0 0 0 en  
1458219955539742724 swyx 33521530 2021-11-09T23:48:24+00:00 Just got access to @TwitterBlue. Looks like they use @Stripe Checkout!!! $40 billion company, I think this may be the biggest Stripe Checkout user yet? https://twitter.com/swyx/status/1397379577710743552 https://twitter.com/swyx/status/1458219955539742724/photo/1   1397379577710743552 1397379577710743552   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 177]             1 5 113 0 0 0 en  
1458579427055398912 swyx 33521530 2021-11-10T23:36:49+00:00 I played around with Redux Toolkit's new `condition` API and it's great! See for yourself: https://codesandbox.io/s/redux-toolkit-action-listener-middleware-demo-react-tailwind-98brh?file=/src/App.tsx:2045-2052 I was able to build a Tweet undo button in minutes. How do you like them apples, @TwitterBlue? https://twitter.com/acemarke/status/1457535446674718725 https://twitter.com/swyx/status/1458579427055398912/video/1   1457535446674718725 1457535446674718725   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 234]             1 5 59 0 0 0 en  
1462123847390576648 JR Beaudoin 948563334 2021-11-20T18:21:04+00:00 Sveltception! @rauchg bragging about hiring @Rich_Harris and how they are changing the internet. Very happy to attend #SvelteSummit Watch live: http://youtu.be/1Df-9EKvZr0 https://twitter.com/jiherr/status/1462123847390576648/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 170]             0 5 93 1 1 0 en  
1462128802759385098 swyx 33521530 2021-11-20T18:40:46+00:00 RT @jiherr: Sveltception! @rauchg bragging about hiring @Rich_Harris and how they are changing the internet. Very happy to attend #Svelte… 1462123847390576648 1462123847390576648     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 5 0 1 1   en  
1462208114753691648 Gen Ashley 32330308 2021-11-20T23:55:55+00:00 Lots of fun earlier at the #SvelteSummit Watch Party New York! @SvelteSociety @SvelteSirens @sveltejs #svelte #sveltejs #webdev #webdevelopment https://twitter.com/coderinheels/status/1462208114753691648/video/1       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 144]             0 5 35 1 1 0 en  
1462519879857328134 swyx 33521530 2021-11-21T20:34:46+00:00 RT @coderinheels: Lots of fun earlier at the #SvelteSummit Watch Party New York! @SvelteSociety @SvelteSirens @sveltejs #svelte #sveltejs… 1462208114753691648 1462208114753691648     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             0 5 0 1 1   en  
1466473939543199756 Temporal 1204202807298969600 2021-12-02T18:26:47+00:00 Our monthly meetup recording is up! Featuring: - Temporalite @Datadog - Temporal @TypeScript SDK - Temporal + XState @BDevessier @StatelyAI - Building @FlightControlHQ with Temporal! @abadir_ A packed hour of fun and distributed systems! https://youtu.be/GpbOkDjpeYU       Agorapulse app 86e9766d5e36b5847fe04f82904117b15d8fde9c 0 [0, 263]             0 5 26 1 1 0 en  
1466475039054708737 swyx 33521530 2021-12-02T18:31:09+00:00 RT @temporalio: Our monthly meetup recording is up! Featuring: - Temporalite @Datadog - Temporal @TypeScript SDK - Temporal + XState @BDev… 1466473939543199756 1466473939543199756     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 5 0 1 1   en  
1466858328537980936 swyx 33521530 2021-12-03T19:54:13+00:00 If you learn in public, you can build a network. If you build a network, you can build anything. When you can build anything, you realize: That was the easy part.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 165]             0 5 108 0 0   en  
1467343720936792071 Mark Erikson 727704217012604928 2021-12-05T04:02:59+00:00 I'm not a frequent podcast listener, but I am _loving_ these deep-dive discussions that Swyx is recording. Great guests, thorough discussion of meaningful topics, and some really good insight into the state of our industry. https://twitter.com/swyx/status/1467304180003917824   1467304180003917824 1467304180003917824   TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 223]             1 5 45 1 1 0 en  
1467347814686416898 swyx 33521530 2021-12-05T04:19:15+00:00 RT @acemarke: I'm not a frequent podcast listener, but I am _loving_ these deep-dive discussions that Swyx is recording. Great guests, thor… 1467343720936792071 1467343720936792071     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 5 0 1 1   en  
1467947006911864832 Jason Laster 312750384 2021-12-06T20:00:14+00:00 http://Replay.io just shipped a new Outline View that can easily show ~50k functions in a file 🚀 If you’re looking to add a print statement in a file, the Outline View is your friend! 1/3 https://twitter.com/jasonlaster11/status/1467947006911864832/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 196]             0 5 73 1 1 0 en  
1467958083007565826 swyx 33521530 2021-12-06T20:44:14+00:00 RT @jasonlaster11: http://Replay.io just shipped a new Outline View that can easily show ~50k functions in a file 🚀 If you’re looki… 1467947006911864832 1467947006911864832     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 5 0 1 1 0 en  
1469377424005632003 swyx 33521530 2021-12-10T18:44:12+00:00 Inspiration rarely walks a straight line, and devtools are no exception. This week we learned: - Concurrent React came from React Native - @TailwindCSS started as a tiny utility and now is a JIT compiler - @Amasad was 5x rejected from FB, peers, YC, CEOs and VCs before @Replit       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 278]             0 5 62 0 0   en  
1472746901711855617 swyx 33521530 2021-12-20T01:53:18+00:00 "Good open standards, both for software interfaces and for data formats, are more important than for software itself to be open source." *profound* insight from Peter Deutsch, on @jeffdoolittle's @seradio episode https://www.se-radio.net/2021/07/episode-470-l-peter-deutsch-on-the-fallacies-of-distributed-computing/ (44-46 mins) https://twitter.com/swyx/status/1472746901711855617/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 250]             0 5 31 0 0 0 en  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);