Activity tagged “database”
OMGWTFBBQ!? This looks incredible.
Geographic routing algorithms on top of PostGIS.
Graph database built on top of Tokyo Cabinet. Young, but has an un-fucked-up (BSD) license.
A great Cassandra success story from Digg (76 billion columns, 3 TB, sub-second updates). I'm looking forward to the opportunity to use Cassandra myself.
A proper couchdb backend for Django. This would be a good place to start for anyone wanting to write non-relational backends for Django.
It's decisions like this that make me confident and happy about my choice of PostgreSQL. I can barely wait for hot standby to land, but features are worthless if they're not stable. Maintainers willing to make tough cuts like this one are what makes quality software.
We were just discussing the easiest way to do this at LPDN last night.
Comparing MySQL 4, MySQL 5, and Postgres 8. Don't pay too much attention to the numbers, but notice the shape of the graphs. MySQL does worse after about 7-10 concurrent queries, but Postgres gets the same throughput at 10 concurrent requests as it does at 100.
A look at one app's AWS architecture. Nginx, HAProxy, Rails, pgpool II, PostgreSQL, and RabbitMQ. I didn't realize that pgpool II did sharding at the balancer layer; that makes this kind of set up much easier.
This is just nuts: something stamped final should not be this full of fail. Monty's got a great roundup of what went wrong, and as you might expect it's the classic case of letting suits and marketing schedules run software release. I thought Open Source was supposed to put the power back in the hands of the technocrats…
Read Apache logs into a sqlite database.
Andrew's implementation of a “denormalized field” for Django. There's a bit I don't get about the implementation — factory functions? really? — but this is a Good Idea and ought to only get better.
The schema evolution in Django space is really heating up. With luck we can keep the competition friendly, and pull out a best-of-breed solution to roll back into Django.
PostgreSQL 8.3 config values, documented and annotated.
Finally a good guide to tuning Postgres straight from the source.
Another database migration tool. This one's not Django-specific (though it will work with Django), but it is PostgreSQL specific. I'm really quite happy with the competition in this space right now; it'll force any eventually Django built-in migration to
Eric explores how MVCC actually works in Postgres. Good stuff; I'd vaguly understood this before reading the post, but now I think I really get what's going on.
New in Google Spreadsheets: publish a web form which submits data into your spreadsheet. This is completely brilliant. I can see this being incredibly useful. Yet another reason never to use Excel again.
Matt explains how he and Christian brought election results to ten sites in under two days. I'm blown away by how awesome their coverage was, and with how quickly they pulled it together. Congrats!
Wow. This might actually be a good move for MySQL, but it certainly puts Sun's support of PostgreSQL in jepordy, which is a shame.
SimpleDB is out. And it's built on top of Erlang. Awesome.
Google Docs Help Center - How can I use spreadsheets to answer some of my many questions about the world?
This, truly, is a frequently asked question. I can't tell you how many times I've wished that my spreadsheet could tell me Roger Clemens' ERA. (Seriously, for a moment: this is amazingly cool.)
Mah head asplode.
“Bucardo is an asynchronous Postgres replication system, allowing for both multi-master and multi-slave operations.” Whoa.
Info about Postgres' stats collector and associated views. I just discovered the pg_stat_user_tables and pg_stat_user_indexes views which are amazingly helpful.
Pretty amazing technique: use ZFS to allow read/write against WAL-shipped warm standby PostgreSQL databases. ZFS FTW!
Diff two PG schemas. Very cool.
A paper comparing different DBMSes for Erlang.
Greg Mullane's complete talk on optimizing postgresql. Looks like a few things have changed since 2003 (7.3 —> 8.2), but this still seems *very* relevant.
Low-level database connectors for MySQL. Essentially you get to use a relational database without SQL. Could be very interesting when combined with an ORM.
“…observes your every interaction with app … then creates a personal shoebox of all the web pages you visit, emails you read, documents you write and much more.”
I missed it when it happened, but Oracle now offers .debs for download. Schweet.
A kick-ass look at how to extend Django's lookup API with custom methods. This one adds fulltext search in a particularly nifty way.
Mentioned in passing: “craigslist tends to have 200% growth yearly both in posting and reading.” Wow.
“Complete batting and pitching statistics from 1871-2005. Plus fielding statistics, standings, team stats, managerial records, post-season data, and more.”
Really awesome database of airports, airlines, flights, etc — 37 million flight records!
Using the Jet engine (MS Access) from Python on Windows
Some good tips on organizing DB schema updates. I'd like Django's schema evolution framework to work something like this.