This is a quick Tip. Earlier today, I ran into a situation where the seeming straightforward query to udpate a record using JpaRepository did not update the database record. The following was the query I was using. Upon looking into the console, I noticed the following error. Looks like all I needed to was to… Continue reading How to run update query with JPA?
MySQL – How to insert data to a table by selecting from another table.
I had a music table which was normalized, but then I wanted to break it into albums and songs. The data was normalized in first place because of how the crawler was crawling it. After I created a separate songs table, I had to copy the album code from the normalized table into the songs… Continue reading MySQL – How to insert data to a table by selecting from another table.
React / Angular App with Spring Boot Backend – How to Fix BrowserRoute URLs in Production for SEO
Update: 12/20/2020After I converted all my HashRoute URL to BrowserRoute URL, and did some mod rewrite in tomcat, Google has successfully crawled my website and indexed it. So you got your react app running locally (and probably angular too) with the backend service or REST API running on Spring Boot with Embedded Tomcat. Then one… Continue reading React / Angular App with Spring Boot Backend – How to Fix BrowserRoute URLs in Production for SEO
Storage capacity of TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT in MySQL Database
You can store text of various sizes in MySQL database. Although, VARCHAR formats are common for smaller text, mysql provides an alternative to store texts. Here are the different data type and their capacity. TINYTEXT – Can hold up to 255 bytes i.e. 255 characters with 1 byte overhead. SMALLTEXT – Can hold up to… Continue reading Storage capacity of TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT in MySQL Database
How to use Qsync Software by QNAP to sync your local folder to NAS folder.
If you have used QNAP NAS as your Network Attached Storage for either your home or business, you might have a need to auto backup certain contents from your laptop, pc or mac. This is doable, however it requires an extra software, also developed by the QNAP itself, and some configurations on that server. This… Continue reading How to use Qsync Software by QNAP to sync your local folder to NAS folder.