tweets

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

43 rows where is_quote_status = 1, retweeted = 1 and user = 33521530 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, retweet_count

favorited 2 ✖

  • 0 23
  • 1 20

user 1 ✖

  • swyx · 43 ✖

lang 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
1420136685472342016 swyx 33521530 2021-07-27T21:39:05+00:00 RT @copyconstruct: Instant buy!! The first edition is one of my all time favorite books! Everyone writing software should read it! Even… 1420135785987117060 1420135785987117060     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             1 6 0 0 1   en  
1421277387413606403 swyx 33521530 2021-07-31T01:11:49+00:00 RT @jhooks: a couple of years ago @swyx asked us what our big hairy audacious goal was... this is still my answer I am super motivated to… 1421273039648399364 1421273039648399364     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             1 3 0 0 1   en  
1426606285269602308 swyx 33521530 2021-08-14T18:06:58+00:00 RT @mipsytipsy: Ever wondered what columnar databases are, or peered skeptically at my claim that you basically can't have observability wi… 1426405785832095749 1426405785832095749     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 43 0 0 1   en  
1427393308997783602 swyx 33521530 2021-08-16T22:14:19+00:00 RT @andyhattemer: Lots of great info in this post! @swyx categorizes devrel programs into "Community", "Content" and "Product". For me, he… 1427370301495652354 1427370301495652354     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 1 0 0 1   en  
1428402450839457800 swyx 33521530 2021-08-19T17:04:17+00:00 RT @beyang: Super happy that a lot of these efforts are now well under way. Especially excited about indexing the entire world of open sour… 1428402268550754304 1428402268550754304     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 4 0 0 1   en  
1434242885893844992 swyx 33521530 2021-09-04T19:52:05+00:00 RT @SvelteSociety: Svelte Summit Fall 2021 is happening on November 20th! CFPs are open as well! 1434106223721426945 1434106223721426945     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 96]             1 11 0 0 1   en  
1434287058596597762 swyx 33521530 2021-09-04T22:47:37+00:00 RT @pullara: Let me get this straight... @jhuber had the GENIUS idea to buy @YouTube, debated internally for a bit, got pushback... ...… 1433880742682112001 1433880742682112001     TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 140]             1 12 0 0 1   en  
1434928945774972931 swyx 33521530 2021-09-06T17:18:15+00:00 RT @ryanatkn: as @sveltejs passes 50k GitHub stars, here's the https://is.gd/artmachine AI interpreting "sveltejs space elevator", a 🚀 metap… 1434918776462585856 1434918776462585856     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 4 0 0 1 0 en  
1436214579705569283 swyx 33521530 2021-09-10T06:26:54+00:00 RT @kiwicopple: Less than 2 years ago I met @AntWilson in a coffee shop to brainstorm an open source company that could delight developers.… 1436145598772625462 1436145598772625462     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 25 0 0 1   en  
1438094706555097089 swyx 33521530 2021-09-15T10:57:51+00:00 RT @cyberdees: Q: Engineers — you've always wanted to time travel, right? A: Now you can. When debugging w/ @ReplayIO. Crafted by @jason… 1438052380227117076 1438052380227117076     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 9 0 0 1   en  
1438939235801653249 swyx 33521530 2021-09-17T18:53:42+00:00 How @Temporalio Works: 1. Write async code with SDK 2. Temporal Server handles queues, timers, retries, timeouts, heartbeats. Checkpoint every step to resume from downtime 3. Testing, versioning, observability built in 4. Scale any part of system by throwing more machines at it https://twitter.com/EricVicenti/status/1438571865765662721 https://twitter.com/swyx/status/1438939235801653249/photo/1   1438571865765662721 1438571865765662721   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 303]             1 12 81 0 1 0 en  
1439026846549495812 swyx 33521530 2021-09-18T00:41:50+00:00 RT @swyx: How @Temporalio Works: 1. Write async code with SDK 2. Temporal Server handles queues, timers, retries, timeouts, heartbeats. Ch… 1438939235801653249 1438939235801653249     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 12 0 0 1   en  
1439976474623234050 swyx 33521530 2021-09-20T15:35:19+00:00 RT @tannerlinsley: "GraphQL helps solve the overfetching problem. In practice, I think the importance of this is overhyped unless you are F… 1439976152995545090 1439976152995545090     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 29 0 0 1   en  
1441072853168840705 swyx 33521530 2021-09-23T16:11:56+00:00 RT @brianleroux: This in no way assuaged my overall skepticism but super appreciate the hype-free honesty of the current state of "web3". M… 1441062360811143175 1441062360811143175     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 3 0 0 1   en  
1441519278235082753 swyx 33521530 2021-09-24T21:45:52+00:00 RT @simonw: This right here is why I've invested so much of my career learning (and building) tools that enable really rapid prototyping I… 1441502655021387790 1441502655021387790     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             1 15 0 0 1   en  
1445537727131176967 swyx 33521530 2021-10-05T23:53:45+00:00 RT @ritakozlov_: A+ write up from @swyx. the great thing about “from the outside in” metaphor is that it works figuratively and literally —… 1445533835945414662 1445533835945414662     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             1 3 0 0 1   en  
1445565723502264331 swyx 33521530 2021-10-06T01:45:00+00:00 RT @kristoferbaxter: Some of the best writing in our industry comes from @swyx. This is yet another great read. 1445564661965807617 1445564661965807617     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 111]             1 1 0 0 1   en  
1447731092144869376 swyx 33521530 2021-10-12T01:09:24+00:00 RT @patio11: Understanding difference between O(N^2) vs. O(n) is indistinguishable from magic at least some of the time, like all good tech… 1447414882081521665 1447414882081521665     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 145 0 0 1   en  
1449105641797128192 swyx 33521530 2021-10-15T20:11:22+00:00 RT @ChibuzorObilom: I've always believed that the 80/20 rule is grossly misunderstood or misrepresented. There's nothing like doing only 2… 1449103297839763459 1449103297839763459     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 0 1   en  
1449117060265492481 swyx 33521530 2021-10-15T20:56:45+00:00 RT @threepointone: Really good talk. This is a great slide demonstrating their programming model; to do a recurring subscription, you liter… 1449112317917110276 1449112317917110276     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 0 1   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  
1450404185153757189 swyx 33521530 2021-10-19T10:11:19+00:00 RT @ascorbic: This is a really interesting discussion on Gatsby and the state of the Jamstack ecosystem and I agree with most of it. Worth… 1450403609078898694 1450403609078898694     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             1 7 0 0 1   en  
1451392641598255110 swyx 33521530 2021-10-22T03:39:05+00:00 RT @dan_abramov: Wouldn’t it be cool if React Docs were written with Hooks first, had interactive examples and challenges, API diagrams, an… 1451349199082213378 1451349199082213378     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 152 0 1 1   en  
1452683398254714880 swyx 33521530 2021-10-25T17:08:06+00:00 RT @kentcdodds: This is similar to my attitude toward content creation. I choose the topics I choose primarily because I want to. This is… 1452479329686876163 1452479329686876163     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 139]             1 1 0 1 1   en  
1453538330176413704 swyx 33521530 2021-10-28T01:45:18+00:00 RT @seldo: I don't think enough has been made of the discovery that Google's funding of AMP was an explicitly anti-competitive move designe… 1453377986791575552 1453377986791575552     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 353 0 1 1   en  
1455263219027628034 swyx 33521530 2021-11-01T19:59:23+00:00 RT @hillelogram: Other examples are preemptive pluralization (https://twitter.com/swyx/status/1370513317379280897) and preemptive pagination. Not always the right choi… 1455261914297249798 1455261914297249798     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 3 0 1 1 0 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  
1460327694801850368 swyx 33521530 2021-11-15T19:23:48+00:00 RT @Rich_Harris: for the @brooklyn_js family, this is taking place at the event space right next to 61 local. this saturday, 12-4pm it's s… 1460291937412521997 1460291937412521997     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 11 0 1 1   en  
1460785490282483718 swyx 33521530 2021-11-17T01:42:55+00:00 RT @SvelteSociety: Svelte Summit viewing parties are springing up all over! Organize here or on Discord! NYC 🗽 @swyx Mainz 🇩🇪@einbuhrmi Z… 1460785448876331010 1460785448876331010     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 6 0 1 1   en  
1462854647891197954 swyx 33521530 2021-11-22T18:45:01+00:00 RT @ronvoluted: "Productivity through Product Focus" by Reddit's @volanStudio is about to begin! Tune in: https://youtube.com/watch?v=0g0BQex8fyo and joi… 1462840959427772418 1462840959427772418     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 1 1 0 en  
1463618402841284609 swyx 33521530 2021-11-24T21:19:54+00:00 RT @Rich_Harris: adding facebook to the "who uses svelte" list :) 1463612706867630097 1463612706867630097     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 65]             1 72 0 1 1   en  
1463692023278358534 swyx 33521530 2021-11-25T02:12:27+00:00 RT @swyx: TIL you can use object destructuring on an *array* to get at its properties... and immediately use them in an index with `[ ]` no… 1172604337366941697 1172604337366941697     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 336 0 0 1   en  
1464320734533017600 swyx 33521530 2021-11-26T19:50:43+00:00 RT @adamwathan: Execute Program is way too under the radar for how good it is. If they have a course on something, it is the best way to le… 1464316615453986818 1464316615453986818     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 8 0 1 1   en  
1465823027497607171 swyx 33521530 2021-11-30T23:20:18+00:00 RT @thomaspaulmann: Today is a big day for @raycastapp! We're thrilled to announce our $15m Series A and release our Extensions Store and A… 1465601156449804290 1465601156449804290     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 8 0 1 1   en  
1466847530872762370 swyx 33521530 2021-12-03T19:11:18+00:00 RT @corecursive: A great list to be a part of! 🏆 1466846573078487043 1466846573078487043     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 48]             1 3 0 1 1   en  
1467304180003917824 swyx 33521530 2021-12-05T01:25:52+00:00 🎙️ My latest podcast is with @argyleink! *Complexity Cliffs, DX, and the Disruption of Web Design* https://www.youtube.com/watch?v=xEyJ6LY7DKI - UI Complexity Cliffs - Open UI - UX vs DX - @Adobe vs @Figma vs @Webflow - Thoughtleading for Good - @dalmaer - and of course: How to Learn CSS! https://twitter.com/swyx/status/1451667101412954114 https://twitter.com/swyx/status/1467304180003917824/video/1   1451667101412954114 1451667101412954114   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 297]             1 14 120 1 1 0 en  
1467343666473623557 swyx 33521530 2021-12-05T04:02:46+00:00 RT @swyx: 🎙️ My latest podcast is with @argyleink! *Complexity Cliffs, DX, and the Disruption of Web Design* https://www.youtube.com/watch?v=xEyJ6LY7DKI - U… 1467304180003917824 1467304180003917824     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 14 0 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  
1469801943019110401 swyx 33521530 2021-12-11T22:51:05+00:00 RT @JoshWComeau: I had a bill recently go from $20/month to $660/month because I exceeded a magic threshold. My actual usage increased mayb… 1469313115598860293 1469313115598860293     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 4 0 1 1   en  
1470900644055711747 swyx 33521530 2021-12-14T23:36:56+00:00 RT @beyang: The amazing thing about @swyx is he got into programming not too long ago after making a big career pivot from finance. It's aw… 1470874194283884545 1470874194283884545     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 1 1   en  
1471290912856690691 swyx 33521530 2021-12-16T01:27:43+00:00 RT @stubbornella: Utility classes: I'm not in a mood to be erased today. I was experimenting with utility classes in large production sites… 1471213109767405568 1471213109767405568     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 135 0 1 1   en  
1473206717403959297 swyx 33521530 2021-12-21T08:20:26+00:00 RT @Nina_Ledid: Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "wh… 1473192929414070273 1473192929414070273     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 2 0 1 1   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]);