snowflake VS cockroach

If you're not distributed, use an incrementing integer.

If you're distributed, look into vector clocks[1] or snowflake[2]

[1] https://en.wikipedia.org/wiki/Vector_clock

[2] https://github.com/twitter-archive/snowflake/tree/snowflake-...

MongoDB ObjectId Time, Clocks, and the Ordering of Events in a Distributed System Snowflake

There are so many of them in big data, e.g. Kafka, Spark, Flink, Delta, Snowplow, Finagle, Deequ, CMAK, OpenWhisk, Snowflake, TheHive, TVM-VTA, etc.

Twitter built Snowflake https://github.com/twitter-archive/snowflake/tree/snowflake-2010

that being said, I have seen people acting weird about the whole thing, I don't care if you're mad at HYBE or BIGHIT for not telling him, what I care about are these people acting as if Jimin cannot deal with this or handle it himself. why they are THEY asking an explanation to be given to them? this is none of your business, he's a grown man and he can handle it himself. it's funny because even if he was to talk to someone about this, we will never know and that will be him dealing with his issue. they sit on twitter.com and try to play BTS manager and think they how BTS should be managed and HYBE needs to do things their way. they have managers for a reason and we are not the ones, I can't even believe this whole thing blew up so much.

Employ distributed databases like CockroachDB, Cassandra, or managed services like Amazon Aurora Global Databases.

In fact, even in the absence of these commercial databases, users can effortlessly install PostgreSQL and leverage its built-in pgvector functionality for vector search. PostgreSQL stands as the benchmark in the realm of open-source databases, offering comprehensive support across various domains of database management. It excels in transaction processing (e.g., CockroachDB), online analytics (e.g., DuckDB), stream processing (e.g., RisingWave), time series analysis (e.g., Timescale), spatial analysis (e.g., PostGIS), and more. For non-professional users seeking to explore vector databases, they can readily download the open-source PostgreSQL or utilize managed services like Supabase and Neon to establish their own basic AI applications. Other than PostgreSQL, several open-source databases, including OpenSearch, ClickHouse, and Cassandra, have implemented their own vector search functionality. You do not need to adopt a new vector database if you have already used these systems.

Postgres-compatible DSQL solutions: Distributed SQL databases that are either Postgres or Postgres-compatible like Citus, Aurora DSQL, and CockroachDB might be the right approach for handling your scale without forcing you to change much of your code. They each have their strengths and weaknesses and the right one for you depends on your use cases and needs.

Still very much "open-source": https://github.com/cockroachdb/cockroach

But relicensed to the "CockroachDB Software License" as a form of BSL to prevent reselling.

code in a given file is licensed under the BSL and ..." That is sucky.

[0] https://github.com/cockroachdb/cockroach?tab=License-1-ov-fi...

CockroachDB — Distributed SQL database built for cloud applications.

CockroachDB is a distributed SQL database designed for cloud applications. It provides strong consistency, horizontal scalability, and high availability.

Round rectangles can look not round enough on low-DPI displays, and the colors can also be wrong due to incorrect averaging in non-linear color space. Example: https://github.com/ClickHouse/ClickHouse/pull/33453#issuecom...

It is similar to how subtle gradients look striped and dirty on many websites if displayed with only 24-bit color: https://github.com/cockroachdb/cockroach/issues/91316