Kyle Wascher
LightNews LightNews
banner
waschlogic.com
Kyle Wascher
@waschlogic.com
140 followers 660 following 100 posts
Current: #ReactNative #ComputerVision #ML #typescript #android #ios
Past: 14 years of corporate dev, #csharp #dotnetcore #react #sql

#MLS #ColumbusCrew #USWNT #USMNT
#Fishing
Posts Replies Media Videos
waschlogic.com
Typescripts biggest lacking feature -> Go to definition for TypeScript literal strings

github.com/microsoft/Ty...
A VSCode Screenshot showing some typescript and react code. VSCode has a goto definition dialog open, with "Go to Definition" highlighted.
December 3, 2024 at 9:44 PM
waschlogic.com
/shutters
November 19, 2024 at 8:49 PM
waschlogic.com
Here's a real world example:

I originally hard coded my fish species with a human friendly string. Ex: "Smallmouth Bass"

Later during development I realized It makes more sense to have its own table.
Here's a patch that adds `species_id` and removes `species`.
ALTER TABLE fishing_trip_catch ADD `species_id` text REFERENCES fish_species(id);--> statement-breakpoint UPDATE fishing_trip_catch SET species_id = 'bass_smallmouth' WHERE species = 'Smallmouth Bass'; UPDATE fishing_trip_catch SET species_id = 'bass_largemouth' WHERE species = 'Largemouth Bass'; UPDATE fishing_trip_catch SET species_id = 'catfish_channel' WHERE species = 'Catfish'; UPDATE fishing_trip_catch SET species_id = 'crappie_black' WHERE species = 'Crappie'; UPDATE fishing_trip_catch SET species_id = 'muskellunge_northern' WHERE species = 'Muskie'; UPDATE fishing_trip_catch SET species_id = 'northern_pike' WHERE species = 'Northern Pike'; UPDATE fishing_trip_catch SET species_id = 'perch_yellow' WHERE species = 'Yellow Perch'; UPDATE fishing_trip_catch SET species_id = 'salmon_chinook' WHERE species = 'Chinook Salmon'; UPDATE fishing_trip_catch SET species_id = 'salmon_atlantic' WHERE species = 'Atlantic Salmon'; UPDATE fishing_trip_catch SET species_id = 'trout_lake' WHERE species = 'Lake Trout'; UPDATE fishing_trip_catch SET species_id = 'trout_brown' WHERE species = 'Brown Trout'; UPDATE fishing_trip_catch SET species_id = 'walleye' WHERE species = 'Walleye'; ALTER TABLE `fishing_trip_catch` DROP COLUMN `species`;
November 15, 2024 at 3:07 PM
waschlogic.com
I use sql migrations.

I have a simple folder with straight sql files for schema changes. (They are randomly generated names lol)
November 15, 2024 at 3:07 PM
waschlogic.com
Starting to see lots of tech folks in my timeline!

The time has come.
Friendship ended with x, now BSKY is my best friend.
November 7, 2024 at 3:01 PM