FSM-enabled key-value store

I'm not even sure exactly what keyvi is, except something very wonderful. If I understand correctly, it finds strings in a fuzzy manner. I should really look at it more closely.

Boilerplate-free REST API for arbitrary databases, in Python: sandman

Now this is software engineering, folks. SQLAlchemy for database introspection, flask for the API provision, and voila, a database editor in ten lines.

Excision

Datomic is a kind of neat database that I haven't really looked into. The upshot is that it tracks changes in data over time; when a fact is added, it remembers when it was added, so you can restore your state of knowledge at a given point in time.

There are requirements, though (e.g. privacy laws) that require information to be removed outright - that you forget you ever knew it in the first place - and this is excision.

TokuDB

TokuDB apparently scales MySQL/MariaDB instances by improving indexing?

Indexing in PostgreSQL

Some tips and tricks.

DataNitro: Python from Excel

Neat little article using DataNitro to link SQL databases to Excel.  Neat.

Postgres

A couple of excellent slideshows about Postgres and its Django bindings that are really pretty convincing - brief, but that's because they're slideshows.

NoSQL pondering

This guy seems to have some good thoughts about databases.  I should probably read more of him.

DevJoist

Looks like DevJoist is some kind of source version control system for database work.  Very interesting indeed, and deserving of some thought when I get a minute.

IMAP architectural patterns

Here's an interesting concept in terms of architectural patterns: synchronization between multiple IMAP servers with OfflineIMAP.  Again, yeah, structural database application, yadda yadda.

Hmm. Zapier to move data between dozens of Web apps.

OLAP and MDX

I've been poking around looking at techniques for database design, because every actual application I go to design these days essentially starts with a database.  (More on this later.)  (Well, and previously, of course.)

But while looking at these things, I ran across the concept of OLAP (online analytical processing), which is essentially based on the concept of keeping a matrix of figures of high dimensionality available for fast ad-hoc querying.  The query language usually used is MDX.  (MultiDimensional eXpressions.)

I don't have much specifically to say about this, just wanted to note that OLAP exists but is apparently entirely dominated by big players.  Which is interesting.  Is it because only the big players can market successfully to the corporate buyer most interested in OLAP, or because OLAP just isn't that interesting to the open-source world?  (I find the latter improbable, so maybe there's a market for low-price OLAP.)

Interesting database designer

Build your database using Excel-like tables. Online.

LINQ

So I looked up LINQ, and it turns out it's just a better interface for query manipulation.  Kind of like Data::Table::Lazy.  But it's got drivers for everything in the world.  So it's worth reading about.

RethinkDB

A new, presumably rethought, database.  Decentral, and NoSQL.

Forking data

Heroku has a neat new feature: data forks of PostgreSQL databases.  The advantage: you think less in terms of database servers and more in terms of the data.

That's a good insight.

"World countries" database

Here's a neat little idea, a Web service that generates MySQL code to create and load a list of countries according to fresh data.

This could be generalized to another data-dictionary kind of gallery.  Think about that!

Using Dropbox as a database

Cool idea: use JSON files on Dropbox for database storage.  Built into Opa (a server-and-client JavaScript language that I've noted before).

The Prime Pages

Model this.  It's a database of information about prime numbers.  Way Web 2.0 before that was even a concept (founded 1990-freaking-4, before even I got into online databases...)

PostgreSQL and Redis

PostgreSQL can talk to anything.  Like Redis.

Dbpatterns.com

Dbpatterns.com is a neat gallery/forking site for database patterns - it seems a little thin (you don't seem to be able to download patterns in a machine-readable form, for example), but the site itself is on Github and the idea is groovy.

Take that and make it machine-readable in a schema description format that can be composed and used to output SQL and man, I love it.