tweets
16 rows where favorite_count = 14 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: retweet_count, favorited, lang
created_at (date) 15 ✖
- 2021-12-23 2
- 2021-08-18 1
- 2021-08-20 1
- 2021-08-26 1
- 2021-09-01 1
- 2021-09-03 1
- 2021-09-05 1
- 2021-09-13 1
- 2021-09-22 1
- 2021-09-25 1
- 2021-10-06 1
- 2021-10-10 1
- 2021-10-21 1
- 2021-11-25 1
- 2021-12-10 1
user 4 ✖
- swyx 13
- Ben Kunz 1
- Emelia 👸🏻 1
- Theodorus Clarence 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1427988073292476418 | Emelia 👸🏻 14063149 | 2021-08-18T13:37:42+00:00 | @JessTelford JWTs for external use tend not to solve the problems people think they do; for internal use, or cross authorisation boundaries, they can be good because then you can assert using public/private key cryptography that the token your presented really came from the authorising server | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 293] | 1427986367905161221 | 14063149 | ThisIsMissEm | 0 | 1 | 14 | 0 | 0 | en | ||||||||
| 1428518661338263567 | swyx 33521530 | 2021-08-20T00:46:04+00:00 | @ericnakagawa $4m, seattle | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 26] | 1428441265922740225 | 2349251 | ericnakagawa | 0 | 0 | 14 | 0 | 0 | en | ||||||||
| 1430949616371961862 | swyx 33521530 | 2021-08-26T17:45:48+00:00 | i often hear that indie hackers have little to learn from working at bigco or venture track startups. The resource limitations, interpersonal management, product timeline, and transparency lessons are at minimum irrelevant, at worst totally inverse! this is the norm, but | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 274] | 0 | 0 | 14 | 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 | ||||||||
| 1434389932177559555 | swyx 33521530 | 2021-09-05T05:36:24+00:00 | Taken from this excellent compendium of Visual Programming - a very valuable format of blogpost! https://drossbucket.com/2021/06/30/hacker-news-folk-wisdom-on-visual-programming/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 121] | 1434388834087800832 | 33521530 | swyx | 0 | 2 | 14 | 0 | 0 | 0 | en | |||||||
| 1437407435241689102 | swyx 33521530 | 2021-09-13T13:26:52+00:00 | There’s a lot of advocacy of going all in on one cloud on Twitter, but this is the best collection of arguments for multi-cloud I’ve seen in a single talk — from @AdrienneTacke https://youtu.be/6Mzs5y_fjPE | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 202] | 0 | 3 | 14 | 0 | 0 | 0 | en | ||||||||||
| 1440797518749601803 | swyx 33521530 | 2021-09-22T21:57:51+00:00 | Quite a few questions on Smart Servers so far. Coincidentally @chris_mccord just published about their path to Phoenix Liveview, which is worth a look for what the Smart Server paradigm can do https://fly.io/blog/how-we-got-to-liveview/ amazing scoop for @flydotio in hiring him!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 262] | 1439966955570618376 | 33521530 | swyx | 0 | 0 | 14 | 0 | 0 | 0 | en | |||||||
| 1441908391211716608 | swyx 33521530 | 2021-09-25T23:32:04+00:00 | @jkup my site is still under construction with over a million visitors per year | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 79] | 1441872380016701440 | 255634108 | jkup | 0 | 0 | 14 | 0 | 0 | en | ||||||||
| 1445583402518802437 | swyx 33521530 | 2021-10-06T02:55:15+00:00 | @flybayer @blitz_js protip keep a “celebrate wins” or “wall of love” or “feedback” channel in slack where you collect these, you’re going to want them easy to find in future for the psychological pickup/investor update/user research | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [20, 232] | 1445398474397212672 | 2826554209 | flybayer | 0 | 0 | 14 | 0 | 0 | en | ||||||||
| 1447061274148311041 | swyx 33521530 | 2021-10-10T04:47:47+00:00 | @dan_abramov ah a man of culture! i don’t think pizza restaurants realize how much business they lose out on when customers walk close, squint at the menu, and walk off when they see that the restaurant are anti pineapple snobs | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 228] | 1447029234732523524 | 70345946 | dan_abramov | 0 | 0 | 14 | 0 | 0 | en | ||||||||
| 1451242768559443976 | Ben Kunz 4266261 | 2021-10-21T17:43:33+00:00 | Exceptional post by @swyx. How to create your luck. TLDR: Move more and observe. https://www.swyx.io/create-luck/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 108] | 0 | 7 | 14 | 1 | 1 | 0 | en | ||||||||||
| 1463718231454011393 | swyx 33521530 | 2021-11-25T03:56:35+00:00 | @jkup @AdamRackis finding so many people to mute, this is bliss | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 63] | 1463676727431946241 | 255634108 | jkup | 0 | 0 | 14 | 0 | 0 | en | ||||||||
| 1469128619716870146 | swyx 33521530 | 2021-12-10T02:15:32+00:00 | @JoeEmison @dmessing something i didnt stick around long enough to understand at Amplify was why people running atop AWS could build a faster experience than Amplify. You could blame CFN/CloudFront, but then @begin does that, with like a team of 4 people. wish i had the time to figure it out. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [21, 293] | 1469052947262754820 | 272692606 | JoeEmison | 0 | 1 | 14 | 0 | 0 | en | ||||||||
| 1473895021321482242 | swyx 33521530 | 2021-12-23T05:55:31+00:00 | @kevinakwok oof you said the thing i didnt dare say | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 51] | 1473891723973701635 | 169791252 | kevinakwok | 0 | 0 | 14 | 0 | 0 | en | ||||||||
| 1473962147965112320 | Theodorus Clarence 1228336168892170241 | 2021-12-23T10:22:15+00:00 | + opinions about tailwindcss 👀 awesome book by the way @swyx https://twitter.com/th_clarence/status/1473962147965112320/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 61] | 0 | 2 | 14 | 0 | 0 | 0 | en | ||||||||||
| 1433682486106542088 | swyx 33521530 | 2021-09-03T06:45:15+00:00 | 我吃的盐比你吃的饭还要多😱🤯 You could tell who spoke Chinese by the audible gasps in the room. Tony Leung owned every goddamn second he was onscreen in #shangchi https://twitter.com/swyx/status/1433682486106542088/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 149] | 0 | 0 | 14 | 0 | 0 | 0 | zh |
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]);