Categories
Uncategorized

ORMs: Object-relational Mappers

Object-relational mappers are libraries that help programmers map the database data into objects that are more easily usable in their programming language of choice. By abstracting away the database, programmers can then use their programming language to create their tables and access or modify the data in them. There is no need to write a query in your database language, which can help to speed up the development process. 

Django’s ORM

Django, a popular Python backend framework, offers an ORM that can speed up your web development. With Django’s ORM, you can create models which will be used to generate the tables in your database, and you can use the functions in the database API to then access and modify data in those tables.

Models

Each model is a Python class and contains data fields which will be the columns in the table. Django provides a wide variety of DataFields that map to the various data types available in some popular SQL languages. The DataFields can also be passed parameters so that you can set a max length for a char datatype just like you would in SQL for instance. 

Querying your Database

The database API provided by Django allows you to perform CRUD operations without ever touching SQL as well. We will use the example model from above to write some sample queries to show how this works. 

Create

Creates a user with the name Tyler Rayls.

Retrieve

Since we have only made one user, we can get the only user with the name Tyler.

Update

Changes the user’s name from Tyler Rayls to John Doe.

Delete

Deletes the only user in our database.

Conclusion

ORMs are a useful tool because they can help speed up web development. They do this by abstracting away the database so that programmers can work in their language of choice and access their data in objects they are familiar with. 

Print Friendly, PDF & Email

Leave a Reply

Your email address will not be published. Required fields are marked *