<?xml version="1.0" encoding="UTF-8"?>
 <rdf:RDF xmlns="http://purl.org/rss/1.0/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:cc="http://web.resource.org/cc/" xmlns:syn="http://purl.org/rss/1.0/modules/syndication/" xmlns:admin="http://webns.net/mvcb/">
  <channel rdf:about="http://pinboard.in">
    <title>Pinboard (michaelfox)</title>
    <link>https://pinboard.in/u:michaelfox/public/</link>
    <description>recent bookmarks from michaelfox</description>
    <items>
      <rdf:Seq>	<rdf:li rdf:resource="https://tableplus.com/blog/2023/12/how-to-design-mini-tools-using-tableplus.html"/>
	<rdf:li rdf:resource="https://atymic.dev/tips/mysql-performance-fixing-slow-inserts/"/>
	<rdf:li rdf:resource="https://ovid.github.io/articles/database-design-standards.html"/>
	<rdf:li rdf:resource="https://medium.com/hackernoon/getting-ramped-up-on-airflow-with-mysql-s3-redshift-defcc4522c8c"/>
	<rdf:li rdf:resource="http://kvz.io/blog/2013/12/02/make-your-mysql-table-strict/"/>
	<rdf:li rdf:resource="https://github.com/beyondcode/laravel-query-detector"/>
	<rdf:li rdf:resource="https://github.com/xaprb/xaprb-src/blob/master/content/blog/2008/the-power-of-a-good-sql-naming-convention.md"/>
	<rdf:li rdf:resource="https://www.xaprb.com/essential-books/"/>
	<rdf:li rdf:resource="https://www.xaprb.com/blog/2006/04/26/sql-coding-standards/"/>
	<rdf:li rdf:resource="https://databricks.com/blog/2018/11/01/sql-pivot-converting-rows-to-columns.html"/>
	<rdf:li rdf:resource="https://franciskim.co/how-to-data-collection-automation-bot-using-node-js-your-browser/"/>
	<rdf:li rdf:resource="https://github.com/nilportugues/php-sql-query-formatter"/>
	<rdf:li rdf:resource="https://github.com/Adrian0350/SimplePDOWrapper"/>
	<rdf:li rdf:resource="https://github.com/IncrementaCRM/SimplePDOWrapper"/>
	<rdf:li rdf:resource="https://github.com/phpmyadmin/sql-parser"/>
	<rdf:li rdf:resource="https://github.com/biberlabs/awesome-doctrine"/>
	<rdf:li rdf:resource="https://github.com/andreia/awesome-doctrine"/>
	<rdf:li rdf:resource="https://github.com/webdevops/php-docker-boilerplate"/>
	<rdf:li rdf:resource="https://github.com/paragonie/easydb"/>
	<rdf:li rdf:resource="https://www.db-fiddle.com/"/>
	<rdf:li rdf:resource="https://mathiasbynens.be/notes/mysql-utf8mb4#utf8-to-utf8mb4"/>
	<rdf:li rdf:resource="https://github.com/swisnl/laravel-fulltext"/>
	<rdf:li rdf:resource="https://github.com/MarkLeith/dbahelper"/>
	<rdf:li rdf:resource="http://code.openark.org/forge/common_schema"/>
	<rdf:li rdf:resource="http://anothermysqldba.blogspot.com/2014/04/mysql-partitions-timestamp-datetime.html"/>
	<rdf:li rdf:resource="https://github.com/kormoc/Query-Digest-UI/blob/master/pt-query-advisor.php"/>
	<rdf:li rdf:resource="http://database-programmer.blogspot.com/2008/07/history-tables.html"/>
	<rdf:li rdf:resource="https://itunes.apple.com/us/app/mysql-client-by-sqlpro/id1270754173?mt=8#see-all/more-by-this-developer"/>
	<rdf:li rdf:resource="https://itunes.apple.com/us/app/mysql-client-by-sqlpro/id1270754173?mt=8"/>
	<rdf:li rdf:resource="https://getgrav.org/blog/macos-sierra-apache-mysql-vhost-apc"/>
	<rdf:li rdf:resource="https://mattstauffer.com/blog/new-json-column-where-and-update-syntax-in-laravel-5-3/"/>
	<rdf:li rdf:resource="http://www.qcode.in/use-mysql-json-field-in-laravel/"/>
	<rdf:li rdf:resource="https://serversforhackers.com/c/mysql-network-security"/>
	<rdf:li rdf:resource="https://serversforhackers.com/c/amazon-rds"/>
	<rdf:li rdf:resource="https://serversforhackers.com/c/mysql-utf8-and-indexing"/>
	<rdf:li rdf:resource="https://digitalocean.com/community/tutorials/how-to-use-proxysql-as-a-load-balancer-for-mysql-on-ubuntu-16-04"/>
	<rdf:li rdf:resource="https://medium.com/@yavengy/getting-started-with-laravel-on-docker-cc280dae5e49"/>
	<rdf:li rdf:resource="https://medium.com/@tompec/how-to-store-hours-in-a-database-85981f3973e1"/>
	<rdf:li rdf:resource="https://github.com/shlomi-noach/common_schema"/>
	<rdf:li rdf:resource="https://github.com/sjmudd/ps-top"/>
	<rdf:li rdf:resource="https://shlomi-noach.github.io/awesome-mysql/"/>
	<rdf:li rdf:resource="http://www.sysadminworld.com/2014/automysql-backup-error/"/>
	<rdf:li rdf:resource="http://www.sysadminworld.com/2014/clean-up-binlog-files/"/>
	<rdf:li rdf:resource="https://themsaid.com/laravel-mysql-json-colum-fast-lookup-20160709/"/>
	<rdf:li rdf:resource="https://www.percona.com/blog/2013/10/22/designing-one-many-relations-mongodb-vs-mysql/"/>
	<rdf:li rdf:resource="https://www.percona.com/blog/2013/08/01/schema-design-in-mongodb-vs-schema-design-in-mysql/"/>
	<rdf:li rdf:resource="https://use-the-index-luke.com/"/>
	<rdf:li rdf:resource="https://hackernoon.com/eloquent-relationships-cheat-sheet-5155498c209"/>
	<rdf:li rdf:resource="https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html"/>
	<rdf:li rdf:resource="https://web.archive.org/web/20170606110401/http://blog.loftdigital.com/blog/php-utf-8-cheatsheet"/>
	<rdf:li rdf:resource="https://github.com/jarulraj/sqlcheck"/>
	<rdf:li rdf:resource="https://paragonie.com/blog/2017/05/building-searchable-encrypted-databases-with-php-and-sql"/>
	<rdf:li rdf:resource="http://proxysql.com/"/>
	<rdf:li rdf:resource="https://dba.stackexchange.com/questions/54413/how-to-migrate-oracle-database-to-mysql-server"/>
	<rdf:li rdf:resource="https://gist.github.com/oodavid/2206527"/>
	<rdf:li rdf:resource="http://blog.fatalmind.com/2010/09/29/finding-the-best-match-with-a-top-n-query/"/>
	<rdf:li rdf:resource="http://www.remsys.com/blog/data-warehousing-in-mysql"/>
	<rdf:li rdf:resource="http://www.remsys.com/blog/no-downtime-mysql-backup"/>
	<rdf:li rdf:resource="https://git.tt-rss.org/git/tt-rss/src/master/schema/ttrss_schema_mysql.sql"/>
	<rdf:li rdf:resource="https://www.cyberciti.biz/open-source/command-line-hacks/mycli-awesome-mysqlmariadbpercona-mysql-client-with-auto-completion-and-syntax-highlighting/"/>
	<rdf:li rdf:resource="https://www.digitalocean.com/community/tutorials/how-to-optimize-wordpress-performance-with-mysql-replication-on-ubuntu-14-04"/>
	<rdf:li rdf:resource="https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-zabbix-to-securely-monitor-remote-servers-on-centos-7"/>
	<rdf:li rdf:resource="https://www.digitalocean.com/community/tutorials/how-to-prepare-for-your-mysql-5-7-upgrade"/>
	<rdf:li rdf:resource="https://www.digitalocean.com/community/tutorials/how-to-configure-mysql-group-replication-on-ubuntu-16-04"/>
	<rdf:li rdf:resource="https://www.digitalocean.com/community/tutorials/how-to-measure-mysql-query-performance-with-mysqlslap"/>
	<rdf:li rdf:resource="https://serversforhackers.com/mysql-utf8-and-indexing"/>
	<rdf:li rdf:resource="https://github.com/treffynnon/sqlstyle.guide"/>
	<rdf:li rdf:resource="https://raw.githubusercontent.com/treffynnon/sqlstyle.guide/gh-pages/_includes/sqlstyle.guide.md"/>
	<rdf:li rdf:resource="https://ottomatik.io/"/>
	<rdf:li rdf:resource="http://www.unofficialmysqlguide.com/index.html"/>
      </rdf:Seq>
    </items>
  </channel><item rdf:about="https://tableplus.com/blog/2023/12/how-to-design-mini-tools-using-tableplus.html">
    <title>Design mini tools, forms, charts, live boards using TablePlus</title>
    <dc:date>2025-04-05T18:59:11+00:00</dc:date>
    <link>https://tableplus.com/blog/2023/12/how-to-design-mini-tools-using-tableplus.html</link>
    <dc:creator>michaelfox</dc:creator><dc:subject>tableplus database mysql reference documentation reporting monitoring</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:121404f5a3ff/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:tableplus"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:documentation"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reporting"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:monitoring"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://atymic.dev/tips/mysql-performance-fixing-slow-inserts/">
    <title>RDS MySQL Performance Tuning - Speeding up slow inserts</title>
    <dc:date>2021-04-01T13:29:34+00:00</dc:date>
    <link>https://atymic.dev/tips/mysql-performance-fixing-slow-inserts/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Solve issues with slow MySQL insert queries by deferring disk writes.


refrr:https://dudi.dev/
Solve issues with slow MySQL insert queries by deferring disk writes.


refrr:https://dudi.dev/]]></description>
<dc:subject>mysql rds database performance config devops</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:cfe998e23409/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:rds"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:config"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://ovid.github.io/articles/database-design-standards.html">
    <title>Database Design Standards</title>
    <dc:date>2020-01-14T15:11:30+00:00</dc:date>
    <link>https://ovid.github.io/articles/database-design-standards.html</link>
    <dc:creator>michaelfox</dc:creator><dc:subject>bestpractices database mysql designpatterns patterns styleguide ★</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:268484491170/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:designpatterns"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:patterns"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://medium.com/hackernoon/getting-ramped-up-on-airflow-with-mysql-s3-redshift-defcc4522c8c">
    <title>Getting Ramped-Up on Airflow with MySQL → S3 → Redshift</title>
    <dc:date>2019-08-19T15:57:50+00:00</dc:date>
    <link>https://medium.com/hackernoon/getting-ramped-up-on-airflow-with-mysql-s3-redshift-defcc4522c8c</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[I recently joined Plaid as a data engineer and was getting ramped up on Airflow, a workflow tool that we used to manage ETL pipelines internally. If you’re totally new to Airflow, imagine it as a…


refrr:https://medium.com/tag/redshift/archive/2018
I recently joined Plaid as a data engineer and was getting ramped up on Airflow, a workflow tool that we used to manage ETL pipelines internally. If you’re totally new to Airflow, imagine it as a…


refrr:https://medium.com/tag/redshift/archive/2018]]></description>
<dc:subject>mysql airflow data automation etl redshift s3 aws devops .todo .curvo</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:e99fa53d573c/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:airflow"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:data"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:automation"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:etl"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:redshift"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:s3"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:aws"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.todo"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.curvo"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://kvz.io/blog/2013/12/02/make-your-mysql-table-strict/">
    <title>Make Your MySQL Tables Strict</title>
    <dc:date>2019-05-09T18:44:31+00:00</dc:date>
    <link>http://kvz.io/blog/2013/12/02/make-your-mysql-table-strict/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[When you're upgrading to MySQL 5.6 you may notice strict mode is turnedon by default. You can disable it, but now might be a good time toget your schemas strict, to ensure smooth upgrade paths in the future.


refrr:http://kvz.io/page3/
When you're upgrading to MySQL 5.6 you may notice strict mode is turnedon by default. You can disable it, but now might be a good time toget your schemas strict, to ensure smooth upgrade paths in the future.


refrr:http://kvz.io/page3/]]></description>
<dc:subject>mysql bestpractices styleguide</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:83c469726bde/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:styleguide"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/beyondcode/laravel-query-detector">
    <title>laravel-query-detector</title>
    <dc:date>2018-12-15T17:52:51+00:00</dc:date>
    <link>https://github.com/beyondcode/laravel-query-detector</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Laravel N+1 Query Detector. Contribute to beyondcode/laravel-query-detector development by creating an account on GitHub.]]></description>
<dc:subject>laravel mysql database performance lint audit debug checker bestpractices</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:f05ddd52a772/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:laravel"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:lint"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:audit"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:debug"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:checker"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/xaprb/xaprb-src/blob/master/content/blog/2008/the-power-of-a-good-sql-naming-convention.md">
    <title>xaprb/xaprb-src</title>
    <dc:date>2018-11-18T05:57:26+00:00</dc:date>
    <link>https://github.com/xaprb/xaprb-src/blob/master/content/blog/2008/the-power-of-a-good-sql-naming-convention.md</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[At my previous employer, one of the early decisions that had huge payoffs later was the SQL naming conventions. A good naming convention is more than just a nicety. It lets you write programs that don't need to be told about the relationships among tables and columns.


refrr:https://github.com/xaprb/xaprb-src/blob/master/content/blog/2010/why-high-availability-is-hard-with-databases.md
At my previous employer, one of the early decisions that had huge payoffs later was the SQL naming conventions. A good naming convention is more than just a nicety. It lets you write programs that don't need to be told about the relationships among tables and columns.


refrr:https://github.com/xaprb/xaprb-src/blob/master/content/blog/2010/why-high-availability-is-hard-with-databases.md]]></description>
<dc:subject>naming bestpractices mysql conventions standard styleguide .proj:styleguide</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:6f19baddc20b/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:naming"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:conventions"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:standard"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:styleguide"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://www.xaprb.com/essential-books/">
    <title>Essential Books</title>
    <dc:date>2018-11-18T04:32:25+00:00</dc:date>
    <link>https://www.xaprb.com/essential-books/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[This page lists the most valuable books on my bookshelf. These books contain knowledge that is worth far more than the price.


refrr:https://www.xaprb.com/search/
This page lists the most valuable books on my bookshelf. These books contain knowledge that is worth far more than the price.


refrr:https://www.xaprb.com/search/]]></description>
<dc:subject>book database mysql performance optimization books reading list curated collection</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:fd0d0ee3b20f/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:book"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:optimization"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:books"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reading"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:list"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:curated"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:collection"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://www.xaprb.com/blog/2006/04/26/sql-coding-standards/">
    <title>My Personal SQL Coding Standards</title>
    <dc:date>2018-11-18T04:20:07+00:00</dc:date>
    <link>https://www.xaprb.com/blog/2006/04/26/sql-coding-standards/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[how to group data correctly in SQL

Coding standards are a Good Thing. Unfortunately, most organizations don’t have much in the way of SQL coding standards, and there aren’t many automated tools to help. As a result, I believe SQL is often less consistently written than many other languages. Here are my suggestions.


refrr:https://www.google.com/
how to group data correctly in SQL

Coding standards are a Good Thing. Unfortunately, most organizations don’t have much in the way of SQL coding standards, and there aren’t many automated tools to help. As a result, I believe SQL is often less consistently written than many other languages. Here are my suggestions.


refrr:https://www.google.com/]]></description>
<dc:subject>sql mysql database bestpractices styleguide .proj:styleguide .todo</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:57c69222a9c3/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.todo"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://databricks.com/blog/2018/11/01/sql-pivot-converting-rows-to-columns.html">
    <title>SQL Pivot: Converting Rows to Columns</title>
    <dc:date>2018-11-02T14:08:43+00:00</dc:date>
    <link>https://databricks.com/blog/2018/11/01/sql-pivot-converting-rows-to-columns.html</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[In the upcoming Apache Spark 2.4, the community is extending this powerful functionality of pivoting data to SQL users. In this blog, using temperatures recordings in Seattle, we’ll show how we can use this common SQL Pivot feature to achieve complex data transformations.
In the upcoming Apache Spark 2.4, the community is extending this powerful functionality of pivoting data to SQL users. In this blog, using temperatures recordings in Seattle, we’ll show how we can use this common SQL Pivot feature to achieve complex data transformations.]]></description>
<dc:subject>mysql sql data database query</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:de38148a26a3/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:data"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:query"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://franciskim.co/how-to-data-collection-automation-bot-using-node-js-your-browser/">
    <title>Build a Data Mining Automation Bot Using Node.js &amp; Your Browser</title>
    <dc:date>2018-10-23T23:53:53+00:00</dc:date>
    <link>https://franciskim.co/how-to-data-collection-automation-bot-using-node-js-your-browser/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[The ingredients: Linux server running Node.js + Express (might work on Windows?) Node modules: mysql, body-parser MySQL installed Chrome with Tampermonkey (alternatively Firefox and Greasemonkey) You might wonder, why MySQL? I just happened to be more used to it at the time I coded this bot. If I were to do this again, I would …


refrr:https://franciskim.co/blog/page/9/
The ingredients: Linux server running Node.js + Express (might work on Windows?) Node modules: mysql, body-parser MySQL installed Chrome with Tampermonkey (alternatively Firefox and Greasemonkey) You might wonder, why MySQL? I just happened to be more used to it at the time I coded this bot. If I were to do this again, I would …


refrr:https://franciskim.co/blog/page/9/]]></description>
<dc:subject>chrome javascript js mysql node scraper</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:89ffb1ff6192/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:chrome"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:javascript"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:js"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:node"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:scraper"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/nilportugues/php-sql-query-formatter">
    <title>nilportugues/php-sql-query-formatter</title>
    <dc:date>2018-10-09T14:03:02+00:00</dc:date>
    <link>https://github.com/nilportugues/php-sql-query-formatter</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[refrr:https://github.com/search?l=PHP&q=sql+format&type=Repositories]]></description>
<dc:subject>mysql php database sql parser string format convert .proj:logsphp</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:f1f016c760b7/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:parser"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:string"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:format"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:convert"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:logsphp"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/Adrian0350/SimplePDOWrapper">
    <title>Adrian0350/SimplePDOWrapper</title>
    <dc:date>2018-10-09T14:02:59+00:00</dc:date>
    <link>https://github.com/Adrian0350/SimplePDOWrapper</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[SimplePDOWrapper's purpose is to help you handle simple database actions with a reduced amount of code as well as writting less-messy code following a simple structure.


refrr:https://github.com/search?l=PHP&q=sql+beautifier&type=Repositories
SimplePDOWrapper's purpose is to help you handle simple database actions with a reduced amount of code as well as writting less-messy code following a simple structure.


refrr:https://github.com/search?l=PHP&q=sql+beautifier&type=Repositories]]></description>
<dc:subject>mysql php database sql parser string format convert .proj:logs</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:2c5ab74c6ab6/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:parser"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:string"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:format"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:convert"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:logs"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/IncrementaCRM/SimplePDOWrapper">
    <title>IncrementaCRM/SimplePDOWrapper</title>
    <dc:date>2018-10-09T14:02:56+00:00</dc:date>
    <link>https://github.com/IncrementaCRM/SimplePDOWrapper</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[SimplePDOWrapper's purpose is to help you handle simple database actions with a reduced amount of code as well as writting less-messy code following a simple structure.


refrr:https://github.com/search?l=PHP&q=sql+beautify&type=Repositories
SimplePDOWrapper's purpose is to help you handle simple database actions with a reduced amount of code as well as writting less-messy code following a simple structure.


refrr:https://github.com/search?l=PHP&q=sql+beautify&type=Repositories]]></description>
<dc:subject>mysql php database sql parser string format convert .proj:logs</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:81c6842ad0a6/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:parser"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:string"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:format"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:convert"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:logs"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/phpmyadmin/sql-parser">
    <title>phpmyadmin/sql-parser Loading status checks…</title>
    <dc:date>2018-10-09T14:02:52+00:00</dc:date>
    <link>https://github.com/phpmyadmin/sql-parser</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[A validating SQL lexer and parser with a focus on MySQL dialect.


refrr:https://github.com/search?l=PHP&o=desc&q=sql+parse&s=stars&type=Repositories
A validating SQL lexer and parser with a focus on MySQL dialect.


refrr:https://github.com/search?l=PHP&o=desc&q=sql+parse&s=stars&type=Repositories]]></description>
<dc:subject>mysql php database sql parser string format convert .proj:logs</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:55cacae9ce0c/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:parser"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:string"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:format"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:convert"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:logs"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/biberlabs/awesome-doctrine">
    <title>GitHub - biberlabs/awesome-doctrine: A curated list of amazingly awesome Doctrine 2 ORM related libraries, resources and shiny things.</title>
    <dc:date>2018-08-24T11:39:01+00:00</dc:date>
    <link>https://github.com/biberlabs/awesome-doctrine</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[michaelfox starred biberlabs/awesome-doctrine]]></description>
<dc:subject>created-by:ifttt via:github github-starred awesome doctrine ★ db mysql orm</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:4a4de2af88cc/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:created-by:ifttt"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:via:github"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:github-starred"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:awesome"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:doctrine"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:orm"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/andreia/awesome-doctrine">
    <title>GitHub - andreia/awesome-doctrine: A collection of useful Doctrine snippets.</title>
    <dc:date>2018-08-15T13:59:14+00:00</dc:date>
    <link>https://github.com/andreia/awesome-doctrine</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[michaelfox starred andreia/awesome-doctrine]]></description>
<dc:subject>created-by:ifttt via:github github-starred awesome doctrine ★ db mysql orm</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:49c96c884090/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:created-by:ifttt"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:via:github"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:github-starred"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:awesome"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:doctrine"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:orm"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/webdevops/php-docker-boilerplate">
    <title>webdevops/php-docker-boilerplate</title>
    <dc:date>2018-08-13T14:16:28+00:00</dc:date>
    <link>https://github.com/webdevops/php-docker-boilerplate</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[🍲 PHP Docker Boilerplate for Symfony, Wordpress, Joomla or any other PHP Project (NGINX, Apache HTTPd, PHP-FPM, MySQL, Solr, Elasticsearch, Redis, FTP) https://webdevops.io/projects/php-doc…


refrr:https://github.com/search?o=desc&q=docker+ftp&s=stars&type=Repositories
🍲 PHP Docker Boilerplate for Symfony, Wordpress, Joomla or any other PHP Project (NGINX, Apache HTTPd, PHP-FPM, MySQL, Solr, Elasticsearch, Redis, FTP) https://webdevops.io/projects/php-doc…


refrr:https://github.com/search?o=desc&q=docker+ftp&s=stars&type=Repositories]]></description>
<dc:subject>apache boilerplate mysql php docker devops sysadmin .todo environment setup</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:0ab0775c6886/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:apache"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:boilerplate"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:docker"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sysadmin"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.todo"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:environment"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:setup"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/paragonie/easydb">
    <title>paragonie/easydb</title>
    <dc:date>2018-08-10T13:28:52+00:00</dc:date>
    <link>https://github.com/paragonie/easydb</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Easy-to-use PDO wrapper for PHP projects. paragonie.com/projects


refrr:https://php.libhunt.com/
Easy-to-use PDO wrapper for PHP projects. paragonie.com/projects


refrr:https://php.libhunt.com/]]></description>
<dc:subject>php pdo database mysql library</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:74cd2518936d/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:pdo"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:library"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://www.db-fiddle.com/">
    <title>DB Fiddle - SQL Database Playground</title>
    <dc:date>2018-07-27T17:51:36+00:00</dc:date>
    <link>https://www.db-fiddle.com/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[An online SQL database playground for testing, debugging and sharing SQL snippets.
An online SQL database playground for testing, debugging and sharing SQL snippets.]]></description>
<dc:subject>database query mysql db fiddle sandbox prototype demo testing tools</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:7394e821f69f/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:query"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:fiddle"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sandbox"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:prototype"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:demo"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:testing"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:tools"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://mathiasbynens.be/notes/mysql-utf8mb4#utf8-to-utf8mb4">
    <title>How to support full Unicode in MySQL databases</title>
    <dc:date>2018-06-14T16:25:47+00:00</dc:date>
    <link>https://mathiasbynens.be/notes/mysql-utf8mb4#utf8-to-utf8mb4</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Published 30th July 2012 · tagged with MySQL, security, Unicode
Published 30th July 2012 · tagged with MySQL, security, Unicode]]></description>
<dc:subject>mysql bestpractices styleguide database utf8 emoji data convert unicode reference ★</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:7ad517606eb2/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:utf8"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:emoji"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:data"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:convert"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:unicode"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/swisnl/laravel-fulltext">
    <title>swisnl/laravel-fulltext</title>
    <dc:date>2018-05-16T19:14:56+00:00</dc:date>
    <link>https://github.com/swisnl/laravel-fulltext</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Fulltext indexing and searching for Laravel This package creates a MySQL fulltext index for models and enables you to search through those.
Fulltext indexing and searching for Laravel This package creates a MySQL fulltext index for models and enables you to search through those.]]></description>
<dc:subject>laravel php mysql search database</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:660ae77fac28/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:laravel"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:search"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/MarkLeith/dbahelper">
    <title>MarkLeith/dbahelper</title>
    <dc:date>2018-03-27T06:34:50+00:00</dc:date>
    <link>https://github.com/MarkLeith/dbahelper</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[A collection of scripts to help MySQL DBAs A collection of scripts to help MySQL DBAs


refrr:http://www.markleith.co.uk/ps_helper/
A collection of scripts to help MySQL DBAs A collection of scripts to help MySQL DBAs


refrr:http://www.markleith.co.uk/ps_helper/]]></description>
<dc:subject>mysql database performance monitoring devops tools snippets utilities maintenance db query resource collection ★ .todo inspiration framework opensource library</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:b7fd25c71a08/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:monitoring"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:tools"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:snippets"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:utilities"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:maintenance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:query"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:resource"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:collection"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.todo"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:inspiration"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:framework"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:opensource"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:library"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://code.openark.org/forge/common_schema">
    <title>common_schemacommon_schema</title>
    <dc:date>2018-03-27T06:29:48+00:00</dc:date>
    <link>http://code.openark.org/forge/common_schema</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[common_schema


refrr:http://anothermysqldba.blogspot.com/search/label/tools%20of%20the%20trade
common_schema


refrr:http://anothermysqldba.blogspot.com/search/label/tools%20of%20the%20trade]]></description>
<dc:subject>library opensource mysql sql database db inspiration reference tools framework ★</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:09b0bc7e5d13/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:library"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:opensource"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:inspiration"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:tools"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:framework"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://anothermysqldba.blogspot.com/2014/04/mysql-partitions-timestamp-datetime.html">
    <title>MySQL Partitions timestamp - datetime</title>
    <dc:date>2018-03-27T05:44:45+00:00</dc:date>
    <link>http://anothermysqldba.blogspot.com/2014/04/mysql-partitions-timestamp-datetime.html</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Another MySQL DBA's Blog addressing the concerns and solutions with using MySQL.


refrr:https://www.google.com/
Another MySQL DBA's Blog addressing the concerns and solutions with using MySQL.


refrr:https://www.google.com/]]></description>
<dc:subject>mysql database partition rotate logging performance procedure</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:fe1dbe875354/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:partition"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:rotate"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:logging"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:procedure"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/kormoc/Query-Digest-UI/blob/master/pt-query-advisor.php">
    <title>kormoc/Query-Digest-UI</title>
    <dc:date>2018-03-12T15:50:55+00:00</dc:date>
    <link>https://github.com/kormoc/Query-Digest-UI/blob/master/pt-query-advisor.php</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[refrr:https://www.google.com/

refrr:https://www.google.com/]]></description>
<dc:subject>php database optimization performance bestpractices styleguide audit mysql db scanner checklist dashboard monitoring .todo</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:925cf0d5db99/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:optimization"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:audit"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:scanner"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:checklist"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:dashboard"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:monitoring"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.todo"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://database-programmer.blogspot.com/2008/07/history-tables.html">
    <title>History Tables</title>
    <dc:date>2018-03-11T18:15:35+00:00</dc:date>
    <link>http://database-programmer.blogspot.com/2008/07/history-tables.html</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[A history table allows you to use one table to track changes in another table. While the basic idea is simple, a naive implementation...


refrr:https://www.google.com/
A history table allows you to use one table to track changes in another table. While the basic idea is simple, a naive implementation...


refrr:https://www.google.com/]]></description>
<dc:subject>designpatterns data database schema history logging mysql bestpractices</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:00f64ddace41/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:designpatterns"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:data"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:schema"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:history"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:logging"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://itunes.apple.com/us/app/mysql-client-by-sqlpro/id1270754173?mt=8#see-all/more-by-this-developer">
    <title>Connecting to Apple Music.</title>
    <dc:date>2018-03-07T18:00:48+00:00</dc:date>
    <link>https://itunes.apple.com/us/app/mysql-client-by-sqlpro/id1270754173?mt=8#see-all/more-by-this-developer</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[refrr:https://itunes.apple.com/us/app/mysql-client-by-sqlpro/id1270754173?mt=8
refrr:https://itunes.apple.com/us/app/mysql-client-by-sqlpro/id1270754173?mt=8]]></description>
<dc:subject>mysql ios app</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:eda5943558ae/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:ios"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:app"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://itunes.apple.com/us/app/mysql-client-by-sqlpro/id1270754173?mt=8">
    <title>MySQL Client by SQLPro on the App Store</title>
    <dc:date>2018-03-07T18:00:14+00:00</dc:date>
    <link>https://itunes.apple.com/us/app/mysql-client-by-sqlpro/id1270754173?mt=8</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Read reviews, compare customer ratings, see screenshots, and learn more about MySQL Client by SQLPro. Download MySQL Client by SQLPro and enjoy it on your iPhone, iPad, and iPod touch.
refrr:https://itunes.apple.com/us/app/httper/id1166884043?mt=8
Read reviews, compare customer ratings, see screenshots, and learn more about MySQL Client by SQLPro. Download MySQL Client by SQLPro and enjoy it on your iPhone, iPad, and iPod touch.
refrr:https://itunes.apple.com/us/app/httper/id1166884043?mt=8]]></description>
<dc:subject>mysql ios app</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:736c8c61b19c/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:ios"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:app"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://getgrav.org/blog/macos-sierra-apache-mysql-vhost-apc">
    <title>macOS 10.13 High Sierra Apache Setup: MySQL, APC &amp; More...</title>
    <dc:date>2018-02-05T18:20:28+00:00</dc:date>
    <link>https://getgrav.org/blog/macos-sierra-apache-mysql-vhost-apc</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Grav is an easy to use, yet powerful, opensource CMS that requires no database


refrr:https://getgrav.org/blog/macos-sierra-apache-multiple-php-versions]]></description>
<dc:subject>setup apache php osx development environment tools mysql</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:c06853bc51ea/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:setup"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:apache"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:osx"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:development"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:environment"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:tools"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://mattstauffer.com/blog/new-json-column-where-and-update-syntax-in-laravel-5-3/">
    <title>New JSON-column where() and update() syntax in Laravel 5.3</title>
    <dc:date>2018-02-01T12:41:52+00:00</dc:date>
    <link>https://mattstauffer.com/blog/new-json-column-where-and-update-syntax-in-laravel-5-3/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[While Laravel has had the ability to cast your data to and from JSON since version 5.0, it was previously just a convenience—your data


refrr:https://www.google.com/]]></description>
<dc:subject>laravel php mysql json database eloquent data sql reference</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:4bf42aa3ac61/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:laravel"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:json"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:eloquent"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:data"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://www.qcode.in/use-mysql-json-field-in-laravel/">
    <title>Use MySQL JSON field in Laravel</title>
    <dc:date>2018-02-01T12:41:44+00:00</dc:date>
    <link>http://www.qcode.in/use-mysql-json-field-in-laravel/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[fields

I have been working on an application which needs to store a lot of metadata about user profile, we discussed with the team about using NoSQL database (MongoDB) since its a JSON data set which can be extended and customized for the specific user profile due to its schemaless structure. As we know from MySQL 5.7.8 JSON …


refrr:https://www.google.com/]]></description>
<dc:subject>laravel php mysql json database eloquent data sql reference</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:24e4c43bb148/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:laravel"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:json"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:eloquent"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:data"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://serversforhackers.com/c/mysql-network-security">
    <title>MySQL Network Security</title>
    <dc:date>2018-01-11T18:43:58+00:00</dc:date>
    <link>https://serversforhackers.com/c/mysql-network-security</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[See how to setup MySQL to allow secure remote connections from your application servers.


refrr:https://t.co/284SQshZm5]]></description>
<dc:subject>mysql security bestpractices aws rds database setup .proj:nest reference network</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:287e884ebd77/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:security"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:aws"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:rds"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:setup"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:nest"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:network"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://serversforhackers.com/c/amazon-rds">
    <title>Amazon RDS</title>
    <dc:date>2018-01-11T18:40:44+00:00</dc:date>
    <link>https://serversforhackers.com/c/amazon-rds</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[I've gotten a few questions about how MySQL replication works within RDS. Amazon has a few concepts going on which makes the picture of how everything fits together a little hazy. Here's my attempt at clearing up how the RDS service works!


refrr:https://serversforhackers.com/c/amazon-rds]]></description>
<dc:subject>aws rds database setup .proj:nest reference mysql</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:15dff6e78f64/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:aws"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:rds"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:setup"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:nest"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://serversforhackers.com/c/mysql-utf8-and-indexing">
    <title>MySQL, UTF8 and Indexing</title>
    <dc:date>2018-01-11T18:33:26+00:00</dc:date>
    <link>https://serversforhackers.com/c/mysql-utf8-and-indexing</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[See some pitfalls of using MySQL with UTF-8 when indexing your database.


refrr:https://serversforhackers.com/t/databases]]></description>
<dc:subject>mysql bestpractices charactersets utf8 setup .proj:nest database reference</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:096d4189422f/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:charactersets"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:utf8"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:setup"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:nest"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://digitalocean.com/community/tutorials/how-to-use-proxysql-as-a-load-balancer-for-mysql-on-ubuntu-16-04">
    <title>How to Use ProxySQL as a Load Balancer for MySQL on Ubuntu 16.04</title>
    <dc:date>2018-01-09T18:34:14+00:00</dc:date>
    <link>https://digitalocean.com/community/tutorials/how-to-use-proxysql-as-a-load-balancer-for-mysql-on-ubuntu-16-04</link>
    <dc:creator>michaelfox</dc:creator><dc:subject>mysql monitoring devops scaling loadbalancing database sysadmin logging query optimization debug</dc:subject>
<dc:source>https://readitlater.com/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:9e1f768706e6/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:monitoring"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:scaling"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:loadbalancing"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sysadmin"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:logging"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:query"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:optimization"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:debug"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://medium.com/@yavengy/getting-started-with-laravel-on-docker-cc280dae5e49">
    <title>Getting started with Laravel on Docker</title>
    <dc:date>2018-01-08T15:24:04+00:00</dc:date>
    <link>https://medium.com/@yavengy/getting-started-with-laravel-on-docker-cc280dae5e49</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[In this tutorial, I will show you how you can set up a new Laravel project using Docker. With Docker, you can set up a virtual environment without dependencies from your system, this way your project…

#docker #laravel-5 #mysql #web-development #php
In this tutorial, I will show you how you can set up a new Laravel project using Docker. With Docker, you can set up a virtual environment without dependencies from your system, this way your project…

#docker #laravel-5 #mysql #web-development #php]]></description>
<dc:subject>laravel php mysql docker devops</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:99abe4159a7b/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:laravel"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:docker"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://medium.com/@tompec/how-to-store-hours-in-a-database-85981f3973e1">
    <title>How to store hours in a database</title>
    <dc:date>2017-12-12T03:44:10+00:00</dc:date>
    <link>https://medium.com/@tompec/how-to-store-hours-in-a-database-85981f3973e1</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[<?php
 
function intToHour($int)
{
    $minutes = $int % 60;
    $hours = $int / 60;
    return sprintf(“%02d”, floor($hours)) . “:” . sprintf(“%02d”,    $minutes);
}
function hourToInt($hour)
{
    $array = explode(‘:’, $hour);
    return ($array[0] * 60) + $array[1];
}
So now you can do:
echo hourToInt("13:37"); // 817
And the opposite:
echo intToHour("817"); // 13:37

The easiest way I found to store hours (24-time format) in a database is to convert them in integers. “How to store hours in a database” is published by tompec

#php #database #development #laravel


refrr:https://medium.com/tag/php/latest
<?php
 
function intToHour($int)
{
    $minutes = $int % 60;
    $hours = $int / 60;
    return sprintf(“%02d”, floor($hours)) . “:” . sprintf(“%02d”,    $minutes);
}
function hourToInt($hour)
{
    $array = explode(‘:’, $hour);
    return ($array[0] * 60) + $array[1];
}
So now you can do:
echo hourToInt("13:37"); // 817
And the opposite:
echo intToHour("817"); // 13:37

The easiest way I found to store hours (24-time format) in a database is to convert them in integers. “How to store hours in a database” is published by tompec

#php #database #development #laravel


refrr:https://medium.com/tag/php/latest]]></description>
<dc:subject>laravel php time date data mysql db database convert</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:55bb948a808b/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:laravel"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:time"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:date"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:data"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:convert"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/shlomi-noach/common_schema">
    <title>shlomi-noach/common_schema</title>
    <dc:date>2017-11-23T04:01:10+00:00</dc:date>
    <link>https://github.com/shlomi-noach/common_schema</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[A thorough guide to routines, views, the QueryScript language

DBA's framework for MySQL


refrr:https://shlomi-noach.github.io/awesome-mysql/
A thorough guide to routines, views, the QueryScript language

DBA's framework for MySQL


refrr:https://shlomi-noach.github.io/awesome-mysql/]]></description>
<dc:subject>mysql snippets utilities maintenance devops db database query tools resource collection ★</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:6ef3b620346e/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:snippets"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:utilities"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:maintenance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:query"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:tools"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:resource"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:collection"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/sjmudd/ps-top">
    <title>sjmudd/ps-top</title>
    <dc:date>2017-11-23T04:00:00+00:00</dc:date>
    <link>https://github.com/sjmudd/ps-top</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[ps-top - a top-like program for MySQL


refrr:https://shlomi-noach.github.io/awesome-mysql/]]></description>
<dc:subject>.proj:nest mysql monitoring shell cli performance tools debug logging</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:ad1bfbeca4ec/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:nest"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:monitoring"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:shell"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:cli"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:tools"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:debug"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:logging"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://shlomi-noach.github.io/awesome-mysql/">
    <title>Awesome MySQL</title>
    <dc:date>2017-11-23T03:55:33+00:00</dc:date>
    <link>https://shlomi-noach.github.io/awesome-mysql/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[A curated list of awesome MySQL software, libraries and resources.


refrr:https://www.google.com/]]></description>
<dc:subject>mysql awesome database collection ★</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:e177a9dd2b02/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:awesome"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:collection"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://www.sysadminworld.com/2014/automysql-backup-error/">
    <title>http://www.sysadminworld.com/2014/automysql-backup-error/</title>
    <dc:date>2017-11-23T03:23:26+00:00</dc:date>
    <link>http://www.sysadminworld.com/2014/automysql-backup-error/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Original link found at:  http://www.sysadminworld.com/page/5/
 Original link found at:  http://www.sysadminworld.com/page/5/]]></description>
<dc:subject>mysql backup devops</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:3e6d7ff11c55/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:backup"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://www.sysadminworld.com/2014/clean-up-binlog-files/">
    <title>http://www.sysadminworld.com/2014/clean-up-binlog-files/</title>
    <dc:date>2017-11-23T03:22:20+00:00</dc:date>
    <link>http://www.sysadminworld.com/2014/clean-up-binlog-files/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[ Original link found at:  http://www.sysadminworld.com/page/2/]]></description>
<dc:subject>mysql devops</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:4c231c60112f/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://themsaid.com/laravel-mysql-json-colum-fast-lookup-20160709/">
    <title>Laravel/MySQL JSON documents faster lookup using generated columns</title>
    <dc:date>2017-11-20T05:11:15+00:00</dc:date>
    <link>https://themsaid.com/laravel-mysql-json-colum-fast-lookup-20160709/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Laravel developer & Freediver.
Laravel developer & Freediver.]]></description>
<dc:subject>laravel mysql php db database json index performance bestpractices eloquent data sql reference</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:d0afcc81af81/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:laravel"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:json"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:index"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:eloquent"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:data"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://www.percona.com/blog/2013/10/22/designing-one-many-relations-mongodb-vs-mysql/">
    <title>Designing one to many relations – MongoDB vs MySQL</title>
    <dc:date>2017-11-15T15:24:30+00:00</dc:date>
    <link>https://www.percona.com/blog/2013/10/22/designing-one-many-relations-mongodb-vs-mysql/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Stephane Combaudon reveals several topics that you will have to keep in mind when designing one to many relations in MongoDB. He also compares it to MySQL.


refrr:https://www.percona.com/blog/2013/08/01/schema-design-in-mongodb-vs-schema-design-in-mysql/
Stephane Combaudon reveals several topics that you will have to keep in mind when designing one to many relations in MongoDB. He also compares it to MySQL.


refrr:https://www.percona.com/blog/2013/08/01/schema-design-in-mongodb-vs-schema-design-in-mysql/]]></description>
<dc:subject>mysql database schema bestpractices nosql mongodb</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:0f1bad48b51b/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:schema"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:nosql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mongodb"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://www.percona.com/blog/2013/08/01/schema-design-in-mongodb-vs-schema-design-in-mysql/">
    <title>Schema Design in MongoDB vs Schema Design in MySQL</title>
    <dc:date>2017-11-15T15:24:27+00:00</dc:date>
    <link>https://www.percona.com/blog/2013/08/01/schema-design-in-mongodb-vs-schema-design-in-mysql/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Percona Consultant Stephane Combaudon elaborates on the key differences between a MySQL database schema design and a MongoDB schema design.


refrr:https://www.percona.com/search?s=mongo+schema
Percona Consultant Stephane Combaudon elaborates on the key differences between a MySQL database schema design and a MongoDB schema design.


refrr:https://www.percona.com/search?s=mongo+schema]]></description>
<dc:subject>mysql database schema bestpractices nosql mongodb</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:496433f679d4/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:schema"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:nosql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mongodb"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://use-the-index-luke.com/">
    <title>SQL Indexing and Tuning e-Book</title>
    <dc:date>2017-11-14T02:03:44+00:00</dc:date>
    <link>https://use-the-index-luke.com/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.


refrr:https://use-the-index-luke.com/3-minute-test/mysql
SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.


refrr:https://use-the-index-luke.com/3-minute-test/mysql]]></description>
<dc:subject>book performance database learning sql reference site resource optimization devops mysql monitoring</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:5ad992dad35e/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:book"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:learning"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:site"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:resource"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:optimization"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:monitoring"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://hackernoon.com/eloquent-relationships-cheat-sheet-5155498c209">
    <title>Eloquent Relationships Cheat Sheet</title>
    <dc:date>2017-10-15T01:58:42+00:00</dc:date>
    <link>https://hackernoon.com/eloquent-relationships-cheat-sheet-5155498c209</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[The Man (buyer) can buy many Cars. The Woman (buyer) can buy many Cars. The Car can be bought by one buyer (Man or Woman). The Car table should store the Buyer ID and the Buyer Type. “buyer” is a…

#laravel #eloquent #laravel-eloquent #database #orm


refrr:https://medium.com/tag/laravel
The Man (buyer) can buy many Cars. The Woman (buyer) can buy many Cars. The Car can be bought by one buyer (Man or Woman). The Car table should store the Buyer ID and the Buyer Type. “buyer” is a…

#laravel #eloquent #laravel-eloquent #database #orm


refrr:https://hackernoon.com/eloquent-relationships-cheat-sheet-5155498c209]]></description>
<dc:subject>Unread laravel db eloquent mysql cheatsheet reference ★ php database</dc:subject>
<dc:source>https://readitlater.com/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:6099257678d7/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:Unread"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:laravel"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:eloquent"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:cheatsheet"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html">
    <title>5.5.9 mysqlslap — Load Emulation Client</title>
    <dc:date>2017-09-27T04:06:50+00:00</dc:date>
    <link>https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. It works as if multiple clients are accessing the server.]]></description>
<dc:subject>mysql audit load loadtesting performance optimization devops tools cli mysqlslap</dc:subject>
<dc:source>https://readitlater.com/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:79cef33d2fb6/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:audit"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:load"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:loadtesting"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:optimization"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:tools"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:cli"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysqlslap"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://web.archive.org/web/20170606110401/http://blog.loftdigital.com/blog/php-utf-8-cheatsheet">
    <title>PHP UTF-8 cheatsheet</title>
    <dc:date>2017-09-21T17:35:58+00:00</dc:date>
    <link>https://web.archive.org/web/20170606110401/http://blog.loftdigital.com/blog/php-utf-8-cheatsheet</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Stopgap guide to going UTF-8

#mysql #php #utf8


refrr:https://web.archive.org/web/20170606110401/http://blog.loftdigital.com/blog/php-utf-8-cheatsheet
Stopgap guide to going UTF-8

#mysql #php #utf8


refrr:https://web.archive.org/web/20170606110401/http://blog.loftdigital.com/blog/php-utf-8-cheatsheet]]></description>
<dc:subject>cheatsheet mysql php reference bestpractices styleguide checklist .proj:checker utf8 characters</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:e7b7efacea15/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:cheatsheet"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:checklist"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:checker"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:utf8"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:characters"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/jarulraj/sqlcheck">
    <title>jarulraj/sqlcheck</title>
    <dc:date>2017-08-31T15:28:31+00:00</dc:date>
    <link>https://github.com/jarulraj/sqlcheck</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[SQLCheck automates the detection of common anti-patterns in SQL queries. Such anti-patterns often increase the time taken to run the queries on a database management system. Addressing these anti-patterns will, therefore, help improve the runtime performance of the queries. This tool targets all SQL dialects.

]]></description>
<dc:subject>mysql designpatterns bestpractices styleguide validation lint debug sql db checker ★</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:fee81c148068/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:designpatterns"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:validation"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:lint"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:debug"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:checker"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://paragonie.com/blog/2017/05/building-searchable-encrypted-databases-with-php-and-sql">
    <title>Building Searchable Encrypted Databases with PHP and SQL</title>
    <dc:date>2017-08-29T14:24:00+00:00</dc:date>
    <link>https://paragonie.com/blog/2017/05/building-searchable-encrypted-databases-with-php-and-sql</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[How to implement field-level data encryption while still allowing fast queries.
How to implement field-level data encryption while still allowing fast queries.]]></description>
<dc:subject>php database mysql encryption data security bestpractices devops</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:cf87aa053818/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:encryption"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:data"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:security"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://proxysql.com/">
    <title>ProxySQL</title>
    <dc:date>2017-08-23T18:00:38+00:00</dc:date>
    <link>http://proxysql.com/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[: high-performance, GPL licensed MySQL proxy. It supports hundreds of thousands of concurrent connections and can be multiplexed to hundreds of servers.


refrr:http://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-cache/]]></description>
<dc:subject>mysql database monitoring performance optimization debug proxy tools devops .todo</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:53cedd767381/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:monitoring"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:optimization"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:debug"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:proxy"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:tools"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.todo"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://dba.stackexchange.com/questions/54413/how-to-migrate-oracle-database-to-mysql-server">
    <title>Database Administrators</title>
    <dc:date>2017-08-17T19:16:24+00:00</dc:date>
    <link>https://dba.stackexchange.com/questions/54413/how-to-migrate-oracle-database-to-mysql-server</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Currently our application is running using Oracle 11g database. We are developing newer version of the application which runs on MySQL cluster. We need to migrate the data from Oracle database to M...


refrr:https://www.google.com/]]></description>
<dc:subject>oracle mysql convert database migration</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:b18896f0b672/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:oracle"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:convert"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:migration"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://gist.github.com/oodavid/2206527">
    <title>Backup MySQL to Amazon S3</title>
    <dc:date>2017-08-01T19:07:16+00:00</dc:date>
    <link>https://gist.github.com/oodavid/2206527</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[refrr:https://github.com/vsouza/awesome-gists

refrr:https://github.com/vsouza/awesome-gists]]></description>
<dc:subject>backup mysql aws s3 db scripting shell devops database</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:10ce8f9390e0/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:backup"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:aws"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:s3"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:db"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:scripting"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:shell"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://blog.fatalmind.com/2010/09/29/finding-the-best-match-with-a-top-n-query/">
    <title>Software Quality is Quality of Life</title>
    <dc:date>2017-07-14T02:56:06+00:00</dc:date>
    <link>http://blog.fatalmind.com/2010/09/29/finding-the-best-match-with-a-top-n-query/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[There was an interesting index related performance problem on Stack Overflow recently. The problem was to check an input string against a table that holds about 2000 prefix patterns (e.g., LIKE 'xy...
There was an interesting index related performance problem on Stack Overflow recently. The problem was to check an input string against a table that holds about 2000 prefix patterns (e.g., LIKE 'xy...]]></description>
<dc:subject>mysql database optimization sql performance</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:a04f46d2d7ab/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:optimization"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://www.remsys.com/blog/data-warehousing-in-mysql">
    <title>Data warehousing in MySQL</title>
    <dc:date>2017-07-14T01:14:18+00:00</dc:date>
    <link>http://www.remsys.com/blog/data-warehousing-in-mysql</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Some databases are used to store large amount of historical data (such as call detail records, log messages, etc). This data has the following common characteristics:


refrr:http://www.remsys.com/blog
Some databases are used to store large amount of historical data (such as call detail records, log messages, etc). This data has the following common characteristics:


refrr:http://www.remsys.com/blog]]></description>
<dc:subject>mysql devops</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:6e956753193d/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://www.remsys.com/blog/no-downtime-mysql-backup">
    <title>No-downtime MySQL backup (InnoDB/InnoBackupEx)</title>
    <dc:date>2017-07-14T01:11:05+00:00</dc:date>
    <link>http://www.remsys.com/blog/no-downtime-mysql-backup</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[The high prevalence of MySQL databases leads to their usage in increasingly diverse projects, including those that require nonstop operation and minimal recovery time. Standard tools, such as mysqldump are inconvenient for the use in large databases that can reach tens of gigabytes. If you can still export the data in the reasonable time of a few hours, the restore operation can take tens of hours. Also, using mysqldump to backup causes table locks (making downtime during backup) and can be followed by data inconsistency in backup copy.


refrr:http://www.remsys.com/blog
The high prevalence of MySQL databases leads to their usage in increasingly diverse projects, including those that require nonstop operation and minimal recovery time. Standard tools, such as mysqldump are inconvenient for the use in large databases that can reach tens of gigabytes. If you can still export the data in the reasonable time of a few hours, the restore operation can take tens of hours. Also, using mysqldump to backup causes table locks (making downtime during backup) and can be followed by data inconsistency in backup copy.


refrr:http://www.remsys.com/blog]]></description>
<dc:subject>backup mysql</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:ec18371c75d4/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:backup"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://git.tt-rss.org/git/tt-rss/src/master/schema/ttrss_schema_mysql.sql">
    <title>git/tt-rss</title>
    <dc:date>2017-07-13T01:35:54+00:00</dc:date>
    <link>https://git.tt-rss.org/git/tt-rss/src/master/schema/ttrss_schema_mysql.sql</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[tt-rss - Tiny Tiny RSS
tt-rss - Tiny Tiny RSS]]></description>
<dc:subject>mysql rss bookmarks schema inspiration feed</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:270b2ff84f2a/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:rss"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bookmarks"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:schema"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:inspiration"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:feed"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://www.cyberciti.biz/open-source/command-line-hacks/mycli-awesome-mysqlmariadbpercona-mysql-client-with-auto-completion-and-syntax-highlighting/">
    <title>mycli: Awesome MySQL/MariaDB mysql client with auto-completion and syntax highlighting – nixCraft</title>
    <dc:date>2017-05-23T01:53:24+00:00</dc:date>
    <link>https://www.cyberciti.biz/open-source/command-line-hacks/mycli-awesome-mysqlmariadbpercona-mysql-client-with-auto-completion-and-syntax-highlighting/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[MyCLI is an awesome CLI tool for MySQL, MariaDB, and Percona with auto-completion, history, syntax highlighting and much more.]]></description>
<dc:subject>shell mysql tools .proj:nest .proj:dotfiles</dc:subject>
<dc:identifier>https://pinboard.in/u:michaelfox/b:60079ddd8f43/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:shell"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:tools"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:nest"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:dotfiles"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://www.digitalocean.com/community/tutorials/how-to-optimize-wordpress-performance-with-mysql-replication-on-ubuntu-14-04">
    <title>How To Optimize WordPress Performance With MySQL Replication On Ubuntu 14.04</title>
    <dc:date>2017-04-14T14:23:39+00:00</dc:date>
    <link>https://www.digitalocean.com/community/tutorials/how-to-optimize-wordpress-performance-with-mysql-replication-on-ubuntu-14-04</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[In this tutorial, we will teach you how to scale up your WordPress MySQL database server setup using master-slave database replication and the HyperDB plugin for WordPress. Adding more database servers to your environment in this manner allows your Wo

#wordpress #mysql #scaling #ubuntu


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials
In this tutorial, we will teach you how to scale up your WordPress MySQL database server setup using master-slave database replication and the HyperDB plugin for WordPress. Adding more database servers to your environment in this manner allows your Wo

#wordpress #mysql #scaling #ubuntu


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials]]></description>
<dc:subject>mysql wordpress php optimization performance bestpractices devops .todo</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:2d18d0140d45/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:wordpress"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:optimization"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.todo"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-zabbix-to-securely-monitor-remote-servers-on-centos-7">
    <title>How To Install and Configure Zabbix to Securely Monitor Remote Servers on CentOS 7</title>
    <dc:date>2017-04-14T14:16:40+00:00</dc:date>
    <link>https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-zabbix-to-securely-monitor-remote-servers-on-centos-7</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Zabbix is open source monitoring software you can use to ensure the servers in your infrastructure are working properly so you can fix problems before they affect your users.

#monitoring #networking #high-availability #system-tools #php #apache #centos


refrr:https://www.digitalocean.com/community/tags/php?type=tutorials
Zabbix is open source monitoring software you can use to ensure the servers in your infrastructure are working properly so you can fix problems before they affect your users.

#monitoring #networking #high-availability #system-tools #php #apache #centos


refrr:https://www.digitalocean.com/community/tags/php?type=tutorials]]></description>
<dc:subject>apache php devops monitoring zabbix mysql</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:c3de2a2b5a3a/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:apache"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:php"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:monitoring"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:zabbix"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://www.digitalocean.com/community/tutorials/how-to-prepare-for-your-mysql-5-7-upgrade">
    <title>How To Prepare For Your MySQL 5.7 Upgrade</title>
    <dc:date>2017-04-14T13:30:06+00:00</dc:date>
    <link>https://www.digitalocean.com/community/tutorials/how-to-prepare-for-your-mysql-5-7-upgrade</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[This tutorial will help you prepare to upgrade to MySQL 5.7 from earlier versions. It covers `sql_mode` with practical examples of query responses that get stricter. The tutorial also contains instructions for checking for warnings and errors, and con

#mysql #scaling #arch #centos #coreos #debian #freebsd #rhel #ubuntu


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials
This tutorial will help you prepare to upgrade to MySQL 5.7 from earlier versions. It covers `sql_mode` with practical examples of query responses that get stricter. The tutorial also contains instructions for checking for warnings and errors, and con

#mysql #scaling #arch #centos #coreos #debian #freebsd #rhel #ubuntu


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials]]></description>
<dc:subject>mysql devops server</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:d8a65f8eab29/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:server"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://www.digitalocean.com/community/tutorials/how-to-configure-mysql-group-replication-on-ubuntu-16-04">
    <title>How To Configure MySQL Group Replication on Ubuntu 16.04</title>
    <dc:date>2017-04-14T13:21:49+00:00</dc:date>
    <link>https://www.digitalocean.com/community/tutorials/how-to-configure-mysql-group-replication-on-ubuntu-16-04</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[MySQL replication reliably mirrors the data and operations from one database to another. Conventional replication involves a primary server configured to accept database write operations. Secondary servers copy and apply actions from the primary's log

#scaling #clustering #mysql #ubuntu #ubuntu-16-04


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials
MySQL replication reliably mirrors the data and operations from one database to another. Conventional replication involves a primary server configured to accept database write operations. Secondary servers copy and apply actions from the primary's log

#scaling #clustering #mysql #ubuntu #ubuntu-16-04


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials]]></description>
<dc:subject>mysql scaling devops database server</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:275017fe0dca/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:scaling"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:server"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://www.digitalocean.com/community/tutorials/how-to-measure-mysql-query-performance-with-mysqlslap">
    <title>How To Measure MySQL Query Performance with mysqlslap</title>
    <dc:date>2017-04-14T02:29:23+00:00</dc:date>
    <link>https://www.digitalocean.com/community/tutorials/how-to-measure-mysql-query-performance-with-mysqlslap</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[mysqlslap is a diagnostic tool that can help you measure the performance of MySQL queries. This tutorial shows you how to perform tests of varying complexity, including a test that's practical for production environments with unknown queries.

#mysql #server-optimization #centos]]></description>
<dc:subject>mysql performance optimization testing load server devops database query troubleshooting automation tools ★</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:e56d474c69d6/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:optimization"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:testing"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:load"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:server"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:query"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:troubleshooting"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:automation"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:tools"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://serversforhackers.com/mysql-utf8-and-indexing">
    <title>MySQL, UTF8 and Indexing</title>
    <dc:date>2017-03-23T03:06:23+00:00</dc:date>
    <link>https://serversforhackers.com/mysql-utf8-and-indexing</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[What programmers need to know about servers.

#database #mysql


refrr:https://t.co/sA7kIAiNqc]]></description>
<dc:subject>mysql utf8 characters reference</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:eb5593a24980/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:utf8"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:characters"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://github.com/treffynnon/sqlstyle.guide">
    <title>treffynnon/sqlstyle.guide</title>
    <dc:date>2017-03-21T18:08:10+00:00</dc:date>
    <link>https://github.com/treffynnon/sqlstyle.guide</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[☛ Read the guide
☛ Read the guide]]></description>
<dc:subject>styleguide sql mysql bestpractices documentation .proj:styleguide resource ★</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:d89f4e1dac98/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:documentation"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:resource"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://raw.githubusercontent.com/treffynnon/sqlstyle.guide/gh-pages/_includes/sqlstyle.guide.md">
    <title>[untitled]</title>
    <dc:date>2017-03-21T18:07:10+00:00</dc:date>
    <link>https://raw.githubusercontent.com/treffynnon/sqlstyle.guide/gh-pages/_includes/sqlstyle.guide.md</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[refrr:https://www.simonholywell.com/post/2016/12/sql-style-guide-misconceptions/

refrr:https://www.simonholywell.com/post/2016/12/sql-style-guide-misconceptions/]]></description>
<dc:subject>styleguide sql mysql bestpractices documentation .proj:styleguide resource ★</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:e5056db8873a/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:sql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:bestpractices"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:documentation"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:.proj:styleguide"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:resource"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="https://ottomatik.io/">
    <title>Ottomatik - Super simple backup</title>
    <dc:date>2017-03-16T16:11:45+00:00</dc:date>
    <link>https://ottomatik.io/</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Secure your data now


refrr:https://medium.com/@taylorotwell/how-i-work-a22010d1ad82
Secure your data now


refrr:https://medium.com/@taylorotwell/how-i-work-a22010d1ad82]]></description>
<dc:subject>backup service devops mysql database aws</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:ae3538d2b828/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:backup"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:service"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:aws"/>
</rdf:Bag></taxo:topics>
</item>
<item rdf:about="http://www.unofficialmysqlguide.com/index.html">
    <title>The Unofficial MySQL 8.0 Optimizer Guide</title>
    <dc:date>2017-02-25T22:15:26+00:00</dc:date>
    <link>http://www.unofficialmysqlguide.com/index.html</link>
    <dc:creator>michaelfox</dc:creator><description><![CDATA[Morgan Tocker is the Product Manager for the MySQL Server at Oracle. He has previously worked in a variety of roles including Support, Training and Community. Morgan is based out of Toronto, Canada.   refrr:http://www.unofficialmysqlguide.com/?utm_source=dbweekly&utm_medium=email Morgan Tocker is the Product Manager for the MySQL Server at Oracle. He has previously worked in a variety of roles including Support, Training and Community. Morgan is based out of Toronto, Canada.   refrr:http://www.unofficialmysqlguide.com/?utm_source=dbweekly&utm_medium=email]]></description>
<dc:subject>mysql optimization performance database book reference documentation devops ★</dc:subject>
<dc:source>https://pinboard.in/</dc:source>
<dc:identifier>https://pinboard.in/u:michaelfox/b:6c48c1b892f4/</dc:identifier>
<taxo:topics><rdf:Bag>	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:mysql"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:optimization"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:performance"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:database"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:book"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:reference"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:documentation"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:devops"/>
	<rdf:li rdf:resource="https://pinboard.in/u:michaelfox/t:★"/>
</rdf:Bag></taxo:topics>
</item>
</rdf:RDF>