We are excited to announce the general availability of Yugabyte DB 2.0! The highlight of this release is that it delivers production readiness for Yugabyte SQL (YSQL), our high-performance, fully-relational distributed SQL API. For those of you new to distributed SQL, Yugabyte DB is a Google Spanner-inspired, cloud-native distributed SQL database that is 100% open source. It puts a premium on high performance, data resilience, geographic distribution while ensuring PostgreSQL compatibility.
Schema Spy
Document your database simply and easily
Alternatives:
- Schema Crawler
- DbSchema
dbdiagrams
this tool helps you quickly generate beautiful database/ER diagrams for your postgres db schema :
- the script auto-generates the code by detecting postgres db schema
- this code(sample) can be then copy pasted onto an online tool called dbdiagram.io
Ultimate PostgreSQL Slug Function
What is a slug?!
If you’re reading this, you probably know, but a slug is a URL/SEO friendly representation of a string. If for example you wrote an article:
The World’s “Best” Cafés!
You’d want a slug function to create a representation that looks a bit like:
the-worlds-best-cafes
Granted browsers can probably handle the accented “e” but it’s good to be over conservative for backwards compatibility.
PostgreSQL slug function
The most comprehensive slug function I’ve seen for Postgres (and in general) is by
iankson Github. Slug functions are one of those things that never seems to have a definitive “best and final” version, but this has been very reliable for me.