Page 1 of 1

Support for NoSQL/JSON Data Type

Posted: Tue Aug 14, 2018 5:12 am
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"]
}

Re: Support for NoSQL/JSON Data Type

Posted: Thu Oct 25, 2018 6:06 pm
by josejad

+1


Re: Support for NoSQL/JSON Data Type

Posted: Sun Nov 25, 2018 7:11 pm
by aidas

+1


Re: Support for NoSQL/JSON Data Type

Posted: Mon Mar 18, 2019 3:29 am
by amneo

+1


Re: Support for NoSQL/JSON Data Type

Posted: Thu Jun 20, 2019 4:42 pm
by newbiephp

+1


Re: Support for NoSQL/JSON Data Type

Posted: Fri Jun 21, 2019 9:25 am
by mobhar

+1


Re: Support for NoSQL/JSON Data Type

Posted: Tue Jun 25, 2019 5:20 am
by sangnandar

+1


Re: Support for NoSQL/JSON Data Type

Posted: Thu Jun 27, 2019 9:58 pm
by twuc

+1


Re: Support for NoSQL/JSON Data Type

Posted: Thu Jul 11, 2019 3:27 am
by bioaroma

+1


Re: Support for NoSQL/JSON Data Type

Posted: Wed Aug 07, 2019 9:27 am
by Webmaster

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