Our great sponsors
|3 days ago||4 days ago|
|GNU General Public License v3.0 or later||GNU General Public License v3.0 or later|
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Good database solution
3 projects | reddit.com/r/saasprojects | 8 Mar 2023
Does Go work well as a systems language?
6 projects | reddit.com/r/golang | 5 Mar 2023
You absolutely can write very high performance software in Go, that's kind of the point. You can efficiently interface with C libraries. You can create the sort of software everyone says should be done in Rust, like databases and web servers and system orchestration and games and every other goddamn thing that people will say isn't the right choice for Go.
Embed hard-coded SQL into binaries for a cleaner look!
4 projects | dev.to | 12 Feb 2023
PostgreSQL Parser separated from CockroachDB, a distributed DB.
Any self hostable postgres, clustering, replication and fail over system?
3 projects | reddit.com/r/selfhosted | 25 Jan 2023
Analysing Github Stars - Extracting and analyzing data from Github using Apache NiFi®, Apache Kafka® and Apache Druid®
8 projects | dev.to | 11 Jan 2023
Spencer Kimball (now CEO at CockroachDB) wrote an interesting article on this topic in 2021 where they created spencerkimball/stargazers based on a Python script. So I started thinking: could I create a data pipeline using Nifi and Kafka (two OSS tools often used with Druid) to get the API data into Druid - and then use SQL to do the analytics? The answer was yes! And I have documented the outcome below. Here’s my analytical pipeline for Github stars data using Nifi, Kafka and Druid.
Ask HN: What is your distributed and fault-tolerant PostgreSQL setup?
2 projects | news.ycombinator.com | 26 Dec 2022
Anyone had a success story of replacing C++ with Go?
6 projects | reddit.com/r/golang | 4 Dec 2022
One of the most popular distributed DB is built in Go: https://www.cockroachlabs.com/6 projects | reddit.com/r/golang | 4 Dec 2022
Display CockroachDB metrics in Splunk Dashboards
5 projects | dev.to | 2 Dec 2022
Recently, I worked on such an integration with Splunk. The Splunk dashboard files that emulate the DB Console are now available in our repo for everyone's benefit.
How do I implement a HA PostgreSQL setup in k8s/k3s ?
4 projects | reddit.com/r/kubernetes | 23 Nov 2022
Technically not postgres, but could be worth checking out cockroach db, it can use any postgres driver from programming languages and is build for distribution. I recently moved from postgres to cockroach (with golang postgres driver) and didnt need to change a single query
pREST on YugabyteDB
2 projects | dev.to | 22 Jan 2023
In a previous post, I published an example with PostgREST on YugabyteDB. Here is another one: pREST opens a REST API to PostgreSQL. YugabyteDB is a PostgreSQL-compatible Open-Source Distributed SQL database. It adds horizontal scalability to applications built for PostgreSQL. Let's see how it integrates with pREST.
FerretDB + YugabyteDB on Kubernetes (Amazon EKS): a MongoDB API to Distributed SQL, at scale
3 projects | dev.to | 19 Jan 2023
There is still work in progress in FerretDB, like Create primary key index for _id automatically #1384 . If a Primary Key is added with with the ID, it will become the sharding key in YugabyteDB. Another optimization will be to avoid reading information_schema.columns which is slow on YugabyteDB (the catalog must be shared by all nodes). This will be optimized on YugabyteDB (#7745). If it is still a scalability issue, there's also the possibility to fork the PostgreSQL handler to optimize it for YugabyteDB. All this is open source 🤩 YugabyteDB and FerretDB are Apache License 2.0
Virtualbox 7.0.4 kickstart issue
5 projects | dev.to | 8 Dec 2022
I was building a new version of YugabyteDB vagrant box with packer and virtual box. Because we (Yugabyte) have a new preview release out.
Ask HN: Is there any great free PostgreSQL provider?
2 projects | news.ycombinator.com | 3 Dec 2022
LSM-tree storage in YugabyteDB and packed rows
2 projects | dev.to | 1 Dec 2022
The sst_dump command in version 220.127.116.11 is not yet updated to handle packed rows. I created an issue for it: [DocDB] sst_dump does not recognise packed rows and displays 'Schema packing not found: 0: .'.
3 projects | dev.to | 19 Nov 2022
pgcat: a PostgreSQL pooler
6 projects | dev.to | 14 Nov 2022
I created a pool called "yugabyte" (pools.yugabyte), with pool mode 'session', so that a session remains connected to a backend. I created a pool of servers in pools.yugabyte.shards.0 (yugabyte shards pool 0), with all three of the YSQL nodes in the YugabyteDB cluster, and gave one the role of "primary" and the two others the role of "replica". For YugabyteDB YSQL this does not make sense. Currently, pgcat allows to have the roles to be all "replica", but not have more than one "primary".
Automating Java Application Deployment Across Multiple Cloud Regions
2 projects | dev.to | 2 Sep 2022
As an example, this is how I start a VM in the US West and connect it to my YugabyteDB cluster in the US East:
How to Build a Multi-Zone Java App in One Day
3 projects | dev.to | 18 Aug 2022
YugabyteDB might still be a dark horse for many. That’s the database I’m nerding on these days. It’s a distributed SQL database built on PostgreSQL. Basically, it’s a distributed PostgreSQL that can work across geographies. Exactly what I need for my geo-distributed app.
Moving a Python Application to a Distributed Database in Three Easy Steps.
4 projects | dev.to | 14 Jul 2022
YugabyteDB is an ideal choice here as it is an open-source, PostgreSQL compatible distributed SQL database. (If you want to know more about how and why to use YugabyteDB, you can check out this amazing playlist on YouTube).
What are some alternatives?
vitess - Vitess is a database clustering system for horizontal scaling of MySQL.
tidb - TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial
citus - Distributed PostgreSQL as an extension
Trino - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
rqlite - The lightweight, distributed relational database built on SQLite
InfluxDB - Scalable datastore for metrics, events, and real-time analytics
dgraph - Native GraphQL Database with graph backend
Redis - Redis is an in-memory database that persists on disk. The data model is key-value, but many different kind of values are supported: Strings, Lists, Sets, Sorted Sets, Hashes, Streams, HyperLogLogs, Bitmaps.
snowflake - Snowflake is a network service for generating unique ID numbers at high scale with some simple guarantees.
edgedb - A graph-relational database with declarative schema, built-in migration system, and a next-generation query language
go-mysql - a powerful mysql toolset with Go
psycopg2 - PostgreSQL database adapter for the Python programming language