Redis is a fast single-threaded data structure server, commonly used as a cache, scratchpad, queue, or coordination mechanism between distributed applications. It offers operations over a broad array of datatypes , including binary blobs, lists, sets, sorted sets, maps, geohashes, counters, channels, streams, and…
The resurgence of SQL-based data modeling is a something we should all be interested in. Here's why it's important.
There’s widespread use of adblockers on the web but users are increasingly blocking cookies and other tracking scripts too. Browsers such as Safari, Firefox and Brave are privacy-focused.
The Postgres database is rich with features well beyond that of any other
PostgreSQL 13 development is coming along nicely, Postgres 13 Beta3 was released on 8/13/2020 . The Postgres Beta 1 and 2 releases were released in May and June 2020. One of the features that has my interest in Postgres 13 is the B-Tree deduplication effort. B-Tree indexes are the default indexing method in Postgres…
We’ve been writing a bit about some odd tail behavior in the Fivethirtyeight election forecast, for example that it was giving Joe Biden a 3% chance of winning Alabama (which seemed high), it was displaying Trump winning California as in “the range of scenarios our model thinks is possible” (which didn’t seem right)…
Vacuum is one of the sub-systems in PostgreSQL which gets improved with each release. I have checked past five releases and each has qu...
From zero to linear regression
Why TOAST is the best thing since sliced bread
Grafana is an open source visualization and dashboarding technology that allows you to explore your metrics, logs, and traces no matter where the data is.
We are facing some interesting times at work as we are going to start changing our technology stack in the near future. Most of our Oracle ...
Databases are fabulous resources. Of course, we’ll abuse them in ways that cause challenges.
GoodJob is a new Postgres-based, multithreaded, second-generation ActiveJob backend for Ruby on Rails.
Hundreds of published studies over the last decade have claimed it's possible to predict an individual’s patterns of thoughts and feelings by scanning their brain in an MRI machine as they perform some mental tasks.
I’ve spent the last few months preparing for and applying for data science jobs. It’s possible the data science world may reject me and my lack of both experience and a credential above…
Django is currently the most commonly used full-stack web framework for Python. It has been around for a good 15 years, emerging as a winner from a period in which Python was already mature, but its web development tools were comparatively much more immature and fragmented.
The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 13 is now [available for download](https://www.postgresql.org/download/). This …
Scylla is a distributed wide-column 1 database which originated as a C++ port of Cassandra, aiming for improved performance. It supports both Cassandra- and DynamoDB -compatible APIs, and is intended for high-throughput, low-latency workloads, including analytics, messaging, and other time-series data.
Fully managed Cloud SQL cloud database service now supports PostgreSQL 13.
How SIMD instructions make aggregations faster in QuestDB, including benchmark results and a comparison with Postgres.
