January 2, 2013 
0 Comments
While this example is very basic, it does provide the basic considerations for determining how to shard a given database application. By using this evaluation approach, you can determine if sharding is applicable to your particular environment, and what benefits can be realized by implementing Database Sharding.
(Full Story: Database Sharding)
June 25, 2012 0 Comments
Redis, Neo4J, CouchDB, MongoDB, HBase, Riak, and Postgres: with each database, you’ll tackle a real-world data problem that highlights the concepts and features that make it shine. You’ll explore the five data models employed by these databases: relational, key/value, columnar, document, and graph. See which kinds of problems are best suited to each, and when to use them.
(Full Story: Seven Databases in Seven Weeks – The Pragmatic Bookshelf)
June 25, 2012 0 Comments
Data is just data, after all. Induction supports PostgreSQL, MySQL, SQLite, Redis, and MongoDB out-of-the-box, and has an extensible architecture that makes it easy to write adapters for anything else you can think of. CouchDB? Oracle? Facebook Graph? Excel? Make it so!
(Full Story: Induction – A Polyglot Database Client For Mac OS X)
June 22, 2012 0 Comments
The D2RQ Platform is a system for accessing relational databases as virtual, read-only RDF graphs. It offers RDF-based access to the content of relational databases without having to replicate it into an RDF store. Using D2RQ you can:
- query a non-RDF database using SPARQL
- access the content of the database as Linked Data over the Web
- create custom dumps of the database in RDF formats for loading into an RDF store
- access information in a non-RDF database using the Apache Jena API
(Full Story: The D2RQ Platform – Accessing Relational Databases as Virtual RDF Graphs)
January 12, 2012 0 Comments
You never develop code without version control, why do you develop your database without it? Flyway is database-independent library for tracking, managing and applying database changes.
(Full Story: Flyaway – a java database migration tool)
July 31, 2011 0 Comments
Point 1: NoSQL technologies require more investment than Relational to get going with.
Point 2: There is no particular advantage to NoSQL until you reach scales that require it. In fact it is the opposite, given Point 1.
Point 3: If you are fortunate enough to need the scaling, you will have the time to migrate to NoSQL and it isn’t that expensive or painful to do so when the time comes.
(Full Story: NoSQL is a Premature Optimization)
May 17, 2011 0 Comments
visualizations for data structures and algorithms
(Full Story: Data Structure Visualization)
March 15, 2011 0 Comments
(Full Story: Tips for Tuning MySQL)
February 23, 2011 0 Comments
Base is an application for creating, designing, editing and browsing SQLite 3 database files. It’s a proper Mac OS X application. Fast to launch, quick to get in to and get the data you need.
(Full Story: Base – OSX tool for SQLite)
