-
Examples of PostgreSQL’s RETURNING clause and its impact
The RETURNING clause in PostgreSQL is a powerful feature that allows you to retrieve values of one or more columns immediately after performing an INSERT, UPDATE or DELETE operation. This can save an additional query to fetch the data and is especially useful in applications where you need immediate feedback from the database operation. Below…
-
Upgrade to my server infrastructure setup
In the previous weekend I have made some pretty big changes to my VPS provided by Digital Ocean and where this blog is hosted. Actually two but one is worth mentioning only because it was the reason second happened. So the one not worth mentioning is that I have upgraded my VPS’s operating system Ubuntu…
-
Installing Apache, PHP and MariaDB on Windows manually
These are the steps I took to install my own (local) web development setup on Windows. I moved away from XAMPP or WAMP installation packages because I want to have a way to change software version of each components easier and registering them as a Windows services. Downloaded the latest version of software: Apache, PHP…
-
On MobX Redux dilemma
In my experiences using MobX as a state management library produces less code and lets you get things done quicker (two-folded knife!) but with Redux you get a lot of stuff for free – most notable is scalable approach to architecture and maintenance of web applications. I personally prefer Redux also because it’s functional like…
-
New React Context API
I like new react API for creating and using context. It feels right. One thing I immediately tried to do was creating a helper which simplifies consuming multiple contexts. Because they create context hell. When you component uses more than one context and because of a children as a function pattern (which is basically the…