tweets
49 rows where "created_at" is on date 2021-09-01 sorted by is_quote_status
This data as json, CSV (advanced)
Suggested facets: quoted_status, source, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorite_count, retweeted, lang
user 3 ✖
- swyx 47
- Beyang Liu 1
- Kasra 1
place 0 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1432864028842356736 | swyx 33521530 | 2021-09-01T00:33:00+00:00 | My latest piece: https://www.swyx.io/self-provisioning-runtime/ Advancements in two fields — programming languages and cloud infrastructure — will converge in a single paradigm: where all resources used by a program will be automatically provisioned by the environment that runs it. TLDR in thread: | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 0 | 24 | 109 | 0 | 0 | 0 | en | ||||||||||
1432864032235540480 | swyx 33521530 | 2021-09-01T00:33:01+00:00 | One of Java's advantages over C++ is automatic garbage collection, whereas one of Go's advantages over Java is its native CSP model. At a 50,000 ft view you can see languages as advancing by the number of hard problems that are elegantly solved by convention or language feature. https://twitter.com/swyx/status/1432864032235540480/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 1432864028842356736 | 33521530 | swyx | 0 | 4 | 17 | 0 | 0 | 0 | en | |||||||
1432864036241088513 | swyx 33521530 | 2021-09-01T00:33:02+00:00 | At the same time, infrastructure engineers increasingly embracing higher and higher abstractions to solve their problems. The DevOps movement is not so much "Devs doing Ops" as it is Ops doing Dev. As platforms develop, we are learning the chores that can be cleanly delegated. https://twitter.com/swyx/status/1432864036241088513/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 1432864032235540480 | 33521530 | swyx | 0 | 2 | 7 | 0 | 0 | 0 | en | |||||||
1432864040624091138 | swyx 33521530 | 2021-09-01T00:33:03+00:00 | To paraphrase: DX advances by extending the number of important problems our code handles without thinking of them. If we can isolate these chores, we can design them into the language, or build it into the platform. The holy grail: Language-AS-platform, Infra-FROM-code. https://twitter.com/swyx/status/1432864040624091138/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 274] | 1432864036241088513 | 33521530 | swyx | 0 | 1 | 12 | 0 | 0 | 0 | en | |||||||
1432864042343813120 | swyx 33521530 | 2021-09-01T00:33:03+00:00 | Cutting edge AWS stack for JS dev today: - App code in TypeScript - AWS CDK in TypeScript - 0.4-3 MB of SDK code serverside - (optional) 0.2-1 MB SDK code clientside - a dozen lines of config to make it work This is *good* - gives lots of control! Control that I may not need. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 1432864040624091138 | 33521530 | swyx | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1432864045133008899 | swyx 33521530 | 2021-09-01T00:33:04+00:00 | "Are you ignoring Heroku?" Heroku was so right so early - and then stagnated. We can do a lot more at build time, and at runtime. Among the platforms innovating on this: @begin, @vercel, @netlify, @PulumiCorp, @goserverless, @WaspLang! There's a tangible movement building. https://twitter.com/swyx/status/1432864045133008899/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 1432864042343813120 | 33521530 | swyx | 0 | 2 | 9 | 0 | 0 | 0 | en | |||||||
1432864758869356546 | swyx 33521530 | 2021-09-01T00:35:54+00:00 | @buildsghost @paulbiggar @darklang from what i heard, he already cut back a lot on his original vision 😂 i think Dark was even supposed to handle the frontend originally! but honestly, the sheer ambition is refreshing. too much incrementalism in tech. as i'm sure you no doubt feel. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [35, 282] | 1432855994766217218 | 1175464650395111424 | buildsghost | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1432865442884849667 | swyx 33521530 | 2021-09-01T00:38:37+00:00 | @chriscoyier oh wow it does! thank you! super janky page haha.. who is behind it? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 81] | 1432864414865231875 | 793830 | chriscoyier | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1432886704667447296 | swyx 33521530 | 2021-09-01T02:03:06+00:00 | @secos https://youtu.be/BzAdXyPYKQo | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 30] | 1432879787840782343 | 14494227 | secos | 0 | 0 | 3 | 0 | 0 | 0 | und | |||||||
1432895757812518914 | swyx 33521530 | 2021-09-01T02:39:05+00:00 | @preetster brb raising 5m on 50 post | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 36] | 1432894058821656577 | 16343912 | preetster | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432898918589763587 | swyx 33521530 | 2021-09-01T02:51:38+00:00 | @beyang YES. PLEASE. ESP IF IT LETS ME SEARCH WITHIN FOLDERS URGH | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 65] | 1432894718266986499 | 16520821 | beyang | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1432899310635544578 | swyx 33521530 | 2021-09-01T02:53:12+00:00 | @lesliecdubs @jamstackconf ong this looks AMAZING, kudos whoever coded this up! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 79] | 1432860023475118082 | 22217773 | lesliecdubs | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432901153931464707 | swyx 33521530 | 2021-09-01T03:00:31+00:00 | @shaundai @netflix @burgessdryan holy crap, that’s amazing!!!!! congrats to you AND ryan AND netflix!!!! wow 🤩 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [33, 110] | 1432728448062132224 | 1004483816 | shaundai | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1432901738923651074 | swyx 33521530 | 2021-09-01T03:02:51+00:00 | @willjohnsonio @GatsbyJS one of the very best parts of tech networking is seeing friends glow up in their own way and knowing you have that special bond because you knew each other before they “made it”! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 203] | 1432753753992663044 | 917069583097397248 | willjohnsonio | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1432902144139558917 | swyx 33521530 | 2021-09-01T03:04:27+00:00 | @mitchellh @JordiMonPMM if you’re interested i made an alternative query builder UI for Twitter: https://bettertwitter.netlify.app/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 120] | 1432769589516009472 | 12819682 | mitchellh | 0 | 0 | 8 | 0 | 0 | 0 | en | |||||||
1432902470418661381 | swyx 33521530 | 2021-09-01T03:05:45+00:00 | @oldmanuk @mitchellh i made an alternative twitter query builder UI as well, in case this question comes up again in future https://bettertwitter.netlify.app/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [21, 148] | 1432813730690179073 | 7969342 | oldmanuk | 0 | 1 | 7 | 0 | 0 | 0 | en | |||||||
1432906359121403904 | swyx 33521530 | 2021-09-01T03:21:12+00:00 | @_SreetamDas @lesliecdubs @jamstackconf @zachleat ah nice! was talking more about the ogimage “badge” but literally everyone on Zach’s team is top shelf | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [50, 152] | 1432904504488259584 | 520276345 | _SreetamDas | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432906565804199944 | swyx 33521530 | 2021-09-01T03:22:02+00:00 | @paulbiggar @buildsghost @darklang i see the @edith_h influence haha | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [35, 68] | 1432905149308153860 | 86938585 | paulbiggar | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1432909493805981699 | Beyang Liu 16520821 | 2021-09-01T03:33:40+00:00 | It’s time to speak the truth plainly: @github code search is terrible and the dev world deserves so much better. If you believe this is true, then I invite you to try @sourcegraph. You’ll never look back—I promise. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 214] | 0 | 30 | 241 | 0 | 1 | en | |||||||||||
1432917775362650115 | swyx 33521530 | 2021-09-01T04:06:34+00:00 | RT @beyang: It’s time to speak the truth plainly: @github code search is terrible and the dev world deserves so much better. If you believe… | 1432909493805981699 1432909493805981699 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 30 | 0 | 0 | 1 | en | ||||||||||
1432924236729892865 | swyx 33521530 | 2021-09-01T04:32:15+00:00 | @wooorm @thisismahmoud_ more for your collection | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 48] | 1432825380604420097 | 3269048996 | wooorm | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1432932685224181761 | swyx 33521530 | 2021-09-01T05:05:49+00:00 | @chantastic "Think of how stupid the average person is, and realise half of them are stupider than that." — George Carlin | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 121] | 1432932041708883970 | 12745092 | chantastic | 0 | 0 | 13 | 0 | 0 | en | ||||||||
1432935977970925571 | swyx 33521530 | 2021-09-01T05:18:54+00:00 | Today's clip: looking behind @TimescaleDB! https://share.transistor.fm/s/b8d8684b | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 67] | 1432797787863744519 | 33521530 | swyx | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1432939034540593157 | swyx 33521530 | 2021-09-01T05:31:03+00:00 | @zachleat @_SreetamDas @lesliecdubs @jamstackconf @philhawksworth feedback - i get this error when i hit Laminate and then nothing happens! https://twitter.com/swyx/status/1432939034540593157/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [66, 139] | 1432908344205922305 | 96383 | zachleat | 0 | 0 | 0 | 0 | 0 | 0 | en | |||||||
1432945962255728640 | swyx 33521530 | 2021-09-01T05:58:34+00:00 | @umanagineer 2007 here! there were so many golden opportunities i slept right through 😂 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 87] | 1432942187524681734 | 938901720016363520 | umachingunde | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1432963851780177932 | swyx 33521530 | 2021-09-01T07:09:40+00:00 | @embano1 @eoinbrazil @joe_hellerstein oh wow. thank you for sharing this!!! will take a while to go through 👀 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [38, 109] | 1432961975462637568 | 122923515 | embano1 | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1432977956259778565 | swyx 33521530 | 2021-09-01T08:05:42+00:00 | Met a guy who wanted to switch careers like me, wanted to know about the hard parts of learning to code. Told him: Learning to code is just running into walls repeatedly and not giving up bc you have faith you will figure it out. Every wall is a breakthrough waiting to happen. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 0 | 93 | 633 | 0 | 0 | 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 | ||||||||
1433111522230734850 | swyx 33521530 | 2021-09-01T16:56:27+00:00 | @3rdGenNuke 100% was channeling that quote! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 43] | 1433017373066469376 | 367845362 | 3rdGenNuke | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1433117668156928004 | swyx 33521530 | 2021-09-01T17:20:52+00:00 | This is not to say that if you can’t figure it out, it’s not your fault: we are tremendously bad at documenting our code, and documenting our journeys. Seek out your dev community for help, and remember how this feels when its your turn to see newer devs struggling. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 267] | 1432977957388120064 | 33521530 | swyx | 0 | 1 | 8 | 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 | ||||||||
1433123612899229698 | swyx 33521530 | 2021-09-01T17:44:30+00:00 | @flybayer @blitz_js @rudiyardley hot take: those people never needed graphql in the first place 🤷♂️ but congrats 🎉 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [33, 115] | 1433087810320355339 | 2826554209 | flybayer | 0 | 0 | 14 | 0 | 0 | en | ||||||||
1433126939850465284 | swyx 33521530 | 2021-09-01T17:57:43+00:00 | @colinhacks @flybayer @blitz_js @rudiyardley how bout a case against graphql, made by @rbzhu :) https://www.youtube.com/watch?v=djKPtyXhaNE | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [45, 119] | 1433125135918288896 | 888220718 | colinhacks | 0 | 3 | 39 | 0 | 0 | 0 | en | |||||||
1433140106592800770 | swyx 33521530 | 2021-09-01T18:50:02+00:00 | @kriskoishigawa hahaha thats exactly what it feels like!! thx for the share! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 76] | 1432988683578200066 | 3305745134 | kriskoishigawa | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1433140332405743618 | swyx 33521530 | 2021-09-01T18:50:56+00:00 | @Neitherman inject that koolaid straight into my veins | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 54] | 1433070094679117833 | 36943393 | Neitherman | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1433173737692704768 | swyx 33521530 | 2021-09-01T21:03:40+00:00 | @colinhacks @flybayer @blitz_js @rudiyardley @rbzhu i've come to term these "Heresy talks", after @QuinnyPig's excellent example https://www.youtube.com/watch?v=RB6MvSEaMKI i think every conf should have a brave soul pour water on things and enrage people enough to go make it better | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [52, 264] | 1433166882757042178 | 888220718 | colinhacks | 0 | 4 | 19 | 0 | 0 | 0 | en | |||||||
1433173795729252356 | swyx 33521530 | 2021-09-01T21:03:54+00:00 | @AlexandreSieira ayyy thank you! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [17, 32] | 1433158348564803591 | 485904751 | AlexandreSieira | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1433173897646645259 | swyx 33521530 | 2021-09-01T21:04:18+00:00 | @whatwind101 gm | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 15] | 1433146824047611904 | 982927232627822592 | whatwind101 | 0 | 0 | 0 | 0 | 0 | und | ||||||||
1433175067563855872 | Kasra 1175119837653159936 | 2021-09-01T21:08:57+00:00 | I'm super excited to announce that our work on interactive Program Synthesis with control structures (with @shraddha_96, @HilaCodes, Sorin Lerner, and @polikarn) has been accepted to OOPSLA 2021! More details to come, but here's a sneak preview: https://twitter.com/kasra_ferdowsi/status/1433175067563855872/video/1 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 245] | 0 | 69 | 384 | 0 | 1 | 0 | en | ||||||||||
1433213036886560768 | swyx 33521530 | 2021-09-01T23:39:50+00:00 | Adage: "There are only two ways to make money in software: bundling and unbundling." People doing Monorepo Microservices: https://twitter.com/swyx/status/1433213036886560768/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 122] | 0 | 0 | 15 | 0 | 0 | 0 | en | ||||||||||
1432864048677154818 | swyx 33521530 | 2021-09-01T00:33:05+00:00 | This was part of my @Temporalio pitch: https://twitter.com/swyx/status/1417165270641045505 Because you can dynamically use retries, timeouts, task queues and timers *without any setup* and Temporal takes care of it behind the scenes: this unlocks *self-provisioning asynchrony* in your app code. https://twitter.com/swyx/status/1432864048677154818/photo/1 | 1417165270641045505 1417165270641045505 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 268] | 1432864045133008899 | 33521530 | swyx | 1 | 0 | 7 | 0 | 0 | 0 | en | ||||||
1432864050895994890 | swyx 33521530 | 2021-09-01T00:33:05+00:00 | I previously wrote about Cloud Distros, my term for the "second layer" of clouds forming atop the Big Three: https://twitter.com/swyx/status/1252699745883062272 Self Provisioning Runtimes are one step further into the breach - instead of YAML config and SDK code, these platforms *read the app code*. | 1252699745883062272 1252699745883062272 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 273] | 1432864048677154818 | 33521530 | swyx | 1 | 1 | 12 | 0 | 0 | 0 | en | ||||||
1432864823654555652 | swyx 33521530 | 2021-09-01T00:36:09+00:00 | @paulbiggar tweeted as thread for comments if any :) https://twitter.com/swyx/status/1432864028842356736?s=20 | 1432864028842356736 1432864028842356736 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 76] | 1432719949575905289 | 86938585 | paulbiggar | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
1432866380857044997 | swyx 33521530 | 2021-09-01T00:42:21+00:00 | @Jarsen even better :) got a nice shoutout this morning https://twitter.com/paulbiggar/status/1432719949575905289?s=20 | 1432719949575905289 1432719949575905289 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 79] | 1432866252515512325 | 16645904 | Jarsen | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
1432870334923825161 | swyx 33521530 | 2021-09-01T00:58:03+00:00 | @tiffanywhitedev @begin @vercel @Netlify @PulumiCorp @goserverless @WaspLang have you checked out http://supabase.io? https://twitter.com/florinpop1705/status/1432689385271664641 | 1432689385271664641 1432689385271664641 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [77, 146] | 1432868764861800448 | 2506322185 | tiffanywhitedev | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
1432931687441133568 | swyx 33521530 | 2021-09-01T05:01:51+00:00 | @chantastic https://twitter.com/swyx/status/1372013877731368961?s=20 | 1372013877731368961 1372013877731368961 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 35] | 1432930900325535750 | 12745092 | chantastic | 1 | 0 | 15 | 0 | 0 | 0 | und | ||||||
1433107396839100420 | swyx 33521530 | 2021-09-01T16:40:03+00:00 | this was the post: https://twitter.com/swyx/status/1432864028842356736?s=21 | 1432864028842356736 1432864028842356736 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 42] | 1432602694758273025 | 33521530 | swyx | 1 | 0 | 2 | 0 | 0 | 0 | en | ||||||
1433107445996392448 | swyx 33521530 | 2021-09-01T16:40:15+00:00 | @ArNazeh this! https://twitter.com/swyx/status/1432864028842356736 | 1432864028842356736 1432864028842356736 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 14] | 1432608901430657027 | 176229420 | ArNazeh | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
1433144069581152258 | swyx 33521530 | 2021-09-01T19:05:47+00:00 | @VitalyPushkar @garybernhardt this paradigm exists in 2021! it's @temporalio :) https://twitter.com/swyx/status/1417165270641045505 | 1417165270641045505 1417165270641045505 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [30, 103] | 1432751700515958785 | 437025090 | VitalyPushkar | 1 | 0 | 2 | 0 | 0 | 0 | en |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [tweets] ( [id] INTEGER PRIMARY KEY, [user] INTEGER REFERENCES [users]([id]), [created_at] TEXT, [full_text] TEXT, [retweeted_status] INTEGER, [quoted_status] INTEGER, [place] TEXT REFERENCES [places]([id]), [source] TEXT REFERENCES [sources]([id]), [truncated] INTEGER, [display_text_range] TEXT, [in_reply_to_status_id] INTEGER, [in_reply_to_user_id] INTEGER, [in_reply_to_screen_name] TEXT, [geo] TEXT, [coordinates] TEXT, [contributors] TEXT, [is_quote_status] INTEGER, [retweet_count] INTEGER, [favorite_count] INTEGER, [favorited] INTEGER, [retweeted] INTEGER, [possibly_sensitive] INTEGER, [lang] TEXT, [scopes] TEXT, FOREIGN KEY([retweeted_status]) REFERENCES [tweets]([id]), FOREIGN KEY([quoted_status]) REFERENCES [tweets]([id]) ); CREATE INDEX [idx_tweets_source] ON [tweets] ([source]);