Search Results for: mysql 8
SQLite is really a good tool to set up quick proof of concepts and small applications; however it’s not the most robust solution on the market for working with relational databases. In the open source community two databases take the top of the list: PostgreSQL and MySQL. I did a small project for my studies. … Continue reading Using Active Record migrations beyond SQLite →
This is an unstable release, please don’t use in production. It was rumored that the new MySQL version would be 8 and not as 5.8 as a lot of people thought, and it appears the rumors were true. Below are some of the features that caught my eye at first glance: Roles Although password expiration … Continue reading MySQL 8.0 (dev): what to look for →
This post is a case study of a job I had to do in a legacy application, it doesn’t mean it will apply to you, but it might. This is a table of contents: Performance Searching Converting to a JSON array 1st step: remove the leading commas 2nd step: add brackets to the string 3rd … Continue reading Converting comma separated fields to MySQL JSON – a case study →