Django JSONField inside ArrayField

by

Arrays

First of all, let’s take a close look at this important text from the Postgresql Arrays document.

Tip: Arrays are not sets; searching for specific array elements can be
a sign of database misdesign. Consider using a separate table with a
row for each item that would be an array element. This will be easier
to search, and is likely to scale better for a large number of
elements.

Most of the time, you should not be using arrays.

JSONB

JSONB is available in Django as the JSONField type. This field is more scalable and flexible than array fields and can be searched more efficiently. However if you find yourself searching inside JSONB fields all the time the above statement about Arrays is equally valid for JSONB.

Now what do you have in your system? A an array that holds JSONB field. This is a disaster waiting to happen. Please normalize your data.

Recap

so when to use ArrayField?

On the rare occasion when you don’t need to search in that column and you don’t need to use that column for a join.

More Related Contents:

  1. NumPy array is not JSON serializable
  2. How to convert JSON data into a Python object?
  3. Creating a JSON response using Django and Python
  4. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  5. Where’s my JSON data in my incoming Django request?
  6. is not JSON serializable
  7. django.db.utils.OperationalError Could not connect to server
  8. Django REST Framework POST nested objects
  9. django-rest-framework 3.0 create or update in nested serializer
  10. Use Django ORM as standalone [duplicate]
  11. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  12. Django connection to postgres by docker-compose
  13. How to set up a PostgreSQL database in Django
  14. Trying to parse `request.body` from POST in Django [duplicate]
  15. Composite primary key in django
  16. Updates to JSON field don’t persist to DB
  17. How do you join two tables on a foreign key field using django ORM?
  18. Accessing dictionary by key in Django template
  19. Case insensitive unique model fields in Django?
  20. Django JSONField filtering
  21. Docker- django throws error while connecting to postgres: psycopg2.OperationalError: could not connect to server: Connection refused
  22. How to find pg_config path
  23. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  24. What is the default order of a list returned from a Django filter call?
  25. Rendering JSON objects using a Django template after an Ajax call
  26. Serializing list to JSON [duplicate]
  27. is not JSON serializable
  28. Deploying Django to Heroku (Psycopg2 Error)
  29. SQLAlchemy: filtering on values stored in nested list of the JSONB field
  30. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip

Leave a Comment