Tagged articles
schema
50 articles · Page 1 of 1
This article walks through implementing an @document mention feature for a knowledge‑base Q&A input box, comparing a naïve contenteditable approach with a ProseMirror‑based solution, detailing schema design, plugin and suggestion handling, and the stability challenges of cursor, IME, and undo/redo.
ProseMirrordecorationdocref
0 likes · 12 min read

This article walks you through OpenSpec's three-tier customization—project config, custom schemas, and global overrides—showing how to quickly adapt AI‑driven development workflows to your team's stack, processes, and standards with concrete commands, YAML examples, and validation tips.
AI workflowDevOpsOpenSpec
0 likes · 14 min read

This article explains why naïve database‑per‑tenant designs cause resource waste and operational headaches, and demonstrates how Spring Boot, Hibernate, and PostgreSQL schemas provide a lightweight, high‑performance multi‑tenant architecture with strong isolation, low overhead, and easy scalability.
HibernateMulti-tenancyPostgreSQL
0 likes · 16 min read

This guide shows how to create a custom OpenSpec schema that injects TDD discipline into an AI‑driven coding workflow using three injection points and a four‑layer overlay, demonstrates that the propose phase works as intended while the apply phase only partially enforces TDD, and provides step‑by‑step setup, code examples, comparisons, troubleshooting and best‑practice recommendations.
AI codingClaude CodeNode.js
0 likes · 25 min read

The article presents a generative retrieval framework that anchors on a product‑side explicit semantic space, uses single‑sided query alignment, multi‑stage LLM‑driven attribute extraction, schema standardization, and 14B model SFT + DPO training to achieve interpretable, controllable, and high‑performance e‑commerce search.
DPOLLMSFT
0 likes · 29 min read

This article explains why large language models need tool use, defines the concepts of Tool Use, Tool Call, and Function Calling, compares them, walks through a complete tool‑use workflow, and discusses architectural, safety, and design considerations for building reliable LLM agents.
AgentLLMRuntime
0 likes · 17 min read

pyarrow.Schema is the Python representation of an Arrow table schema, describing column names, types, nullability, and other metadata, and it is essential for defining, inspecting, serializing, and interfacing data structures across libraries like Pandas, Polars, and Arrow‑based query engines.
Apache ArrowPyArrowPython
0 likes · 4 min read

This article dissects the engineering of Tencent's Youtu-GraphRAG, covering its architectural challenges, real‑time FastAPI/WebSocket design, security measures, iterative retrieval chains, parallel processing, intelligent caching, schema‑driven knowledge handling, and performance tweaks, offering practical insights for AI system builders.
AI EngineeringFastAPIGraphRAG
0 likes · 7 min read

While TypeScript guarantees compile-time type safety, it cannot validate runtime data such as API responses or form inputs, so developers add extra checks; Zod solves this by offering a TypeScript-first schema library that performs runtime validation, infers types, reduces duplication, and integrates seamlessly with modern frameworks.
Front-endJavaScriptTypeScript
0 likes · 13 min read

This article examines four typical multi‑tenant isolation approaches—field filtering, schema separation, independent databases, and hybrid architectures—detailing their implementation, risk checklists, code examples, suitable scenarios, and the cost‑security balance each entails.
database isolationfield isolationmulti-tenant
0 likes · 11 min read

This article explains how to upgrade an existing low‑code platform to a zero‑code solution, enabling backend engineers and non‑technical users to build pages effortlessly by defining component schemas, using templates, and automating interface integration.
Templatecomponent librarylow-code
0 likes · 15 min read

This article introduces Apache Pulsar, an open‑source cloud‑native distributed messaging platform, detailing its storage‑compute separation architecture, multi‑tenant support, load balancing, fault tolerance, schema handling, functions, IO connectors, tiered storage, cross‑region replication, and operational commands for managing brokers, bookies, and namespaces.
Apache PulsarMessage QueueMulti-tenancy
0 likes · 20 min read

This article explores the design of a promotion middle platform that abstracts discount rules, componentizes promotion elements, and introduces a schema-driven configuration approach to enable reusable, extensible, and business‑agnostic promotion activities across multiple product lines.
BackendComponentizationmiddleware
0 likes · 15 min read

This article explains the limitations of REST APIs, introduces GraphQL as a flexible alternative, details its core concepts such as schema, types, queries, mutations and subscriptions, and outlines various architectural patterns and tooling for integrating GraphQL into existing backend systems.
APIBackendData Fetching
0 likes · 16 min read

The article explains how REST, despite its 20‑year popularity and simplicity, suffers from redundancy, coarse granularity and maintenance overhead, and shows how GraphQL’s declarative, schema‑driven approach, single endpoint and flexible data fetching address these problems while offering a versatile integration architecture and rich ecosystem.
API DesignData FetchingGraphQL
0 likes · 16 min read


ITPUBSep 30, 2022 · Databases
This guide presents 21 practical MySQL table design guidelines covering naming conventions, field types, primary key strategies, indexing, logical deletion, common columns, storage engines, character sets, time types, relationship modeling, sharding considerations, and SQL optimization tips for robust backend development.
Best PracticesMySQLSQL
0 likes · 19 min read

Moyu Page Builder is a low‑code visual editor for Xianyu that lets operations staff configure page content and dynamic data via extended JSON Schema mapped to Ant Design components, streamlining front‑end development, reducing collaboration overhead, improving first‑screen performance, and enabling time‑based, audience‑targeted scheduling.
FormilyVisual Editorfrontend
0 likes · 10 min read

This article explains the concept of a schema—from its Greek origins and psychological meaning to its role as metadata in databases and Kubernetes—detailing different database schema models, Kubernetes resource definitions, and how to extend and register custom schemas in Go.
databasegolangmetadata
0 likes · 8 min read

This article explains how to tune Apache Solr by configuring caches, SolrCloud, commit strategies, dynamic fields, indexed versus stored fields, copyField, filter queries, and faceting to achieve maximum search performance for production workloads.
CachingIndexingSolrCloud
0 likes · 12 min read

This guide walks through planning a distribution strategy, adding and back‑filling a distribution key, preparing a development Citus cluster, updating schema and queries for multi‑tenant workloads, securing connections, monitoring cross‑node traffic, and finally migrating production data using either pg_dump/pg_restore for small databases or Citus Warp for large deployments.
Distributed Databasemigrationmulti-tenant
0 likes · 20 min read

This article provides a comprehensive introduction to Apache Parquet, covering its origins, columnar storage advantages, nested schema support, internal architecture, storage model components, comparison with ORC, and practical tools for inspecting Parquet files.
Data CompressionHadoopORC Comparison
0 likes · 10 min read

This article explains why Apache Pulsar schemas are essential for serializing POJO data, compares producer usage with and without schemas, details primitive and complex schema types, key/value handling, auto‑schema options, versioning, evolution, compatibility strategies, and provides concrete Java code examples for each scenario.
Apache PulsarJavaMessage Serialization
0 likes · 14 min read


ITPUBMay 15, 2021 · Backend Development
This article explains the limitations of traditional REST APIs, introduces GraphQL as a more flexible and efficient alternative, details its core concepts, execution model, schema design, type system, and provides guidance on server and client implementations, popular services, and tooling.
APIBackendDataFetching
0 likes · 18 min read

This article explains what NoSQL means, contrasts it with SQL and relational databases, walks through schema design, primary keys, indexing, and then demonstrates how to implement a lightweight key‑value NoSQL store in pure Python with full command parsing and handling.
IndexingNoSQLPython
0 likes · 19 min read

This article explains the origins and limitations of REST APIs, introduces GraphQL as a flexible alternative, describes its core concepts such as schema, types, and modifiers, and outlines various server‑side and client‑side implementations, tools, and deployment architectures for modern backend development.
APIData FetchingGraphQL
0 likes · 17 min read

The project designs a scalable Xianyu article publishing tool that uses a compressed JSON schema based on DingTalk’s we‑editor to store and render extensible, high‑fidelity content, separating text and images, adding plugin‑based cards, and optimizing performance to halve first‑screen load time while supporting future interactive features.
Rich Textcontent managementfrontend
0 likes · 11 min read

This article explains why REST APIs have become cumbersome, introduces GraphQL as a more flexible alternative, and details its benefits, execution model, schema and type system, as well as practical server and client implementation options.
API DesignData FetchingGraphQL
0 likes · 14 min read

This article explains the limitations of traditional REST APIs, introduces GraphQL as a flexible alternative, details its core concepts such as schema, types, queries, mutations and subscriptions, and outlines various deployment architectures and implementation considerations for backend development.
APIBackendData Modeling
0 likes · 14 min read


21CTOJan 24, 2021 · Backend Development
This article examines the limitations of traditional REST APIs, explains how GraphQL offers a more flexible, efficient, and declarative approach to data fetching, outlines its core concepts, schema design, type system, and deployment architectures, and provides guidance on integrating GraphQL into existing backend and frontend ecosystems.
API DesignGraphQLREST
0 likes · 17 min read

This article explains the evolution and limitations of REST APIs, introduces GraphQL as a more flexible, declarative alternative, details its core concepts such as schema and type system, compares execution models, and outlines various backend integration architectures for adopting GraphQL.
APIBackendGraphQL
0 likes · 14 min read


21CTOJan 14, 2021 · Backend Development
This article explains how REST’s coarse‑grained, redundant interfaces hinder front‑end efficiency, then introduces GraphQL as a flexible, declarative alternative that automatically adapts to changing data requirements, reduces API proliferation, and streamlines backend‑frontend communication.
API DesignBackendGraphQL
0 likes · 16 min read

This article explains why REST APIs have become cumbersome, introduces GraphQL as a more flexible alternative, describes its core concepts such as schema, types and modifiers, and outlines various server‑side and client‑side integration patterns and tooling options.
APIBackendData Modeling
0 likes · 17 min read

This article compares MySQL and Oracle databases, covering their fundamental nature, security mechanisms, permission models, schema migration considerations, storage concepts, syntax variations, and practical differences such as primary keys, quoting rules, pagination, and data type handling.
MySQLOracledatabase comparison
0 likes · 6 min read


ITPUBOct 29, 2020 · Databases
MongoDB’s flexible, schema‑less design offers performance benefits but can become a maintenance nightmare as projects grow, so the article explains why introducing external schema protocols like Google’s Protobuf or Facebook’s Thrift provides structure, reduces bugs, and balances flexibility with robustness.
Database DesignMongoDBNoSQL
0 likes · 7 min read

This article explains the limitations of traditional REST APIs, introduces GraphQL as a more flexible alternative, compares their advantages, and provides a detailed guide on GraphQL concepts, schema design, server‑client architecture, supported operations, and popular tools for implementation.
APIDataFetchingGraphQL
0 likes · 16 min read

This article explains the limitations of traditional REST APIs, introduces GraphQL as a flexible alternative, compares their architectures, and outlines how GraphQL’s schema‑driven approach simplifies data fetching, reduces redundancy, and integrates with existing backend services.
API DesignBackendGraphQL
0 likes · 16 min read


政采云技术Jun 28, 2020 · Frontend Development
This article explains how ZooTeam’s frontend team builds maintainable, dynamic forms using a schema‑driven, drag‑and‑drop visual editor, covering the concepts, architecture, component configuration, rendering logic, and future enhancements for scalable B2B applications.
drag-and-dropdynamic formsfrontend
0 likes · 12 min read

This article explains the evolution of MySQL parallel replay from schema‑based MTS to logical‑clock and write‑set mechanisms, shows how to configure and tune parallel replication, and introduces a Jain‑index based fairness metric for evaluating the optimal number of slave_parallel_workers.
MySQLfairness metricparallel-replication
0 likes · 8 min read

Apache Avro is a high‑performance binary data serialization system originating from Hadoop that uses JSON‑defined schemas to enable compact storage, efficient network transfer, container file formats for MapReduce, and RPC communication without requiring code generation or explicit field numbers.
HadoopRPCavro
0 likes · 9 min read


ITPUBMay 7, 2020 · Backend Development
This article explains what GraphQL is, why it was created, how it differs from RESTful APIs, and the advantages of its schema‑driven, flexible data fetching model for modern mobile and web applications.
APIDataFetchingGraphQL
0 likes · 11 min read

This Laravel Schema cheat sheet provides concise, English-translated code examples for creating, modifying, and managing database tables, columns, indexes, and foreign keys, covering table creation, column types, indexing options, and common schema operations with clear syntax.
Database MigrationLaravelPHP
0 likes · 5 min read

This article explains the purpose, features, and practical usage of JSON Schema for describing data structures, generating documentation, and validating API inputs and outputs, and provides a detailed example with code and tips for effective schema design.
JSONdata validationjsonschema
0 likes · 5 min read

This article explains the rapid development of knowledge graphs, why graph databases like JanusGraph are preferred over relational databases for large‑scale semantic networks, and provides a step‑by‑step guide covering JanusGraph architecture, schema creation, Gremlin traversal language, server deployment, data import, and query examples.
GremlinJanusGraphTraversal
0 likes · 15 min read

This article introduces GraphQL as a query language for APIs, explains its history, shows how to define a schema and resolvers with graphql‑js, demonstrates query execution, error handling, built‑in types, and presents useful development tools such as GraphiQL and graphql‑import.
APIGraphQLJavaScript
0 likes · 10 min read

This article explains the concept of custom schema URLs in mobile development, describes the problems of a growing ad‑hoc implementation, and presents a refactored, configuration‑driven architecture that provides automatic matching, self‑documenting schemas, and integrated testing for Android apps.
deep linkingdocumentationmobile
0 likes · 9 min read


ITPUBJun 14, 2016 · Databases
The article explains how SQL Server 2005 introduced schemas as separate namespaces, altering table ownership and permission rules compared to SQL Server 2000, and outlines the advantages such as role‑based access, easier user removal, default schema sharing, finer permission control, and business‑specific object organization.
SQL ServerSQL2005permissions
0 likes · 5 min read

Learn how to efficiently validate user input in Node.js using the powerful Joi library, covering schema definitions, conditional rules, handling unknown fields, and integrating validation into Hapi routes, with clear code examples that replace cumbersome if‑else checks.
BackendJoiNode.js
0 likes · 8 min read

This article explains how GraphQL’s schema and type system model complex business data, and how its query language lets front‑end developers freely compose and customize data requests, covering core components, scalar and advanced types, queries, fragments, directives, and practical code examples.
API DesignGraphQLQuery Language
0 likes · 14 min read

This article explains why traditional front‑end/back‑end data coupling leads to duplicated effort, introduces GraphQL as a solution, and provides a step‑by‑step guide to creating a Node.js GraphQL server, defining schemas, handling queries, mutations, and extending the API for flexible, reusable data retrieval across multiple business scenarios.
APIBackendGraphQL
0 likes · 14 min read


21CTOOct 4, 2015 · Databases
This article compares SQL and NoSQL databases, outlining their core characteristics, advantages, and trade‑offs, and demonstrates practical schema designs for contact lists, social networks, and warehouse management, helping developers decide which technology best fits their project requirements.
MongoDBNoSQLSQL
0 likes · 11 min read
