sql   71115

« earlier    

gocmdpev
A command-line GO Postgres query visualizer, heavily inspired by the excellent (web-based) pev
postgres  sql  utility  visualization 
yesterday by joecamel
Faster Operations with the JSONB Data Type in PostgreSQL - Compose Articles
CREATE TABLE books (
book_id serial NOT NULL,
data jsonb
);

INSERT INTO books VALUES (1, '{"title": "Sleeping Beauties", "genres": ["Fiction", "Thriller", "Horror"], "published": false}');
INSERT INTO books VALUES (2, '{"title": "Influence", "genres": ["Marketing & Sales", "Self-Help ", "Psychology"], "published": true}');
INSERT INTO books VALUES (3, '{"title": "The Dictator''s Handbook", "genres": ["Law", "Politics"], "authors": ["Bruce Bueno de Mesquita", "Alastair Smith"], "published": true}');
INSERT INTO books VALUES (4, '{"title": "Deep Work", "genres": ["Productivity", "Reference"], "published": true}');
INSERT INTO books VALUES (5, '{"title": "Siddhartha", "genres": ["Fiction", "Spirituality"], "published": true}');

SELECT data->'title' AS title FROM books;

SELECT * FROM books WHERE data->'published' = 'false';

SELECT jsonb_array_elements_text(data->'genres') AS genre
FROM books
WHERE book_id = 1;
jsonb  json  postgres  sql  database 
3 days ago by dza

« earlier    

related tags

analysis  analytics  antipatterns  app  apple  apps  article  athenax  auto  azure  backtrace  backup  beginner  bi  big-data  book  born  caller  chart  charts  cli  client  cloud  code  coding  collaboration  columns  computing  corrupted  csv  dashboard  data-format  data-visualisation  data  database  databases  datamodel  datascience  datavisualisation  datawarehouse  db  dbic  dbix  debug  debugging  defence  deleted  depth  design  dev  development  diagrams  distinct  distributed  django  domain-specific-language  ecto  editor  elixir  emails  engines  fix  git  github  go  golang  graphql  group_by  hackernews  hdf5  helper  history  in  index  initializer  innerjoin  interactive  interesting  interface  interview  invention  inventor  invoke-sqlcmd  ios  java  javascript  join  json  jsonb  language  learning  left_join  library  lint  linter  linux  log  logger  mac  maintain  maker  mananger  mdf  migration  msdb  mysql  normalization  nosql  object-level  object  opensource  optimisation  optimization  orm  osx  packages  pagination  paper  parser  performance  perl  phoenix  pivot  plugins  postgres  postgresql  powershell  primarykey  procedures  productivity  programing  programming  python  queries  query-language  query  rails  rant  readings  recommendation  reference  relationaldatabases  restore  retro  review  ror  rows  ruby  rubyonrails  saa  scalability  scripts  security  server  snippet  software  spark  sqlite3  sqlserver  stored  streaming  sublime  systems  table  talk  technology  testing  tipps_und_tricks  toolkit  tools  trace  transaction  trigger  tsv  tutorial  unique  utility  video  views  visualization  warehouse  web  webdev  windows  wordpress  xcode 

Copy this bookmark:



description:


tags: