NomadPHP and MySQL JSON Lightening Talk

Nhận đường liên kết
Facebook
X
Pinterest
Email
Ứng dụng khác

tháng 10 12, 2016

I will be presenting a short lightening talk on MySQL's JSON Data Type for NomandPHP on Thursday the 13th of October

. Chuck Reeves will be doing the main presentation on How the 3rd Normal Form Destroyed a Family. Get your tickets here.

Nhận đường liên kết
Facebook
X
Pinterest
Email
Ứng dụng khác

Nhận xét

Đăng nhận xét

Bài đăng phổ biến từ blog này

Using MySQL to Output JSON

tháng 1 06, 2017

MySQL has had a JSON data type since version 5.7 was released way back in '15. But did you know you could produce JSON output from non-JSON columns? It is very simple and saves a lot of time over trying to format it in your application. World Database We will be using the good old World database that MySQL has used for years in documentation, examples, and in the classroom. Starting with a simple query we will build up to something more complex. SELECT Name, District, Population FROM City; This will output the data from the table in a tabular format. 'Kabul', 'Kabol', '1780000' 'Qandahar', 'Qandahar', '237500' Array or Object? We have two options for composing JSON data: JSON_ARRAY and JSON_OBJECT . Of the two, you will find JSON_ARRAY the least fussy. It will JSON-ize your data very easily. It takes a list of values or an empty list and returns a JSON array. We add this function to our example query and it becomes SELECT JSON_...

Đọc thêm

Generated MySQL Columns and Changing Values

tháng 5 27, 2016

I was speaking at PHP[Tek] this week on the JSON Data Type and using generated columns. JSON columns can not be indexed but data from a JSON column can be extracted via a generated column and that column can be indexed. All was going well until someone asked me about modifying data in a generated column. Was it possible? I blinked hard. I have not tried that! I had not seen any mention of that in the documentation. So I had to admit that I did not know and would have to try that. The Test mysql> CREATE TABLE gentest (a INT, b INT AS (a + 1) STORED, INDEX(b)); ... mysql> INSERT INTO gentest VALUES (1),(2),(3),(4); ... So now we have a table with data to test. So lets try to modify the value of one of the generated columns. mysql> UPDATE gentest SET b = 9 WHERE a = 1; And what did the server do? It returned an error and told me The value specified for generated column 'b' in table 'gentest' is not allowed. Lesson Learned So now I know that the server wi...

Đọc thêm

MySQL Document Store: Getting Started

tháng 6 14, 2017

MySQL's new NoSQL database is quite a big change for all used to using a SQL speaking relational database. The Document Store makes use of the new MySQL Shell, the new X Protocol, and the new X Devapi to provide a NoSQL document storage service. This provides a way for developers to have a schema-less, NoSQL data store to build services and applications is a quick fashion without having to design a schema, normalize data, develop queries in SQL, or any of the rest of the overhead needed to create a relational databases. Behind the scenes and invisible to the developer is that the schema-less data is stores in a JSON type column in a MySQL instance. Please note that I am using JavaScript Mode (instead of SQL or Python) for these examples. No special reason. First Step The new MySQL Shell is a separate install from the server software. Once installed it will provide the ability to use MySQL as a document store. The db object is how we can communicate to the server and the world_x...

Đọc thêm