https://pinboard.in/u:sunpig/public/ recent bookmarks from sunpig 2015-03-16T07:57:30+00:00 https://www.simple-talk.com/sql/t-sql-programming/contiguous-time-periods/ sunpig tsql sql time period temporal table db database https://pinboard.in/ https://pinboard.in/u:sunpig/b:e758b1cc5308/ 2015-03-16T07:56:14+00:00 https://www.simple-talk.com/sql/database-administration/how-to-get-database-design-horribly-wrong/ sunpig db design database failure patterns https://pinboard.in/ https://pinboard.in/u:sunpig/b:5cd9fa8c26ad/ 2014-11-17T19:32:57+00:00 http://www.pg-versus-ms.com/ sunpig database databases postgres postgresql sqlserver https://pinboard.in/ https://pinboard.in/u:sunpig/b:71ae62803b30/ 2014-09-25T05:50:08+00:00 http://www.garysieling.com/blog/auditing-data-changes-postgres sunpig postgresql security audit trail table db database pg pgsql sql trigger hstore https://pinboard.in/ https://pinboard.in/u:sunpig/b:1f67c152bf60/ 2014-09-17T15:50:16+00:00 http://robots.thoughtbot.com/postgres-window-functions sunpig database postgres postgresql sql window function rank https://pinboard.in/ https://pinboard.in/u:sunpig/b:89b75ed89084/ 2014-09-17T15:47:45+00:00 https://periscope.io/blog/beyond-random-normal-distributions-in-sql.html sunpig database development random sql statistics normal distribution algorithm marsagnia polar transformation https://pinboard.in/ https://pinboard.in/u:sunpig/b:119578afbeec/ 2014-05-31T14:50:49+00:00 http://www.salsify.com/blog/eager-loading-calculations-database-views-in-rails sunpig dev rails ruby activerecord database view readonly model calculation optimization https://pinboard.in/ https://pinboard.in/u:sunpig/b:7f210457fd48/ 2014-03-20T08:27:20+00:00 http://blog.lostpropertyhq.com/postgres-full-text-search-is-good-enough/ sunpig postgres postgresql sql full text search index db database performance https://pinboard.in/ https://pinboard.in/u:sunpig/b:2415b0ad870d/ 2014-02-06T10:22:42+00:00 http://sqlfiddle.com/ sunpigcode database programming sql tools https://pinboard.in/ https://pinboard.in/u:sunpig/b:fb40a8757fb9/ 2014-01-15T14:26:09+00:00 http://astonj.com/tech/how-to-recover-or-reset-a-lost-postgresql-password/ sunpigpostgres postgresql sql database password reset user https://pinboard.in/ https://pinboard.in/u:sunpig/b:c8bf1e3ed6d7/ 2013-11-11T22:03:59+00:00 http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/ sunpig database databases design schema mongo mongodb json relational social relation cache https://pinboard.in/ https://pinboard.in/u:sunpig/b:c01e428c59b0/ 2013-10-18T08:48:43+00:00 http://scraplab.net/using-geoplanet-data-in-ruby-on-rails/ sunpiggeoplanet yahoo ruby rails import database data load etl index performance sql geo https://pinboard.in/ https://pinboard.in/u:sunpig/b:4b48e58eda06/ 2013-06-06T11:00:16+00:00 http://www.salsify.com/blog/easy-eager-loading-with-database-views/1252 sunpig database rails views materialized db postgres postgresql eager load performance sql https://pinboard.in/ https://pinboard.in/u:sunpig/b:eea639dabc22/ 2013-06-05T12:30:46+00:00 http://www.craigkerstiens.com/2013/05/30/a-collection-of-indexing-tips/ sunpig database postgresql postgres tips index indexing https://pinboard.in/ https://pinboard.in/u:sunpig/b:8be118df8498/ 2013-06-05T12:25:03+00:00 http://blog.endpoint.com/2013/06/postgresql-as-nosql-with-data-validation.html sunpig database javascript json nosql postgres validation index document https://pinboard.in/ https://pinboard.in/u:sunpig/b:7233e405328a/ 2013-05-20T14:16:42+00:00 http://aphyr.com/tags/jepsen sunpigcap database db partition network distributed architecture aphyr jepsen carly rae call me maybe https://pinboard.in/ https://pinboard.in/u:sunpig/b:bea3cfc11f0d/ 2013-05-10T09:35:14+00:00 http://adamsanderson.github.io/railsconf_2013/ sunpigconference postgres postgresql rails activerecord hstore array type data database db https://pinboard.in/ https://pinboard.in/u:sunpig/b:036ff5b2e81a/ 2013-05-10T09:26:18+00:00 http://nathanmlong.com/2013/05/better-single-table-inheritance/ sunpig sti single table inheritance rails ruby database design oo https://pinboard.in/ https://pinboard.in/u:sunpig/b:27a21094325b/ 2012-10-04T17:14:41+00:00 http://www.rollcallapp.com/blog/2011/10/03/adding-multi-tenancy-to-your-rails-app-acts-as-tenant sunpig multitenant db database rails tenancy user postgres pg pgsql schema multiple ruby library select activerecord strategy https://pinboard.in/ https://pinboard.in/u:sunpig/b:79e50b2f5c20/ 2012-10-04T17:13:43+00:00 http://blog.jerodsanto.net/2011/07/building-multi-tenant-rails-apps-with-postgresql-schemas/ sunpig multitenant db database rails tenancy user postgres pg pgsql schema multiple ruby library select activerecord strategy https://pinboard.in/ https://pinboard.in/u:sunpig/b:44dac5dec0a8/ 2012-09-25T10:26:10+00:00 http://highscalability.com/blog/2012/9/24/google-spanners-most-surprising-revelation-nosql-is-out-and.html sunpig database db google spanner nosql sql bigtable megastore data transaction row lock performance bottleneck https://pinboard.in/ https://pinboard.in/u:sunpig/b:6499af0ebce2/ 2012-09-13T10:30:14+00:00 http://wpb2d.com/ sunpigwordpress dropbox backup automated plugin dump sql database https://pinboard.in/ https://pinboard.in/u:sunpig/b:22eddd6338d8/ 2012-04-27T06:54:08+00:00 http://speakerdeck.com/u/jeg2/p/10-things-you-didnt-know-rails-could-do sunpigrails tricks fun database helpers ruby tips presentation shortcut slides https://pinboard.in/ https://pinboard.in/u:sunpig/b:db3b4fe33f9b/ 2012-02-13T23:05:29+00:00 http://www.movabletype.org/documentation/administrator/managing-users/changing-password.html sunpigmovabletype mt password reset database mysql https://pinboard.in/ https://pinboard.in/u:sunpig/b:44b2c6e12466/ 2012-02-01T18:11:03+00:00 http://www.allthingsdistributed.com/2012/01/amazon-dynamodb.html sunpigamazon dynamo dynamodb db database nosql scale aws service https://pinboard.in/ https://pinboard.in/u:sunpig/b:5bf75818b4bd/ 2011-11-28T08:11:18+00:00 http://www.simple-talk.com/sql/database-administration/7-preventable-backup-errors/? sunpigbackup sqlserver sql database problem failure prevent security safety recovery prevention dba https://pinboard.in/ https://pinboard.in/u:sunpig/b:0d79ddf1d3c3/ 2011-06-05T20:33:35+00:00 https://willj.net/2011/05/31/setting-up-postgresql-for-ruby-on-rails-development-on-os-x/?utm_source=rubyweekly&utm_medium=email sunpigpostgres postgresql osx rails mac ruby database install homebrew brew launch configure tutorial https://pinboard.in/ https://pinboard.in/u:sunpig/b:e9011e557dfe/ 2011-04-27T09:08:00+00:00 http://status.heroku.com/incident/151 sunpig heroku amazon aws cloud infrastructure service response recovery outage ebs ec2 storage database https://twitter.com/ https://pinboard.in/u:sunpig/b:6b4a21c743c9/ 2011-04-04T07:51:55+00:00 http://www.simple-talk.com/sql/sql-tools/the-unnecessary-evil-of-the-shared-development-database/?utm_source=simpletalk&utm_medium=email-main&utm_content=SharedDevTroy-20110404&utm_campaign=SQL sunpigsimpletalk sql mssql development practice dev code software programming database db vcs dvcs version control developer productivity local shared https://pinboard.in/ https://pinboard.in/u:sunpig/b:08b457417f05/ 2011-03-24T08:32:16+00:00 http://engineering.foursquare.com/2011/03/22/building-a-recommendation-engine-foursquare-style/ sunpigfoursquare recommendation engine data performance engineering database geo collaborative filter algorithm cluster hadoop https://pinboard.in/ https://pinboard.in/u:sunpig/b:138e2526fc1b/ 2011-03-14T15:07:41+00:00 http://railspikes.com/2008/9/22/is-your-rails-application-safe-from-mass-assignment sunpigruby rails assignment attr_accessible security update_attributes vulnerability database params https://pinboard.in/ https://pinboard.in/u:sunpig/b:604244cb4ecb/ 2011-03-08T20:53:16+00:00 http://pinboard.in/blog/173/ sunpig maciej pinboard delicious architecture performance web mysql database query char varchar slave replication hardware hosting flood https://pinboard.in/ https://pinboard.in/u:sunpig/b:c2cf7cda8347/ 2011-02-21T13:43:50+00:00 http://www.simple-talk.com/sql/t-sql-programming/look-up-tables-in-sql-/?utm_source=simpletalk&utm_medium=email-main&utm_content=LookUp-20110221&utm_campaign=SQL sunpigjoecelko lookup table sql database db design attribute property name https://pinboard.in/ https://pinboard.in/u:sunpig/b:aac799206014/ 2011-02-02T16:16:19+00:00 http://www.kitebird.com/articles/ruby-dbi.html sunpigdatabase programming ruby tutorial dbi dbd access open close connect select db sql https://pinboard.in/ https://pinboard.in/u:sunpig/b:56b212bae013/ 2010-10-03T15:48:14+00:00 http://www.eaipatterns.com/ramblings/18_starbucks.html sunpig starbucks coffee pattern programming transaction commit twophase database messaging acid atomicity consistency failure tolerance fault development architecture https://pinboard.in/ https://pinboard.in/u:sunpig/b:f6d7e917c74b/ 2010-08-18T21:51:13+00:00 http://www.html5rocks.com/tutorials/offline/whats-offline/ sunpightml offline html5 web database storage localstorage sessionstorage browser https://pinboard.in/ https://pinboard.in/u:sunpig/b:44c3f6f82754/ 2010-07-23T15:14:57+00:00 http://facility9.com/2010/01/05/or-ms-panacea-or-polio-braces sunpigorm data database dataaccess sql tsql sqlserver rails ruby activerecord programming oodb object class set https://pinboard.in/ https://pinboard.in/u:sunpig/b:6dad04020182/ 2010-06-20T20:28:03+00:00 http://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/ sunpignames programming schema form database characters rules falsehoods culture localization l10n https://pinboard.in/ https://pinboard.in/u:sunpig/b:07e9f75c9086/ 2010-06-17T21:37:02+00:00 http://www.vineetgupta.com/2010/01/nosql-databases-part-1-landscape.html sunpigvineetgupta nosql voldemort redis cassandra sql scalability database datastore survey overview summary comparison db data https://pinboard.in/ https://pinboard.in/u:sunpig/b:f0e327bf56dc/ 2010-03-29T15:50:19+00:00 http://www.iamcal.com/issue-tracking/#comment1188 sunpig bugtracking issuetracking bug issue database track trouble ticket standard https://pinboard.in/ https://pinboard.in/u:sunpig/b:00d7a77333f0/ 2010-03-27T08:44:32+00:00 http://stu.mp/2010/03/nosql-vs-rdbms-let-the-flames-begin.html sunpig joestump nosql sql database scale performance operational cost mysql https://pinboard.in/ https://pinboard.in/u:sunpig/b:69b4efd77b31/ 2010-03-02T22:46:37+00:00 http://www.yafla.com/dforbes/Getting_Real_about_NoSQL_and_the_SQL_Isnt_Scalable_Lie/ sunpigdennisforbes sql nosql database data relational scalability myth size performance needs itdepends https://pinboard.in/ https://pinboard.in/u:sunpig/b:b3068187874e/ 2010-02-18T05:51:16+00:00 http://everythingmysql.ning.com/profiles/blogs/whats-faster-than-repair sunpigmysql table repair database restore time duration long corruption crash data https://pinboard.in/ https://pinboard.in/u:sunpig/b:0584c62243d6/ 2010-02-09T20:08:03+00:00 http://ai.mee.nu/seeking_a_database_that_doesnt_suck sunpigdatabase db storage data sql nosql mysql postgres redis voldemort couchdb https://pinboard.in/ https://pinboard.in/u:sunpig/b:89a93a6ed357/ 2009-12-13T20:49:57+00:00 http://code.openark.org/blog/mysql/useful-temporal-functions-queries sunpigmysql query sql time date tips database development programming https://pinboard.in/u:sunpig/b:2925e91f45c2/ 2009-08-19T16:21:59+00:00 http://www.xaprb.com/blog/2009/08/18/how-to-find-un-indexed-queries-in-mysql-without-using-the-log/ sunpigmysql performance index database optimization query tcpdump sql log https://pinboard.in/u:sunpig/b:b50cf9410471/ 2009-03-08T21:09:13+00:00 http://www.jurriaanpersyn.com/archives/2009/02/12/database-sharding-at-netlog-with-mysql-and-php/ sunpigperformance data php mysql scale database db availability scaling sharding shard jurriaanpersyn netlog partition https://pinboard.in/u:sunpig/b:37fafcc5e607/ 2009-01-22T21:00:08+00:00 http://devpicayune.com/pycon2008/django_admin.html sunpigpython howto database project admin django webdev quick https://pinboard.in/u:sunpig/b:85f592ea219f/ 2009-01-07T16:50:35+00:00 http://www.37signals.com/svn/posts/1509-mr-moore-gets-to-punt-on-sharding sunpigperformance optimization web space mysql scale database 37signals db memory scaling sharding shard migration geeknotes https://pinboard.in/u:sunpig/b:6831a7cf1832/ 2008-05-20T09:54:49+00:00 http://www.tbray.org/ongoing/When/200x/2008/04/24/Inflection sunpigtimbray ongoing inflection evolution rapid programming language database processor speed https://pinboard.in/u:sunpig/b:b95b3190d244/ 2008-01-22T09:47:14+00:00 http://www.acmqueue.com/modules.php?name=Content&pa=showpage&pid=388 sunpigamazon acm scalability interview wernervogels jimgray soa database business software architecture design https://pinboard.in/u:sunpig/b:e808f1d5e1ee/ 2007-12-14T21:52:18+00:00 http://radar.oreilly.com/archives/2007/12/amazon_launches.html sunpigamazon simpledb data storage cloud application hosted machine database aws web service https://pinboard.in/u:sunpig/b:28d66d26f9da/ 2007-01-11T12:15:40+00:00 http://www.techinterviews.com/?p=161 sunpigsqlserver database db dba interview questions sql work tech job https://pinboard.in/u:sunpig/b:99245c0162f8/ 2006-12-09T21:28:06+00:00 http://scottonwriting.net/sowblog/posts/10592.aspx sunpigscottmitchell sql sqlserver datetime month db database https://pinboard.in/u:sunpig/b:a27a2fc7c111/ 2006-10-16T22:22:42+00:00 http://www.simple-talk.com/opinion/opinion-pieces/bad-carma/ sunpigdatabase application development oracle sql data design code horror programming omfg https://pinboard.in/u:sunpig/b:482aa91b3382/ 2006-05-24T22:56:10+00:00 https://www.red-gate.com/products/SQL_Prompt/index.htm sunpigsb sql sqlserver intellisense redgate autocomplete plugin development database tool https://pinboard.in/u:sunpig/b:ff832cc29aa1/ 2006-04-28T10:44:59+00:00 http://www.4guysfromrolla.com/webtech/042606-1.shtml sunpigsb sql sqlserver sp storedprocedure paging page database procedure optimization sort order https://pinboard.in/u:sunpig/b:bc86565345ea/ 2006-04-18T11:42:10+00:00 http://geekswithblogs.net/joelross/archive/2006/03/23/73180.aspx sunpigsb aspnet asp.net .net viewstate server database c# https://pinboard.in/u:sunpig/b:0cdbe6b495f1/ 2005-11-12T23:52:32+00:00 http://acmqueue.com/modules.php?name=Content&pa=showpage&pid=337&page=1 sunpigweb database xml schema format http text protocol https://pinboard.in/u:sunpig/b:ed691295be54/ 2004-11-01T23:24:42+00:00 http://ryanfarley.com/blog/archive/2004/10/25/1127.aspx sunpigadobe database microsoft pdf sql sqlserver https://pinboard.in/u:sunpig/b:68dcd1d8243c/ 2004-10-07T11:40:22+00:00 http://www.codeproject.com/aspnet/PagingLarge.asp sunpigasp.net code database performance techie https://pinboard.in/u:sunpig/b:b163b8231570/