TypeORM

𝟐𝟎𝟐𝟓 was a pivotal year for TypeORM. We've re-organized the maintenance team to ensure future stability, enhanced performance, improved DX, and more. 𝗟𝗲𝘁'𝘀 𝘀𝘁𝗮𝗿𝘁 𝘄𝗶𝘁𝗵 𝘀𝗼𝗺𝗲 𝗻𝘂𝗺𝗯𝗲𝗿𝘀: 𝟖 𝗢𝗳𝗳𝗶𝗰𝗶𝗮𝗹 𝗥𝗲𝗹𝗲𝗮𝘀𝗲𝘀 (v0.3.21 ... v0.3.28) 𝟏𝟓 𝗖𝗼𝗿𝗲 𝗧𝗲𝗮𝗺 𝗠𝗲𝗺𝗯𝗲𝗿𝘀 𝟖𝟏 𝗨𝗻𝗶𝗾𝘂𝗲 𝗖𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗼𝗿𝘀 𝟕𝟗 𝗕𝘂𝗴𝘀 𝗦𝗺𝗮𝘀𝗵𝗲𝗱 𝗡𝗼𝘄 𝗹𝗲𝘁'𝘀 𝘁𝗮𝗹𝗸 𝗮𝗯𝗼𝘂𝘁 𝘀𝗼𝗺𝗲 𝗼𝗳 𝘁𝗵𝗲 𝘀𝗶𝗴𝗻𝗶𝗳𝗶𝗰𝗮𝗻𝘁 𝗰𝗵𝗮𝗻𝗴𝗲𝘀 𝘁𝗵𝗮𝘁 𝘄𝗲𝗿𝗲 𝗺𝗮𝗱𝗲: 𝟭. 𝗗𝗼𝗰𝘀 𝗢𝘃𝗲𝗿𝗵𝗮𝘂𝗹 We've completely redesigned our docs site and moved them to use Docusaurus. 𝗖𝗵𝗲𝗰𝗸 𝗶𝘁 𝗼𝘂𝘁 𝗮𝘁 𝗵𝘁𝘁𝗽𝘀://𝘁𝘆𝗽𝗲𝗼𝗿𝗺.𝗶𝗼 𝟮. 𝗧𝗵𝗲 𝗔𝗜/𝗩𝗲𝗰𝘁𝗼𝗿 𝗥𝗲𝘃𝗼𝗹𝘂𝘁𝗶𝗼𝗻 We’ve rolled out native vector support for 🔹 PostgreSQL (via pgvector) 🔹 MySQL 9 & MariaDB 11.7+ 🔹 MSSQL 2025 🔹 SAP HANA Cloud 𝟯. 𝗠𝗼𝗱𝗲𝗿𝗻 𝗗𝗿𝗶𝘃𝗲𝗿 𝗦𝘂𝗽𝗽𝗼𝗿𝘁  Full-first-class support for better-sqlite3, the latest Expo versions for mobile-first developers, and some optimizations for the newest MySQL/MariaDB releases. 𝟰. 𝗣𝗿𝗲𝗰𝗶𝘀𝗲 𝗡𝘂𝗹𝗹 𝘃𝘀. 𝗨𝗻𝗱𝗲𝗳𝗶𝗻𝗲𝗱 𝗦𝘂𝗽𝗽𝗼𝗿𝘁 We’ve heard the community loud and clear about the current default behavior of null/undefined, so we’ve refined how TypeORM handles these values. We've added a data source option to adjust the way TypeORM handles these kinds of values. 𝗬𝗼𝘂 𝗰𝗮𝗻 𝗿𝗲𝗮𝗱 𝗺𝗼𝗿𝗲 𝗮𝗯𝗼𝘂𝘁 𝗶𝘁 𝗮𝘁: 𝗵𝘁𝘁𝗽𝘀://𝘁𝘆𝗽𝗲𝗼𝗿𝗺.𝗶𝗼/𝗱𝗼𝗰𝘀/𝗱𝗮𝘁𝗮-𝘀𝗼𝘂𝗿𝗰𝗲/𝗻𝘂𝗹𝗹-𝗮𝗻𝗱-𝘂𝗻𝗱𝗲𝗳𝗶𝗻𝗲𝗱-𝗵𝗮𝗻𝗱𝗹𝗶𝗻𝗴 𝟱. 𝗠𝗮𝗷𝗼𝗿 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗜𝗺𝗽𝗿𝗼𝘃𝗲𝗺𝗲𝗻𝘁𝘀 Optimized entity updates and query transforms for high-volume workloads, added connection pool support for SAP Hana and more. 𝗬𝗼𝘂 𝗰𝗮𝗻 𝗿𝗲𝗮𝗱 𝘁𝗵𝗲 𝗳𝘂𝗹𝗹 𝗹𝗶𝘀𝘁 𝗼𝗳 𝗰𝗵𝗮𝗻𝗴𝗲𝘀 𝗮𝘁: 𝗵𝘁𝘁𝗽𝘀://𝗴𝗶𝘁𝗵𝘂𝗯.𝗰𝗼𝗺/𝘁𝘆𝗽𝗲𝗼𝗿𝗺/𝘁𝘆𝗽𝗲𝗼𝗿𝗺/𝗿𝗲𝗹𝗲𝗮𝘀𝗲𝘀 ------ 𝗧𝗵𝗲 𝗙𝘂𝘁𝘂𝗿𝗲 In 2025 we also released our "Future of TypeORM" roadmap, which means we are moving away from the "solo-maintainer" model toward a sustainable, enterprise-grade foundation: - 𝗙𝗼𝘂𝗻𝗱𝗮𝘁𝗶𝗼𝗻 𝗚𝗼𝘃𝗲𝗿𝗻𝗮𝗻𝗰𝗲: We are establishing a non-profit foundation to ensure TypeORM remains a neutral, community-governed asset forever. - 𝗧𝗵𝗿𝗲𝗲 𝗖𝗼𝗿𝗲 𝗗𝗼𝗺𝗮𝗶𝗻𝘀: We structured the project into dedicated teams for Development, Operations, and Community to ensure no PR goes unnoticed. - 𝗘𝘀𝘁𝗮𝗯𝗹𝗶𝘀𝗵 𝗮 𝗯𝗼𝗮𝗿𝗱: We appointed Michael Bromley, David Höck and Lucian Mocanu as our board members. Lucian will be leading the technical side. TypeORM exists because of the thousands of developers who trust us with their data layer every single day. Whether you contributed a one-line bug fix or a major driver implementation, 𝘁𝗵𝗮𝗻𝗸 𝘆𝗼𝘂. 𝗪𝗮𝗻𝘁 𝘁𝗼 𝗵𝗲𝗹𝗽 𝘀𝗵𝗮𝗽𝗲 𝟮𝟬𝟮𝟲? We are looking for sponsors and contributors to join us. Let’s build the most feature-rich and performant TypeScript ORM together. ✉️ 𝗖𝗼𝗻𝘁𝗮𝗰𝘁 𝘂𝘀 𝗮𝘁 maintainers@typeorm.io

Just merged a PR in TypeORM removing the sha.js dependency, replacing it with Node.js’s built-in crypto where available and the internal RandomGenerator in other environments (browsers / React Native / Hermes). Dropping sha.js alone removes 33 out of 81 dependencies, nearly half of TypeORM’s dependency tree, while relying on native, better-maintained implementations. PR: https://lnkd.in/dZVcEehY

📣 𝗧𝘆𝗽𝗲𝗢𝗥𝗠 𝟬.𝟯.𝟮𝟴 𝗶𝘀 𝗻𝗼𝘄 𝗹𝗶𝘃𝗲. This release addresses a critical security patch, expands our AI capabilities to more drivers, and closes some important API gaps. 🔒 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 We've upgraded our glob peer dependency version specification to help resolve 𝐂𝐕𝐄-𝟐𝟎𝟐𝟓-𝟔𝟒𝟕𝟓𝟔. If your vulnerability scanner flagged this recently, this release fixes it. 🤖 𝗩𝗲𝗰𝘁𝗼𝗿 𝗦𝗲𝗮𝗿𝗰𝗵 𝗘𝘃𝗲𝗿𝘆𝘄𝗵𝗲𝗿𝗲 We’ve extended 𝐕𝐞𝐜𝐭𝐨𝐫 column support beyond Postgres and SAP HANA to include MySQL, MariaDB, and MSSQL. 🌳  𝗘𝗻𝘁𝗶𝘁𝘆 𝗦𝗰𝗵𝗲𝗺𝗮𝘀 𝗴𝗲𝘁 𝗧𝗿𝗲𝗲𝘀 For those who prefer 𝐄𝐧𝐭𝐢𝐭𝐲𝐒𝐜𝐡𝐞𝐦𝐚 over decorators, entity schemas can now declare tree structures (e.g., nested-set), enabling parent/child relations and full TreeRepository support (findRoots, findAncestors, findDescendants). 🕒 𝗨𝗧𝗖 𝗦𝘂𝗽𝗽𝗼𝗿𝘁 𝗳𝗼𝗿 𝗗𝗮𝘁𝗲 𝗖𝗼𝗹𝘂𝗺𝗻𝘀 We added a 𝐮𝐭𝐜 option to date types. This ensures dates are stored and retrieved in UTC, ensuring consistency regardless of the server's local timezone. 𝗢𝘁𝗵𝗲𝗿 𝗶𝗺𝗽𝗿𝗼𝘃𝗲𝗺𝗲𝗻𝘁𝘀: 𝗣𝗼𝘀𝘁𝗴𝗿𝗲𝘀: Added 𝐣𝐬𝐨𝐧𝐩𝐚𝐭𝐡 column type support. 𝗠𝗼𝗻𝗴𝗼𝗗𝗕: Added 𝐟𝐢𝐧𝐝𝐁𝐲 methods to the Entity Manager and SOCKS5 proxy support. 𝗠𝗦𝗦𝗤𝗟: Added 𝐦𝐮𝐥𝐭𝐢𝐒𝐮𝐛𝐧𝐞𝐭𝐅𝐚𝐢𝐥𝐨𝐯𝐞𝐫 for high-availability setups. 𝗧𝘆𝗽𝗲𝗦𝗰𝗿𝗶𝗽𝘁: Exported 𝐐𝐮𝐞𝐫𝐲𝐏𝐚𝐫𝐭𝐢𝐚𝐥𝐄𝐧𝐭𝐢𝐭𝐲 and 𝐐𝐮𝐞𝐫𝐲𝐃𝐞𝐞𝐩𝐏𝐚𝐫𝐭𝐢𝐚𝐥𝐄𝐧𝐭𝐢𝐭𝐲 for better type safety. And more... Huge thanks to our community for the contributions, we appreciate you ❤️ 🔗 𝗥𝗲𝗹𝗲𝗮𝘀𝗲 𝗻𝗼𝘁𝗲𝘀 𝗹𝗶𝗻𝗸 𝗶𝗻 𝘁𝗵𝗲 𝗳𝗶𝗿𝘀𝘁 𝗰𝗼𝗺𝗺𝗲𝗻𝘁 #TypeORM #TypeScript #OpenSource #Database #AI #Security

TypeORM has 36k+ GitHub stars!! Know what it doesn't have? A funded maintenance team. We're changing that. I'm looking for companies that run TypeORM in production and want to sponsor its continued development. DBaaS companies, dev tooling vendors, anyone whose stack depends on this project. What sponsors get: - direct access to our maintenance team - priority bug fixes - a seat at the table when we decide what to work on next We're done with the "pray a volunteer fixes it" model. We're building something sustainable. Interested? DM me or email maintainers@typeorm.io.

Read more about the new TypeORM association and become a part of the next chapter! 👇

📣 TypeORM 0.3.27 has landed! This release brings some exciting enhancements and solid improvements: ◀️ Reverted https://lnkd.in/dgxjpeap that was introduced in the previous version and caused a regression ✅ Enhanced null/undefined handling in where conditions - We've added a new data source option called "invalidWhereValuesBehavior" that gives control over null/undefined values behavior in where conditions (you can read more about it on https://lnkd.in/dF3mkHjB) ✅ VirtualColumn improvements - We now support initially non-selectable virtual columns ✅ MySQL 9 & MariaDB 12 support ✅ PGVector initial support - Added vector and halfvec data types ✅ Enhanced migration templates - Improved JSDoc types in generated migration files ✅ React Native compatibility - Better package.json exports for mobile development ✅ Query builder fixes - Better handling of empty result sets and offset scenarios ✅ mysql2 JSON parsing fixes ✅ and more... 🙌 A huge shoutout to our amazing community contributors who made this release possible! 🔗 Ready to upgrade? Check out the full release notes: https://lnkd.in/dmfG-tAH #TypeORM #TypeScript #JavaScript #WebDevelopment #OpenSource #Database #ORM #MySQL #PostgreSQL. #PGVector #ReactNative #AI #MachineLearning

Earlier today we merged a long-awaited feature to TypeORM, many users have encountered scenarios where they accidentally provided null/undefined values in where conditions, TypeORM ignored these values, and developers had to add their own guardrails around it. I'm proud to say that from the next version of TypeORM you'll be able to control the behavior of each scenario by using the new `invalidWhereValuesBehavior` data source option. For null we've added the following options: -  `'ignore'` (default) - skips null properties     -  `'sql-null'` - transforms null to SQL NULL     -  `'throw'` - throws an error and for undefined:     -  `'ignore'` (default) - skips undefined properties     -  `'throw'` - throws an error In a future release we'll switch the behavior to be throw for both values as we believe it's the most proper behavior for it, and if you feel it's not the right option for you, you'll still be able to configure it for your project specifically. The link to the commit and docs are in the comments

TypeORM just passed 10 million monthly downloads in May. When Michael and I took over as maintenance leads last year, the project was at a crossroads. The community had started losing confidence, releases were stuck, and the docs were not even indexed in Google. We knew TypeORM was critical to many production systems, including our own at Vendure, and we saw the potential to turn it around. Since then, we’ve built a strong team of honorary maintainers and contributors. Together we have: • Released multiple new versions • Launched a fully revamped, SEO-optimized documentation site • Prepared the first major release, coming soon And the momentum is clearly visible. 10 million monthly downloads. Growing month by month. Confidence in the project is back. Huge thanks to everyone in the community who supported this journey so far. We’re just getting started.

🚀 Exciting News - our new documentation site is live! We're thrilled to announce the launch of our completely redesigned documentation website! 📚✨ Built with Docusaurus, Typesense and deployed on Cloudflare pages. 👉 Check it out at https://typeorm.io Let us know what you think about it #TypeORM #TypeScript #Developer #Documentation #OpenSource #Database #ORM #WebDevelopment #JavaScript

📣 TypeORM 0.3.23 has landed! This release brings: ✅ New foreign key decorator for improved relationship management ✅ Added a flag for generating migrations in ESM format ✅ Query timeout support for MySQL ✅ New FormattedConsoleLogger for nicer debugging ✅ Performance improvements with Date.now() optimization ✅ Better handling of array columns in Postgres ✅ and much more 🙌 A huge shoutout to our amazing community — welcoming 12 new contributors in this release! 🔗 Ready to upgrade? Check out the full release notes: https://lnkd.in/d4QHCV5x #TypeORM #TypeScript #JavaScript #WebDevelopment #OpenSource #Database #ORM