Script Raccoon

@scriptraccoon.dev

Mathematican, Software Developer, YouTuber 🔗 https://scriptraccoon.dev

Say I have a SvelteKit in which most pages can be prerendered and this requires data from the DB. Some pages require the DB live. Now what happens during a deployment? I need to update the DB (if migrations were added) and then update the web application and push the new code. However, since... 1/2

Any ideas how to prerender a list of dynamic routes in SvelteKit whose slugs are saved in the database? In config.kit.prerender I can list them, but currently it's hard coded. Not sure if it's good to query the database for the build step? I could have a secret page with links to all these routes...

I tried out a new web framework (I won't mention its name). Every time that happens, I immediately compare it to SvelteKit and come to the conclusion that it's much worse. DX, speed, structure... Nothing beats #svelte. Only downside is that my projects have the same structure and don't vary much.

YouTubers reaching 1mio subs: big party, screaming, donation special, explosions, bragging, storytelling, guests, ... Kevin Powell reaching 1mio subs: cool. :-) I plan to write a blog post about why he is my favorite programming YouTuber (since 2019 actually).

Top 8 Countries from which people access my portfolio website: 1. United States - 23.51% 2. Singapore - 17.55% 3. China - 8.46% 4. Germany - 6.27% 5. France - 5.33% 6. United Kingdom - 4.7% 7. Canada - 3.76% 8. Italy - 2.51% I am really surprised about Singapore. Also, India ... where are you?

Is there actually any good SQL formatter extension for vs code? I have tried the first 5 that pop up in the search for extension, and they all have big issues. I am thinking about manually formatting the code for now.

It was time to migrate a SQLite database to a Postgres database. The setup took some time, and I needed to change the implementation of my wrapper query function. But most of the application code did not need to be touched, basically because the *interface* of my query function did not change. 🦝

If you think you don't make any progress, just look at the code you wrote one year ago. You will likely immediately see lots of things that can be improved. This is what you learned in the meantime.