|3 days ago||about 1 month ago|
|Apache License 2.0||MIT License|
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.
Typesafe Database Queries on the Edge
9 projects | dev.to | 12 Nov 2022
PlanetScale is a serverless MySQL database provider which is based on Vitess. You get the scaling benefits of Vitess without the need to manage it yourself.
YouTube confirms that it has removed the “sort by oldest/newest” option
10 projects | news.ycombinator.com | 11 Nov 2022
Ask HN: Real-world anecdotes of MySQL at scale?
2 projects | news.ycombinator.com | 27 Sep 2022
Are you referring to distributed MySQL such as Vitess? It is the backend for Slack and GitHub; also was the backend for YouTube in the past.2 projects | news.ycombinator.com | 27 Sep 2022
There’s Vitess that’s been mentioned on HN a lot recently. https://vitess.io/
One million queries per second with MySQL
3 projects | news.ycombinator.com | 1 Sep 2022
> A relational database without relations is an oxymoron.
OK. You're the only one talking to this straw man though. :-) Every Vitess user that I'm aware of has a pretty typical 2NF/3NF schema design. A small sampling of them being listed here: https://vitess.io
You setup your data distribution/partitioning/sharding scheme so that you have data locality for 99.9999+% of your queries -- meaning that the query executes against a data subset that lives on a single shard/node (e.g. sharding by customer) -- and you live with the performance hit and consistency tradeoffs for those very rare cases that cross shard queries cannot be avoided (Vitess does support this). You should do this even if the solution you're using claims to have distributed SQL with ACID and MVCC guarantees/properties. There's no magic that improves the speed of light and removes other resource constraints. In practice most people say they want perfect security/consistency/ but then realize that the costs (perf, resources, $$, etc) are simply so high that it is not practical for their business/use case.
I know MySQL fairly well (I started working at MySQL, AB in 2003) and you can certainly claim that "MySQL-compatible" is dishonest but I would offer a counter claim that either you don't know this space very well or you're not operating in good faith here.
Need ideas for dealing with networking for high-throughput IoT platform
3 projects | reddit.com/r/sysadmin | 27 Jun 2022
Rather than do this sharding manually, you can use something like Vitess.
Databases inside or outside k8s cluster?
4 projects | reddit.com/r/kubernetes | 7 Jun 2022
Examples: - Vitess - MySQL cluster - YugabyteDB - ScyllaDB - Couchbase - ArangoDB
How I made a really fast Link Shortener that runs on the edge
7 projects | dev.to | 31 May 2022
The frontend is built with Next.js which is a full stack React framework. I'm using tRPC as my API layer for that sweet type-safety. I wrote a blog about tRPC if you're not familiar with it. The database is a MySQL database (Vitess to be precise) provided by PlanetScale.
Dragonflydb – A modern replacement for Redis and Memcached
20 projects | news.ycombinator.com | 30 May 2022
> Every major technological startup turned away from BSD/Apache 2.0 licenses due to inability to compete with cloud providers without technological edge.
No, there are plenty that still use permissive licenses.
GitLab uses MIT and a custom license for EE: https://docs.gitlab.com/ee/development/licensing.html
Deno uses an MIT license and has some secret sauce that is currently just in hosted services AFAIK: https://github.com/denoland/deno/blob/main/LICENSE.md
Finally Redis has a BSD licensed core, a source available license for additional modules, and a closed source license for enterprise. https://redis.com/legal/licenses/
PlanetScale Insights: Advanced query monitoring
3 projects | news.ycombinator.com | 26 May 2022
Installing the time zone tables on a single instance is certainly not hard: https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.ht...
The trickier part is orchestrating the ongoing management of that across a large dynamic fleet. And in this case, it was much more than simply loading the tables but about using them to support importing databases into PlanetScale: https://github.com/vitessio/vitess/pull/10102
I'll link to my other comment on the billing issue: https://news.ycombinator.com/item?id=31509240
We've had to do some other changes to our MySQL fork as well that will show up there, but we'd love to not have any patches! We'd love to keep the patch set minimal (just as Amazon certainly does with RDS and Aurora). And I would certainly argue that Vitess, which is what we build PlanetScale around, is a meaningful piece of technology that pairs with MySQL to make a great database: https://vitess.io
Your Data Fits in RAM
4 projects | news.ycombinator.com | 2 Aug 2022
I actually worked on a project that did this. We used a database called "Tile38"  which used an R-Tree to make geospatial queries speedy. It was pretty good.
Our dataset was ~150 GiB, I think? All in RAM. Took a while to start the server, as it all came off disk. Could have been faster. (It borrowed Redis's query language, and its storage was just "store the commands the recreate the DB, literally", IIRC. Dead simple, but a lot of slack/wasted space there.)
Overall not a bad database. Latency serving out of RAM was, as one should/would expect, very speedy!
Redcon - Redis compatible server framework for Rust
10 projects | reddit.com/r/rust | 14 May 2022
I ported it from Go and use it for my Tile38 project.
Path hints for B-trees can bring a performance increase of 150% – 300%
3 projects | news.ycombinator.com | 30 Jul 2021
What are some alternatives?
supabase - The open source Firebase alternative. Follow to stay updated about our public Beta.
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
cockroach - CockroachDB - the open source, cloud-native distributed SQL database.
citus - Distributed PostgreSQL as an extension
go-mysql-elasticsearch - Sync MySQL data into elasticsearch
kingshard - A high-performance MySQL proxy
migrate - Database migrations. CLI and Golang library.
goleveldb - LevelDB key/value database in Go.
ledisdb - A high performance NoSQL Database Server powered by Go
groupcache - groupcache is a caching and cache-filling library, intended as a replacement for memcached in many cases.
InfluxDB - Scalable datastore for metrics, events, and real-time analytics