Search Results for: mysql 8

Using Active Record migrations beyond SQLite

Using Active Record migrations beyond SQLite

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

Converting comma separated fields to MySQL JSON – a case study

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