Tag Archives: database

MongoDB Replication is Easy

Posted on August 8, 2010 by Geoff Lane

Database replication with MongoDB is easy to setup. Replication duplicates all of the data from a master to one or more slave instances and allows for safety and quick recovery in case of a problem with your master database. Here … Continue reading →

Posted in Code | Tagged , , | Leave a comment

MongoDB and Java: Find an item by Id

Posted on June 17, 2010 by Geoff Lane

MongoDB is one of a number of new databases that have cropped up lately eschewing SQL. These NoSQL databases provide non-relational models that are suitable for solving different kinds of problems. This camp includes document oriented, tabular and key/value oriented … Continue reading →

Posted in Code, Java | Tagged , , | Leave a comment

Database Migrations for .NET

Posted on April 20, 2008 by Geoff Lane

One of the more difficult things to manage in software projects is often changing a database schema over time. On the projects that I work on, we don’t usually have DBAs who manage the schema so it is left up … Continue reading →

Posted in .NET, Automation, Code | Tagged , , | 4 Comments

Using SQL Compact Edition Under ASP.NET

Posted on January 17, 2007 by Geoff Lane

What is SQLCE? SQL Compact Edition is the “low end” version of a SQL database solution from Microsoft. It is a single-file, application managed, database implementation. It doesn’t have all of the bells and whistles of the high end database … Continue reading →

Posted in .NET, Web | Tagged , , | 1 Comment

Fake Materialized Views

Posted on November 27, 2006 by Geoff Lane

In a previous post, I discussed materialized views in Oracle. I wanted to share a relatively simple technique that can be used to create similar functionality in Oracle or another database. Why Use Something Else? Materialized Views are a feature … Continue reading →

Posted in Code | Tagged , , | 1 Comment

Oracle Materialized Views

Posted on October 29, 2006 by Geoff Lane

So the existence of Materialized Views might not be news to the Oracle DBAs around the world, but I present topics from the perspective of a software developer. As software developers we often have to use databases with our applications. … Continue reading →

Posted in Code | Tagged , , , | 2 Comments

Hibernate HQL And Performance

Posted on August 23, 2006 by Geoff Lane

The Hibernate ORM tool give you the ability to write SQL-esque queries using HQL to do custom joining, filtering, etc. to pull Objects from your database. The documentation gives you a lot of examples of the things you can do, … Continue reading →

Posted in Code, Java | Tagged , , , , | 14 Comments