I could barely stuff this week’s OpenLampTech issue #31 into the email client to send out. It is that full! 🤣
(more…)#Reading
Weekly Reading for week of 02/09/2019
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 Roles Have Changed in MySQL 8.0 and How to Use Them (Courtesy of yours truly)
- How to produce meaningful datasets using only SQL (Fantastic Read)
- Support for LATERAL derived tables added to MySQL 8.0.14
- Inspecting the Content of a MySQL Histogram
- MySQL Tutorial – Understanding The Seconds Behind Master Value
- What is LOAD DATA and how does it work
- How long will a 64 bit Transaction-ID last in PostgreSQL?
- UUIDs in MySQL are really not random
- IMPLEMENTING “AS OF”-QUERIES IN POSTGRESQL
- An Overview of the Index Changes in PostgreSQL 11
Weekly Reading for week of 09-15-2018
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 Shell: Built-In Help
- How to Show MySQL Users
- Geolocation with PostgreSQL
- PL/pgSQL Example – Function That Returns A Table
- Advanced MySQL JSON_TABLE
- MySQL 8: Load Fine Tuning With Resource Groups
- Finding Records that Don’t Exist in PostgreSQL
- Understanding System Columns in PostgreSQL
- Comparing Data At-Rest Encryption Features for MariaDB, MySQL and Percona Server for MySQL
- A Missing Link in Postgres 11: Fast Column Creation with Defaults
- Getting Help in MySQL Shell
- Fast Full-Text Search in PostgreSQL
- A Guide to Partitioning Data In PostgreSQL
Weekly Reading – Week of 07-28-2018
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…
Weekly Reading for Week of 07/21/2018
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…