pgzx VS cockroach

Demo Image Gallery https://image-gallery-cms-with-astro-xata-cloudflare.pages.dev/rishi GitHub Repo https://github.com/rishi-raj-jain/image-gallery-cms-with-astro-xata-cloudflare Astro with Xata https://xata.io/docs/getting-started/astro Astro View Transition Forms https://docs.astro.build/en/guides/view-transitions/#transitions-with-forms Xata File Attachments https://xata.io/docs/sdk/file-attachments#upload-a-file-using-file-apis Xata Transformations https://xata.io/docs/sdk/image-transformations Xata Get Records https://xata.io/docs/sdk/get#the-typescript-sdk-functions-for-querying Cloudflare Workers Limits https://developers.cloudflare.com/workers/platform/limits/#request-limits

Resource Link GitHub Repo https://github.com/rishi-raj-jain/remix-wysiwyg-litellm-xata-vercel Remix with Xata https://xata.io/docs/getting-started/remix Xata File Attachments https://xata.io/docs/sdk/file-attachments#upload-a-file-using-file-apis Remix Route Actions https://remix.run/docs/en/main/discussion/data-flow#route-action Remix Route Loaders https://remix.run/docs/en/main/discussion/data-flow#route-loader

We're building on top of Aurora at https://xata.io.

Currently our Aurora instances are in private beta. If you're interested in trying it out, drop me an email: [email protected]

Resource Link GitHub Repo https://github.com/rishi-raj-jain/xata-rag-chatbot SvelteKit with Xata https://xata.io/docs/getting-started/sveltekit Xata Vector Search https://xata.io/docs/sdk/vector-search How to Prompt Llama 2 https://huggingface.co/blog/llama2#how-to-prompt-llama-2 SvelteKit AI SDK https://sdk.vercel.ai/docs/guides/frameworks/sveltekit

A Xata account

Like Supabase, Xata is a serverless database platform that was founded in 2020 and supports Postgres. It combines the powers of PostgreSQL and ElasticSearch for database operations.

Consider also the companies and work behind pgrx [0] and pgzx [1]:

[0] https://github.com/pgcentralfoundation/pgrx

[1] https://github.com/xataio/pgzx

Restate is built as a sharded replicated state machine similar to how TiKV (https://tikv.org/), Kudu (https://kudu.apache.org/kudu.pdf) or CockroachDB (https://github.com/cockroachdb/cockroach) are designed. Instead of relying on a specific consensus implementation, we have decided to encapsulate this part into a virtual log (inspired by Delos https://www.usenix.org/system/files/osdi20-balakrishnan.pdf) since it makes it possible to tune the system more easily for different deployment scenarios (on-prem, cloud, cost-effective blob storage). Moreover, it allows for some other cool things like seamlessly moving from one log implementation to another. Apart from that the whole system design has been influenced by ideas from stream processing systems such as Apache Flink (https://flink.apache.org/), log storage systems such as LogDevice (https://logdevice.io/) and others.

We plan to publish a more detailed follow-up blog post where we explain why we developed a new stateful system, how we implemented it, and what the benefits are. Stay tuned!

CockroachDB is an open source distributed SQL database designed for scalability and resilience. While it offers SQL databases, CockroachDB is also compatible with PostgreSQL.

cockroachdb might be close: https://github.com/cockroachdb/cockroach

CockroachDB - SQL

For example, when you create a serverless postgres database with a platform like CockroachDB or Neon, you effectively get a connection string with a strong password. Anyone can connect to your database from anywhere so long as they have the right connection string. There are no security settings in these services to change this behavior.

> Yes you can on the android emulator. The biggest issue is compu arch in that case.

I can also download VirtualBox and run all Windows programs, that would mean that all Windows apps are Linux apps?

> Yes you can for the most part

You can't statically link glibc: https://github.com/cockroachdb/cockroach/issues/3392

glibc can break stuff: https://www.gamingonlinux.com/2022/08/valve-dev-understandab...

I had binaries break because the newer version if openssl was put under a slightly different name.

Also, worth noting, if you're already using PostgreSQL (or plan to) you might want to take a look at https://www.cockroachlabs.com/ they have a free tier too and CockroachDB has a PostgreSQL interface.

I know that some projects like cockroach use custom build tools like bazel. But we actually really like to use to be able to build our projects simply with the great go toolchain and don't really aim to dive deep into custom build solutions.

CockroachDB is designed to be globally distributed. It has to handle causality when resolving collisions. It has to account for having a write operation to arrive after another and still have time priority because it was sent out a few milliseconds earlier.

Cockroachdb created a go runtime patch which measures the Grunning time of a goroutine: https://github.com/cockroachdb/cockroach/pull/82356. It doesn't entirely solve the problem though.