jsonb   205

« earlier    

How to query JSONB, beginner sheet cheat – Hacker Noon
You can use the ->> operator with the classic operator you use on text: =, <>, IS NULL, etc. Do not forget to index metadata->>'country' with a B-tree index.

postgresql  jsonb  cheatsheet  databases 
4 weeks ago by philiphagen
How to query JSONB, beginner sheet cheat – Hacker Noon
You can query with the @> operator on metadata. This operator can compare partial JSON strings against a JSONB column. It’s the containment operator. For this case you may need to add a GIN index on…
pg  postgres  postgresql  json  jsonb 
march 2018 by nharbour
Using PostgreSQL and jsonb with Ruby on Rails
PostgreSQL 9.4 introduced jsonb, the binary version for JSON columns. See how you can use it with Ruby on Rails 4.2+.
Dev  rails  jsonb  postgres  active_record 
march 2018 by nicholasmott

« earlier    

related tags

active_record  activerecord  aggregation  ajo  api  arel  arrays  article  audit  benchmark  c  cheatsheet  clojure  cms  constraints  data  data_binding  database  databases  databse  dbi  dbix  dev  django  document  eav  ecto  ef  elixir  feature  features  golang  hstore  index  indexing  intro  java  javaee8  jaxb  json  knex  log  merging  migration  mongo  mousetrap  nosql  perf  performance  perl  pg  post  postgre  postgres  postgresql  postgresql_feature_jsonb  postgresql_tips  postgrsql  python  query  rails  range  ruby  search  select  sql  sqlite  store_accessor  tagging  tips  tree  tutorial  update 

Copy this bookmark: