Script Raccoon

Script Raccoon

@scriptraccoon.dev

Mathematican, Software Developer, YouTuber ๐Ÿ”— https://scriptraccoon.dev

181 followers70 following374 posts

Script Raccoon
@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

Script Raccoon
@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

Script Raccoon
@scriptraccoon.dev

... these steps may require a few mins, data might be inconsistent. The pages that require the DB live already have the new data before the deployment is finished. This might actually crash the application. AI suggests removing the prerendering and using caching instead. Other ideas? 2/2

Script Raccoon
@scriptraccoon.dev

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...

Script Raccoon
@scriptraccoon.dev

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.

Script Raccoon
@scriptraccoon.dev

PS. But also I just feel confident writing CSS, much more than handling graphics software (still haven't found one for macOS that I like). And it is fun to write code to generate images. ๐Ÿง‘โ€๐Ÿ’ป

Script Raccoon
@scriptraccoon.dev

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).

Script Raccoon
@scriptraccoon.dev

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?

Script Raccoon
@scriptraccoon.dev

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.

Script Raccoon
@scriptraccoon.dev

I call the YouTube data API every day to get the number of views for a video tutorial (which explains exactly that). Yesterday it went from 243 to 242. ๐Ÿคท

Script Raccoon
@scriptraccoon.dev

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. ๐Ÿฆ

Script Raccoon
@scriptraccoon.dev

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.

Script Raccoon
@scriptraccoon.dev

Apart from loops, here are two features I am still missing in Vanilla CSS. (1) Mixins (to avoid code duplication and improve readability) (2) Variables in keyframes (to make them more dynamic).

Script Raccoon
@scriptraccoon.dev

You won't believe how many times I need to delete a comment and send it again (here on Bluesky, but also on X when I was active there). It's much better on Reddit, for example.

Script Raccoon
@scriptraccoon.dev

I find it quite surprising that 70% of the visitors of my website are using light mode, only 30% are using dark mode (this is one of the dimensions I have recently added to my analytics). I would have expected 90% dark mode, because I was under the impression that developers are nerdy night owls ๐Ÿฆ‰

Script Raccoon
@scriptraccoon.dev

PS. This made me realize that I should not drop light mode (which I thought about lately) and instead I should check every blog post also in light mode (some posts had code blocks which were unreadable in light mode).

Script Raccoon
@scriptraccoon.dev

Try to create a GitHub account today (with email + password). ๐Ÿ˜ฎโ€๐Ÿ’จ While I understand that GitHub needs to check that I am a human being: why do I need to make 10 tests? Also, why did they choose such low-res images? Sometimes the solution was not clear at all. The audio tests also take too long.