https://pinboard.in/u:mcroydon/public/ recent bookmarks from mcroydon 2025-01-19T20:19:30+00:00 https://avi.im/blag/2024/sqlite-past-present-future/ mcroydon sqlite databases algorithms performance https://pinboard.in/ https://pinboard.in/u:mcroydon/b:5d6618f9de32/ 2025-01-11T15:19:10+00:00 https://www.cs.cmu.edu/~pavlo/blog/2025/01/2024-databases-retrospective.html mcroydon links review databases tech history code database programming https://pinboard.in/ https://pinboard.in/u:mcroydon/b:d45560da8800/ 2025-01-11T15:14:53+00:00 https://benjamincongdon.me/blog/2021/08/17/B-Trees-More-Than-I-Thought-Id-Want-to-Know/ mcroydondatastructure data-structures datastructures computerscience databases storage algorithms tutorial database programming https://pinboard.in/ https://pinboard.in/u:mcroydon/b:c27db45b1e75/ 2020-06-30T19:30:03+00:00 https://blog.twitter.com/engineering/en_us/topics/infrastructure/2019/metricsdb.html mcroydonmetric devops db databases database https://pinboard.in/ https://pinboard.in/u:mcroydon/b:997af1167b07/ 2016-02-22T15:03:14+00:00 http://static.googleusercontent.com/media/research.google.com/en//pubs/archive/43287.pdf mcroydonunread papers databases graph database https://pinboard.in/ https://pinboard.in/u:mcroydon/b:60a5f909f436/ 2011-09-23T15:49:55+00:00 http://lwn.net/Articles/452307/ mcroydon bigdata data databases mapreduce https://pinboard.in/ https://pinboard.in/u:mcroydon/b:3b48c1f06a8c/ 2011-09-23T14:51:03+00:00 http://www.nicollet.net/2011/08/coping-with-inconsistent-databases/ mcroydonconsistency databases db nosql https://pinboard.in/ https://pinboard.in/u:mcroydon/b:14b04eaa2911/ 2011-01-24T07:27:48+00:00 http://mattfleming.com/node/192 mcroydon database databases datastructures optimization https://pinboard.in/ https://pinboard.in/u:mcroydon/b:3f57194e0a0e/ 2010-10-24T19:03:52+00:00 http://it.toolbox.com/blogs/database-soup/5-minutes-to-binary-replication-41873?rss=1 mcroydon database databases documentation howto infrastructure sysadmin replication reference postgresql postgres https://pinboard.in/u:mcroydon/b:6e636016009a/ 2010-09-21T15:30:53+00:00 http://membase.org/ mcroydon apache architecture bigtable cache caching cluster database development db datastructures databases distributed facebook key-value keyvalue memcache kvs scalability programming opensource memcached nosql scaling software storage sql webdesign webdev zynga https://pinboard.in/u:mcroydon/b:7cf438897a13/ 2010-09-21T15:15:18+00:00 http://www.subbu.org/articles/nuts-and-bolts-of-transaction-processing mcroydon architecture articles cart checkout databases database local java ecommerce development design processing programming transaction transactions networking transaction-processing mechanisms global jta acid 2pc https://pinboard.in/u:mcroydon/b:ce82d6ac9370/ 2010-06-11T14:59:54+00:00 http://apgdiff.sourceforge.net/ mcroydon admin configuration_management database databases db java free evolution differences diff development dba management oss migration postgres postgresql tools tool sql schema programming dbms.postgresql https://pinboard.in/u:mcroydon/b:eb51377c0bd2/ 2010-05-13T02:19:45+00:00 http://www.rackspacecloud.com/blog/2010/05/12/cassandra-by-example/ mcroydon articles cassandra rackspace python database relational tutorial databases db twitter web example examples webdev webdevelopment hackernews howto nosql programming https://pinboard.in/u:mcroydon/b:3391e2507681/ 2010-04-24T12:44:03+00:00 http://www.slideshare.net/kevinweil/nosql-at-twitter-nosql-eu-2010 mcroydon analytics architecture cassandra cloud databases database db grid hbase nosql hadoop presentation pig programming read twitter slideshare slides scribe scaling scalability flockdb yam https://pinboard.in/u:mcroydon/b:76d5e8e8cb7b/ 2010-03-26T20:45:37+00:00 http://stu.mp/2010/03/nosql-vs-rdbms-let-the-flames-begin.html mcroydon cost data database databases decisions domain ec2 sql scaling rdbms performance nosql mysql make experience simplegeo https://pinboard.in/u:mcroydon/b:2df228a9e859/ 2010-03-19T09:42:45+00:00 http://pl.atyp.us/wordpress/?p=2521 mcroydon algorithms architecture article availability concurrency cap consistency partition distributed nosql development databases database data consistent performance scalability theorem https://pinboard.in/u:mcroydon/b:16c104e04f35/ 2010-03-15T12:22:22+00:00 http://www.mikeperham.com/2010/03/13/cassandra-internals-writing/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+mikeperham+(Mike+Perham)&utm_content=Google+Reader mcroydon cassandra databases db development key-value nosql performance https://pinboard.in/u:mcroydon/b:e01c25a102d2/ 2010-03-14T19:32:08+00:00 http://blog.nahurst.com/visual-guide-to-nosql-systems mcroydon blogs database databases db guide hbase nosql visualization sql https://pinboard.in/u:mcroydon/b:bce419ae6c6d/ 2010-03-09T16:24:52+00:00 http://blog.boxedice.com/2010/02/28/notes-from-a-production-mongodb-deployment/ mcroydon 2read architecture couchdb database databases datacenter linux experience distributed development deployment db mongo mongodb mysql notes nosql performance production software sharding server scalability replication programming sysadmin to_read tips web https://pinboard.in/u:mcroydon/b:f6df6d3ee339/ 2010-03-07T23:53:17+00:00 http://www.larsgeorge.com/2009/10/hbase-architecture-101-storage.html mcroydon arch architecture article bigtable blog data database important hbase hadoop good distributed design databases info kvstore nosql performance reference storage toread https://pinboard.in/u:mcroydon/b:045e4064507c/ 2010-03-07T23:51:43+00:00 https://www.cloudkick.com/blog/2010/mar/02/4_months_with_cassandra/ mcroydon admin via:jacobian administration architecture article cassandra database databases opensource nosql mysql monitoring django distributed db datawarehouse python scalability scaling storage toread webdev programming cloudkick neat https://pinboard.in/u:mcroydon/b:4dc8a5bbe860/ 2010-02-17T13:43:44+00:00 http://www.paperplanes.de/2010/2/16/a_collection_of_redis_use_cases.html mcroydon examples programming reference keyvalue redis code user samples case database ruby webdev server cool architecture databases db list ideas tutorials example nosql usecases https://pinboard.in/u:mcroydon/b:e94e05362991/ 2010-02-09T02:31:21+00:00 http://highscalability.com/blog/2010/2/8/how-farmville-scales-to-harvest-75-million-players-a-month.html mcroydon opensource scalability games database web performance cool architecture scaling coding databases db rest memcached php review facebook puppet munin memcache webdevelopment gamedev farmville zynga https://pinboard.in/u:mcroydon/b:4531b654760c/ 2010-02-05T13:18:13+00:00 http://hmarr.com/2010/feb/04/introducing-mongoengine/ mcroydon dev django python db databases mongodb nosql libs orm mongoengine https://pinboard.in/u:mcroydon/b:ccd6caa145f1/ 2010-01-18T15:07:46+00:00 http://practicalcloudcomputing.com/post/313922691/5-steps-simpledb-performance mcroydon howto scalability performance aws startup databases cloud db cloudcomputing migration nosql simpledb load scalable https://pinboard.in/u:mcroydon/b:b43157e3c89b/ 2010-01-11T17:59:37+00:00 http://www.depesz.com/index.php/2010/01/08/waiting-for-8-5-hot-standby/ mcroydon databases scaling postgresql read https://pinboard.in/u:mcroydon/b:3ecf60f9779c/ 2009-12-28T14:40:37+00:00 http://asserttrue.blogspot.com/2009/12/nosql-required-reading.html mcroydon programming database reference development toread webdev scalability blog architecture distributed databases scaling todo cloud db resources paper sql couchdb reading to-read papers nosql read bigtable scale links collection to_read readlater https://pinboard.in/u:mcroydon/b:377fd6f7be34/ 2009-11-02T13:57:23+00:00 http://open.blogs.nytimes.com/2009/10/29/first-5000-tags-released-to-the-linked-data-cloud/ mcroydon data database journalism news api media internet open databases cloud awesome rdf nytimes nyt semanticweb freebase tags mashups archives linkeddata semantic.web https://pinboard.in/u:mcroydon/b:b689232fbc2b/ 2009-10-27T13:11:11+00:00 http://www.luciddb.org/ mcroydon programming software development database data business opensource java scalability storage distributed cluster databases sql db datamining olap columndb bi datawarehouse dbms reporting rdbms luciddb column warehousing column-store data_warehouse column-oriented dwh https://pinboard.in/u:mcroydon/b:3ad82aec0321/ 2009-10-25T20:25:57+00:00 http://esw.w3.org/topic/LargeTripleStores mcroydon programming web software data reference database tools scalability storage wiki performance db databases list store benchmark rdf metadata semantic semanticweb ontology semweb sparql triplestore owl large sesame triple https://pinboard.in/u:mcroydon/b:edba450fcf17/ 2009-10-25T20:24:18+00:00 http://www.franz.com/agraph/allegrograph/ mcroydon web linux database amazon storage aws databases graph ec2 db download rdf store semantic semanticweb semweb ontology semantic-web triplestore datastore web3.0 sparql allegrograph graphdb allegro https://pinboard.in/u:mcroydon/b:0be44a42462a/ 2009-10-25T20:19:30+00:00 http://techportal.ibuildings.com/2009/09/07/graphs-in-the-database-sql-meets-social-networks/ mcroydon programming code database toread webdev howto tutorial blog network algorithms performance article social databases postgresql graph mysql linkedin datastructures socialnetworking webdevelopment networks facebook sql db php graphs socialnetworks https://pinboard.in/u:mcroydon/b:941f0e4ca21c/ 2009-10-22T15:16:09+00:00 http://simonwillison.net/2009/Oct/22/redis/ mcroydon python programming data storage database dev distributed article databases cache db memcached caching articles convert cli nosql experiments redis schemaless repl https://pinboard.in/u:mcroydon/b:6040d89061ac/ 2009-10-15T01:58:37+00:00 http://bobby-tables.com/ mcroydon programming development database webdev howto computer rails hack security coding hacks fun databases geek hacking mysql tips sql db .net bugs c# injection tables sqlinjection sql-injection https://pinboard.in/u:mcroydon/b:118ff15a5b36/ 2009-10-08T21:10:19+00:00 http://www.engineyard.com/blog/2009/mongodb-a-light-in-the-darkness-key-value-stores-part-5/ mcroydon database toread tutorial ruby erlang rails scalability databases inspiration db hash document bigtable key-value keyvalue nosql key mongodb engineyard mongo irb https://pinboard.in/u:mcroydon/b:90251e7034be/ 2009-10-08T21:08:11+00:00 http://riak.basho.com/ mcroydon programming web development key-value database webdev opensource erlang storage scalability distributed rest databases http mapreduce json db couchdb store kvstore datastore keyvalue nosql document cloudcomputing riak decentralized basho documentoriented key-value-store https://pinboard.in/u:mcroydon/b:dbe6bca299bb/ 2009-09-12T12:34:34+00:00 http://blog.digg.com/?p=966 mcroydon programming development data database toread blog storage scalability architecture performance distributed scaling article databases mysql cloud sql keystore nosql cassandra acm keyvalue key-value bigtable production advice digg to-read deployment https://pinboard.in/u:mcroydon/b:d0f28376710b/ 2009-09-12T12:31:35+00:00 http://code.google.com/p/python-sqlparse/ mcroydon python programming django software linux code tools database presentation opensource library databases sql module parsing parser parse pretty formatting googlecode format sparql komodo sqlparse https://pinboard.in/u:mcroydon/b:78e3ded5792a/ 2009-08-08T14:13:59+00:00 http://blog.gtuhl.com/2009/08/07/postgresql-tips-and-tricks/ mcroydon postgresql databases list tips postgres https://pinboard.in/u:mcroydon/b:3edb6ccc282d/ 2009-08-03T16:40:00+00:00 http://4store.org/ mcroydon programming web software open-source development data database opensource scalability storage databases gpl rdf store db c semantic semanticweb repository ontology semweb semantic-web triplestore sparql garlik 4store triple-store rdfstore triple websemantique https://pinboard.in/u:mcroydon/b:dd6896dad8de/ 2009-07-27T15:39:58+00:00 http://db.cs.yale.edu/hadoopdb/hadoopdb.html mcroydon programming software development database java opensource research scalability distributed performance scaling hadoop cluster postgresql databases mysql hadoopdb map-reduce hive dbms rdbms 2009 analytics postgres db sql mapreduce yale vldb https://pinboard.in/u:mcroydon/b:0ca3fea1098f/ 2009-07-07T15:26:37+00:00 http://queue.acm.org/detail.cfm?id=1563874 mcroydon storage algorithm postgresql databases compsci scale big data acm https://pinboard.in/u:mcroydon/b:3288cca7df44/ 2009-07-02T19:14:57+00:00 http://thinkvitamin.com/dev/should-you-go-beyond-relational-databases/ mcroydon programming development web data reference database toread technology opensource dev scalability storage work hadoop article graph databases mysql nosql keyvalue bigtable rdbms resource reading couchdb comparison db mapreduce relational alternative https://pinboard.in/u:mcroydon/b:cc6b14ac1ac2/ 2009-07-02T16:58:09+00:00 http://blog.oskarsson.nu/2009/06/nosql-debrief.html mcroydon software nosql kvstore mongodb dynomite video database scalability storage architecture distributed scaling hadoop presentation mysql databases db sql slides couchdb conference videos bigtable hbase trends keyvalue key-value cassandra voldemort hypertable https://pinboard.in/u:mcroydon/b:57ded9f1cfa1/ 2009-06-18T20:10:27+00:00 http://well-formed-data.net/archives/306/dbcounter-quick-visual-database-stats mcroydon database tech visualization databases nodebox https://pinboard.in/u:mcroydon/b:43b65aa731db/ 2009-06-15T14:46:24+00:00 http://highscalability.com/neo4j-graph-database-kicks-buttox mcroydon data database toread visualization java opensource network scalability cool architecture performance graph hadoop databases db graphs 2009 arch socialnetworking socialmedia dataviz neo4j graph_database graph-database relationship https://pinboard.in/u:mcroydon/b:fdc3f94ce3f3/ 2009-06-06T09:28:51+00:00 http://blog.marcua.net/post/117671929/mit-database-systems-6-830-ta-course-notes mcroydon programming reference data database tutorial toread blog education free computing databases learning cs mapreduce sql db notes academic mit course lectures lecture courses class rdbms bigtable systems 6.830 10 ta https://pinboard.in/u:mcroydon/b:7a2d7c812759/ 2009-05-01T13:15:56+00:00 http://www.facebook.com/note.php?note_id=76191543919 mcroydon development data reference webdev server scalability tech storage architecture scaling performance photo image databases photos pictures computerscience haystack softwareengineering nfs scale images facebook https://pinboard.in/u:mcroydon/b:2896ee9e21b2/ 2009-04-23T15:37:14+00:00 http://blog.freebase.com/2008/04/09/a-brief-tour-of-graphd/ mcroydon software programming data database server storage architecture distributed performance article databases graph hadoop db store benchmarks rdf semantic freebase semanticweb metaweb ontology semweb graphd tuplespace triplestore tuple datastructures tuples implementation https://pinboard.in/u:mcroydon/b:b77908e3ccb3/ 2009-04-21T14:16:48+00:00 http://randomfoo.net/2009/04/20/some-notes-on-distributed-key-stores mcroydon data database blog scalability storage distributed scaling databases ec2 mysql cloud dht hash key-value rdbms tokyocabinet keyvalue cassandra tokyotyrant voldemort keystore https://pinboard.in/u:mcroydon/b:8a5849f3e580/ 2009-03-11T21:31:35+00:00 http://www.metabrew.com/article/anti-rdbms-a-list-of-distributed-key-value-stores/ mcroydon programming development data database erlang scalability storage architecture distributed performance databases mysql memcached list comparison cloud scalaris keyvalue rdbms hbase dynamo key-value bigtable dht simpledb couchdb db store voldemort hypertable https://pinboard.in/u:mcroydon/b:4856bb177cb8/ 2009-03-01T17:21:58+00:00 http://opensource.plurk.com/LightCloud/ mcroydon python database opensource storage scalability cool scaling distributed performance databases memcached lua components cloud oss db hashing cloudcomputing dht key-value tokyocabinet dictionary dynamo tokyo-tyrant tokyo-cabinet keyvalue dist lightcloud plurk tokyotyrant https://pinboard.in/u:mcroydon/b:830ac47cf581/ 2009-02-27T22:25:59+00:00 http://bret.appspot.com/entry/how-friendfeed-uses-mysql mcroydon python programming design web software development data database howto blog scalability storage architecture scaling performance databases mysql article json sql couchdb db index schema sharding friendfeed rdbms schemaless schema-less blob https://pinboard.in/u:mcroydon/b:95b489ad7fc4/ 2009-02-27T22:04:28+00:00 http://blog.directededge.com/2009/02/27/on-building-a-stupidly-fast-graph-database/ mcroydon programming design database visualization blog research algorithms scalability algorithm performance scaling coding engineering graph databases cs graphs recommendations memory scale mathematics datamining db hashing concurrency notes https://pinboard.in/u:mcroydon/b:e3e1b4cc7cc8/ 2009-02-27T21:00:37+00:00 http://code.google.com/p/redis/ mcroydon programming data google code database opensource hacking storage scalability performance databases cache memcached caching c memcache db memory key key-value persistence redis value kvs https://pinboard.in/u:mcroydon/b:677c06e66176/ 2009-02-14T10:31:36+00:00 http://www.omninerd.com/articles/Automating_Data_Visualization_with_Ruby_and_Graphviz mcroydon programming data howto tutorial ruby visualization rails graphics network statistics math charts chart graph databases graphs tutorials article datamining reporting visualisation diagram networks graphviz scripts graphing data-visualization dot datavisualization erp https://pinboard.in/u:mcroydon/b:dccfbc2665fa/ 2009-02-11T19:39:44+00:00 http://wiki.apache.org/solr/DataImportHandler mcroydon programming data java search database databases mysql lucene sql solr indexing find db query import rdbms https://pinboard.in/u:mcroydon/b:7aafdc5b6079/ 2009-01-20T15:51:00+00:00 http://code.google.com/p/scalaris/ mcroydon programming development google code database erlang scalability java storage opensource architecture scaling cluster framework distributed clustering replication db dht store p2p cloud caching hash grid cache databases scalaris paxos key-value https://pinboard.in/u:mcroydon/b:e337f7407475/ 2009-01-16T15:29:09+00:00 http://push.cx/2009/rules-of-database-app-aging mcroydon programming web development database webdev databases dev process https://pinboard.in/u:mcroydon/b:6897dddf1c1c/ 2009-01-16T03:41:37+00:00 http://push.cx/2009/washington-post-update mcroydon web django data journalism visualization mashup databases webapps washingtonpost https://pinboard.in/u:mcroydon/b:d9bae0414373/ 2008-10-27T18:43:26+00:00 http://www.commandprompt.com/products/mammothreplicator/ mcroydon design development database sysadmin scalability cluster postgresql distributed performance clustering chart databases postgres backup sql irc high-availability db commercial replication distributed-computing https://pinboard.in/u:mcroydon/b:342fb89d19c3/ 2008-10-15T04:23:58+00:00 http://open.blogs.nytimes.com/2008/10/14/announcing-the-new-york-times-campaign-finance-api/ mcroydon web data journalism database api mashup newspapers databases politics election finance elections money nytimes nyt webservices mashups campaignfinance campaign https://pinboard.in/u:mcroydon/b:3d84a4427de2/ 2008-10-11T20:47:38+00:00 http://jonathangardner.net/tech/w/PostgreSQL/Materialized_Views mcroydon programming code howto database tutorial books wiki postgresql databases postgres article sql dbms views materialized materializedviews view https://pinboard.in/u:mcroydon/b:b3119d6372ad/ 2008-10-03T12:18:49+00:00 http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html mcroydon programming database tools scalability management performance mysql databases optimization sql test debugging db profiler profile query debug https://pinboard.in/u:mcroydon/b:ebf50d08ee2c/ 2008-09-15T16:43:28+00:00 http://dataferrett.census.gov/ mcroydon software data reference database server tools research math search online census market db datamining tool government databases statistics demographics datasets population genealogy gov resource ferrett https://pinboard.in/u:mcroydon/b:a32651f2b242/ 2008-08-26T11:38:09+00:00 http://www.scribd.com/doc/2592098/DVPmysqlucFederation-at-Flickr-Doing-Billions-of-Queries-Per-Day mcroydon shard sharded programming database sysadmin architecture presentation scalability scaling flickr performance mysql databases optimization sharding federation shards ops https://pinboard.in/u:mcroydon/b:e5fe6d6985a9/ 2008-08-21T17:31:27+00:00 http://developer.amazonwebservices.com/connect/entry.jspa?externalID=1663&categoryID=100 mcroydon reference database howto toread tutorial amazon sysadmin storage s3 aws scalability computing ec2 databases mysql webhosting cloud article tutorials cloudcomputing ebs xfs webservices https://pinboard.in/u:mcroydon/b:4c68ab5bf59f/ 2008-04-23T10:32:33+00:00 http://www.igvita.com/2008/04/22/mysql-conf-memcached-internals/ mcroydon architecture cache caching database databases development infrastructure memcached optimization performance presentation scalability scaling https://pinboard.in/u:mcroydon/b:e93a64fb6996/ 2008-04-20T04:13:56+00:00 http://en.wikipedia.org/wiki/Column-oriented_DBMS mcroydon algorithm compsci computer science computer-science data database databases development fast interesting performance programming reference software sql storage toread wiki wikipedia @toread https://pinboard.in/u:mcroydon/b:f6325140e6af/ 2008-03-24T01:42:07+00:00 http://www.fedspending.org/ mcroydon data database databases economy federal finance funding government marketing innovation money politics https://pinboard.in/u:mcroydon/b:71a379c61159/