If you are actively using Rails for developing your projects, then it’s likely that in at least one of your projects you are using PostgreSQL as the database technology. You have already added the pg in your Gemfile and have already started to use it. Then your client asks you about the version of PostgreSQL that you are using, and you may be confused for a bit about it, as you aren’t sure.
Continue readingTag: database
As one of the most famous languages out there that developers use all the time, knowing at least a few things about SQL can be quite helpful. Of course, you can refer back to one of its online documentations, or check up at w3schools.com, but you may also prefer a quick cheat sheet that you can use to refresh up your knowledge or learn something that you may have not learned before. A relatively new Github repository, at least at the time of this writing, has been created, which has some of the most common SQL commands that you may use in your daily tasks. Continue reading
One of the most important parts of developing a project is the necessity to have a clear picture in mind about the end goal. Namely, knowing the target audience that this project has and the features that it will include. This means that we need to make sure we are informed as much as possible about the business logic, and then be able to do the implementation of all the features as needed. Continue reading
Comma Separated Values (CSV) files represent some commonly used files. You may have a CSV file generated from a report generated, and then you may need to write a Ruby method or task to insert it into the database. Continue reading