Comments on: common_schema 2.1 released: advanced & improved split(), persistent script tables, more schema analysis, and (ahem) charts! https://shlomi-noach.github.io/blog/mysql/common_schema-2-1-released-advanced-improved-split-persistent-script-tables-more-schema-analysis-and-ahem-charts Blog by Shlomi Noach Fri, 26 Jul 2013 04:25:00 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/common_schema-2-1-released-advanced-improved-split-persistent-script-tables-more-schema-analysis-and-ahem-charts/comment-page-1#comment-215606 Fri, 26 Jul 2013 04:25:00 +0000 https://shlomi-noach.github.io/blog/?p=6398#comment-215606 @HB
It depends on whether you need to filter your rows based on a JSON value. If not, there’s no point in using common_schema for that.

At any case benchmarking is on you: but do come back and let us know how goes!

]]> By: HB https://shlomi-noach.github.io/blog/mysql/common_schema-2-1-released-advanced-improved-split-persistent-script-tables-more-schema-analysis-and-ahem-charts/comment-page-1#comment-215573 Thu, 25 Jul 2013 23:27:25 +0000 https://shlomi-noach.github.io/blog/?p=6398#comment-215573 A quick question about extract_json_value, it is said it should be used with care because of performance hits, when using MySQL through other backend like PHP or ASP.NET would you advice rather getting the whole raw resultset data and decoding JSON avoiding common_schema? have you run any benchmark comparing one way over the other?

Sorry if this isn’t the right place to ask, but I’m new to common_schema, didn’t see any message board related to it, and I’m right now over a restricted mobile network connection.

]]> By: combuilder https://shlomi-noach.github.io/blog/mysql/common_schema-2-1-released-advanced-improved-split-persistent-script-tables-more-schema-analysis-and-ahem-charts/comment-page-1#comment-214795 Thu, 18 Jul 2013 08:06:28 +0000 https://shlomi-noach.github.io/blog/?p=6398#comment-214795 Great!!
I have a post talking about your framework, in spanish.

Here you have the link: http://www.manejandodatos.es/2013/07/frameworks-para-dba-en-mysql/

]]> By: Framework para DBA en MySQL - Manejando datos https://shlomi-noach.github.io/blog/mysql/common_schema-2-1-released-advanced-improved-split-persistent-script-tables-more-schema-analysis-and-ahem-charts/comment-page-1#comment-214794 Thu, 18 Jul 2013 07:49:14 +0000 https://shlomi-noach.github.io/blog/?p=6398#comment-214794 […] A los pocos días de publicar esta entrada, aparece la versión 2.1 de este framework commom_schema, con interesantes novedades. Tenéis toda la información aquí: https://shlomi-noach.github.io/blog/mysql/common_schema-2-1-released-advanced-improved-split-persistent-scr…. […]

]]>