SQLite 3.45加入JSONB格式支援
· 2024-01-19

SQLite 3.45添加JSONB二進位表示方式,能以更高效靈活的方式儲存和處理JSON資料

知名資料庫SQLite發布最新的3.45版本,該版本其中一項值得注意的更新,在於JSON SQL函式的強化。SQLite 3.45所有JSON函式都被重寫,改用新的內部解析樹格式JSONB,JSONB格式可以序列化並儲存在資料庫中,避免在使用JSON值時,還需要進行不必要的重複解析,因此透過支援JSONB,SQLite在處理JSON資料能夠更高效靈活。

JSONB是一種新的二進位表示方式,用於內部儲存和處理JSON資料,SQLite支援JSONB的目的,便是要提高處理JSON資料的效率和效能。JSONB能夠將JSON的解析樹,以BLOB二進位的形式儲存在磁碟上,且可以減少應用程式讀取和更新JSON值的解析和渲染開銷,比起JSON,JSONB使用更小的磁碟空間,在處理速度上更快。

透過支援JSONB,SQLite還能更好地與其他二進位JSON格式系統整合,除此之外,雖然目前SQLite的JSONB不支援O(1)時間複雜度元素查詢,但在其格式保留添加該功能的空間,因此未來版本的效能可能還會有進一步提高。

SQLite承諾其生成的JSONB保證格式良好,但是由於JSONB本質上就是一個BLOB,因此可能存在格式不正確的JSONB,而SQLite在處理格式不正確的JSONB,就可能出現不同行為,像是產生錯誤、回傳正確或是錯誤答案等情況發生。不過SQLite也保證,格式錯誤的JSONB永遠不會導致記憶體錯誤或是類似問題,也不會出現系統漏洞。

Popular articles
SBC Summit Canada to Make Player Safety a Key Pillar of 2026 Agenda
Marketing
1spin4win grows its Latin American presence by partnering with Fortuna Juegos
Online Game
Indiana online casino bill stalls in House committee
Regulation
That’s a Wrap: AffPapa Conference Madrid 2026 Highlights
Online Game
Super PAC Raises $48 Million: Sports Betting Forces Ramp Up Political Push
Regulation
PropellerAds Positions Itself as a Go-To Traffic Source for iGaming Advertisers Ahead of a High-Demand Season
Marketing
Online gambling, crypto pose ongoing money laundering risks in Philippines, analyst says
Southeast Asia
JILI Partners with Cricket Legend AB de Villiers (ABD) to Launch Exclusive Branded Game Series 100% 11
Sports Game
Global Game Connect (GGC) 2027 Officially Opens Sponsorship & Exhibition Opportunities in Sri Lanka!
HUIDU Focus
UK MPs reopen 2025 gambling inquiry as reform stalls
Regulation
GAT CDMX 2025 Institutional Academy: Leaders and Experts Analyze the Present and Future of the Gaming Industry in Mexico and Lat
Sports Game
Full House at GAT Expo Cartagena 2026 Academic Agenda
Online Game
Vietnam’s Controlled Gaming Shift Gains Ground, But Domestic Demand Still Lags
Southeast Asia
Manila delivers: Highlights from SiGMA Asia 2026 
Southeast Asia
Brazil Proposes Raising Gambling Tax Rate to 24%, With Revenue Allocated to Social Security and Healthcare
Regulation
Home
Game
Cooperation
Find
My