STGY Technical Notes

Design, implementation, and business strategy

I publish technical documentation about STGY.

STGY aims to be a textbook-style implementation of an SNS and is published as open-source software. These articles discuss how to achieve a high standard of usability, accessibility, scalability, performance, and security. If you are interested, see the codebase.

2025/01/01 STGY ArchitectureArchitecture diagram This article explains the implementation of STGY. STGY was built as a system for the developer to study TypeScript and Node.js, a...
2025/01/01 Installing STGYReferences between server… This article explains how to install the entire STGY system in both development and demo-operation environments. It covers ...
2025/01/01 STGY DatabaseER diagram This article explains the configuration and schema of the STGY database. STGY manages user and post data in PostgreSQL. Overview and Design...
2025/01/01 Analysis of STGY's Major QueriesTOAST illustration This article analyzes the queries issued to the database during STGY operation. It presents concrete SQL examples, analyzes their c...
2025/01/01 STGY Media StorageImage list screen This article explains how STGY manages media data such as images. It describes how to build simple and robust data management using ...
2025/01/01 STGY Full-Text SearchThis article explains STGY's full-text search for posts and users. Instead of adding full-text indexes to PostgreSQL, STGY uses TTTS (time-tiered text...
2025/01/01 STGY RecommendationsThis article explains STGY's post recommendation feature. STGY displays per-user recommendations in the All view of the post list and also provides a ...
2025/01/01 STGY AI AgentsThis article explains the design and implementation of AI agents that participate on STGY. An STGY AI agent is neither a chatbot that answers question...
2025/01/01 STGY Maps and TracksThis article explains STGY's functions for embedding maps and routes in articles, analyzing track data such as FIT and GPX, and converting between pla...
2025/01/01 STGY External PublicationThis article explains how STGY publishes posts externally to viewers who are not logged in, including sharing, external comments, and the access count...
2025/01/01 STGY Administration FeaturesSTGY provides administrative features for service operators to inspect system status and manage posts and users, separately from the posting, search, ...
2025/01/01 Other STGY FeaturesTo be written. Next: Other STGY Features
2025/01/01 Other STGY FeaturesTo be written.