philiphagen + postgresql   9

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 
july 2018 by philiphagen
TablePlus | Modern, Native Tool for Database Management
Modern, native client with intuitive GUI tools to create, access, query & edit multiple relational databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, and Redis.
software  tools  database  postgresql  osx  programming  gui 
may 2018 by philiphagen
Postgresql's Jsonb brings all the NOSQL you'll ever need into Rails
NOSQL Databases' schemaless storage is a useful feature. But what if you could have this advantage while staying on Postgresql ? It would be great, and it's possible.
postgresql  databases  programming  rubyonrails  webdev  json 
april 2015 by philiphagen

Copy this bookmark: