December 2014 Summaries

Node.js has a built-in debugger that can be activated in running processes by sending a SIGUSR1 signal, although it only listens on 127.0.0.1, the local interface. To debug a Node.js application running on a company's private network from a laptop, one must SSH into the production host to put the app into debug mode and set up an SSH tunnel to connect the private network with localhost. From the laptop, another SSH tunnel must be established through a bastion host to the production host, enabling remote debugging through an IDE like PyCharm or via the command line. The process involves creating a remote debugging configuration in PyCharm, connecting to the local SSH tunnel, and setting breakpoints to step through the application. If connectivity issues arise, restarting the SSH tunnels and PyCharm debugger is recommended, and users are encouraged to try Rollbar for managing application errors.

RQL has introduced a basic library of string functions that allow users to manipulate and group data flexibly, similar to MySQL's functionality. These functions include concat, concat_ws, lower, upper, left, right, substring, locate, length, and char_length, enabling operations such as extracting email domains to analyze event occurrences within a specified time frame. Users can now perform queries like identifying "email domains with the most events in the past hour" by employing these functions to slice and group data, enhancing RQL's data processing capabilities. For detailed usage, the RQL documentation provides further information on these functions.