Not so long time ago, I was very useful as Full-Stack Rails developer for 27faces project. It is like AI as a Service platform that can be pretty helpful as solution of a bunch of marketing problems. The main idea is to recognize the faces of the people staying or walking in front of regular camera connected to PC. The system can classify viewers by age, gender, their attention and mark the time visitors spent near the camera. It’s possible to collect such statistics from a set of configured camera-points on the server side and represent the data in the form of charts, that all business analysts love. I was working on back-end, UI, data collection, charts and devops. The implementation is standard rails application + set of usual gems, so, solution is robust. Besides, there are Bootstrap for UI and amazing Capistrano for deployment. In despite of node.js hype, rails is still sexy and widely used.
Today I’ve migrated the database of Ruby on Rails project from Sqlite to MySQL. It’s not first time I’ve done it. So, I decided to note it as a post.
First of all, it needs to add special yaml_db gem to the project:
It allows us to dump all data from the storage by command like:
RAILS_ENV=production rake db:dump
then switch the storage (production inour case) from Sqlite to MySQL in config/database.yml file and load the data back to the storage:
RAILS_ENV=production rake db:load
in this case into MySQL backend.
It’s a preferred way of such migration because of its pure abstract yaml representation of the data. It doesn’t depend on specific SQL.
I’ve passed free online SAAS classes provided by professors of UC Berkeley and even received the statement of successful accomplishment. There are several lectures recorded into short movies available to download or watch online. Those lectures are split into several weeks by themes. After each week it needs to pass the quiz and make done pure practically coding tasks as homework. There are 4 main themes: Ruby, Rails, BDD with cucumber and TDD with RSpec. It was not very interesting as other classes (like AI, Machine Learning, NLP, Crypto) because the majority of topics (ruby, rails, web and unit tests) are regular software development tasks. BDD with cucumber was exceptionally interesting.
I’m involved as Ruby On Rails developer on the start-up web project.
The project has not hosting place, so, to provide any demo I need some free ROR hosting.
I’ve googled heroku.com. It’s interesting service ready to be used as ROR hosting for free.
git push heroku master