https://pinboard.in/u:michaelfox/public/ recent bookmarks from michaelfox 2020-01-31T14:45:39+00:00 https://about.gitlab.com/handbook/business-ops/data-team/sql-style-guide/ michaelfox styleguide sql bestpractices .proj:styleguide https://pinboard.in/ https://pinboard.in/u:michaelfox/b:eb5845975484/ 2020-01-31T14:44:47+00:00 http://bytepawn.com/how-i-write-sql-code.html#how-i-write-sql-code michaelfox styleguide sql bestpractices .proj:styleguide https://pinboard.in/ https://pinboard.in/u:michaelfox/b:88acc61ffeb2/ 2020-01-30T15:33:13+00:00 https://dbdiagram.io/home michaelfox database db data visualization schema documentation generator tools planning diagram sql https://pinboard.in/ https://pinboard.in/u:michaelfox/b:57470f5787dd/ 2020-01-30T15:31:00+00:00 https://schemaexplorer.io/ michaelfox database db data documentation generator visualization sql schema https://pinboard.in/ https://pinboard.in/u:michaelfox/b:e3a8d343c7a4/ 2019-08-19T03:18:34+00:00 https://severalnines.com/database-blog/my-favorite-postgresql-queries-and-why-they-matter michaelfox postgres sql db snippets https://pinboard.in/ https://pinboard.in/u:michaelfox/b:aa19676fa43c/ 2019-05-20T16:49:20+00:00 https://mode.com/help/articles/use-your-data-with-the-mode-playbook/#database-notes michaelfox modeanalytics db sql reference https://pinboard.in/ https://pinboard.in/u:michaelfox/b:7524cc7d0b42/ 2019-05-09T19:17:26+00:00 http://kvz.io/blog/2009/03/04/sql-formatting/ michaelfox styleguide sql https://pinboard.in/ https://pinboard.in/u:michaelfox/b:ec62c2ee48a6/ 2019-04-26T01:08:11+00:00 http://www.postgresqltutorial.com/postgresql-window-function/ michaelfox postgres sql query https://pinboard.in/ https://pinboard.in/u:michaelfox/b:19f294d7624e/ 2019-02-13T14:52:44+00:00 https://github.com/joereynolds/sql-lint michaelfox setup tools lint validation sql format convert https://pinboard.in/ https://pinboard.in/u:michaelfox/b:871d49529e6b/ 2019-01-11T17:23:26+00:00 https://tapoueh.org/blog/2017/06/how-to-write-sql/ michaelfox sql db database styleguide bestpractices .proj:styleguide https://pinboard.in/ https://pinboard.in/u:michaelfox/b:1475c049a7e7/ 2018-11-18T04:20:07+00:00 https://www.xaprb.com/blog/2006/04/26/sql-coding-standards/ michaelfox sql mysql database bestpractices styleguide .proj:styleguide .todo https://pinboard.in/ https://pinboard.in/u:michaelfox/b:57c69222a9c3/ 2018-11-02T14:08:43+00:00 https://databricks.com/blog/2018/11/01/sql-pivot-converting-rows-to-columns.html michaelfox mysql sql data database query https://pinboard.in/ https://pinboard.in/u:michaelfox/b:de38148a26a3/ 2018-10-09T14:03:02+00:00 https://github.com/nilportugues/php-sql-query-formatter michaelfox mysql php database sql parser string format convert .proj:logsphp https://pinboard.in/ https://pinboard.in/u:michaelfox/b:f1f016c760b7/ 2018-10-09T14:02:59+00:00 https://github.com/Adrian0350/SimplePDOWrapper michaelfox mysql php database sql parser string format convert .proj:logs https://pinboard.in/ https://pinboard.in/u:michaelfox/b:2c5ab74c6ab6/ 2018-10-09T14:02:56+00:00 https://github.com/IncrementaCRM/SimplePDOWrapper michaelfox mysql php database sql parser string format convert .proj:logs https://pinboard.in/ https://pinboard.in/u:michaelfox/b:81c6842ad0a6/ 2018-10-09T14:02:52+00:00 https://github.com/phpmyadmin/sql-parser michaelfox mysql php database sql parser string format convert .proj:logs https://pinboard.in/ https://pinboard.in/u:michaelfox/b:55cacae9ce0c/ 2018-08-27T13:36:25+00:00 https://gitlab.com/gitlab-org/gitlab-ce/blob/f8c4dc97230c520df077c1274fd8d88680da5242/doc/development/migration_style_guide.md michaelfox migrations styleguide .proj:styleguide database sql https://pinboard.in/ https://pinboard.in/u:michaelfox/b:e890c525b1c0/ 2018-06-19T18:20:11+00:00 https://github.com/HVF/franchise michaelfox code sql db databases notes notebook dev tools data analysis scratch editor query chart visualization https://pinboard.in/ https://pinboard.in/u:michaelfox/b:6b5471c56fb2/ 2018-03-27T06:29:48+00:00 http://code.openark.org/forge/common_schema michaelfox library opensource mysql sql database db inspiration reference tools framework ★ https://pinboard.in/ https://pinboard.in/u:michaelfox/b:09b0bc7e5d13/ 2018-03-26T04:16:49+00:00 http://www.agiledata.org/essays/adopting.html michaelfox agile data database schema sql orm model patterns oop https://pinboard.in/ https://pinboard.in/u:michaelfox/b:930c07192d7a/ 2018-03-26T04:16:38+00:00 http://www.agiledata.org/links.html michaelfox agile data database schema sql orm model patterns oop https://pinboard.in/ https://pinboard.in/u:michaelfox/b:f63b09e68938/ 2018-03-26T03:04:26+00:00 http://agilemodeling.com/style/ michaelfox agile data database schema sql orm model patterns oop styleguide bestpractices uml https://pinboard.in/ https://pinboard.in/u:michaelfox/b:ab573850541c/ 2018-03-26T03:03:06+00:00 http://www.agiledata.org/essays/findingObjects.html michaelfox agile data database schema sql orm model patterns oop bestpractices styleguide https://pinboard.in/ https://pinboard.in/u:michaelfox/b:986adce0dbb3/ 2018-03-26T03:02:22+00:00 http://www.hotelspiedmont.com/en/dwinfocenter.html michaelfox book agile data database schema sql orm model patterns datawarehouse bigdata architecture reference https://pinboard.in/ https://pinboard.in/u:michaelfox/b:c4fcf938d4f9/ 2018-03-26T03:01:45+00:00 http://www.agiledata.org/essays/reporting.html michaelfox agile data database schema sql orm model patterns architecture reports query bigdata datawarehouse https://pinboard.in/ https://pinboard.in/u:michaelfox/b:8bbd17403d42/ 2018-03-26T02:59:59+00:00 http://www.agiledata.org/essays/mappingObjects.html michaelfox agile data database schema sql orm model patterns https://pinboard.in/ https://pinboard.in/u:michaelfox/b:bba7393065b9/ 2018-03-26T02:13:09+00:00 http://www.agiledata.org/essays/databaseTesting.html michaelfox bestpractices agile data database schema styleguide tools documentation sql orm model https://pinboard.in/ https://pinboard.in/u:michaelfox/b:716dcca9049f/ 2018-03-26T02:12:00+00:00 http://www.agiledata.org/essays/drivingForces.html michaelfox bestpractices agile data database schema styleguide tools documentation sql orm model https://pinboard.in/ https://pinboard.in/u:michaelfox/b:9a23920a34ab/ 2018-03-26T02:11:47+00:00 http://www.agiledata.org/essays/databaseRefactoring.html michaelfox bestpractices agile data database schema styleguide tools documentation sql orm model refactoring https://pinboard.in/ https://pinboard.in/u:michaelfox/b:135e2086486c/ 2018-03-26T02:11:22+00:00 http://www.agiledata.org/essays/agileDataModeling.html michaelfox bestpractices agile data database schema styleguide tools documentation sql orm model https://pinboard.in/ https://pinboard.in/u:michaelfox/b:c7243e6a7d3e/ 2018-03-26T02:10:54+00:00 http://www.agiledata.org/essays/dataModeling101.html michaelfox bestpractices agile data database schema styleguide tools documentation sql orm model https://pinboard.in/ https://pinboard.in/u:michaelfox/b:8bbe1e5bd62a/ 2018-03-26T02:10:44+00:00 http://agiledata.org/essays/developerSkills.html michaelfox bestpractices agile data database schema styleguide tools documentation sql orm model https://pinboard.in/ https://pinboard.in/u:michaelfox/b:0c4ba90adafe/ 2018-02-14T16:16:14+00:00 https://github.com/harelba/q michaelfox csv sql data text python query search https://pinboard.in/u:michaelfox/b:c0c31c149031/ 2018-02-01T12:41:52+00:00 https://mattstauffer.com/blog/new-json-column-where-and-update-syntax-in-laravel-5-3/ michaelfox laravel php mysql json database eloquent data sql reference https://pinboard.in/ https://pinboard.in/u:michaelfox/b:4bf42aa3ac61/ 2018-02-01T12:41:44+00:00 http://www.qcode.in/use-mysql-json-field-in-laravel/ michaelfox laravel php mysql json database eloquent data sql reference https://pinboard.in/ https://pinboard.in/u:michaelfox/b:24e4c43bb148/ 2017-12-06T10:32:47+00:00 http://www.midnightcowboycoder.com/ michaelfoxtools laravel php database sql eloquent convert https://pinboard.in/u:michaelfox/b:2be36ced6dd5/ 2017-11-20T05:11:15+00:00 https://themsaid.com/laravel-mysql-json-colum-fast-lookup-20160709/ michaelfox laravel mysql php db database json index performance bestpractices eloquent data sql reference https://pinboard.in/ https://pinboard.in/u:michaelfox/b:d0afcc81af81/ 2017-11-20T04:35:24+00:00 https://github.com/cybertec-postgresql/postgres-showcase michaelfox postgres db database sample example code sql https://pinboard.in/ https://pinboard.in/u:michaelfox/b:ad9926a9f218/ 2017-11-14T02:03:44+00:00 https://use-the-index-luke.com/ michaelfox book performance database learning sql reference site resource optimization devops mysql monitoring https://pinboard.in/ https://pinboard.in/u:michaelfox/b:5ad992dad35e/ 2017-08-31T15:28:31+00:00 https://github.com/jarulraj/sqlcheck michaelfox mysql designpatterns bestpractices styleguide validation lint debug sql db checker ★ https://pinboard.in/ https://pinboard.in/u:michaelfox/b:fee81c148068/ 2017-08-04T17:10:07+00:00 https://blog.teamsql.io/the-seven-types-of-sql-joins-5bc72f69a609?ct=t(DevOpsLinks_71) michaelfox sql database reference cheatsheet ★ https://pinboard.in/ https://pinboard.in/u:michaelfox/b:69f1cc482b0d/ 2017-07-14T02:56:06+00:00 http://blog.fatalmind.com/2010/09/29/finding-the-best-match-with-a-top-n-query/ michaelfox mysql database optimization sql performance https://pinboard.in/ https://pinboard.in/u:michaelfox/b:a04f46d2d7ab/ 2017-07-11T19:15:33+00:00 https://sqlify.io/convert michaelfox Unread sql csv data convert tools json https://readitlater.com/ https://pinboard.in/u:michaelfox/b:7275a64b245e/ 2017-05-15T03:31:02+00:00 https://www.simple-talk.com/sql/t-sql-programming/basics-good-t-sql-coding-style/ michaelfox sql standard styleguide database syntax bestpractices .proj:styleguide ★ https://pinboard.in/ https://pinboard.in/u:michaelfox/b:93466b33bf0c/ 2017-03-21T18:08:10+00:00 https://github.com/treffynnon/sqlstyle.guide michaelfox styleguide sql mysql bestpractices documentation .proj:styleguide resource ★ https://pinboard.in/ https://pinboard.in/u:michaelfox/b:d89f4e1dac98/ 2017-03-21T18:07:10+00:00 https://raw.githubusercontent.com/treffynnon/sqlstyle.guide/gh-pages/_includes/sqlstyle.guide.md michaelfox styleguide sql mysql bestpractices documentation .proj:styleguide resource ★ https://pinboard.in/ https://pinboard.in/u:michaelfox/b:e5056db8873a/ 2017-02-23T19:03:38+00:00 http://stackoverflow.com/questions/15243114/wordpress-join-wp-post-and-wp-postmeta michaelfox wordpress php mysql sql meta metadata https://pinboard.in/ https://pinboard.in/u:michaelfox/b:8430407b4ddc/ 2017-02-23T19:03:27+00:00 http://wordpress.stackexchange.com/questions/38530/most-efficient-way-to-get-posts-with-postmeta michaelfox wordpress php mysql sql meta metadata https://pinboard.in/ https://pinboard.in/u:michaelfox/b:5c063e246edd/ 2017-02-01T19:27:58+00:00 http://beaver-mysql-logger.com/ michaelfox mysql logging debug performance optimization tools devtools query sql https://pinboard.in/ https://pinboard.in/u:michaelfox/b:0efd3872aed4/ 2016-11-15T03:23:27+00:00 https://gist.github.com/fredbenenson/7bb92718e19138c20591 michaelfox sql styleguide mysql data database bestpractices .proj:styleguide https://pinboard.in/ https://pinboard.in/u:michaelfox/b:acd358d58372/ 2016-10-12T17:46:52+00:00 https://github.com/treffynnon/sqlstyle.guide/ michaelfox bestpractices styleguide sql .todo .proj:styleguide .proj:rb-wiki database https://pinboard.in/ https://pinboard.in/u:michaelfox/b:a8ff94a6fd91/ 2016-10-12T15:54:23+00:00 http://billauer.co.il/blog/2009/03/mysql-datetime-epoch-unix-time/ michaelfox bestpractices styleguide sql .todo .proj:styleguide .proj:rb-wiki database mysql https://pinboard.in/ https://pinboard.in/u:michaelfox/b:f43ccc2a7109/ 2016-10-12T15:53:56+00:00 https://code.tutsplus.com/tutorials/top-20-mysql-best-practices--net-7855 michaelfox mysql bestpractices styleguide sql .todo .proj:styleguide .proj:rb-wiki database https://pinboard.in/ https://pinboard.in/u:michaelfox/b:9653caa27955/ 2016-10-12T15:50:09+00:00 http://www.databasedesign-resource.com/null-values-in-a-database.html michaelfox bestpractices styleguide sql .todo .proj:styleguide .proj:rb-wiki database https://pinboard.in/ https://pinboard.in/u:michaelfox/b:4d99d4fdc177/ 2016-10-12T15:50:02+00:00 https://www.bennadel.com/blog/1050-alf-pedersen-on-null-value-usage-in-database-design.htm michaelfox bestpractices styleguide sql .todo .proj:styleguide .proj:rb-wiki database https://pinboard.in/ https://pinboard.in/u:michaelfox/b:5fc732acc66d/ 2016-10-12T15:49:44+00:00 https://www.bennadel.com/blog/85-why-null-values-should-not-be-used-in-a-database-unless-required.htm michaelfox bestpractices styleguide sql .todo .proj:styleguide .proj:rb-wiki database https://pinboard.in/ https://pinboard.in/u:michaelfox/b:96decdeb647c/ 2016-10-12T15:37:46+00:00 http://poorsql.com/ michaelfox sql database lint tools convert formatting beautify syntax styleguide https://pinboard.in/ https://pinboard.in/u:michaelfox/b:f4046a183581/ 2016-10-12T15:20:47+00:00 http://www.sqlstyle.guide/ michaelfox bestpractices styleguide sql .todo .proj:styleguide .proj:rb-wiki database db mysql naming organization documentation resource ★ https://pinboard.in/ https://pinboard.in/u:michaelfox/b:bcfb3f9f8457/ 2016-10-10T23:27:49+00:00 http://dbglass.web-pal.com/ michaelfox postgresql electron postgres app osx database gui sql query tools https://pinboard.in/ https://pinboard.in/u:michaelfox/b:18d722f88d4d/ 2016-10-10T23:26:56+00:00 https://github.com/web-pal/DBGlass michaelfox app osx electron database gui postgresql sql query https://pinboard.in/ https://pinboard.in/u:michaelfox/b:703c4e93069f/ 2016-08-26T00:24:16+00:00 http://alasql.org/ michaelfox javascript localstorage html5 offline datab database sql https://pinboard.in/ https://pinboard.in/u:michaelfox/b:7c8cbe69b198/ 2016-08-26T00:23:07+00:00 http://dev.yathit.com/ydn-db/index.html michaelfox javascript localstorage html5 offline datab database websql sql https://pinboard.in/ https://pinboard.in/u:michaelfox/b:8b53ad82c137/ 2016-06-24T19:48:29+00:00 http://www.databaseanswers.org/data_models/index.htm michaelfox programming reference database design sql data model naming metadata list collection https://pinboard.in/ https://pinboard.in/u:michaelfox/b:5f70fabb5164/ 2016-05-24T13:51:56+00:00 https://github.com/amaksr/Strelki.js michaelfox javascript library sql data db https://pinboard.in/ https://pinboard.in/u:michaelfox/b:a97d46bbb038/ 2016-03-25T13:01:23+00:00 https://www.netsparker.com/blog/web-security/sql-injection-cheat-sheet/ michaelfox sql database db security reference cheatsheet .proj:rb-wiki mysql postgres https://pinboard.in/ https://pinboard.in/u:michaelfox/b:d05e42e47483/ 2016-02-19T00:19:26+00:00 http://www.querymongo.com/ michaelfoxmongo database generator tools sql convert mysql https://pinboard.in/u:michaelfox/b:e72e01be2d89/ 2016-02-19T00:06:52+00:00 http://explain.depesz.com/ michaelfox database sql debug tools postgres performance https://pinboard.in/u:michaelfox/b:1cbc95603738/ 2016-01-25T13:52:33+00:00 https://www.youtube.com/watch?v=wuH5OoPC3hA michaelfoxmysql hieratical hierarchical php database sql algorithm programming presentation tree data https://pinboard.in/u:michaelfox/b:886e630fd72e/ 2016-01-16T03:25:10+00:00 http://schinckel.net/2014/05/25/querying-json-in-postgres/ michaelfox postgresql sql database json nosql https://pinboard.in/ https://pinboard.in/u:michaelfox/b:9337efeb4135/ 2016-01-16T03:24:39+00:00 http://blog.timothyandrew.net/blog/2013/06/24/recursive-postgres-queries/ michaelfox postgresql sql database hierarchy https://pinboard.in/ https://pinboard.in/u:michaelfox/b:b99d3caa63a9/