TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Omen2: Python Database/Object Interface

1 pointsby earonestyover 3 years ago

1 comment

earonestyover 3 years ago
I know this could be seen as &quot;yet another object manager&quot;, and it is. Thing is, I have a real issue with typical object managers and their interaction with an organization.<p>An ORM layer should always serve as your primary object interface, not just a weird way to execute SQL calls, while your real objects do the work.<p>Also, I like my DBA&#x27;s to be DBA&#x27;s: to know everything about how to optimize databases, indexes and to do so with SQL. I don&#x27;t need or want them to be experts at some ORM.<p>omen2 takes a unique approach to object management by generating &quot;convenience code&quot; based on an existing database&#x27;s schema. Also, the codegen layer is completely optional.<p>I&#x27;m not going to claim it&#x27;s done the best possible way, but it&#x27;s good enough for the dozen or so databases we&#x27;re using it for, and it&#x27;s makes far fewer assumptions and has no built-in limitations.<p>omen2 allows a full separation between marshalling, serialization and databased design.