Author: Ben Taylor

Editorials

Optimizing Data Transformations

AutoMap is a Dot Net library used to transform data model objects to and from data transfer objects. It uses a fluent syntax, helping you manage your data conversion efficiently. Personally, I don’t find it any more efficient that rolling your own transformation methods. However, the standardized way in which it is implemented, and the widespread use of this library […]

Editorials

SqLite and Dot net

Today I was working with an application where I create a SqLite database for an embedded device. I’ve been using the System.Data.SqLite package started on SourceForge years ago. It provides dot net device drivers for SqLite, implementing the Ado.Net interfaces, allowing me to work with a database using traditional Ado.Net code. The library also supports Entity Framework, should you need […]

Editorials

What’s In A Name?

I’ve had the pleasure (great deal of sarcasm intended) of recently working with a legacy system where the database objects are limited to 8 or less characters. Table names are often numbered. Column names use some abbreviations in an effort to provide the illuminated with some meaning. To work with these databases a person requires a special decoder ring to […]

Editorials

What Do I Need To Know?

I’ve been thinking about what would be the most essential skills when working with relational databases. I’d probably break it down into two key capabilities, when it comes to developing performant code. I’d start with a good understanding of relational design. It’s important to know the different forms of normalization, and understand when it is best to apply the more […]

Editorials

Closing the Loop on Locking

When optimizing an OLTP database, one of the key performance issues is to isolate the writes from the reads. We’ve been talking about using Immutable data as a way to keep reads from blocking writes, by reading without locks, etc. Today I want to talk about another method that works rather well. Even if you use database locking, and have […]

More Immutability
Editorials

More Immutability

Lots of comments were made regarding immutable of data in a database. Everything prompts me to think further on the topic, as well as provide some clarification. AZ Jim’s comment compares immutable data to that of slowing changing dimensions or facts in a data warehouse. While this is very similar in concept to immutable data, the intention is not exactly […]

Immutable Data
Editorials

Immutable Data

Is there such a thing as immutable data in a relational database? Immutable data is not a term usually applied to a database, it is more of an Object oriented term. Immutable objects are those objects where he values (properties) of an object may not be modified after it is instantiated. The properties may only be set through construction. Once […]

LinqJs
Editorials

LinqJs

Today I was introduced to a library new to me that has been out there for more than 6 years. LinqJs is a library bringing Linq styled syntax to the JavaScript world. At the core, what Linq does for you is to remove all of the iteration logic from your visible code so that the things that you are intending […]