Sign in Subscribe

rails

Store JSON in PostgreSQL column

Today I want to share with you how to store JSON object or array in PostgreSQL table column.

This problem is really easy to solve since the PostgreSQL has a native support for storing JSONs as Binary JSON or JSONB.

Just create a new column of type jsonb:
add_column :TABLE, :COLUMN_NAME, :jsonb

So whenever you want to store any Array or Hash, just store it in the ActiveRecord object like with any other column and then access it natively as Array or Hash.

Read next

Just published my first React Native package to NPM

Just published my first React Native package to NPM

For a few weeks now I'm working on a small React Native app. After trying to find a package that will work for me and failed, I decided to create a custom component. If you have an iOS device, you most certainly know the Segmented Control view (UISegmentedControl): Publishing this

The useState() Hook: Practical Guide

The useState() Hook: Practical Guide

Do you know what is the difference between a class component and a function component in React? In this practical guide I will try to explain how the component's state is managed in both components after the second got on steroids! Stateful and Stateless components In the previous example, we

How to access Firestore subcollections with react-redux-firebase

How to access Firestore subcollections with react-redux-firebase

I would like to share with you a code snipped of how to access subcollections in the Cloud Firestore database. Lets say we have this structure: - Users | -- Tasks Our exercise is to access the tasks list of a certain user. import { compose } from "redux"; import { connect } from "react-redux"

Comments ()