Sometimes you have files or other large chunks of data that you need to associate with a record in your database. It might be convenient to just store that as base64-encoded data or HTML in a "longtext" column, but that can eventually cause issues—especially as the table grows. What other options are there?In this episode of Over Engineered, we go back to the show's roots and try to find the absolute best solution to a problem we already have an acceptable solution for.

<description>
 &lt;p&gt;Sometimes you have files or other large chunks of data that you need to associate with a record in your database. It might be convenient to just store that as base64-encoded data or HTML in a "longtext" column, but that can eventually cause issues—especially as the table grows. What other options are there?&lt;/p&gt;&lt;p&gt;In this episode of Over Engineered, we go back to the show's roots and try to find the absolute best solution to a problem we already have an acceptable solution for.&lt;/p&gt;
 </description>

Storing Files in the Database w/ Bogdan Kharchenko and Skyler Katz

At the beginning of August, after six years of working on it on-and-off, Ben Holmen took his <a href="https://kilopx.com/">Kilopixel</a> project live. It's a 1000 pixel display, where each pixel has to be manually toggled by a custom CNC rig, and it's whimsical and impractical and took the internet by storm. In today's episode, Chris chats with Ben and Joe about the whole project and what's next for the display.Links:<ul><li><a href="https://kilopx.com/">Kilopixel</a></li><li><a href="https://benholmen.com/blog/kilopixel/">I spent 6 years building a ridiculous wooden pixel display</a></li><li><a href="https://benholmen.com/blog/kilopixel-season-1/">The Kilopixel recap</a></li><li><a href="https://news.ycombinator.com/item?id=44787902">Show HN</a></li><li><a href="https://sideprojectpodcast.com/episodes/kilopixel-with-ben-holmen">Kilopixel on Side Projects</a></li><li><a href="https://overengineered.fm/episodes/the-art-of-pairing-with-strangers-w-ben-holmen">Ben Holmen on Over Engineered</a></li></ul>

<description>
 &lt;p&gt;At the beginning of August, after six years of working on it on-and-off, Ben Holmen took his &lt;a href="https://kilopx.com/"&gt;Kilopixel&lt;/a&gt; project live. It's a 1000 pixel display, where each pixel has to be manually toggled by a custom CNC rig, and it's whimsical and impractical and took the internet by storm. In today's episode, Chris chats with Ben and Joe about the whole project and what's next for the display.&lt;/p&gt;&lt;p&gt;Links:&lt;/p&gt;&lt;ul&gt;&lt;li&gt;&lt;a href="https://kilopx.com/"&gt;Kilopixel&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://benholmen.com/blog/kilopixel/"&gt;I spent 6 years building a ridiculous wooden pixel display&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://benholmen.com/blog/kilopixel-season-1/"&gt;The Kilopixel recap&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://news.ycombinator.com/item?id=44787902"&gt;Show HN&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://sideprojectpodcast.com/episodes/kilopixel-with-ben-holmen"&gt;Kilopixel on Side Projects&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://overengineered.fm/episodes/the-art-of-pairing-with-strangers-w-ben-holmen"&gt;Ben Holmen on Over Engineered&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;
 </description>

Kilopixel Retro w/ Ben Holmen + Joe Tannenbaum

Up until now, browser testing in Laravel has felt… bad. Dusk was a huge step over nothing, but it's been slow and flaky and just waiting to be replaced with something better. And with Pest 4, Nuno's cracked it!In today's episode of Over Engineered with dig into the technical details of what makes browser testing in Pest 4 both very fast and much more stable than Dusk and all the other browser testing approaches that came before it.Links:<ul><li><a href="https://pestphp.com/">Pest</a></li><li><a href="https://nunomaduro.com/">Nuno Maduro</a> (<a href="https://nunomaduro.com/socials">all his socials</a>)</li><li><a href="https://playwright.dev/">Playwright</a></li><li><a href="https://www.youtube.com/live/p-LNw423EwU?si=I0CKSTZywMv9munt">Nuno's livestream of this episode</a></li></ul>

<description>
 &lt;p&gt;Up until now, browser testing in Laravel has felt… bad. Dusk was a huge step over nothing, but it's been slow and flaky and just waiting to be replaced with something better. And with Pest 4, Nuno's cracked it!&lt;/p&gt;&lt;p&gt;In today's episode of Over Engineered with dig into the technical details of what makes browser testing in Pest 4 both &lt;strong&gt;very fast&lt;/strong&gt; and &lt;strong&gt;much more stable&lt;/strong&gt; than Dusk and all the other browser testing approaches that came before it.&lt;/p&gt;&lt;p&gt;Links:&lt;/p&gt;&lt;ul&gt;&lt;li&gt;&lt;a href="https://pestphp.com/"&gt;Pest&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://nunomaduro.com/"&gt;Nuno Maduro&lt;/a&gt; (&lt;a href="https://nunomaduro.com/socials"&gt;all his socials&lt;/a&gt;)&lt;/li&gt;&lt;li&gt;&lt;a href="https://playwright.dev/"&gt;Playwright&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://www.youtube.com/live/p-LNw423EwU?si=I0CKSTZywMv9munt"&gt;Nuno's livestream of this episode&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;
 </description>

(Actually good) browser testing w/ Nuno Maduro

Alex Hillman has been thinking about and actively supporting communities for decades. In this episode, Chris and Alex talk about lessons he's learned along the way that can help meetup organizers tend their local tech communities, and brainstorm about ways that we can organize together to support meetups in general.Links:<ul><li><a href="https://tiny.mba/">tiny.mba</a></li><li><a href="https://stackingthebricks.com/">stackingthebricks.com</a></li><li><a href="https://indyhall.org/">indyhall.org</a></li><li><a href="http://10k.city/">10k.city</a></li><li><a href="https://phpx.world/">phpx.world</a></li></ul>

<description>
 &lt;p&gt;Alex Hillman has been thinking about and actively supporting communities for decades. In this episode, Chris and Alex talk about lessons he's learned along the way that can help meetup organizers tend their local tech communities, and brainstorm about ways that we can organize together to support meetups in general.&lt;/p&gt;&lt;p&gt;Links:&lt;/p&gt;&lt;ul&gt;&lt;li&gt;&lt;a href="https://tiny.mba/"&gt;tiny.mba&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://stackingthebricks.com/"&gt;stackingthebricks.com&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://indyhall.org/"&gt;indyhall.org&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="http://10k.city/"&gt;10k.city&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://phpx.world/"&gt;phpx.world&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;
 </description>

Fostering Community w/ Alex Hillman

Simon Hamp and Marcel Pociot have been working on NativePHP for a number of years, and Simon just surprised with world at Laracon EU with a NativePHP for Mobile announcement. In this episode, Simon and Chris get deep into the the NativePHP innards, explore sustainable open source, and generally just have a good time for &lt;&lt;checks watch&gt;&gt; over two hours 😅Links:<ul><li><a href="https://nativephp.com/">NativePHP</a></li><li><a href="https://zephpyr.com/">Zephpyr</a></li><li><a href="https://github.com/Stillat/dagger">dagger</a></li></ul>

<description>
 &lt;p&gt;Simon Hamp and Marcel Pociot have been working on NativePHP for a number of years, and Simon just surprised with world at Laracon EU with a NativePHP for Mobile announcement. In this episode, Simon and Chris get deep into the the NativePHP innards, explore sustainable open source, and generally just have a good time for &amp;lt;&amp;lt;checks watch&amp;gt;&amp;gt; over two hours 😅&lt;/p&gt;&lt;p&gt;Links:&lt;/p&gt;&lt;ul&gt;&lt;li&gt;&lt;a href="https://nativephp.com/"&gt;NativePHP&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://zephpyr.com/"&gt;Zephpyr&lt;/a&gt;&lt;/li&gt;&lt;li&gt;&lt;a href="https://github.com/Stillat/dagger"&gt;dagger&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;
 </description>

Native PHP w/ Simon Hamp

A podcast where we explore unimportant programming questions (mostly PHP/Laravel/JavaScript) in extreme detail.

Over Engineered

Details

Recent Episodes