Jacob Kaplan-Moss
Activity tagged “database”
Bookmarks
HTSQL — a database query language for the accidental programmer
OMGWTFBBQ!? This looks incredible.
pgRouting
Geographic routing algorithms on top of PostGIS.
stevedekorte's vertexdb at master - GitHub
Graph database built on top of Tokyo Cabinet. Young, but has an un-fucked-up (BSD) license.
Digg the Blog » Blog Archive » Looking to the future with Cassandra
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.
42's 42-django-couchdb at master - GitHub
A proper couchdb backend for Django. This would be a good place to start for anyone wanting to write non-relational backends for Django.
What happened to Hot Standby?
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.
Feeding the Cloud: Finding the size of a Postgres database on disk
We were just discussing the easiest way to do this at LPDN last night.
Database test: dual Intel Xeon 5160 (6/6) | Tweakers.net
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.
Amazon Web Services Blog: 100% on Amazon Web Services: Soocial.com
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.
Monty says: Oops, we did it again (MySQL 5.1 released as GA with crashing bugs)
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…
Steve.org.uk - asql - Apache SQL querying
Read Apache logs into a sqlite database.
Aeracode :: Denormalisation Follies
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.
Simon Willison: Announcing dmigrations
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.
44_annotated_gucs_draft1.pdf (application/pdf Object)
PostgreSQL 8.3 config values, documented and annotated.
Tuning Your PostgreSQL Server - PostgreSQL Wiki
Finally a good guide to tuning Postgres straight from the source.
pgmigrate - Google Code
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
Understanding PSQL's MVCC | One More Blog
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.
Official Google Docs Blog: Stop sharing spreadsheets, start collecting information
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.
Covering Kansas Democratic Caucus Results at Matt Croydon::Postneo
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!
Sun acquires MySQL
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.
inside looking out » What You Need To Know About Amazon SimpleDB
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.)
about:cmlenz - CouchDB “Joins”
Mah head asplode.
Bucardo - multi-master replication for Postgres
“Bucardo is an asynchronous Postgres replication system, allowing for both multi-master and multi-slave operations.” Whoa.
PostgreSQL: Documentation: Manuals: PostgreSQL 8.2: The Statistics Collector
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.
PostgreSQL warm standby on ZFS crack - Esoteric Curio
Pretty amazing technique: use ZFS to allow read/write against WAL-shipped warm standby PostgreSQL databases. ZFS FTW!
Another PostgreSQL Diff Tool - Welcome to Another PostgreSQL Diff Tool
Diff two PG schemas. Very cool.
Evaluation of Database Management Systems for Erlang
A paper comparing different DBMSes for Erlang.
Efficient SQL
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.
Connectors for the NdbApi in Launchpad
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.
Onlife
“…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.”
Oracle Database 10g Express Edition Downloads for Linux x86
I missed it when it happened, but Oracle now offers .debs for download. Schweet.
Extending Django's database API to include full-text search (Mercurytide)
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.
O'Reilly Radar > Database War Stories #5: craigslist
Mentioned in passing: “craigslist tends to have 200% growth yearly both in posting and reading.” Wow.
Download Database Version 5
“Complete batting and pitching statistics from 1871-2005. Plus fielding statistics, standings, team stats, managerial records, post-season data, and more.”
FlightStats: Home
Really awesome database of airports, airlines, flights, etc — 37 million flight records!
Python and Microsoft Access
Using the Jet engine (MS Access) from Python on Windows
Varlena, LLC | PostgreSQL General Bits Newsletter
Some good tips on organizing DB schema updates. I'd like Django's schema evolution framework to work something like this.