Sveta's blog (Comments)https://blogs.oracle.com/svetasmirnova/feed/comments/atom2015-07-24T07:19:20+00:00Apache Rollerhttps://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_0_4#comment-1426026182523Re: JSON UDF functions version 0.4.0 have been released Olivier Bertrand2015-03-10T22:23:02+00:002015-03-10T22:23:02+00:00
<p>Frederico,</p>
<p>Concerning MariaDB 10.0 you may be also interested to look at the JSON table type of the CONNECT storage plugin.</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_0_4#comment-1425859458367Re: JSON UDF functions version 0.4.0 have been released Sveta Smirnova2015-03-09T00:04:18+00:002015-03-09T00:04:18+00:00
<p>Thanks!</p>
<p>They built with 5.6.23, so they definitely work with 5.6 =) I test them with 5.5 and 5.7 also. They should work with Maria, but I never tested. I also heard that people have issues with compiling with Maria: you need to change inlude dir in CMakeLists.txt</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_0_4#comment-1425734885339Re: JSON UDF functions version 0.4.0 have been released Federico Razzoli2015-03-07T13:28:05+00:002015-03-07T13:28:05+00:00
<p>Definitely interesting. Do these functions work with 5.6? And MariaDB 10.0?</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_04#comment-1424952281034Re: JSON UDF functions version 0.3.2 have been releasedSveta Smirnova2015-02-26T12:04:41+00:002015-02-26T12:04:41+00:00
<p>I think you don't understand purpose of this project. This project is not to pretend that MySQL has *built-in* JSON support, but to provide necessary functionality for users who need JSON functions *now* and in *any* MySQL version.</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_04#comment-1424884675195Re: JSON UDF functions version 0.3.2 have been releasedguest2015-02-25T17:17:55+00:002015-02-25T17:17:55+00:00
<p>Cool. How many more years of half-assed UDF &quot;development&quot; releases so you can keep pretending mysql has JSON functionallity? </p>
https://blogs.oracle.com/svetasmirnova/entry/memory_summary_tables_in_performance#comment-1423950681606Re: Memory summary tables in Performance Schema in MySQL 5.7guest2015-02-14T21:51:21+00:002015-02-14T21:51:21+00:00
<p>Wow this is amazing. We need 5.7 to be production ready! </p>
https://blogs.oracle.com/svetasmirnova/entry/mysql_plugin_for_oracle_enterprise#comment-1420117369033Re: MySQL Plugin for Oracle Enterprise Manager on VirtualBox: installation gotchasDani&euml;l van Eeden2015-01-01T13:02:49+00:002015-01-01T13:02:49+00:00
<p>Great to see the use of vboxmanage instead of some none-scriptable GUI walkthrough.</p>
<p>I would have used --resizefs with lvextend as that reduces the change for errors (esp. when shrinking filesystems).</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_01#comment-1419312548192Re: JSON UDF functions version 0.3.0 have been released.Sveta Smirnova2014-12-23T05:29:08+00:002014-12-23T05:29:08+00:00
<p>Dowload from MySQL Labs at <a href="http://labs.mysql.com/," rel="nofollow">http://labs.mysql.com/,</a> use instructions in README file to install</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_01#comment-1419301291175Re: JSON UDF functions version 0.3.0 have been released.guest2014-12-23T02:21:31+00:002014-12-23T02:21:31+00:00
<p>how can I get it? and install it?</p>
https://blogs.oracle.com/svetasmirnova/entry/performance_schema_memory_tables_and#comment-1419267724387Re: Performance Schema memory tables and rightless usersSveta Smirnova2014-12-22T17:02:04+00:002014-12-22T17:02:04+00:00
<p>And to be absolutely pedantic even if you want to examine memory usage of current connection you should write a bit more complicated query:</p>
<p>mysql&gt; select * from sys.memory_by_thread_by_current_bytes where thread_id in(select thread_id from performance_schema.threads where processlist_id=CONNECTION_ID())\G<br/>
*************************** 1. row ***************************<br/>
thread_id: 20<br/>
user: root@localhost<br/>
current_count_used: 625<br/>
current_allocated: 1.59 MiB<br/>
current_avg_alloc: 2.60 KiB<br/>
current_max_alloc: 454.50 KiB<br/>
total_allocated: 16.30 MiB<br/>
1 row in set (0.21 sec)</p>
<p>thread_id != processlist_id</p>
https://blogs.oracle.com/svetasmirnova/entry/performance_schema_memory_tables_and#comment-1419244763704Re: Performance Schema memory tables and rightless usersSveta Smirnova2014-12-22T10:39:23+00:002014-12-22T10:39:23+00:00
<p>@guest</p>
<p>CONNECTION_ID() returns id of current connection, but we are usually interested in memory usage of another connection.</p>
https://blogs.oracle.com/svetasmirnova/entry/performance_schema_memory_tables_and#comment-1419221451143Re: Performance Schema memory tables and rightless usersguest2014-12-22T04:10:51+00:002014-12-22T04:10:51+00:00
<p>select * from sys.memory_by_thread_by_current_bytes where thread_id in(CONNECTION_ID())</p>
https://blogs.oracle.com/svetasmirnova/entry/performance_schema_memory_tables_and#comment-1418335477141Re: Performance Schema memory tables and rightless usersanton2014-12-11T22:04:37+00:002014-12-11T22:04:37+00:00
<p>Good we now can catch such issues! Thanks!</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_03#comment-1415770927894Re: JSON UDF functions version 0.3.1 have been released.guest2014-11-12T05:42:07+00:002014-11-12T05:42:07+00:00
<p>Issue seems fixed now</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_03#comment-1407354587575Re: JSON UDF functions version 0.3.1 have been released.Sveta Smirnova2014-08-06T19:49:47+00:002014-08-06T19:49:47+00:00
<p>Not needed, posted myself at <a href="http://bugs.mysql.com/bug.php?id=73486" rel="nofollow">http://bugs.mysql.com/bug.php?id=73486</a></p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_03#comment-1406851461379Re: JSON UDF functions version 0.3.1 have been released.Sveta Smirnova2014-08-01T00:04:21+00:002014-08-01T00:04:21+00:00
<p>Yes, looks like a bug. Please report at bugs.mysql.com</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_03#comment-1406842851033Re: JSON UDF functions version 0.3.1 have been released.guest2014-07-31T21:40:51+00:002014-07-31T21:40:51+00:00
<p>Possibly a bug (0.3.1): <br/>
select json_set('{}', 'a', '&quot;b&quot;') =&gt; {} (empty object)<br/>
expeted result:<br/>
select json_set('{}', 'a', '&quot;b&quot;') =&gt; {&quot;a&quot;:&quot;b&quot;}<br/>
Thank you.</p>
https://blogs.oracle.com/svetasmirnova/entry/mysql_and_postgresql_json_functions#comment-1404838468359Re: MySQL and PostgreSQL JSON functions: do they differ much?guest2014-07-08T16:54:28+00:002014-07-08T16:54:28+00:00
<p>I don't know what Oracle supports (I assume you should visit OOW for latest news: <a href="https://oracleus.activeevents.com/2014/connect/search.ww#loadSearch-event=null&amp;searchPhrase=json&amp;searchType=session&amp;tc=0&amp;sortBy=&amp;p=&amp;i%2810009%29=10105)," rel="nofollow">https://oracleus.activeevents.com/2014/connect/search.ww#loadSearch-event=null&amp;searchPhrase=json&amp;searchType=session&amp;tc=0&amp;sortBy=&amp;p=&amp;i%2810009%29=10105),</a> but MySQL does not support JSON indexing now.</p>
https://blogs.oracle.com/svetasmirnova/entry/mysql_and_postgresql_json_functions#comment-1404837728812Re: MySQL and PostgreSQL JSON functions: do they differ much?it support2014-07-08T16:42:08+00:002014-07-08T16:42:08+00:00
<p>what's about json indexing in MySQL and Oracle ? We added json indexing for PostgreSQL 9.4 and are working on more advanced indexing for 9.5.</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_01#comment-1404764283373Re: JSON UDF functions version 0.3.0 have been released.Sveta Smirnova2014-07-07T20:18:03+00:002014-07-07T20:18:03+00:00
<p>Thank you, it support, for the compliments!</p>
<p>But which problem do you have?</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_01#comment-1404763995538Re: JSON UDF functions version 0.3.0 have been released.it support2014-07-07T20:13:15+00:002014-07-07T20:13:15+00:00
<p>These JSON Udf's are potentially just gold for MySQL!<br/>
But I have one problem to use them. </p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_03#comment-1404291243454Re: JSON UDF functions version 0.3.1 have been released.Sveta Smirnova2014-07-02T08:54:03+00:002014-07-02T08:54:03+00:00
<p>You need to install functions first. Please read README file and use script install_jsonudf.sql</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_03#comment-1403799843795Re: JSON UDF functions version 0.3.1 have been released.guest2014-06-26T16:24:03+00:002014-06-26T16:24:03+00:00
<p>I'm trying to run the json_extract function through cmd bt I'm getting a error showing function db.json_extract donot exist what shud I do.??? Plzzz guide me..</p>
https://blogs.oracle.com/svetasmirnova/entry/mysql_and_postgresql_json_functions#comment-1395260908631Re: MySQL and PostgreSQL JSON functions: do they differ much?Sveta Smirnova2014-03-19T20:28:28+00:002014-03-19T20:28:28+00:00
<p>Hi Oleg,</p>
<p>good topic! Probably I should write one more blog post. But looks like we have to compare third-party solutions (<a href="http://sourceforge.net/projects/pljson/)," rel="nofollow">http://sourceforge.net/projects/pljson/),</a> APIs (<a href="http://www.oracle.com/technetwork/articles/java/json-1973242.html)" rel="nofollow">http://www.oracle.com/technetwork/articles/java/json-1973242.html)</a> and upcoming features (<a href="http://technology.amis.nl/2013/09/26/oow13-schema-less-data-management-using-sqljson/)." rel="nofollow">http://technology.amis.nl/2013/09/26/oow13-schema-less-data-management-using-sqljson/).</a> I even cannot find official documentation of native JSON support in Oracle. Looks like it is not in 12c yet. But very promising!</p>
https://blogs.oracle.com/svetasmirnova/entry/mysql_and_postgresql_json_functions#comment-1395258807863Re: MySQL and PostgreSQL JSON functions: do they differ much?Oleg Bartunov2014-03-19T19:53:27+00:002014-03-19T19:53:27+00:00
<p>Sveta,</p>
<p>what's about json indexing in MySQL and Oracle ? We added json indexing for PostgreSQL 9.4 and are working on more advanced indexing for 9.5.</p>
<p>Oleg</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_01#comment-1393159871019Re: JSON UDF functions version 0.3.0 have been released.Yaniv Hakim2014-02-23T12:51:11+00:002014-02-23T12:51:11+00:00
<p>Thanks! :)<br/>
I filed a bug as you requested.</p>
<p>Looking forward for your fix!</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_01#comment-1393151451861Re: JSON UDF functions version 0.3.0 have been released.Sveta Smirnova2014-02-23T10:30:51+00:002014-02-23T10:30:51+00:00
<p>Hi Yaniv,</p>
<p>yes, I can consider adding this feature. Please file a request at bugs.mysql.com under JSON UDF category.</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_02#comment-1393148136155Re: JSON UDF functions version 0.2.2 have been released.Yaniv Hakim2014-02-23T09:35:36+00:002014-02-23T09:35:36+00:00
<p>Hi Sveta,</p>
<p>Thanks for your hard work!<br/>
These JSON Udf's are potentially just gold for MySQL!<br/>
But I have one problem to use them. <br/>
The only function I really need is the JSON merge but currently when merging two json docs it duplicates key's and values that are present on both the docs being merged instead of just updates the value with the new doc... for example: json_merge( {&quot;a&quot;:&quot;b&quot;}, {&quot;a&quot;:&quot;c&quot;} ) returns: {&quot;a&quot;:&quot;b&quot;,&quot;a&quot;:&quot;c&quot;} instead of: {&quot;a&quot;:&quot;c&quot;}<br/>
this is causing the returned doc to be non serializable and i think non legal json. <br/>
what i really need is a function that acts like json_set but for two json docs..</p>
<p>can you please add this?</p>
<p>thanks!</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_01#comment-1393147123814Re: JSON UDF functions version 0.3.0 have been released.Yaniv Hakim2014-02-23T09:18:43+00:002014-02-23T09:18:43+00:00
<p>Hi Sveta,</p>
<p>These JSON Udf's are potentially just gold for MySQL!<br/>
But I have one problem to use them. <br/>
The only function I really need is the JSON merge but currently when merging two json docs it duplicates key's and values that are present on both the docs being merged instead of just updates the value with the new doc... for example: json_merge( {&quot;a&quot;:&quot;b&quot;}, {&quot;a&quot;:&quot;c&quot;} ) returns: {&quot;a&quot;:&quot;b&quot;,&quot;a&quot;:&quot;c&quot;} instead of: {&quot;a&quot;:&quot;c&quot;}<br/>
this is causing the returned doc to be non serializable and i think non legal json. <br/>
what i really need is a function that acts like json_set but for two json docs..</p>
<p>can you please add this?</p>
<p>thanks!</p>
https://blogs.oracle.com/svetasmirnova/entry/json_udf_functions_version_02#comment-1391097328667Re: JSON UDF functions version 0.2.2 have been released.Todd Farmer2014-01-30T15:55:28+00:002014-01-30T15:55:28+00:00
<p>Great work, Sveta - thanks for your continued dedication to making JSON data more consumable within MySQL!</p>