Support for NoSQL/JSON Data Type

Post Reply
PhYrE
User
Posts: 1

Support for NoSQL/JSON Data Type

Post by PhYrE »

Is there any plans for NoSQL/JSON Support. MySQL 5.7/MariaDB 10.2.7/PostgreSQL 9 support a JSON Data Type: https://dev.mysql.com/doc/refman/5.7/en/json.html / https://mariadb.com/resources/blog/json-mariadb-102 / https://www.postgresql.org/docs/9.4/sta ... -json.html

Doing so could allow for a field like the one below, that lets you put any number of attributes into a field and make them searchable/indexable/etc. It allows for a mix of dissimilar products to be stored in one database without reserving space. It allows for a single field for contact information instead of a field for each item of a users' contact info.

NoSQL is becoming increasingly popular and an implementation of being able to put and pull fields in/out of a JSON field would be amazing!

{
  "video": {
     "resolution": "1080p",
     "aspectRatio": "1.85:1"
  },
  "cuts": [{
     "name": "Theatrical",
     "runtime": 138
  },
  {
     "name": "Special Edition",
     "runtime": 155
  }
  ],
  "audio": ["DTS HD", "Dolby Surround"]
}

josejad
User
Posts: 117
Location: Spain

Post by josejad »

+1


aidas
User
Posts: 3

Post by aidas »

+1


amneo
User
Posts: 28

Post by amneo »

+1


newbiephp
User
Posts: 304

Post by newbiephp »

+1


mobhar
User
Posts: 11727

Post by mobhar »

+1


sangnandar
User
Posts: 980

Post by sangnandar »

+1


twuc
User
Posts: 72

Post by twuc »

+1


bioaroma
User
Posts: 24

Post by bioaroma »

+1


Webmaster
User
Posts: 9427

Post by Webmaster »

PHPMaker 2020 allows MySQL/PostgreSQL JSON data types as string types.


Post Reply