TKYT #62 Orange ORM: The TypeScript ORM for the browser & server
Summary
In this TKYT session, Lars-Erik Roald introduces Orange ORM, a lightweight and flexible ORM for Node.js and TypeScript.
He explains the key features of Orange, including its powerful query syntax, support for multiple databases, and seamless integration with TypeScript.
Lars-Erik demonstrates how to define mappings and relationships between tables, perform CRUD operations, and execute raw SQL queries.
He also showcases how to use Orange in a browser client and discusses future plans for optimizing performance and supporting additional databases.
Takeaways
Orange ORM was created to meet the need for a booking solution for a transportation product
A good ORM should have a consistent and straightforward API, support complex filters, and offer good performance
Orange supports multiple databases through adapters and allows users to drop down to the driver level
Migrations are not currently supported in Orange, but may be added in the future
Orange can be used with various frameworks, including Express Orange is a lightweight and flexible ORM for Node.js and TypeScript
It provides a powerful query syntax and supports multiple databases
Orange seamlessly integrates with TypeScript and offers strong typing
You can define mappings and relationships between tables
Orange allows you to perform CRUD operations and execute raw SQL queries
It can be used in a browser client by hosting it in Express
Future plans for Orange include optimizing performance and supporting additional databases
LINKS 🔗
Orange ORM's website
https://orange-orm.io/
Lars on Twitter
https://x.com/lroal
STAY IN TOUCH 👋
Follow me on Twitter 🐦 - / dominus_kelvin
Subscribe to my newsletter 📧 - https://newsletter.dominuskelvin.dev
Chapters
00:00 Introduction and Background
03:30 Creating the Orange ORM
08:14 Key Considerations for a Good ORM
12:50 Supporting Multiple Databases with Adapters
15:17 The Future of Migrations in Orange
36:38 Introducing Orange: A Lightweight and Flexible ORM for Node.js and TypeScript
37:21 Defining Mappings and Relationships with Orange
39:09 Performing CRUD Operations and Executing Raw SQL Queries with Orange
45:31 Using Orange in a Browser Client
48:21 Future Plans for Orange: Performance Optimization and Support for More Databases
QUESTIONS...?
Join the Discord Server 💬 - https://sailscasts.com/community
Learn Web Development 📖 - https://sailscasts.com/courses
The Boring JavaScript Stack 🥱 - https://sailscasts.com/boring
Ship less JavaScript™️ consultation - https://shiplessjavascript.com
#javascript #webdevelopment #coding #programming #vim #vscode #softwareengineering #codinglife #webdesign #webdevelopment #webdev #javascript #programmerhumor #codinghumor #software #softwareengineer #softwaredeveloper #softwaredevelopment