Menu

Hand-researched boat specs as JSON, applied by slug in a seeder
📰

Hand-researched boat specs as JSON, applied by slug in a seeder

DEV Community: laravel·Matt·2 days ago
#0GZXsp5O
#devtolaravel#devto#dev#design#every
Reading 0:00
15s threshold

I built a CLC Northeaster Dory in my garage in 2020. The hardest part of choosing it was not the woodworking. It was finding honest numbers: how long the boat really is, what it is built from, and how many hours it took people like me. That is why I built Boat Build Log , a Laravel 13 and MySQL 8 site where amateur builders log their builds and every design gets a page with real medians from those logs.

The logs need a catalog of designs to hang on. It has 1,052 design pages from dozens of designers, plus a few hundred production boats for people who restore rather than build. This post is about how the specs and write-ups for all of those got into the database, and how they stay there.

The problem

The catalog started as plain PHP arrays in database/seeders/data , one file per vendor, crawled from the designers' own listings. Each vendor publishes differently, so the files have different shapes. CLC gives a beam, Glen-L mostly does not, Devlin has his own format, and so on.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.