web://❤ A web related blog by Christian Engel

Convert a MySQL or Postgres database to SQLite

Published on Mon May 30 2022

If you want to convert old MySQL-driven websites to static sites, a SQLite database on your harddrive could be helpful. Here is how to convert MySQL to SQLite.

Read Convert a MySQL or Postgres database to SQLite

Subscribable stores in React

Published on Sat May 21 2022

Subscribable stores are a pattern which is relatively new for React applications.

Read Subscribable stores in React

Limit access of Strapi users to their own entries

Published on Sun May 15 2022

What I wanted was that when a user requested a list of or a certain entity, the backend should only respond with entities which belong to the user. By default, Strapi would send all entities from everyone.

Read Limit access of Strapi users to their own entries

Strapi quirks you should know about

Published on Sat Apr 30 2022

When I first came across Strapi, I had some misconceptions about it which are not immediately clear when reading about the framework in their docs.

Read Strapi quirks you should know about

A typed event system for Typescript

Published on Tue Apr 19 2022

I wrote a simple, typed event emitter/subscriber system on the weekend.

Read A typed event system for Typescript

Access denied for 'root'@'localhost'

Published on Thu Dec 09 2021

MySQL won't let me authenticate as root user through an SSH tunnel in dbeaver.

Read Access denied for 'root'@'localhost'

Media Query organization in SASS

Published on Fri Nov 19 2021

SASS makes working with media queries / breakpoints easy, if you apply this pattern

Read Media Query organization in SASS

The Redirect Response pattern

Published on Mon Oct 04 2021

Using HTTP callbacks with your API gives interesting possibilities to reduce client side javascript.

Read The Redirect Response pattern

Introducing and using Obsidian

Published on Tue Sep 28 2021

I discovered a valuable note-taking app I want to share with you

Read Introducing and using Obsidian

Mocking modules with jest and typescript

Published on Thu Dec 10 2020

Since it took me some time to understand the behaviour and the jest docs don't tell much about it, I wanted to write down how to mock modules with jest and especially update the return values of module functions across your tests.

Read Mocking modules with jest and typescript

The new old school

Published on Wed Oct 14 2020

My blog is finally online again. This time as a statically generated page. Here is how I made it.

Read The new old school

Updates about react hook router

Published on Tue Apr 30 2019

It's been about a month, since I released my initial version of hookrouter. Lots of things happened since then.

Read Updates about react hook router

Modern and clean routing with hooks

Published on Thu Mar 21 2019

A quick experiment about using hooks for routing in a react app turned out to be very flexible and powerful.

Read Modern and clean routing with hooks

Create a react component as npm module

Published on Wed Mar 06 2019

There are a lot of guides out there that advise you to use webpack to wrap up your components before publishing them to npm. This is absolutely not necessary. I would even consider it bad practice. Its much easier without webpack, too.

Read Create a react component as npm module