twitter: tweets: 12 rows where in_reply_to_user

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

12 rows where in_reply_to_user_id = 40663578 sorted by lang

Search:

descending

id	user	created_at	full_text	quoted_status	source	display_text_range	in_reply_to_status_id	in_reply_to_user_id	in_reply_to_screen_name	is_quote_status	retweet_count	favorite_count	favorited	retweeted	possibly_sensitive	lang ▼
1428266802174332930	swyx 33521530	2021-08-19T08:05:16+00:00	@sebastienlorber @docusaurus thank you!! yeah the real challenge is TWO WAY linking… (aka destination page also gets a list of pages that link to it) i think it is possible but need to hack into the classic theme even further. in gatsby this is easy bc of the data pipeline but here im less familiar		Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20	[29, 299]	1428265486274514947	40663578	sebastienlorber	0	0	1	0	0		en
1428267482867933191	swyx 33521530	2021-08-19T08:07:58+00:00	@sebastienlorber @reactjs @docusaurus code is here! https://github.com/sw-yx/demo-docusaurus-mdx-preview-poc/blob/ec326366710577162500b78ced31a4734b47b101/src/theme/MDXComponents/index.js#L63 idk if its possible to enable by default, it requires the weird importing and extra metadata for rendering the short description. but i’d love to see if u have ideas.		Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20	[38, 243]	1428266511580508164	40663578	sebastienlorber	0	0	2	0	0	0	en
1428267871528919042	swyx 33521530	2021-08-19T08:09:31+00:00	@sebastienlorber @reactjs @docusaurus ah makes sense. perhaps worth inserting a “you may not need to swizzle! try wrapping instead!” when someone uses the swizzle —danger flag		Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20	[38, 175]	1428267010291601408	40663578	sebastienlorber	0	0	1	0	0		en
1428268334257037313	swyx 33521530	2021-08-19T08:11:21+00:00	@sebastienlorber @reactjs @docusaurus got u. my thinking on this one is someday i might want to display an excerpt derived from the markdown itself so i can offer rich text in the preview. but no idea how to cut it off automatically/manually.		Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20	[38, 243]	1428267246477090820	40663578	sebastienlorber	0	0	1	0	0		en
1428269886883581952	swyx 33521530	2021-08-19T08:17:31+00:00	@sebastienlorber @docusaurus 🔥 one nuance to handle here is you may also want to track which section links to the page, so in the backlink you can use the #anchor tag to send readers directly to the linked text. mad science bonus goal: include surrounding text		Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20	[29, 264]	1428268180972216323	40663578	sebastienlorber	0	0	1	0	0		en
1428270697105612802	swyx 33521530	2021-08-19T08:20:44+00:00	@sebastienlorber @reactjs @docusaurus i think also would be no problem rendering iframe since same origin, no screenshot needed. yeah ok so we’ll just go with simple metadata for now ♥️		Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20	[38, 187]	1428269843199971332	40663578	sebastienlorber	0	0	1	0	0		en
1451410441012273155	swyx 33521530	2021-10-22T04:49:49+00:00	@sebastienlorber honestly miss getting excited about stuff like this. love that react continues to innovate. 💜		Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20	[17, 110]	1451216514779172867	40663578	sebastienlorber	0	0	12	0	0		en
1451458652750057473	swyx 33521530	2021-10-22T08:01:24+00:00	@sebastienlorber @Abdullah_Mzaien some hints here :) https://twitter.com/swyx/status/1439702355553886211	1439702355553886211 1439702355553886211	Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20	[34, 52]	1451225120752783367	40663578	sebastienlorber	1	0	1	0	0	0	en
1458068399318253582	Sebastien Lorber 🇫🇷 🦖 ⚛️ 📨 40663578	2021-11-09T13:46:10+00:00	🧵 🎙️🎥 Podcast with @swyx & @leeerob Lots of interesting subjects! Couldn't listen to it this week 😅 But definitely will, I'll comment next week! https://www.youtube.com/watch?v=mlsTlFW7BSo https://twitter.com/sebastienlorber/status/1458068399318253582/photo/1		FeedHive.io 6746f3a6d1b3aa371a4a2dc1c08c7862cd6e911e	[0, 178]	1458068394197098505	40663578	sebastienlorber	0	1	16	1	1	0	en
1465611368178978817	swyx 33521530	2021-11-30T09:19:14+00:00	@sebastienlorber @remotion_dev youtube intros for work and personal, maaaaybe full tutorials, IF the coding portion is not too heavy (i am not yet convinced... i always say we should not use code tools to make code presentations, because we often end up wasting a lot of time fixing the code tools)		Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952	[31, 298]	1465606845863706624	40663578	sebastienlorber	0	0	3	0	0		en
1422237396096012289	swyx 33521530	2021-08-02T16:46:33+00:00	@sebastienlorber buttondown		Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952	[17, 27]	1422236579951697933	40663578	sebastienlorber	0	0	4	0	0		it
1453290745906057219	swyx 33521530	2021-10-27T09:21:29+00:00	@sebastienlorber 🎉		Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20	[17, 18]	1453262895912005639	40663578	sebastienlorber	0	0	2	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]);