Aaron Parecki

#database

• PostgreSQL when it is not your job (reinout.vanrees.org)

  Wed, Jun 6, 2012 10:17am -07:00 #database #db #postgres #servers #sysadmin #tips
• Well-known text (en.wikipedia.org)

  Sat, Mar 3, 2012 3:35pm -08:00 #database #geo #geography #postgis #wkt
• PostGIS Geography Type (postgis.refractions.net)

  Sat, Mar 3, 2012 3:35pm -08:00 #database #geo #geography #postgis
• MySQL/Galera is synchronous multi-master cluster for MySQL/InnoDB database (codership.com)

  Mon, Feb 20, 2012 7:58am -08:00 #database #multi-master #mysql #replication
• Hybrid Incremental MySQL Backups (www.facebook.com)

  Tue, Apr 5, 2011 12:49pm -07:00 #database #facebook #infrastructure #mysql #scaling #systems
• What's the best manner of implementing a social activity stream? (stackoverflow.com)

  Tue, Apr 5, 2011 12:41pm -07:00 #activity stream #architecture #database #feed #scaling #system #timeline
• Sagging Couch - PHP Library for CouchDB (www.saggingcouch.com)

  Thu, Mar 3, 2011 3:17am -08:00 #couchdb #database #library #nosql #php #resources
• Code: Flickr Developer Blog » Ticket Servers: Distributed Unique Primary Keys on the Cheap (code.flickr.com)

  Mon, Oct 11, 2010 11:46pm -07:00 #architecture #database #flickr #mysql #performance #scaling
• MySQL :: MySQL 5.1 Reference Manual :: 5.1.6 Server Status Variables (dev.mysql.com)

  Fri, Oct 8, 2010 11:40am -07:00 #database #mysql #performance
• InformIT: Optimizing and Tuning Your MySQL Database > MySQL Startup Options (www.informit.com)

  Fri, Oct 8, 2010 11:07am -07:00 #database #linux #mysql #performance #sysadmin #tuning
• Maatkit documentation: a toolkit of utilities and tools for MySQL (www.maatkit.org)

  Mon, Oct 4, 2010 11:54pm -07:00 #database #mysql #optimization #performance
• High Scalability - High Scalability - Scaling Digg and Other Web Applications (highscalability.com)

  Mon, Oct 4, 2010 10:57pm -07:00 #application #architecture #database #development #mysql #programming #scalability #scaling
• Matasano Security LLC - Chargen - Enough With The Rainbow Tables: What You Need To Know About Secure Password Schemes (chargen.matasano.com)

  Fri, Sep 10, 2010 8:57am -07:00 #algorithm #authentication #crypto #cryptography #database #encryption #hash #md5 #password #php #security #web
• Quora - Why does Quora use MySQL as the data store rather than NoSQLs such as Cassandra, MongoDB, CouchDB, etc? (www.quora.com)

  Wed, Jun 30, 2010 12:28pm -07:00 #database #development #facebook #mysql #nosql #scalability

• Sorting a query in MySQL ignoring the word "The"

  When you have a database of books or movies, some of the titles begin with "The." If you do a regular ORDER BY on the table, all the titles that start with "the" get clumped together. One option is running an unsorted query and sorting in PHP, but it would be better to sort at the database level. Here is a query I came up with to do that, using an IF function in MySQL!

  continue reading...

  Sat, Apr 19, 2008 9:50pm -07:00 #code #database #MySQL #sorting #SQL