Tagged articles

json

505 articles · Page 6 of 6
dbaplus Community
dbaplus Community
Feb 3, 2016 · Databases

What Makes PostgreSQL Superior? Data Types, Indexes, and Queries Compared

This article examines why PostgreSQL claims to be the most advanced open‑source database by detailing its object‑relational model, extensive native data types, large‑scale size limits, robust ACID compliance, powerful indexing options, flexible virtual table features, built‑in functions, language extensions, and how these capabilities compare to MySQL, MariaDB and Firebird.

CTEData TypesDatabase Comparison
0 likes · 21 min read
What Makes PostgreSQL Superior? Data Types, Indexes, and Queries Compared
Qunar Tech Salon
Qunar Tech Salon
Jul 27, 2015 · Frontend Development

JavaScript JSON Number Handling and Integer Overflow Issues

The article explains how JavaScript interprets JSON values without quotation marks as numbers, demonstrates the difference between numeric and string representations of the same value, and warns that large numeric literals may overflow a 32‑bit integer during internal conversion.

Data TypesJavaScriptinteger overflow
0 likes · 2 min read
JavaScript JSON Number Handling and Integer Overflow Issues
MaGe Linux Operations
MaGe Linux Operations
Apr 14, 2015 · Databases

Unlocking MySQL 5.7 JSON: Native Support, Indexing, and Virtual Columns

This article explains how MySQL 5.7 introduced native JSON support with validity checks, performance improvements, and virtual column indexing, compares it to MariaDB's dynamic column and PostgreSQL, and provides step‑by‑step SQL examples for creating, inserting, querying, and indexing JSON data.

DatabaseIndexingMySQL
0 likes · 5 min read
Unlocking MySQL 5.7 JSON: Native Support, Indexing, and Virtual Columns
Baidu Tech Salon
Baidu Tech Salon
Dec 15, 2014 · Frontend Development

Build a Simple Baidu Translate Desktop App with WPF in Minutes

This guide walks you through creating a lightweight WPF desktop application that leverages Baidu Translate’s public API to translate words, covering API key acquisition, HTTP GET requests, JSON parsing with Newtonsoft.Json, UI design in XAML, and handling special characters, enabling instant word translation without ads.

APIBaidu TranslateC++
0 likes · 9 min read
Build a Simple Baidu Translate Desktop App with WPF in Minutes