SQLite in version 3.45.0 brings a new feature - SQLite JSONB. This article will summarize how the standard JSON can be handled in SQLite, how it can be inserted and retrieved from tables. Additionally, it introduces SQLite JSONB and provides insights into its basic usage.
https://discussion.fedoraproject.org/t/an-overview-of-how-json-and-new-jsonb-can-be-used-with-sqlite/103662
Metadata Update from @rlengland: - Issue assigned to zmiklank - Issue tagged with: article, needs-image
@zmiklank I see a significant amount of work has been done on your article. Is it ready for reviewing and editing?
Hi, not yet. I am struggling little bit with the SEO at the moment. Will let you know when it is ready.
However, if you have any ideas how to improve the SEO status, the text itself is finished and ready to review: https://fedoramagazine.org/?p=39721&preview=1&_ppp=2ed264bef0
What changes are needed to improve the SEO status are found in one of the expandable sections in the controls at the bottom of the page when editing:
Metadata Update from @rlengland: - Custom field preview-link adjusted to https://fedoramagazine.org/?p=39721&preview=true
@zmiklank I've done a review/edit pass on your article.
I modified some sentence structures for readability and changed the code sections to preformatted to conform to the magazine standard.
One question I had is about the � symbol that appears in the return data in two examples. Were these intended to be there or are they artifacts of some embedded binary data?
Please review the article to make certain that I haven't misinterpreted anything or misrepresented something in my changes. I did my best to be true to your writing.
Thank you.
You can omit the data type of the column when creating table at all.
I'm not sure what this means? Perhaps you meant "... tables et al."?
When storing the JSON as a blob the jsonb() function can be use.
... can be used.
Otherwise, LGTM. 🙂
You can omit the data type of the column when creating table at all. I'm not sure what this means? Perhaps you meant "... tables et al."?
Corrected "used" but hopefully @zmiklank can clarify "tables at all"
Metadata Update from @rlengland: - Custom field editor adjusted to @rlengland - Custom field image-editor adjusted to @rlengland
It seems I wrote this sentence not the best way possible :). It should have been something like this instead:
"When creating a table, you have the option to omit specifying the data type of each column entirely."
I have corrected this in the article.
These symbols are intended to be there. jsonb functions (mostly) return binary representation of the JSON structure.
Thank you @rlengland and @glb for reviewing the article. I have re-read that and it seems OK to me.
Metadata Update from @rlengland: - Custom field preview-link adjusted to https://fedoramagazine.org/?p=39721&preview=1&_ppp=2ed264bef0 (was: https://fedoramagazine.org/?p=39721&preview=true) - Custom field publish adjusted to 2024-02-09
Metadata Update from @rlengland: - Issue untagged with: needs-image
Metadata Update from @rlengland: - Custom field publish adjusted to 2024-02-11 (was: 2024-02-09)
Metadata Update from @rlengland: - Custom field publish adjusted to 2024-02-12 (was: 2024-02-11)
Issue status updated to: Closed (was: Open) Issue close_status updated to: published