In part-one I started a journey on implementing and setting up an initial database using MongoDB. At the end of that post, I had a single collection, called "projects" with a defined schema and about 1000 records populated in it. In this post, I will explore how query many tables/collections, how to update data, and... Continue Reading →
Quick primer on MongoDB from a SQL nerd – part one
In my free time, I'm exploring the MEAN stack. My previous employer had a few teams running Node.JS & MongoDB and the resulting products and team-velocity looked slick! I'm following "Web Development with MongoDB and Node.js" by Jason Krol. Getting Started with MongoDB For this play-instance, I'm using a t2.micro Ubuntu instance (free-tier eligible) on... Continue Reading →
Postgres performance tuning – shmmax
Kudos to this blog for helping with postgres performance tuning. http://www.revsys.com/writings/postgresql-performance.html Per the blog, the biggest change that you'll notice is the shared_buffers change. I tried this, but got into kernel shmmax ...
Remember all the oracle functions? We need those in postgresql.
Well, how the hell do I do that? Here's how: 1. Install perl (if you don't already have it): apt-get install perl perl -MCPAN -e shell m DBI get DBD::Oracle 2. Install oracle instant client on your linux box (if you don't already have it): apt-get...