Database Programming

Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…

• How to Customize your MySQL & MariaDB Backups with ClusterControl
  
• Take a Dip into PostgreSQL Arrays
• Data Masking in MySQL
• MySQL Shell: API Command Line Integration for DevOps
• Tracking Foreign Keys
• Tracking foreign keys throughout a schema
• Care To Know Clauses: All About SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, and LIMIT (Courtesy of yours truly)
• Utilizing Encryption to Strengthen PostgreSQL Database Security
• Auto-Refreshing Reports in MySQL Shell
• Importing Data from MongoDB to MySQL using JavaScript
• An Introduction to Join Ordering
• Pager for the New MySQL Shell
  
• Delayed Replication with Amazon RDS
• PostgreSQL and heap-only-tuples updates – part 1

Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…

• PostgreSQL locking, part 2: heavyweight locks
• A Poor Man’s Column Oriented Database in PostgreSQL
• How to Set up a Password as a Default User in PostgreSQL
• It’s just an expression
• The Biggest Mistake Postgres Ever Made
• PostgreSQL locking, part 3: lightweight locks
• MySQL on Docker: Running ProxySQL as Kubernetes Service
• SQL Firewalling Made Easy with ClusterControl & ProxySQL
• How to Create a Single Endpoint for your PostgreSQL Replication setup using HAProxy
• MySQL Shell 8.0.13 Prompt: Now with New Line Support
• GH-OST for MySQL Schema Change.
• On the consequences of sync_binlog != 1 (part #1)
• Remember your history
• Materialized views vs. Rollup tables in Postgres
• Temporary tables are now allowed in transactions when GTIDs are enabled
• OmniDB debugger for PostgreSQL 11
• PostgreSQL: Efficient Queries – Indexing
• Migrating from MSSQL to PostgreSQL – What You Should Know
• KILLED INDEX TUPLES

Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…

• MySQL : InnoDB Transparent Tablespace Encryption
• Replication Monitoring with the Performance Schema
• Persistence of autoinc fixed in MySQL 8.0
• Some Tips on Using Arrays in PostgreSQL
• PostgreSQL: The Versatile INSERT
• POSTGRESQL: IMPROVING SORT PERFORMANCE
• Won’t You Be My Neighbor? Quickly Finding Who is Nearby
• How to update large tables in PostgreSQL
• ARE YOUR FOREIGN KEYS INDEXED?
• Instrumenting Read Only Transactions in InnoDB
• Managing Freezing in PostgreSQL
• Find the number of the longest continuously rising days for a stock
• PostgreSQL Tips: Documenting the Database
• MySQL 8: Performance Schema Digests Improvements
• Track PostgreSQL Row Changes Using Public/Private Key Signing
• Generating Identifiers – from AUTO_INCREMENT to Sequence
• Upgrading to PostgreSQL 11 with Logical Replication
  
• dentifying High Load Spots in MySQL Using Slow Query Log and pt-query-digest
• PostgreSQL locking, Part 1: Row Locks
• IDEAS FOR SCALING POSTGRESQL TO MULTI-TERABYTE AND BEYOND
• Export to JSON from MySQL All Ready for MongoDB
• One Billion Tables in MySQL 8.0 with ZFS
• MySQL on Docker: Running ProxySQL as a Helper Container on Kubernetes
• Commenting your Postgres database