Showing a preview of an image before uploading is the really cool feature which improves UX. In this article, I want to share with the code which shows all file details before uploading. My code is created in Vue, but I think reading of it should be enough easy for everyone who knows basic JS.

UNION and UNION ALL are very similar - both combines result-set of SELECT queries, but the final sets are different. Let me allow to show you differences.

While developing apps, software developers often have to be sure that a database won't have duplicated data. Users are one of the best example. An username or an email has to be unique for one app. It might seem to be a trivial issue but for some cases, a solution is more sophisticated.

When I migrated from Vue 2 to Vue 3, one thing was annoying - how to get access to a DOM element in Composition API? In Vue 2, it was easy, you just needed to use the this.$refs object. How to do it in Vue 3?

While programming learning, I guess, you often read the sentence that you have to add comments, if you don't comment, your code is bad. It's truth, but only half-truth. Let me allow to share with my experience.