Tagged articles
481 articles
Page 5 of 5
ITPUB
ITPUB
Nov 28, 2019 · Fundamentals

9 Essential JSON Validation and Formatting Tools Every Developer Should Know

This article introduces nine popular JSON utilities—including online validators, command‑line converters, IDE plugins, and formatters—detailing their main features, usage scenarios, and where to download or access their source code, helping developers choose the right tool for JSON processing tasks.

JSONWebdeveloper
0 likes · 6 min read
9 Essential JSON Validation and Formatting Tools Every Developer Should Know
Programmer DD
Programmer DD
Nov 27, 2019 · Backend Development

Master Fastjson: Fast Java JSON Parsing and Serialization Guide

This article introduces JSON basics, explains the Fastjson library from Alibaba, outlines its key features, and provides practical Java code examples for parsing, serializing, and converting between JSON strings, objects, arrays, maps, lists, and beans using Fastjson’s API.

DeserializationJSONJava
0 likes · 6 min read
Master Fastjson: Fast Java JSON Parsing and Serialization Guide
Programmer DD
Programmer DD
Nov 18, 2019 · Fundamentals

9 Essential JSON Tools Every Developer Should Know

Discover nine powerful JSON utilities—including online validators, formatters, CLI converters, and IDE plugins—that simplify parsing, validation, and editing, with direct links to each tool’s website or repository, helping developers efficiently work with JSON across various environments.

BackendJSONdeveloper tools
0 likes · 6 min read
9 Essential JSON Tools Every Developer Should Know
Architecture Digest
Architecture Digest
Nov 3, 2019 · Backend Development

Analyzing Spring Boot 2.2.0.RELEASE Configuration Loading Mechanism

This article examines how Spring Boot 2.2.0.RELEASE loads configuration files, where it searches for them, how it supports YAML and properties formats, how to add JSON support, the precedence of property sources, and the placeholder resolution process by tracing the relevant source code.

JSONPropertySourceSpring Boot
0 likes · 10 min read
Analyzing Spring Boot 2.2.0.RELEASE Configuration Loading Mechanism
ITPUB
ITPUB
Oct 9, 2019 · Databases

What’s New in PostgreSQL 12? Performance Boosts and Advanced Features

PostgreSQL 12 brings major enhancements—including up to 40% faster queries on large datasets, improved indexing, partitioning, JSON path queries, generated columns, pluggable table access methods, stronger authentication, and built‑in JIT compilation—while also adding better localization, multi‑constraint authorization, and convenient maintenance commands.

JSONPartitioningPostgreSQL
0 likes · 6 min read
What’s New in PostgreSQL 12? Performance Boosts and Advanced Features
Programmer DD
Programmer DD
Sep 12, 2019 · Backend Development

Master JSON Serialization in Java: A Deep Dive into Gson

This article walks through why developers should replace FastJson with Gson, explains Gson's core features, demonstrates basic and advanced serialization and deserialization—including handling arrays, collections, generic types, custom serializers, and annotations—while providing complete code examples and best‑practice tips.

DeserializationGsonGsonBuilder
0 likes · 20 min read
Master JSON Serialization in Java: A Deep Dive into Gson
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 5, 2019 · Databases

Using MySQL 8.0 JSON Error Log Output and Filtering

MySQL 8.0 adds JSON‑formatted error logs and flexible filtering components, allowing administrators to install JSON sink and filter modules, extract specific fields with tools like jq, and apply rules that drop or throttle messages to improve log readability and automation.

Database AdministrationJSONLog Filtering
0 likes · 9 min read
Using MySQL 8.0 JSON Error Log Output and Filtering
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 23, 2019 · Backend Development

Choosing Between boolean and Boolean for POJO Fields: Naming, Default Values, and Serialization Implications

This article examines how to correctly define boolean-type member variables in Java POJOs, comparing primitive boolean and wrapper Boolean, discussing naming conventions like success vs isSuccess, default values, JavaBeans getter/setter rules, and the impact on JSON serialization across fastjson, Gson, and Jackson.

JSONJavaNaming Convention
0 likes · 12 min read
Choosing Between boolean and Boolean for POJO Fields: Naming, Default Values, and Serialization Implications
FunTester
FunTester
Aug 8, 2019 · Backend Development

How to Pretty‑Print JSON in Java Console Without Plugins

This article explains why JSON output in a Java console is often unreadable, presents a custom method that formats and indents JSON strings with visual markers, provides the full implementation code, shows the resulting output, and notes its current limitations.

DebuggingJSONJava
0 likes · 4 min read
How to Pretty‑Print JSON in Java Console Without Plugins
360 Tech Engineering
360 Tech Engineering
Aug 6, 2019 · Mobile Development

Performance Comparison of JSON, Protocol Buffers, and FlatBuffers for H5‑Hybrid and Flutter Data Transmission

This article presents a real‑device performance test of three data serialization structures—JSON, Protocol Buffers, and FlatBuffers—used in H5‑Hybrid and Flutter development, analyzing their size, serialization/deserialization speed, and suitability for Android, Flutter, and H5 communication channels.

AndroidFlatBuffersFlutter
0 likes · 13 min read
Performance Comparison of JSON, Protocol Buffers, and FlatBuffers for H5‑Hybrid and Flutter Data Transmission
Huajiao Technology
Huajiao Technology
Aug 6, 2019 · Mobile Development

Which Serialization Wins? Json vs Protocol Buffers vs FlatBuffers on Android, Flutter & H5

This article presents a real‑device performance comparison of Json, Protocol Buffers and FlatBuffers across Android, Flutter and H5 channels, explains their internal structures, shows serialization/deserialization code, and provides practical guidance on choosing the right format for mobile data transmission.

FlatBuffersJSONMobile Development
0 likes · 13 min read
Which Serialization Wins? Json vs Protocol Buffers vs FlatBuffers on Android, Flutter & H5
FunTester
FunTester
Jul 17, 2019 · Backend Development

Fixing Moco API POST JSON Parameter Extraction with a Custom JsonExtractor

When using Moco API for interface virtualization, the default extractor cannot handle POST requests with JSON bodies, so a custom JsonExtractor is created to read the request content, parse the JSON, and return the desired parameter value.

API mockingGroovyHttpRequestExtractor
0 likes · 4 min read
Fixing Moco API POST JSON Parameter Extraction with a Custom JsonExtractor
FunTester
FunTester
Jul 9, 2019 · Backend Development

Mocking POST JSON Requests with Moco: A Custom JsonExtractor Guide

When using Moco API for request virtualization, the default extractor cannot handle POST JSON bodies, so this article shows how to implement a custom JsonExtractor in Java and use Groovy matchers to verify JSON parameters effectively.

API mockingGroovyJSON
0 likes · 5 min read
Mocking POST JSON Requests with Moco: A Custom JsonExtractor Guide
21CTO
21CTO
Jul 6, 2019 · Mobile Development

How Zhihu Accelerated Mobile Ad Updates with the Morph DSL Native+ Solution

Zhihu’s Morph dynamic solution, built on a Flexbox‑based DSL and JSON, enabled rapid, cross‑platform updates of mobile ad cards, dramatically reducing rollout time from eight days to one and supporting over 70 styles with minimal impact on app size and performance.

Ad TechDSLDynamic UI
0 likes · 20 min read
How Zhihu Accelerated Mobile Ad Updates with the Morph DSL Native+ Solution
Java Captain
Java Captain
Jun 27, 2019 · Backend Development

Performance Benchmark of Common Java JSON Libraries Using JMH

Using JMH, this article benchmarks the serialization and deserialization performance of four popular Java JSON libraries—Gson, Fastjson, Jackson, and Json-lib—by testing various scenarios with a complex Person model, analyzing results, and providing guidance on selecting the most suitable library for high‑performance applications.

GsonJMHJSON
0 likes · 13 min read
Performance Benchmark of Common Java JSON Libraries Using JMH
FunTester
FunTester
May 30, 2019 · Backend Development

Custom JSON Request Extractor for Moco to Handle POST Parameters

The article describes a problem with Moco's default request extractor that fails to retrieve JSON parameters from POST requests and provides a custom Java extractor implementation that reads the request content and extracts the desired JSON field.

BackendExtractorHTTP
0 likes · 3 min read
Custom JSON Request Extractor for Moco to Handle POST Parameters
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
May 28, 2019 · Backend Development

Unlock Go’s gobox Framework: Exception Handling, Utilities & Practical Examples

This article introduces the lightweight Go framework gobox, demonstrating its exception definition, common utility functions such as slice deduplication, file and directory existence checks, recursive file listing, JSON file saving and parsing, substring extraction, time formatting constants, and random number generation based on timestamps, all with clear code examples.

Exception HandlingJSONgobox
0 likes · 8 min read
Unlock Go’s gobox Framework: Exception Handling, Utilities & Practical Examples
Didi Tech
Didi Tech
May 17, 2019 · Fundamentals

Understanding Go Reflection: Types, Values, and Practical Applications

Go’s reflection, accessed via the reflect package’s TypeOf and ValueOf functions, lets programs inspect and modify runtime types and values—including fields, tags, and slices—while obeying settable rules, enabling generic utilities such as JSON serialization, deep equality checks, and dynamic ORM-like behavior.

@ValueDeepEqualGo
0 likes · 27 min read
Understanding Go Reflection: Types, Values, and Practical Applications
Java Captain
Java Captain
Feb 17, 2019 · Backend Development

Implementing a JSON Parser in Java: Structures, Tokenization, and Parsing

This article explains the fundamentals of JSON, its object and array structures, maps JSON types to Java equivalents, and provides a complete Java implementation of a JSON parser including token definitions, lexical analysis, and object/array construction with detailed code examples.

JSONJavaParser
0 likes · 14 min read
Implementing a JSON Parser in Java: Structures, Tokenization, and Parsing
Xianyu Technology
Xianyu Technology
Jan 29, 2019 · Mobile Development

Object Serialization in Flutter: A Practical Approach

The article examines Flutter’s limited built-in JSON handling, explains why the popular json_serializable package can fall short for complex, generic objects, and introduces fish-serializable—a custom library with a ValueHolder, FishSerializable interface, JsonSerializer, and IntelliJ plugin—already used in production at Alibaba’s Xianyu and soon to be open-sourced.

DARTFlutterJSON
0 likes · 8 min read
Object Serialization in Flutter: A Practical Approach
HomeTech
HomeTech
Jan 24, 2019 · Mobile Development

Cross‑Platform Mobile Development with Flutter: Evolution, Practices, and Challenges

This article examines the drawbacks of maintaining separate native codebases for iOS and Android, reviews the evolution of cross‑platform solutions such as WebView‑based frameworks, React Native, and Flutter, and shares practical insights, code examples, and future plans for using Flutter in large‑scale mobile projects.

DARTFlutterJSON
0 likes · 22 min read
Cross‑Platform Mobile Development with Flutter: Evolution, Practices, and Challenges
Node Underground
Node Underground
Nov 29, 2018 · Backend Development

Boost Node.js Performance: 8 Proven Techniques for Faster Apps

This article presents eight practical strategies—including upgrading Node.js, leveraging fast-json-stringify, optimizing promises, tuning V8 GC, using streams correctly, and employing node‑clinic tools—to dramatically improve the performance and scalability of Node.js applications.

BenchmarkJSONNode.js
0 likes · 21 min read
Boost Node.js Performance: 8 Proven Techniques for Faster Apps
Continuous Delivery 2.0
Continuous Delivery 2.0
Nov 28, 2018 · Backend Development

Building a Stable, Flexible, and Efficient Mobile Operations Configuration Platform – Insights from Meituan‑Dianping

The article shares Meituan‑Dianping’s practical experience in designing a mobile operations configuration platform that achieves high efficiency, flexibility, and stability through visual tooling, workflow control, preview mechanisms, JSON‑based data, and a three‑stage architecture evolution from classic caching to SDK‑driven distributed caching.

JSONMobile BackendOperational Efficiency
0 likes · 10 min read
Building a Stable, Flexible, and Efficient Mobile Operations Configuration Platform – Insights from Meituan‑Dianping
ITPUB
ITPUB
Apr 23, 2018 · Databases

What’s New in MySQL 8.0 GA? Key Features and Upgrade Tips

MySQL 8.0 GA (8.0.11) brings up to twice the performance of 5.7, adds NoSQL document storage, window functions, hidden and descending indexes, CTEs, enhanced JSON handling, improved InnoDB reliability, built‑in high availability, and stronger security, while requiring in‑place upgrades and backups.

8.0JSONNoSQL
0 likes · 7 min read
What’s New in MySQL 8.0 GA? Key Features and Upgrade Tips
Liulishuo Tech Team
Liulishuo Tech Team
Apr 19, 2018 · Mobile Development

Using Swift 4.1 JSONEncoder/JSONDecoder KeyEncodingStrategy to Bridge Snake_case and CamelCase and Create Custom Key Strategies

This article explains how Swift 4.0 introduced Codable, how Swift 4.1 added keyEncodingStrategy and keyDecodingStrategy to automatically convert between snake_case and camelCase, and how to implement custom key transformations such as PascalCase using the .custom strategy.

CodableJSONKeyEncodingStrategy
0 likes · 9 min read
Using Swift 4.1 JSONEncoder/JSONDecoder KeyEncodingStrategy to Bridge Snake_case and CamelCase and Create Custom Key Strategies
Tencent Cloud Developer
Tencent Cloud Developer
Mar 22, 2018 · Mobile Development

Evolution of App Communication: From JSON Text Protocol to Binary JCE Protocol in the XinYue Club App

The XinYue Club App migrated from an HTTP + JSON text protocol to a compact, AES‑GCM‑encrypted binary JCE protocol, detailing header/body structures, compression, signature validation, and security measures, while comparing the readability and debugging ease of JSON against the performance and protection benefits of binary communication.

AES encryptionJSONbinary protocol
0 likes · 12 min read
Evolution of App Communication: From JSON Text Protocol to Binary JCE Protocol in the XinYue Club App
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Mar 19, 2018 · Backend Development

Mastering API Design: Essential Standards for Mobile Apps

This article presents a comprehensive guide to API design for mobile applications, covering documentation standards, common request and response parameters, naming conventions, thin‑client principles, extensibility, security, compatibility, performance and user‑experience optimizations, with practical examples and code snippets.

JSONMobile Backendapi-design
0 likes · 24 min read
Mastering API Design: Essential Standards for Mobile Apps
Programmer DD
Programmer DD
Mar 13, 2018 · Backend Development

Why Feign Fails with LocalDate/LocalDateTime and How to Fix It

When a Spring Cloud Feign client sends a request containing Java 8 date/time types like LocalDate, LocalTime, or LocalDateTime, the response may trigger JSON parse errors because Spring MVC serializes them as arrays, but Feign expects a proper object, which can be resolved by adding Jackson's JSR‑310 module and configuring the ObjectMapper.

JSONJacksonJavaTimeModule
0 likes · 6 min read
Why Feign Fails with LocalDate/LocalDateTime and How to Fix It
Tencent IMWeb Frontend Team
Tencent IMWeb Frontend Team
Feb 1, 2018 · Frontend Development

Mastering AJAX: From XMLHttpRequest to CORS and JSON

This article walks through the evolution of AJAX, explains how XMLHttpRequest works, introduces JSON as a lightweight data format, and shows how to handle cross‑origin requests with CORS, including practical code examples and a simple jQuery wrapper.

CORSJSONXMLHttpRequest
0 likes · 11 min read
Mastering AJAX: From XMLHttpRequest to CORS and JSON
Meituan Technology Team
Meituan Technology Team
Jan 5, 2018 · Mobile Development

Performance Optimization of JSON Serialization on Android: Replacing Gson with JSONObject and Mson

The article shows that replacing reflection‑heavy Gson with lightweight JSONObject for manual serialization and a compile‑time annotation‑processor generated library called Mson can cut JSON parsing and writing time to about one‑tenth, while maintaining compatibility and eliminating ProGuard rules for performance‑critical Android apps.

AndroidAnnotationProcessorGson
0 likes · 13 min read
Performance Optimization of JSON Serialization on Android: Replacing Gson with JSONObject and Mson
ITPUB
ITPUB
Dec 16, 2017 · Databases

Why PostgreSQL Is Climbing the DB‑Engines Rankings in 2017

The December 2017 DB‑Engines ranking shows Oracle still on top, while PostgreSQL maintains steady growth, gaining momentum with JSON support and the Citus extension, as developers turn to it over NoSQL alternatives, signaling a potential shift in the database landscape.

CitusDB-EnginesDatabase Rankings
0 likes · 5 min read
Why PostgreSQL Is Climbing the DB‑Engines Rankings in 2017
ITPUB
ITPUB
Nov 15, 2017 · Databases

Master MySQL JSON: Create, Query, Update, and Index JSON Data in MySQL 5.7+

This guide walks you through using MySQL's native JSON data type—creating tables with JSON columns, inserting simple and complex JSON values, updating nested structures, generating indexed columns from JSON fields, converting strings to JSON, and a comprehensive list of built‑in JSON functions.

JSONSQLdatabase
0 likes · 6 min read
Master MySQL JSON: Create, Query, Update, and Index JSON Data in MySQL 5.7+
ITPUB
ITPUB
Sep 28, 2017 · Databases

What’s New in MySQL 8.0 RC1? Key Features for Modern Apps

MySQL 8.0 RC1 introduces major enhancements such as improved JSON handling, a full‑featured Document Store with transaction support, expanded Unicode and GIS capabilities, plus a suite of modern SQL features designed to better serve mobile‑first and cloud‑native applications.

Database FeaturesDocument StoreJSON
0 likes · 5 min read
What’s New in MySQL 8.0 RC1? Key Features for Modern Apps
Tencent Music Tech Team
Tencent Music Tech Team
Sep 8, 2017 · Mobile Development

Lottie Animation Library: Introduction, Usage, Implementation Details, and Performance on Android

Lottie, Airbnb’s open‑source animation library, parses After Effects‑exported JSON to render vector animations natively on Android, iOS, and React Native, letting developers share a single asset across platforms, simplify code, manage assets from assets, SD card or network, while balancing modest APK size increase against performance limits for complex scenes.

AndroidJSONLottie
0 likes · 14 min read
Lottie Animation Library: Introduction, Usage, Implementation Details, and Performance on Android
21CTO
21CTO
Apr 17, 2017 · Frontend Development

Master JSON in JavaScript: From Serialization Basics to Advanced Tricks

This article explains what JSON is, why it’s ideal for data exchange, contrasts it with JavaScript objects, and dives deep into JSON.stringify, JSON.parse, and toJSON, illustrating each concept with clear code examples and practical tips for developers.

JSONJSON.parseJSON.stringify
0 likes · 17 min read
Master JSON in JavaScript: From Serialization Basics to Advanced Tricks
High Availability Architecture
High Availability Architecture
Mar 31, 2017 · Backend Development

Benchmarking JSON vs Protobuf Performance in Java

This article benchmarks Java JSON libraries against Google Protobuf, analyzing decode/encode performance for integers, doubles, strings, objects, and lists, revealing that while Protobuf often outperforms JSON, optimized JSON libraries like DSL‑JSON can narrow the gap dramatically.

BenchmarkJSONJava
0 likes · 22 min read
Benchmarking JSON vs Protobuf Performance in Java
Java High-Performance Architecture
Java High-Performance Architecture
Feb 7, 2017 · Databases

New MySQL Features: Data Dictionary, InnoDB, JSON, and Optimizer Boosts

The latest MySQL release introduces a transactional data dictionary, role‑based account permission management, multiple InnoDB enhancements—including stable auto‑increment counters, memcached multi‑key support, dynamic deadlock detection, shared temporary tables, and NOWAIT/SKIP LOCKED options—plus advanced JSON operators, aggregation functions, pretty‑print utility, and optimizer features such as hidden and descending indexes.

InnoDBJSONRoles
0 likes · 4 min read
New MySQL Features: Data Dictionary, InnoDB, JSON, and Optimizer Boosts
Tencent Cloud Developer
Tencent Cloud Developer
Jan 5, 2017 · Databases

MySQL JSON Data Type: Features, Implementation, and Indexing

MySQL 5.7.7 adds a native JSON data type that validates documents, stores them in a pointer‑key/value structure for fast selective deserialization, provides rich functions and path expressions for manipulation, and enables indexing via generated virtual columns while defining clear comparison and sorting rules.

Data TypesJSONmysql
0 likes · 11 min read
MySQL JSON Data Type: Features, Implementation, and Indexing
Architecture Digest
Architecture Digest
Jan 2, 2017 · Backend Development

API Design Guidelines for Mobile Applications

This article presents comprehensive API design standards for mobile apps, covering request/response conventions, naming rules, data type handling, security measures, compatibility, performance and user‑experience optimizations, and offers practical examples to help front‑end and back‑end engineers create robust, maintainable interfaces.

BackendJSONSecurity
0 likes · 19 min read
API Design Guidelines for Mobile Applications
dbaplus Community
dbaplus Community
Oct 20, 2016 · Databases

Inside MySQL 8.0: New Features, Community Insights, and Future Roadmap

The article recaps a MySQL 8.0 optimizer meetup where experts discussed version naming, enterprise vs community edition differences, character‑set choices, storage‑engine evolution, hint usage, sharding strategies, high‑availability architectures, market position, and upcoming feature requests from the community.

8.0HintsJSON
0 likes · 13 min read
Inside MySQL 8.0: New Features, Community Insights, and Future Roadmap
dbaplus Community
dbaplus Community
Sep 12, 2016 · Databases

What’s New in MySQL 5.7? InnoDB, JSON, and Feature Highlights

This article walks through the major MySQL 5.7 enhancements—including InnoDB buffer‑dump improvements, multi‑threaded page cleaning, dynamic buffer‑pool resizing, global tablespaces, default DYNAMIC row format, native partitioning, truncate‑undo logs, native JSON support, sys schema, optimizer hints, trigger upgrades, syslog integration, and virtual columns—providing practical steps, examples, and usage tips for DBAs.

Database FeaturesInnoDBJSON
0 likes · 12 min read
What’s New in MySQL 5.7? InnoDB, JSON, and Feature Highlights
ITPUB
ITPUB
Sep 3, 2016 · Databases

8 MySQL Gotchas That Will Make You Rethink Relational Databases

The article lists eight common complaints about MySQL—from deep‑rooted bugs and inflexible relational schemas to confusing forks, storage‑engine chaos, profit‑driven licensing, weak native JSON support, and proprietary extensions—highlighting why many developers consider alternatives.

Database BugsJSONRelational Databases
0 likes · 9 min read
8 MySQL Gotchas That Will Make You Rethink Relational Databases
Liulishuo Tech Team
Liulishuo Tech Team
Aug 6, 2016 · Product Management

Structuring and Managing Data Collection Requirements with JSON and Git

By defining data collection (event tracking) requirements in a structured JSON format and storing them in Git with a web interface that abstracts version control, teams can standardize identifiers, validate data formats automatically, track changes via commit logs, and streamline collaboration between product managers, developers, and testers.

GitJSONdata collection
0 likes · 7 min read
Structuring and Managing Data Collection Requirements with JSON and Git
Java High-Performance Architecture
Java High-Performance Architecture
Jun 9, 2016 · Databases

Discover MySQL 5.7: 9 Powerful New Features You Must Know

MySQL 5.7 introduces major enhancements such as native JSON support, an expanded Performance Schema, a new SYS Schema for health monitoring, improved security, advanced GIS capabilities, three‑fold query throughput gains, InnoDB optimizations, multi‑source replication, and a smarter optimizer with dynamic costing.

GISInnoDBJSON
0 likes · 3 min read
Discover MySQL 5.7: 9 Powerful New Features You Must Know
Architecture Digest
Architecture Digest
Jun 8, 2016 · Backend Development

Analysis of the Top 100 Most Popular Java Libraries on GitHub

Based on an analysis of 47,251 dependency declarations from 3,862 popular GitHub Java projects, this article presents the 100 most widely used Java libraries, highlights the top 20, examines the rise of Spring components, and discusses notable JSON and other standout libraries.

Dependency AnalysisJSONlibraries
0 likes · 7 min read
Analysis of the Top 100 Most Popular Java Libraries on GitHub
ITPUB
ITPUB
Apr 20, 2016 · Databases

How to Shrink a 130GB Logistics JSON Column in MySQL

This article examines a MySQL table storing large JSON logistics data, analyzes why its size grows to 130 GB, and presents practical optimizations such as data archiving, JSON field reduction, and schema redesign to keep the table manageable.

JSONLogisticsSchema Optimization
0 likes · 8 min read
How to Shrink a 130GB Logistics JSON Column in MySQL
21CTO
21CTO
Apr 11, 2016 · Databases

How to Import JSON, XML, CSV, and Text Files into MySQL Efficiently

This article explains practical methods for importing various external data formats—such as CSV, plain text, XML, and JSON—into MySQL, covering command-line utilities, LOAD DATA statements, stored procedures, third‑party tools like mysqljsonimport, and using MySQL Workbench, while addressing configuration and security considerations.

CSVJSONLOAD DATA
0 likes · 11 min read
How to Import JSON, XML, CSV, and Text Files into MySQL Efficiently
21CTO
21CTO
Mar 24, 2016 · Backend Development

Mastering PHP cURL: How to Perform GET and POST Requests

This guide introduces PHP's cURL extension, outlines its basic workflow, and provides clear GET and POST code examples, showing how to configure options, execute requests, handle responses, and decode JSON data into arrays or objects.

HTTPJSONPHP
0 likes · 3 min read
Mastering PHP cURL: How to Perform GET and POST Requests
ITPUB
ITPUB
Mar 9, 2016 · Databases

8 Critical Drawbacks of MySQL You Should Know

The article enumerates eight fundamental issues with MySQL—including deep‑seated bugs, rigid relational schemas, complex JOIN handling, confusing branch and storage‑engine choices, profit‑driven licensing, lack of native JSON support, and proprietary modules—while urging developers to consider more flexible alternatives.

JSONRelational DatabasesStorage Engines
0 likes · 9 min read
8 Critical Drawbacks of MySQL You Should Know
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 TypesJSON
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 TypesJSONJavaScript
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.

JSONVirtual Columnsdatabase
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