(Dave Stokes) The MySQL Document Store introduced with version 5.7.12 allows developers to create document collections without have to know Structured Query Language. The new feature also comes with a new set of terminology.
Tag: Open Source
How We Made MySQL Great Again, or Upgrading MySQL with Orchestrator
(Manjot Singh and Daniel Yosef) In this blog post, we’ll discuss upgrading MySQL with Orchestrator.
The new MySQL X DevAPI Protocol and what it means for PHP
(Dave Stokes) The relational database world just changed and you didn’t notice, did you? Rather than speaking SQL to your data, what if you could talk to it in PHP directly? No longer do you have to struggle to remember arcane structured query language syntax and just grab data with PHP.
How to rename MySQL DB by moving tables
RENAME DATABASE statement was removed from MySQL because it was found to be dangerous.
Simplifying MySQL Database Design using a Graphical Data Modeling Tool
(Rob Gravelle) A proper database design is essential to achieving your goals in working with a database, whether they prioritize rapid information retrieval, efficient storage, or some combination of both.
MySQL 5.7 Introduces a JSON Data Type
(Lorna Mitchell) There’s a new JSON data type available in MySQL 5.7 that I’ve been playing with. I wanted to share some examples of when it’s useful to have JSON data in your MySQL database and how to work with the new data types (not least so I can refer back to them later!)
NOT NULL all the things!
(Gabriela D’Ávila) Different types of languages deal with this “value” in diverse ways. You can have a more comprehensive list of what NULL can mean on this website. What I like to think about NULL is along the lines of invalid, as if some sort of garbage is stored there.
Creating Geo-Enabled applications with MongoDB, GeoJSON and MySQL
(Alexander Rubin) This blog post will discuss creating geo-enabled applications with MongoDB, GeoJSON and MySQL.
(MySQL) Performance Monitoring with Prometheus [UPDATE]
(Keine Kommentare) In my last I was looking for a way to do performance monitoring and I stumbled upon Prometheus. Prometheus is much more than monitoring a single node service. Anyway let’s get the idea of gathering metrics using MySQL as example.
MySQL Document Store Developments
(Peter Zaitsev) This blog will discuss some recent developments with MySQL document store.
