Schedule - PGConf NYC 2022

NORM_GEN: an alternative to ORM

Date: 2022-09-23
Time: 14:10–15:00
Room: The Innovation Space
Level: Intermediate
Feedback: Leave feedback

NORM (No ORM framework) was introduced in 2017 to make a breakthrough in solving the problem of ORIM - Object-Relational Imdepance Mismatch. In short, the ORIM can be described as follows: although the database performance is great and each query is executed in milliseconds, the overall application response time may be slow, making the users wait for a response for extended periods. In most cases, the root cause of the problem is the usage of ORM - Object-Relational Mappers. Application developers love them because they allow accessing databases without knowledge of database internals. NORM was designed to become a framework as easy to use as any ORM but helps escape the common ORM pitfalls. NORM became very popular with application developers with only one caveat – writing PostgreSQL functions and stored procedures requires expertise above the typical application developer’s level. To address this problem and facilitate adopting the NORM approach, we developed a tool to generate user-defined types and functions. The input data is presented in the form of annotated JSON schema, making them easy to use by both database and application developers. Using NORM-GEN is as easy as any popular ORM, but the resulting queries are significantly more efficient. Even more important, applications become less chatty and can process data as sets rather than individual records.


The following slides have been made available for this session:


Boris Novikov
Henrietta Dombrovskaya