Tag

Database

2 pages tagged “Database”.

JSON datatype in postgreSQL

json versus jsonb in PostgreSQL: how each stores its input, why only one of them supports indexing, and how to query both with jsonpath.

Using Constants in PostgreSQL queries

Long queries turn unreadable when the same literal appears five times. Using a WITH common table expression to name constants, scoped to the query and leaving nothing behind.