Learn how to use JSON and JSONB types in Postgres!. Sometimes, you need to store schema-less data in your Postgres database, and JSONB type is perfect for such a use case!

JSON and JSONB columns are handy for just throwing any schemaless data at them, but sometimes you may want to add some level of enforcement!. You can use the pg_jsonschema extension to define the schema, giving you more control over the shape of those columns!

Dian Fay now presenting “Application Development Challenges with Postgres” at #PGConfDev. With over 20 years in the industry, she explores the rise of the accidental DBA, vernacular schema pitfalls, JSONB power, and the future of faster, safer app dev on #PostgreSQL.

PostgreSQL JSONb columns do No-SQL better than NoSQL does NoSQL.

@JBerri0s jsonb is a postgresql column type that allows you to store json in binary format in which you can query directly on the json data itself too. Aaron goes in depth on it here.

If you’re working with JSON in Postgres, you have probably seen that there are two separate data types for this. So … what is the difference between json and jsonb?. - json - lightweight, unprocessed storage.- jsonb - structured, indexable, and performant. ◘ json stores text

There is zero reason to use NoSql with modern migration tools. People claim JSONB in Postgres is the replacement, but it’s a mistake. Define your schema and use a migration, it’s just as fast.

PostgreSQL GROUP BY on JSONB fields still triggers index scans, no index-only scan like a B-Tree on a separate column. Read on to see why. { author: @FranckPachot } #DEVCommunity #Database.

Cause of Death?. Difference b/w SQL NULL & JSONB NULL

Another case where using JSONB to replace a document database fails with indexing.

Te tqm Postgres + JSONB ❤️

Another trap you might encounter when thinking that JSONB can turn #PostgreSQL into a document database. JSON is a valuable addition to SQL, but it should be used appropriately (as an additional datatype—not as a replacement for MongoDB)

🚀 pgstream v0.7.1 is out!. ✨ JSON transformers to transform json/jsonb data with set and delete operations. 📊 Snapshot progress tracking. ⚡ Wildcard support for snapshots. Read the blog here → #Postgres #pgstream #opensource #json #jsonb.

昨日 Laravel に送った PR が２こともマージされた！. １つ目は，Model の casts に json:unicode を追加．日本語を含む JSON を encode するとエスケープされる問題を解決. ２つ目はオプトインで SQLite の json/jsonb 型を許可する設定を追加.

wow Amazon DocumentDB is a rip off at $200/mo. Just use postgres jsonb

在 PostgreSQL 中给 jsonb 字段加索引时，选择合适的索引很重要。建议使用 GIN 索引，而不是 B-Tree，GIN 更适合处理 jsonb 查询。

MySQL is still better than PostgreSQL for 90% of startups. Every new dev team these days says the same thing:. We’re using PostgreSQL because… it’s cooler and has JSONB. But lets be honest:. - MySQL is easier to scale.- Simpler to set up and replicate.- Way more hosting options

Coral reef scientists are scaling up global conservation efforts—with help from #PostgreSQL 🌍🌊. @datamermaid uses PostGIS + JSONB to turn complex field data into real-time insights that drive smarter reef protection. Explore how open data fuels action:

First victim of vibe coding is prob the weirdest db schemas. JSONb will the salvation.