Orm Articles
Page 5 of 8
(144 articles)
11/9/2019
•
EN
Relationship issues
A Laravel developer explains solving a complex database performance issue by creating a custom Eloquent relation to efficiently load nested model data.
11/8/2019
•
EN
Laravel's HasManyThrough cheatsheet
A concise guide to using Laravel's HasManyThrough relationship with a practical database schema and code example.
9/30/2019
•
EN
Preventing SQL Injection Attacks With Python
Explains how to prevent SQL injection in Python using psycopg2's low-level sql.Identifier and sql.Literal functions for safe query building.
7/16/2019
•
EN
Dapper | Avoid parentheses in SQL statement when using IN clause
Explains how to correctly use Dapper's IN clause with collection parameters to avoid SQL syntax errors from double parentheses.
5/20/2019
•
EN
Welcome My Fascicle on JPA
Author announces the release of a self-published, 240-page guide on Java Persistence API (JPA), covering fundamentals to advanced integration.
3/9/2019
•
EN
How to Use Grouping Sets in Django
A guide to optimizing Django dashboard performance using SQL grouping sets for advanced aggregation, including a cautionary note.
1/10/2019
•
EN
3 ActiveRecord Mistakes That Slow Down Rails Apps: Count, Where and Present
Identifies three common ActiveRecord usage mistakes in Rails that cause unnecessary SQL queries and slow down application performance.
1/1/2019
•
EN
Modeling Polymorphism in Django
Explores five different approaches to implementing polymorphism in Django models, a common challenge in Django ORM design.
1/28/2018
•
EN
9 Django Tips for Working with Databases
Practical tips for optimizing Django database interactions, covering aggregation filters, namedtuples, and custom functions.
7/6/2017
•
EN
How to Manage Concurrency in Django Models
Explains concurrency issues in Django models and demonstrates solutions using pessimistic locking with select_for_update to ensure data integrity.
6/20/2017
•
EN
How to paginate records in MySQL using Sequelize and Nodejs
A tutorial on implementing pagination for MySQL databases using Sequelize ORM in a Node.js REST API.
5/30/2017
•
EN
Getting Started with Sequelize for Nodejs Applications
A beginner's guide to using Sequelize, a popular promise-based ORM for Node.js, covering installation, connection setup, and basic configuration.
4/28/2017
•
EN
All You Need To Know About Prefetching in Django
A technical guide explaining how to use Django's prefetch_related to solve the N+1 query problem and optimize database performance.
4/2/2017
•
EN
Delete or not to delete
Discusses the pros and cons of soft deletion vs. hard deletion in databases, with a focus on Django implementations and related libraries.
2/14/2017
•
EN
PostgreSQL text search in Django
Explores using PostgreSQL's full text search and trigram similarity in Django for a college search feature, detailing implementation choices.
8/4/2016
•
EN
Things You Must Know About Django Admin As Your App Gets Bigger
Optimizing Django Admin performance for large-scale applications by addressing common issues like the N+1 query problem and database load.
8/4/2016
•
EN
Dealing with Enum in a Symfony App with Doctrine2 as ORM
A guide to implementing custom, reusable PHP Enums in a Symfony application using Doctrine2 as the ORM, with examples for entities and forms.
11/30/2015
•
EN
Node, Postgres, MassiveJS - A better database experience
Exploring MassiveJS, a Node.js library for PostgreSQL that offers a better alternative to traditional ORMs by embracing SQL power and good database design.
2/14/2015
•
EN
Laravel 5.0 - Eloquent Attribute Casting
Explains Laravel 5.0's Eloquent attribute casting feature, which automatically converts model attributes to specific data types like boolean or integer.