Understanding how different database internals work is incredibly helpful. Different explanations make it easier to understand how your favorite database works. Plus, you never know when you'll have to work with a different database.
- Jeremiah Peschka
Hadi Hariri brings up an important point - withNoSQL databases we can't afford to be ignorant of the underlying implementation. Barring syntactical differences, one OLTP database is largely the same as any other. With NoSQL databases we cannot take any feature for granted. We need to understand how our data is being stored, how to access it, and what goes on under the covers.
- Jeremiah Peschka
VisualEyes is web-based authoring tool developed at the University of Virginia to weave images, maps, charts, video and data into highly interactive and compelling dynamic visualizations. Yup, we can now create interactive presentations that let people explore data in a variety of ways. Cool stuff.
- Jeremiah Peschka
Some of the inner workings of PostgreSQL make it difficult to implement index only scans. Robert Haas details the changes that need to be made in PostgreSQL to make this possible.
- Jeremiah Peschka
All data isn't created equal. Robert Haas writes about potential new features for PostgreSQL that will enable additional concurrency as well as existing features that make it possible to get higher transactional throughput.
- Jeremiah Peschka
sometimes OS X is like a visit to crazy town... population: you. Specifically when you're dealing with the internals of launchctl and launchd
- Jeremiah Peschka
It's tough to find good use cases for new things, especially when you're reading the documentation. Here are 10 common use cases for Hadoop.
- Jeremiah Peschka
Adrian Cockcroft has posed a set of standard questions for each NoSQL database vendor. These are the answers supplied by Basho about Riak.
- Jeremiah Peschka
Mladen Prajdic demonstrates how it's possible to restore a single table from a backup without using a vendor tool. Admittedly, this is a pretty dirty hack, but it's interesting to dig around in SQL Server at this level.
- Jeremiah Peschka
Ever wonder when you might want to use the RandomPartioner vs the OrderPreservingPartitioner and what kind over problems they solve/cause?
- Jeremiah Peschka