tweets
26 rows where "created_at" is on date 2021-08-10 and retweeted = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, in_reply_to_screen_name, is_quote_status, favorite_count, lang
in_reply_to_user_id 15 ✖
- 676363 4
- 11754732 2
- 33521530 2
- 127461367 2
- 1010918910 2
- 14137772 1
- 14904098 1
- 17534675 1
- 20705255 1
- 23587474 1
- 339520646 1
- 1567529924 1
- 2480319486 1
- 945098033124950016 1
- 958043149275934720 1
user 2 ✖
- swyx 25
- Sharif Shameem 1
quoted_status 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||
1424953927426928646 | swyx 33521530 | 2021-08-10T04:41:05+00:00 | @moretothat’s unification of the power and money divides into a single bell curve dimension is indirectly an incredible rebuttal of the Michael Scott Theory of Social Class - arguing FOR being peak Michael Scott! https://twitter.com/alex_danco/status/1352701338833072135?s=21 https://twitter.com/swyx/status/1424953927426928646/photo/1 | 1352701338833072135 1352701338833072135 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 237] | 1424951893864816644 | 33521530 | swyx | 1 | 4 | 24 | 0 | 0 | 0 | en | ||||||
1424970485721309186 | swyx 33521530 | 2021-08-10T05:46:53+00:00 | @ashleymcnamara 👋 changed careers at 30. would love to be a part! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 65] | 1424861717478076435 | 14137772 | ashleymcnamara | 0 | 0 | 8 | 0 | 0 | en | ||||||||
1425166770273284098 | swyx 33521530 | 2021-08-10T18:46:51+00:00 | @leeb delicious and delightful! | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [6, 31] | 1425164338344517632 | 14904098 | leeb | 0 | 0 | 1 | 0 | 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 | ||||||||||
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 | |||||||||||
1425207317935452161 | swyx 33521530 | 2021-08-10T21:27:58+00:00 | @berenguel what do you hate most? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 33] | 1425205298676092934 | 17534675 | berenguel | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1425208387147419648 | swyx 33521530 | 2021-08-10T21:32:13+00:00 | @venkey_ariv yeah i am looking into usability mainly. thank you! need to research Splunk. looking to standardize terminology about scheduled runs: - Overlap Policy: SKIP, BUFFER_ONE, BUFFER_ALL, ALLOW_ALL to control what happens if a job runs over into the next window | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 270] | 1425206384199536645 | 1010918910 | venkey_ariv | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1425208911787806725 | swyx 33521530 | 2021-08-10T21:34:18+00:00 | @venkey_ariv - Catchup Window: if system goes down, how far back we look to pick up scheduled jobs - Pause After Failure: if one a job "fails", do we pause all future jobs - Delayed start - Run limit (for finite runs) - Jitter (uniform random starts) - Exclusions (avoid weekends) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 281] | 1425208387147419648 | 33521530 | swyx | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1425210442134089732 | swyx 33521530 | 2021-08-10T21:40:23+00:00 | @brianleroux whats an underappreciated thing it does well? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 58] | 1425209754117345284 | 676363 | brianleroux | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1425210747668160515 | swyx 33521530 | 2021-08-10T21:41:36+00:00 | @janbhwilhelm @flybayer @skn0tt yea it does look pretty sweet! Does it offer an API to "backfill" i.e. manually retry jobs that failed or didnt start because the system was down? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [32, 178] | 1425207824322371585 | 958043149275934720 | janbhwilhelm | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1425211431104835585 | swyx 33521530 | 2021-08-10T21:44:18+00:00 | @gr2m its great! but it is very flaky: https://github.com/sw-yx/gh-action-data-scraping/actions?query=is%3Afailure 2 failures in the last day alone | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 96] | 1425210809555177472 | 11754732 | gr2m | 0 | 0 | 7 | 0 | 0 | 0 | en | |||||||
1425211636554506246 | swyx 33521530 | 2021-08-10T21:45:07+00:00 | @brianleroux serverless IaC, you are nothing if not consistent | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 62] | 1425210927008321542 | 676363 | brianleroux | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1425212750666498052 | swyx 33521530 | 2021-08-10T21:49:33+00:00 | @brianleroux that said the right meme usually gets up and running way faster than the original creators ever intend https://newsletter.banklesshq.com/p/the-history-of-ultra-sound-money-db5 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 139] | 1425211761976819716 | 676363 | brianleroux | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1425212958460633089 | swyx 33521530 | 2021-08-10T21:50:23+00:00 | @gr2m and version controlled! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 29] | 1425212570424668162 | 11754732 | gr2m | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1425213339769073666 | swyx 33521530 | 2021-08-10T21:51:54+00:00 | @brianleroux would be fun to build a little cost estimator thing into that arc transpiler tool: "given some load assumptions and this arc file, whats the ballpark cost?" | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 169] | 1425212085185744896 | 676363 | brianleroux | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1425217481480695811 | swyx 33521530 | 2021-08-10T22:08:21+00:00 | @ryanlevander @getAkiflow @being_skyler @readwiseio i'm a few days into this thing and i think its actually sticking. i'm getting through the tasks i plan for myself! could be honeymoon period but very promising | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [52, 211] | 1423463867510779905 | 339520646 | ryanlevander | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1425218091479289863 | swyx 33521530 | 2021-08-10T22:10:46+00:00 | @betterbomb @PostgreSQL @supabase a fantastic solution as well :) but needs extra work to backfill failed/missed jobs, manually trigger them, or control overlap for long running jobs | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [34, 182] | 1425217961854324738 | 127461367 | betterbomb | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1425219679203651587 | swyx 33521530 | 2021-08-10T22:17:05+00:00 | @betterbomb @PostgreSQL @supabase haha well i'm one level below that, i'm working on a redesign of our scheduled workflow capability | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [34, 132] | 1425219365058670605 | 127461367 | betterbomb | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1425224399121117186 | swyx 33521530 | 2021-08-10T22:35:50+00:00 | @venkey_ariv retries and timeouts are our bread and butter @temporalio | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [13, 70] | 1425221481076723712 | 1010918910 | venkey_ariv | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1425224645771362309 | swyx 33521530 | 2021-08-10T22:36:49+00:00 | @evntdrvn excellent thank you! you didnt use it personally? | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [10, 59] | 1425222470739582977 | 23587474 | evntdrvn | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1425224923459383297 | swyx 33521530 | 2021-08-10T22:37:55+00:00 | @coreyhainesco thought it was a very honest reflection :) at the same time i also think tech is too lucrative and fun so would be surprised to see you leave | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [15, 156] | 1425166764036460555 | 2480319486 | coreyhainesco | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1425233830869274624 | swyx 33521530 | 2021-08-10T23:13:19+00:00 | @Lucid_Dan yes! we call this our overlap policy (exact names TBD) https://twitter.com/swyx/status/1425233830869274624/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 65] | 1425231281059635201 | 945098033124950016 | Lucid_Dan | 0 | 0 | 4 | 0 | 0 | 0 | en | |||||||
1424932215624962049 | swyx 33521530 | 2021-08-10T03:14:48+00:00 | @jsjoeio https://github.com/sw-yx/spark-joy#sound | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 32] | 1424914603885006850 | 1567529924 | jsjoeio | 0 | 0 | 10 | 0 | 0 | 0 | und | |||||||
1425123109032513549 | swyx 33521530 | 2021-08-10T15:53:21+00:00 | @chaseadamsio @rothgar @vercel @darklang | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [31, 40] | 1425121027562999812 | 20705255 | chaseadamsio | 0 | 0 | 0 | 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]);