tweets

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

6 rows where favorited = 0 and retweet_count = 30 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

created_at (date) 5 ✖

retweeted 2 ✖

is_quote_status 2 ✖

retweet_count 1 ✖

quoted_status 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
1417165270641045505 swyx 33521530 2021-07-19T16:51:44+00:00 I'm excited to finally share why I've joined @temporalio as Head of Developer Experience! Here's my explainer on 3 core opinions of Temporal, why they're hard to do well, and the business opportunities it presents: https://www.swyx.io/why-temporal/       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 240]             0 30 396 0 0 0 en  
1422553148099645451 Kenton Varda 17459118 2021-08-03T13:41:14+00:00 A very wonky blog post. We noticed many Durable Objects apps had classic storage bugs (race conditions, unconfirmed writes, long waits, etc.). Instead of telling people to fix their code, we fixed the system, so intuitively-written code is now correct. https://blog.cloudflare.com/durable-objects-easy-fast-correct-choose-three/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 276]             0 30 141 0 0 0 en  
1424502535411224581 swyx 33521530 2021-08-08T22:47:25+00:00 My take on Why @TailwindCSS: https://www.swyx.io/why-tailwind/ Probably obvious to experts, but it's the top organic Google result for "Why Tailwind" now. I think more people should write straightforward "Why X" or "What is X" posts. You don't always have to write earthshattering theses. https://twitter.com/Tyler_Potts_/status/1424481436766199819 https://twitter.com/swyx/status/1424502535411224581/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 304]             1 30 226 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  
1447291658739978243 Elizabeth Yin 14756283 2021-10-10T20:03:15+00:00 I'm a big fan of the @AcquiredFM podcast (you should follow it!) But, I was floored by the TSMC (Taiwan Semiconductor Manufacturing Company) episode. Wow, what a fascinating company and story! Some learnings here >>       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 225]             0 30 228 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]);