Tag Archives: database

posted

June 20, 2016

Optimizing database queries

by

Most projects you will work on will have a database of some sort. For this reason, optimizing your queries allows you to use all that the database provides without having your application try to reinvent the wheel. In this blog, I’ll be using Postgres and Ruby on Rails to demonstrate some ways that you can optimize things. Much of the second section is Postgres specific, but the concepts should apply to whatever ORM you are using. Hopefully by the end you will have learned some new tricks to improve your project.

read on

posted

November 30, 2015

SQL & NOSQL: A Brief History

by

The Relational Model & SQL

The relational model was proposed in a paper published in 1970 by Edgar Codd, a computer scientist working at IBM. In previous years, some storage systems had already emerged, but the relational model was first proposed with a strong theoretical basis.

read on

posted

April 21, 2015

HOWTO: Status Check for a Website Database

by

Many people know about services that allow you to ping your website to be sure it’s always online. The idea behind those is that they check every 5/10 mins sending a GET request to the given website and if they get an answer 200 they send you an email.

read on

posted

January 26, 2013

Introduction To Core Data

by

Core Data is a framework provided by Apple that allows developers to design, build and interact with a database, without ever having any direct interaction with SQL.

read on

posted

March 14, 2012

Getting started with Amazon DynamoDB

by

What’s Amazon DynamoDB?

DynamoDB is one of the most recent services offered by Amazon.com. Announced on January 18, 2012, it is a fully managed NoSQL database service that provides fast and predictable performance along with excellent scalability. Let’s quickly analyze its positive and negative aspects in the lists below:

read on