MySQL Error – Field ‘name’ doesn’t have a default value – OS X

This error crops up when you’re trying to run INSERT or UPDATE command with empty fields for which default value isn’t set.

Cause:

MySQL has a couple of modes,  of which STRICT_TRANS_TABLES is the one screwing you over. This mode is enabled by default in an install-script generated my-default.cnf or my.cnf file. (the exact name depends on your MySQL version)

Install NVM on OSX sooner than later

Much like Ruby’s version manager, its best to get Nodejs Version Manager from the beginning if you’re going to be working with Node.
Node being actively under improvement is churning new versions quickly. Keeping up with different package requirements can be a mess even if you’re not dealing with multiple projects. And you probably need some serious help if you’re doing so. Which is where NVM comes in.

How to automatically download songs (mp3) from YouTube using Ruby Script

I asked a friend for some music suggestions, and received a long list of songs. Unsure what to do with it, I wrote a Ruby Script to lookup the songs on YouTube, and download the first link that shows up as an Mp3 file. You can do the same with any list of songs titles.

Pre-requisites:

• Ruby
• RubyGem Selenium-Webdriver

NetSuite API Integration with Ruby on Rails – Part 2 – Add Sales Order

NetSuite is a popular ERP software used by several businesses and can be easily integrated with a Rails project using a gem called ‘netsuite‘. In my previous post, we sent Get, Get All, Get Select Value, and Search requests to query data from NetSuite System. We also collected all the data and stored it in a handy csv.

Now, we’ll see how to create a Sales Order Object and send an Add request to add a new Sales Order to the NetSuite records.

NetSuite API Integration with Ruby on Rails – Part 1 – Queries

Recently we faced a client requirement to integrate NetSuite with our rails project. NetSuite is a popular cloud based ERP software used by several medium and large businesses to typically manage their Sales Orders, Customers and Inventory Items.

Use Google Drive to Automatically Sync Music between Android Phone and PC for free

Without music, life would be a mistake. – Friedrich Nietzsche

We want our music everywhere we go. Whether we’re working on a desktop at the office, lazing around with our laptops, or on a bus with our phones.
When we add to or remove music from our library, we want it to happen on all the devices, automatically.
We want to use our favourite music players, and not the ones the cloud services choose to impose on us.
We want all the music available offline too. Because crappy network connectivity shouldn’t stop the music.

Sounds like we’re asking for a lot. But there are still a couple of ways we can get all of that for free.

Quoted-printable – crossing the 1000 character SMTP barrier

While sending some lengthy text files as email attachments, I discovered that some of my sentences were broken mid-word into new lines. Turns out, SMTP protocol allows only 1000 characters per line.

Set up Monit for Sidekiq on Rails Server

Monit is a handy utility that can be used to monitor memory, processes or services on your Unix machine or server. It can send mail alerts or automatically restart processes as per configuration.

Monit can be installed with a simple command:
sudo apt-get install monit

Clear sidekiq / redis queue

Sidekiq is mostly used for moving long-running jobs into a background process. It uses Redis to manage its job queue. During development, we often need to clear this queue of jobs to start afresh.