Research Article
Typeconnect: ORM and Entity Manager for Databases
@INPROCEEDINGS{10.4108/eai.28-4-2025.2357937, author={T Sasank Reddy and V Kushal and Shaik Mohammad Akmal and Suddapalli Kedharnath and Surya Krishna Bharadwaj and Gayathri Ramasamy}, title={Typeconnect: ORM and Entity Manager for Databases}, proceedings={Proceedings of the 4th International Conference on Information Technology, Civil Innovation, Science, and Management, ICITSM 2025, 28-29 April 2025, Tiruchengode, Tamil Nadu, India, Part I}, publisher={EAI}, proceedings_a={ICITSM PART I}, year={2025}, month={10}, keywords={typescript postgresql orm crud web development database integration}, doi={10.4108/eai.28-4-2025.2357937} }- T Sasank Reddy
V Kushal
Shaik Mohammad Akmal
Suddapalli Kedharnath
Surya Krishna Bharadwaj
Gayathri Ramasamy
Year: 2025
Typeconnect: ORM and Entity Manager for Databases
ICITSM PART I
EAI
DOI: 10.4108/eai.28-4-2025.2357937
Abstract
Object-Relational Mapping (ORM) designs are common in web development today to map object-oriented programming languages to relational databases. The bulk of today's traditional ORM designs are much too abstracted, complex, and runtime-hungry, which is not suitable for low-complexity, performance-oriented projects. In this paper, we discuss Type Connect, a lightweight, TypeScript-focused ORM, very targeted to be specific to PostgreSQL. Leveraging TypeScript's expressive type system and metadata reflectivity, Type Connect enables developers to declare database schemes in terms of type-safe, annotation-based entities and have their schema automatically created with database and codebase congruence. Type Connect is extremely scalable in its schema-first approach, with minimalistic, straightforward API to facilitate simple, normal database operations such as creation, query, update, and delete. We dissect Type Connect internal use dynamics to prove Type Connect reduces boilerplate code to avoid compromising developer experience and is capable to maintain performance. Comparison with other widely used ORMs demonstrates how Type Connect boasts query execution time performance as well as lean usage of memory space, thus being efficient.
