Stack Overflow
Stack Overflow

Questions tagged [common-schema]

a self contained schema which includes a set of sophisticated views, routines and a specialized scripting language (QueryScript), simplifying MySQL server administration and analysis.

common_schema provides with:

A function library (text functions, security routines, execution and flow control, more...) A set of informational and analysis views (security, schema design, processes, transactions, more...) QueryScript interpreter, allowing for server side scripting. rdebug: a debugger and debugging API for MySQL stored routines (alpha) It introduces SQL based tools which simplify otherwise complex shell and client scripts, allowing the DBA to be independent of operating system, installed packages and dependencies.

It is a self contained schema, compatible with all MySQL >= 5.1 servers. Installed by importing the schema into the server, there is no need to configure nor compile. No special plugins are required, and no changes to your configuration.

6 questions
1
vote
1 answer

DBT - best practices on schema to which the dbt deployed models should belong to?

I am working on a database intensive project where there are lots of schemas and tables/views etc that are created in these schemas. My question is around the best practice or recommended practice on to what schema should all the DBT deployed models…
user961
  • 453
  • 6
  • 20
1
vote
1 answer

Using common_schema library not able to parse the json array values

We are using this common_schema library in mysql 5.6 to extract the values from json array. The format is given below. But it returns the NULL value. So, can you please help us out how to parse the json array using common_schema. select…
Kalyan
  • 263
  • 5
  • 22
1
vote
1 answer

How to use common_schema inside mysql trigger?

I have to manipulate json object inside mysql trigger. For this I have already installed common_schema. It is installed successfully and whlie quering directly it is proving approptiate results. However while using same query inside mysql trigger it…
Garima Chowrasia
  • 11
  • 4
0
votes
1 answer

split() not working with mySQL join?

I'm currently using the mySQL common schema package along with the split() function, but I'm struggling to get a working JOIN query to work? set @script := " split({size:2000} : UPDATE world SET world.CountryName = ( …
Curtis
  • 2,646
  • 6
  • 29
  • 53
0
votes
1 answer

Extracting value using common_schema not working for nested JSON

I have a DB field called data of type is MEDIUMTEXT, which stores values in JSON format. I'm using extract_json_value method from common_schema. When JSON is not nested, it works fine. For example, when applications_data table's data field is { …
baqx0r
  • 105
  • 1
  • 2
  • 11
0
votes
1 answer

How to extract value from JSON with common_schema?

I have a JSON string (in MySQL) and I want to get the name where id=2: SET @json := ' { "list": [ {"id": "1", "name": "John"}, {"id": "2", "name": "Ben"}, {"id": "3", "name": "Clara"} ] } …
P.G
  • 11
  • 2