body { -ms-overflow-style: scrollbar; overflow-y: scroll; overscroll-behavior-y: none; } .errorContainer { background-color: #FFF; color: #0F1419; max-width: 600px; margin: 0 auto; padding: 10%; font-family: Helvetica, sans-serif; font-size: 16px; } .errorButton { margin: 3em 0; } .errorButton a { background: #1DA1F2; border-radius: 2.5em; color: white; padding: 1em 2em; text-decoration: none; } .errorButton a:hover, .errorButton a:focus { background: rgb(26, 145, 218); } .errorFooter { color: #657786; font-size: 80%; line-height: 1.5; padding: 1em 0; } .errorFooter a, .errorFooter a:visited { color: #657786; text-decoration: none; padding-right: 1em; } .errorFooter a:hover, .errorFooter a:active { text-decoration: underline; } #placeholder, #react-root { display: none !important; } body { background-color: #FFF !important; }

JavaScript is not available.

We’ve detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our Help Center.

Terms of Service Privacy Policy Cookie Policy Imprint Ads info © 2023 Twitter, Inc.

Conversation

Merging a MASSIVE PR to

in a couple of hours that: ◆ Adds features like UTM builder, password protection, archiving links, filtering & sorting links, etc. ◆ Refactors the codebase to switch from Redis → MySQL for storing link metadata ...wish me luck 🤞

7

1

78

miguel piedrafita

Replying to

and

ooo excited to source-dive new db schema, i love sql

1

1

Replying to

and

Yessss, learned about adding sort order to sql indexes when building this 👀

How to configure index functionality and add full text indexes

1

1

miguel piedrafita

Replying to

and

I learned a lot about optimizing SQL with

's course (very laravel-focused unfortunately, but still lots of gold nuggets in there that can be applied elsewhere if u understand Eloquent)

eloquent-course.reinink.ca

Eloquent Performance Patterns

Learn how to drastically improve the performance of your Laravel applications by pushing more work to the database, all while still using the Eloquent ORM.

5:32 PM · Oct 22, 2022

Replying to

and

this is sooo good! we sometimes forget that your website is only as fast as your slowest API calls and SQL optimization is so important for improving API latency! thanks for sharing that!

4