Hi all,
We come back with a new issue this week. If you like BetterDev, please help spead word out by refer to your friends. Buy me a coffee would be great too.
I’m a bit busy this week so we don’t have a lot of links but we will resume next week :-).
Nothing as good as when company throw out the number. Pair it with another one detail on engineering aspect of How LedgerStore supports trillions of indexes
You would have a good laugh after this. Please go ahead and read it. I won’t spoil anything here.
Title say it’s all.
OCPP, short for Open Charge Point Protocol, is like the universal language of EV charging. It sets the standard for how charging stations talk to central systems, enabling functions like monitoring, management, billing, and even integration with third-party systems. This open-source protocol isn’t just a buzzword — it’s backed by a robust community of vendors and manufacturers, making it a widely adopted and trusted solution.
Understand the exact structure with working implementation of the Llama 3 model. This is over my head, but definetely something I want to dip my toe in. These Llama model is amazing.
When building a SaaS app, you will face the question: “should we use app.domain.com” or “company-name.domain.com” ? in this article, shortcut.com shared their approach. For me, personally, I prefer to use a single subdomain because of the same login session can be shared to join other team.
rate limiting is like measureing speed? how can you measure speed at a given time? you need to measure volume, divide by time, but what define a time window? In this post, we’ll explore the three most common algorithms to answer each of these questions: Fixed windows, sliding windows and toke buckets
An interesting tale of victory after PostgreSQL rejected our attempts to optimize a query. We had a query we were observing that was growing in latency. We analyzed it and determined the best course of action was to add an index. PostgreSQL disagreed, and outrightly refused to employ the index. Following is the story of the negotiation that took place to push past the blatant rejection of Postgres.
You might have heard “it’s important to know your data” when working with databases. But what does that look like in practice? This post is one answer: an example of how knowing our data helped us debug a slow query.
Mattermost query Postgres data then index into ElasticSearch for search, but they discovered a slow query. The walk us through the investigation process and run EXPLAIN to debug the slowness.
In this post, let’s see how to control psql from outside with the coproc functionality in bash.
GPU-accelerated compiler
an extension that transforms Postgres into an analytical query engine over object stores like S3 and table formats like Delta Lake. Queries are pushed down to Apache DataFusion, which delivers excellent analytical performance. Combinations of the following object stores, table formats, and file formats are supported.
Reorganize tables in PostgreSQL databases with minimal locks
Stract is an open source web search engine hosted at stract.com targeted towards tinkerers and developers.
Photo library and interactive editor built with Next.js & Cloudinary
BetterDev Link
Every Monday