Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 10

Displaying posts with tag: udfs (reset)

JSON UDF functions version 0.3.2 have been released
Employee_Team +1 Vote Up -0Vote Down

Today new version of JSON UDF functions: 0.3.2 was released. This is development release which contains new functionality. You can download functions from the MySQL Labs website.

What is new?

New function `JSON_COUNT` added. This function returns number of children of the key path specified. If no key path specified, number of children of the root element is returned. Bug #70580/17584692 ADD FUNCTION `JSON_COUNT` TO COUNT SIZE OF JSON DOCUMENT

mysql> select json_count('{"MySQL Central": ["conference", …
  [Read more...]
JSON UDF functions version 0.3.1 have been released.
Employee_Team +1 Vote Up -0Vote Down

Today new version of JSON UDF functions: 0.3.1 was released. This is development release which contains new functionality. You can download functions from the MySQL Labs website.

What is new?

Default value for compile option `WITH_PCRE` now is `bundled` independently from the
platform (Bug #71265/18081332 Library name mismatch for PCRE on Ubuntu)

New values, passed to functions `JSON_APPEND`, `JSON_REPLACE`, `JSON_SET` as numbers, empty strings or `NULL`s are converted to JSON objects. …



  [Read more...]
Why is important to be active at bugs.mysql.com?
Employee_Team +1 Vote Up -0Vote Down

When I presented JSON UDF functions at MySQL Connect last year attendees asked me to implement few features. I quickly wrote their wishes in my notepad. I also created feature requests at bugs.mysql.com  when I was home.

During following months I fixed bugs in the functions and implemented feature requests, including those which I got from MySQL Connect. I started from most important and affecting users, such as wrong results bugs of features for which I got more than one request.

But today all such requests finished and I am working on …

  [Read more...]
JSON UDF functions version 0.2.2 have been released.
Employee_Team +1 Vote Up -0Vote Down

New version of JSON UDF functions 0.2.2 have been just released. It is last maintenance release of 0.2 series. However it contains two new features:

JSON_VALID now accepts array as a root element of the JSON document (Bug#70567/17583282)

JSON functions can now be installed and uninstalled using a script (Bug#71263/18022788 Easy installation sql script).

This feature is Community contribution. Thank you, Daniel van Eeden!

This release also contains …







  [Read more...]
JSON UDF functions version 0.3.0 have been released.
Employee_Team +1 Vote Up -0Vote Down

Today new version of JSON UDF functions: 0.3.0 was released. This is major release which contains new functionality. You can download functions from the MySQL Labs website.

What was added?

Functions JSON_EXTRACT, JSON_CONTAINS_KEY, JSON_APPEND, JSON_REMOVE, JSON_REPLACE, JSON_SET now accept both string and integer arguments as array indexes. (Bug #70393/17491709)

Now syntax JSON_EXTRACT(doc, 'key', 1); is accepted.

New function JSON_SAFE_MERGE checks JSON documents for validity before merging them. In addition …







  [Read more...]
JSON UDFs first feedback
Employee_Team +1 Vote Up -0Vote Down

Yesterday Ulf Wendel created great blog post with deep analysis of JSON UDF functions which I presented at MySQL Connect at September, 21.

Ulf found few bugs in these functions, I reported them all at bugs.mysql.com. You can find numbers in my comment to his blog post. But he also raised concerns, which can not be considered pure bugs, rather feature requests, or even design especiallities.

* First concern, of course, is the documentation. Ulf writes: "Here’s what the README, the only documentation available apart from the …



  [Read more...]
Memcached Functions For MySQL 1.1 Released
+1 Vote Up -0Vote Down

I'm pleased to announce the release of Memcached Functions for MySQL version 1.1. I realized in the past few weeks, while writing my latest book "Expert PHP and MySQL", that there was no way to obtain the CAS value of a cached item in order to successfully use the function memc_cas(). So, I decided to create a new function, memc_get_cas(), which obtains the CAS value for an item so you can subsequently use this value in a memc_cas() call, which is shown in the example below:

mysql> select memc_get_cas('t1'); …


  [Read more...]
memcached talk tonight, ManadLUG
+0 Vote Up -0Vote Down

I have a talk scheduled tonight, for anyone who's in the Southern New Hampshire area (or greater Northern New England area): http://permalink.gmane.org/gmane.org.user-groups.linux.gnhlug.announce/743

I'll be going over a number of things, time permitting:

* memcached (in general)
* NorthScale's memcached Amazon Machine Images and Virtual Appliance
* moxi - memcached proxy
* memcached Functions for MySQL

I'll run a couple demonstrations with each, first simple memcached usage, then using two memcached instances …








  [Read more...]
Drizzle may now sleep!
+1 Vote Up -0Vote Down

I realized the other day that I need the sleep() function, which up until this morning, Drizzle did not have, for testing the memcached Drizzle UDFs. Well, now it does:

drizzle> select sleep(3);
+----------+
| sleep(3) |
+----------+
| 0 |
+----------+
1 row in set (3 sec)

drizzle> select sleep(0);
+----------+
| sleep(0) |
+----------+
| 0 |
+----------+
1 row in set (0 sec)

drizzle> select sleep(20);
+-----------+
| sleep(20) |
+-----------+
| 0 |
+-----------+
1 row in set (20 sec)



























  [Read more...]
memcached Functions for MySQL now on launchpad
+0 Vote Up -0Vote Down

Hi all,

This is a quick post to let you know that the memcached functions for MySQL have been moved to Launchpad. The project page is: https://launchpad.net/memcached-udfs

I think this will help to get the project more exposure, as well as making it easier for people to contribute to the project. I've found Launchpad to be quite useful for managing projects and so decided to move the UDFs there.

I'm working on getting out another version soon. I just fixed a bug the deals with user-defined variables that were set to NULL causing the UDFs to crash the server. It was a bug in …





  [Read more...]
Showing entries 1 to 10 of 10

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.