https://pinboard.in/u:mcroydon/public/ recent bookmarks from mcroydon 2025-06-15T14:42:19+00:00 https://techcommunity.microsoft.com/blog/adforpostgresql/announcing-a-new-ide-for-postgresql-in-vs-code-from-microsoft/4414648 mcroydon ide microsoft sql db postgresql https://pinboard.in/ https://pinboard.in/u:mcroydon/b:3ef8750e227c/ 2022-03-08T14:36:49+00:00 http://www.textbook.ds100.org/intro.html mcroydon database data-science sql https://pinboard.in/ https://pinboard.in/u:mcroydon/b:a35fdf00e3eb/ 2022-03-08T14:35:37+00:00 https://www.essentialsql.com/database-normalization/ mcroydon sql database normalization https://pinboard.in/ https://pinboard.in/u:mcroydon/b:8284936a73de/ 2020-06-30T19:30:29+00:00 https://blog.jupyter.org/a-jupyter-kernel-for-sqlite-9549c5dcf551 mcroydonsqlite sql python https://pinboard.in/ https://pinboard.in/u:mcroydon/b:291120b05043/ 2019-02-21T17:13:22+00:00 https://explain.depesz.com/ mcroydonpostgres sql postgresql database https://pinboard.in/ https://pinboard.in/u:mcroydon/b:6118505c06f5/ 2015-01-20T19:33:48+00:00 http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html mcroydon sqlite sql optimization performance database https://pinboard.in/ https://pinboard.in/u:mcroydon/b:00f49bc078ec/ 2014-12-09T15:23:24+00:00 https://www.periscope.io/ mcroydon sql analytics visualization database data https://pinboard.in/ https://pinboard.in/u:mcroydon/b:cfa5d14209a4/ 2013-12-10T15:16:43+00:00 http://probcomp.csail.mit.edu/bayesdb/ mcroydon bayes bayesian database sql statistics https://pinboard.in/ https://pinboard.in/u:mcroydon/b:de5f425ccf42/ 2012-10-04T14:12:07+00:00 http://highscalability.com/blog/2012/9/24/google-spanners-most-surprising-revelation-nosql-is-out-and.html mcroydon database google nosql sql spanner https://pinboard.in/ https://pinboard.in/u:mcroydon/b:67adf6a89334/ 2012-02-16T12:38:25+00:00 https://github.com/bakks/virginian mcroydon GPU performance database SQL https://pinboard.in/ https://pinboard.in/u:mcroydon/b:6dee6fc68748/ 2011-09-22T16:52:44+00:00 http://use-the-index-luke.com/sql/preface mcroydon database development optimization index sql https://pinboard.in/ https://pinboard.in/u:mcroydon/b:d079d3e908be/ 2010-12-20T07:07:59+00:00 http://forms.basho.com/basho-riak-schema-design-and-the-transition-from-2ns/ mcroydon riak nosql sql data migration https://pinboard.in/ https://pinboard.in/u:mcroydon/b:661735773636/ 2010-11-15T16:23:09+00:00 http://archives.postgresql.org/pgsql-sql/2002-04/msg00318.php mcroydoncomputer database db dbs deployment development optimization performance postgres postgresql reference sql tuning pgsql https://pinboard.in/u:mcroydon/b:3f03ffe264ee/ 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-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-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-25T14:49:00+00:00 http://spyced.blogspot.com/2010/03/cassandra-in-action.html mcroydon cassandra cloudkick database db digg hadoop example read programming nosql mysql lucene kvs key-value hbase reddit scalability scaling sql storage toread twitter https://pinboard.in/u:mcroydon/b:478c0e37cf79/ 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/ 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-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: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-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-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-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-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-23T17:05:39+00:00 http://www.facebook.com/note.php?note_id=89508453919 mcroydon design data database blog java map scalability storage distributed computing scaling article hadoop sql mapreduce db reading facebook analytics rdbms arch comment hive datawarehouse warehouse data-warehousing hdfs dw https://pinboard.in/u:mcroydon/b:276f269e387f/ 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-06-01T18:56:42+00:00 http://www.cloudera.com/hadoop-sqoop mcroydon scalability hadoop rdbms sql cloudera https://pinboard.in/u:mcroydon/b:901a02037733/ 2009-05-19T01:10:35+00:00 http://www.continuent.com/community/sequoia mcroydon database java performance cluster postgresql mysql clustering sql tool db replication ha jdbc highavailability https://pinboard.in/u:mcroydon/b:93e8a5e81dba/ 2009-05-01T13:16:45+00:00 http://www.greenplum.com/ mcroydon programming software development data database business technology opensource storage scalability performance cluster postgresql startup open postgres sql mapreduce datamining db analytics oss reporting rdbms intelligence bi businessintelligence datawarehouse greenplum bizgres https://pinboard.in/u:mcroydon/b:97d792e18079/ 2009-04-16T21:10:32+00:00 http://www.davidcramer.net/code/448/cleaning-up-with-json-and-sql.html mcroydon django python database json sql schema forms field https://pinboard.in/u:mcroydon/b:9c5f1fefcbae/ 2009-03-12T04:37:41+00:00 http://code.google.com/p/touchcode/ mcroydon programming mobile development code apple mac library osx dev api xml opensource framework iphone source json ipod sql macosx cocoa touch sdk repository sqlite objc objectivec objective-c touchcode iphonedev iphone_dev license:mit https://pinboard.in/u:mcroydon/b:73f60bd6bb5f/ 2009-03-03T18:07:34+00:00 http://developer.symbian.com/wiki/display/pub/Wikipedia+v1.0+(Symbian+SQL+Demo) mcroydon symbian sql wikipedia sqlite https://pinboard.in/u:mcroydon/b:72e37c1f9372/ 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-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-02T03:53:55+00:00 http://www.mysqlperformanceblog.com/2008/12/22/high-performance-click-analysis-with-mysql/ mcroydon design web data database blog statistics storage scalability analysis scaling performance stats mysql optimization hadoop sql tracking ad article analytics datamining english reporting db sharding seo warehouse click lesen realtime datawarehouse https://pinboard.in/u:mcroydon/b:40b28d85e491/ 2009-01-02T03:49:22+00:00 http://github.com/robhudson/django-debug-toolbar/tree/master mcroydon python programming django web development tools webdev dev work opensource http sql app apps debugging tool djangocon middleware profiling contrib debug toolbar header https://pinboard.in/u:mcroydon/b:5f9d57c02e9b/ 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-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-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-04-01T11:51:08+00:00 http://www.allaboutsymbian.com/news/item/7004_Symbian_adds_SQL_and_Location_.php mcroydon symbian sql sqlite data database mobile https://pinboard.in/u:mcroydon/b:9751d194eddb/ 2008-02-09T04:22:26+00:00 http://pgfouine.projects.postgresql.org/ mcroydon analysis analytics apache benchmark database databases debian development monitor optimization performance postgres quality postgresql scalability server software sysadmin sql system tools https://pinboard.in/u:mcroydon/b:f5d5cdb3c668/ 2007-12-31T05:03:11+00:00 http://code.google.com/p/django-mptt/ mcroydon algorithms code cs database django model python sql tree https://pinboard.in/u:mcroydon/b:64d3d6a66dd2/ 2007-12-29T15:41:49+00:00 http://diveintomark.org/archives/2007/12/28/receipts mcroydon funny system tech sql paperwork https://pinboard.in/u:mcroydon/b:345eca9b8f7e/ 2007-12-23T03:59:01+00:00 http://511.ksdot.org/kanroadpublic/qryrpt/allrpt_pub.asp?sCDRS=to_char(alert_insert_dt,'MM/DD/YYYY%20HH:MI%20AM')%20as%20cdrsdt%20from%20cdrs_alert_route%20order%20by%20beg_lrs_route,%20BEG_STATE_LOGMILE&sRCRS=road_cond_time%20as%20rctime,%20gis_county.county_number,%20gis_county.county_name%20from%20rcrs_roads,%20gis_county%20where%20road_condition%20%3C%3E%201%20and%20road_condition%20%3C%3E%202%20and%20rcrs_roads.county_no%20=%20gis_county.county_number%20order%20by%20rcrs_roads.route_id,%20rcrs_roads.BEG_STATE_LOGMILE&ShowMetric=0&RiderRoute=1&uCondition=1&uRouteCDRS=&uCountyCDRS=&uDistrictCDRS=&uRegionCDRS=&uAreaCDRS=&fulltext=This%20report%20is%20for:%20entire%20State,%20along%20All%20Routes mcroydon kansas sql injection attack https://pinboard.in/u:mcroydon/b:386fc410d2f8/ 2007-10-10T12:18:36+00:00 http://xkcd.com/327/ mcroydon comics database databases sql injection https://pinboard.in/u:mcroydon/b:f0aafd627226/ 2007-08-30T07:41:32+00:00 http://errtheblog.com/post/10722 mcroydon ruby sql erlang mnesia database https://pinboard.in/u:mcroydon/b:c2903f5f48d4/ 2007-07-09T21:24:01+00:00 http://www.postgresqlformac.com/ mcroydon apple computers database databases development mac macintosh postgres osx postgresql software sql tools https://pinboard.in/u:mcroydon/b:abe393f198eb/ 2007-06-25T13:29:31+00:00 http://www.25hoursaday.com/weblog/2007/06/25/GoogleScalabilityConferenceTripReportMapReduceBigTableAndOtherDistributedSystemAbstractionsForHandlingLargeDatasets.aspx mcroydon algorithms architecture coding database design development google scalability scaling software sql https://pinboard.in/u:mcroydon/b:3eff9484217a/ 2007-03-18T17:32:57+00:00 http://ferruh.mavituna.com/makale/sql-injection-cheatsheet/ mcroydon sql database injection attack hack hacking intrusion https://pinboard.in/u:mcroydon/b:f2840749b3d1/ 2007-02-26T00:54:16+00:00 http://postgis.refractions.net/support/wiki/index.php?ExamplesJoinTables mcroydon sql geo geowanking geolocation postgres postgresql postgis https://pinboard.in/u:mcroydon/b:3e6b6f12ec3d/ 2006-12-25T20:00:41+00:00 http://enfranchisedmind.com/blog/archive/2006/11/04/166 mcroydon database databases development partition postgres postgresql sql tables https://pinboard.in/u:mcroydon/b:2d81c254d7ac/ 2006-12-23T01:00:29+00:00 http://linuxboxadmin.com/articles/postgresql-for-mysql-users.php mcroydon database mysql postgresql server sql https://pinboard.in/u:mcroydon/b:d46812ae9987/ 2006-12-22T15:03:52+00:00 http://urbanmainframe.com/folders/blog/20050125/ mcroydon mysql sql wordpress https://pinboard.in/u:mcroydon/b:9b9cccf664b3/ 2006-11-18T22:34:39+00:00 http://codist.biit.com/fiche/thecodist/article/write-your-own-database-again-an-interview-with-the-author-of-h2-thomas-mueller mcroydon java database sql https://pinboard.in/u:mcroydon/b:09893e06724f/ 2006-03-30T13:11:03+00:00 http://www.vsj.co.uk/articles/display.asp?id=540 mcroydon algorithms code database sql https://pinboard.in/u:mcroydon/b:706874b61d1f/ 2006-01-26T15:28:40+00:00 http://www.unixwiz.net/techtips/sql-injection.html mcroydon sql security development https://pinboard.in/u:mcroydon/b:d807915cc1bb/