Skip to main content
Share Your Experience: Take the 2024 Developer Survey

New answers tagged

0 votes

Storing arrays of data in a time-series database

There are some options in this case. These include traditional relational tables and NoSQL databases. A database like MySQL has JSON data type (see MySQL - JSON Data Type - Creating JSON Values) which ...
prasad_'s user avatar
  • 446
0 votes

MySQL Trigger updating second table based on History and computed values

The final solution I got using @nbk adivice is: Remove trigger trg_BI_Lottery_Cycle_Missing Remove trigger trg_BI_Lottery_Cycle_Cycle Refactor the trigger trg_AI_Lottery_Cycle_Update_Lottery_Cycle ...
Wisdom's user avatar
  • 11
0 votes

Select rows where an item in a list of items is in a jsonb array of items

Use the "jsonb_exists_any" operator ?| taking text[] as right operand. The manual: Do any of the strings in the text array exist as top-level keys or array elements? SELECT * FROM ...
Erwin Brandstetter's user avatar

Top 50 recent answers are included