Jacob Kaplan-Moss

56 items tagged โ€œdatabaseโ€

๐Ÿ“Œ Deskthority wiki #
๐Ÿ“Œ NVD - Data Feeds #
๐Ÿ“Œ Quartz/bad-data-guide

โ€œAn exhaustive reference to problems seen in real-world data along with suggestions on how to resolve them.โ€ #

๐Ÿ“Œ Titan

Holy crap a graph database with a license that means I can actually use it! #

๐Ÿ“Œ Django snippets: Server Side Cursors for Django's psycopg2 Backend

We should add this to Django. #

๐Ÿ“Œ 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. #

๐Ÿ“Œ Replication, Clustering, and Connection Pooling - PostgreSQL Wiki

Nice high-level comparison of the various PostgreSQL replication, clustering, load balancing, and connection pooling solutions. #

๐Ÿ“Œ 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. #

๐Ÿ“Œ IP address geolocation SQL database | Share your knowledge!

Finally, a free GeoIP database. #

๐Ÿ“Œ 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. #

๐Ÿ“Œ Dabble DB Blog: Giving Dabble DB a time machine #
๐Ÿ“Œ 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! #

๐Ÿ“Œ How Rackspace Now Uses MapReduce and Hadoop to Query Terabytes of Data | High Scalability #
๐Ÿ“Œ 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. #