Company
Date Published
Author
Jimmy Guerrero
Word count
869
Language
English
Hacker News points
None

Summary

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. It's wire compatible with PostgreSQL's SQL API. YugabyteDB can be used to migrate large tables from PostgreSQL using the COPY command, which provides better performance when enabled. The durable_wal_write flag can be used to enable fsync, guaranteeing every transaction is synced to disk before considering it successful, but this comes at a performance hit. Replacing a "dead" YugabyteDB node with a new one while keeping the same IP address is possible after 15 minutes of unavailability. The yugabyted server can be used to extract dates from timestamps using functions like date() and substring(). New documentation, blogs, tutorials, and videos have been published, including guides on sharding strategies, PostgreSQL table functions, and getting started with DbSchema. YugabyteDB is hiring software engineers, developers advocates, and other roles. The database can be explored locally on a laptop and compared to other databases like CockroachDB, Google Cloud Spanner, and MongoDB.