|
HyperLogLog Javascript (js-hll) & Postgres (postgres-hll): making them talk to each other!
-
geo.rocks
-
5 years ago
-
eng
1 2 3 4 5 6 7 8 9 10 11 hex_array = [ "/x138b7f010101c101e3024104e1058305a105c3072207810922098209a209c30b220c410ce20e210e410e610ee11002106310a210e31323138513a213c2142114421463156115a115e416011661168316a216e1186218a31927194119611aa81b411b611be11c411d431dc21e22218121a121e122a322e12324236123c224c12641266127c3288329442a012a612b012be22cc52d412e612e812fa12fc1302131843282338133e335023541356235a236233641382338....
|
|
Feedback is one of the most importante things when you are creating a product (probably the most important one!), so it should be easy for users to give feedback. In this post we’ll see how to implement a feedback button easily. This exact code is what I’m using at drwn.io , a little project I’m working on with a friend. The button does the following: after you use it, it will change its text to “Thank you!”, then it will fade out we wil..
|
|
Tests should be correct by inspection Tests require a different approach than normal code. We don't have tests for tests, so tests need to be correct by inspection -- and the main technique to achieve this is to get rid of the generality of the production code, and exercise only very narrow and specific scenarios. Decide what test to write The goal of testing is to increase confidence A test's purpose is to increase the confidence that y....
|
|
Tests should be correct by inspection Tests require a different approach than normal code. We don't have tests for tests, so tests need to be correct by inspection -- and the main technique to achieve this is to get rid of the generality of the production code, and exercise only very narrow and specific scenarios. Decide what test to write The goal of testing is to increase confidence A test's purpose is to increase the confidence that y....
|
|
Tests should be correct by inspection Tests require a different approach than normal code. We don't have tests for tests, so tests need to be correct by inspection -- and the main technique to achieve this is to get rid of the generality of the production code, and exercise only very narrow and specific scenarios. Decide what test to write The goal of testing is to increase confidence A test's purpose is to increase the confidence that y....
|
|
If you’re using the AWS suite of Kubernetes-related tools, you’ll be pleased to know that you use Snyk to scan directly into your workflows there, with integrations into Amazon Elastic Container Registry ( ECR ) and Amazon Elastic Kubernetes Service ( EKS ).
|
|
Querying Postgres with Python Fastapi Backend and Leaflet-Geoman Frontend - Applying Geometry Filters
-
geo.rocks
-
5 years ago
-
eng
Querying Postgres with Python Fastapi Backend and Leaflet & Geoman Fronted - Applying Geometry Filters How to query a database with a user-defined geometry drawn on a Leaflet frontend? A very common use case for map applications are custom filters. Either thematic, temporal or value-based filters play a significant role but probably in a geographical context the most dominant one might be spatial filtering. In this blog post, I describe a..
|
|
Add Diagnostic Settings to Azure Storage account via Terraform
-
blog.gripdev.xyz
-
5 years ago
-
eng
So you want to add a diagnostic setting to your Azure storage account via Terraform and you pass the storage account ID to target_resource_id only to get the following error: Status=400 Code=“BadRequest” Message=“Category ‘StorageWrite’ is not supported.” Here is the fix, the diagnostic target resource actually needs to be a sub-resource of the storage account, the ID for that is constructed as: /blobServices/default/ Using ..
|
|
If you have heard about blockchain or cryptocurrency, then the term that initially comes to mind is Bitcoin . Launched 12 years ago, it was the late 2017 bull run that created a media frenzy that propelled Bitcoin into the mainstream and our modern day lexicon. -Continue to read the article on SerHack.me
|
|
In this installment of our cheatsheet series, we’re going to cover eight Go security best practices for Go developers.
|
|
Panics in Rust are normally isolated to the thread that caused them, and are sometimes recoverable. This post introduces panik-rs, a crate to make panics on all threads fatal (to the application!) and prevent them from being silently swallowed.
|
|
Panics in Rust are normally isolated to the thread that caused them, and are sometimes recoverable. This post introduces panik-rs, a crate to make panics on all threads fatal (to the application!) and prevent them from being silently swallowed.
|
|
This post derives finite-sample bias-correction factors for MAD to make it a consistent estimator of the standard deviation. Pragmastat recommends Spread — the Shamos estimator — as a more efficient robust scale alternative that does not require such corrections. Confidence intervals are available via SpreadBounds . pragmastat.dev github.com/AndreyAkinshin/pragmastat The median absolute deviation ($\textrm{MAD}$) is a robus....
|
|
If you are trying to get Debian 10 Buster to run in Vagrant and are receiving the following error default: /dev/vda does not exist, so cannot grub-install to it! default: You must correct your GRUB install devices before proceeding: default: default: dpkg-reconfigure grub-pc default: dpkg: error processing package grub-pc (--configure): default: installed grub-pc package post-installation script subprocess returned error exit status 1 d..
|
|
After almost a decade, we decided to rebuild our in-house Business Intelligence web application to better support the organization. It is always challenging to replace software with a long history and a high degree of complexity. Nevertheless, we successfully completed the project because we fundamentally challenged and re-thought all aspects of the project.
|
|
This post derives finite-sample bias-correction factors for MAD to make it a consistent estimator of the standard deviation. Pragmastat recommends Spread — the Shamos estimator — as a more efficient robust scale alternative that does not require such corrections. Confidence intervals are available via SpreadBounds . pragmastat.dev github.com/AndreyAkinshin/pragmastat The median absolute deviation ($\textrm{MAD}$) is a robus....
|
|
After almost a decade, we decided to rebuild our in-house Business Intelligence web application to better support the organization. It is always challenging to replace software with a long history and a high degree of complexity. Nevertheless, we successfully completed the project because we fundamentally challenged and re-thought all aspects of the project.
|
React libraries are hard to keep track of. This article attempts to put the ones worth talking about on one page.
|
|
Ever had your old, trusty Python virtual environment fail on you? I sure did. Sometimes, when I activate or switch between virtual environments, I get the following error: $ workon eve dyld: Library not loaded: @executable_path/../.Python I never really took the time to look into it. When this happens, because I am in a rush (and because I am a lazy old fart), I shrug it off, recreate the virtual environment on the spot, and get back to ..
|
|
CSS-in-JS is a relatively new and a very contradictory way of writing CSS. On the one hand, it tries to overcome the limitations of traditional CSS to make it more reusable, especially when it comes to styling components. On the other hand, it’s different from traditional CSS and has it’s own disadvantages. There is no single CSS-in-JS library, there is even no sight of a clear winner in this race. However, all CSS-in-JS implementations hav..
|
|
CSS-in-JS is a relatively new and a very contradictory way of writing CSS. On the one hand, it tries to overcome the limitations of traditional CSS to make it more reusable, especially when it comes to styling components. On the other hand, it’s different from traditional CSS and has it’s own disadvantages. There is no single CSS-in-JS library, there is even no sight of a clear winner in this race. However, all CSS-in-JS implementations hav..
|
|
By focusing on what is interesting and keeping written track of your own intellectual development, topics, questions, and arguments will naturally emerge without force.
|
|
By focusing on what is interesting and keeping written track of your own intellectual development, topics, questions, and arguments will naturally emerge without force.
|
|
Here’s the High Performance Block IO on Linux hacking session video. It’s based on my recent article about achieving 11M IOPS & 66 GB/s IO on a single ThreadRipper workstation . Enjoy! Towards the end of this video, I also explain how I got up to 11.5M IOPS without having to keep CPUs 100% busy, with batched I/O submission and completion checks I reduced the CPU usage pretty noticeably. Also, with properly configuring I/O p..
|
|
Here’s the High Performance Block IO on Linux hacking session video. It’s based on my recent article about achieving 11M IOPS & 66 GB/s IO on a single ThreadRipper workstation . Enjoy! Towards the end of this video, I also explain how I got up to 11.5M IOPS without having to keep CPUs 100% busy, with batched I/O submission and completion checks I reduced the CPU usage pretty noticeably. Also, with properly configuring I/O p..
|
Red Mulberry ( Morus rubra ). (By: Famartin CC BY-SA 3.0 ) It is with great excitement and joy, I’d like to introduce to you the first post in a series of growlogs detailing my adventures with growing rare and beautiful Red Mulberry Trees . The first post will discuss what is mulberry tree , why I decide to focus on a red mulberry and how I am growing them.
|
|
It’s February and I am already planting my tree seeds for spring! The gardening technique I will be using is called “Winter-Sowing” . This is my first blog post pertaining to growing trees from winter sown seeds. I plan on logging and documenting my growing experience in this series of weblogs titled as Winter Sown Seeds Weblog .
|
|
Some time ago I wrote a similar post about React, in which with a few lines of code we have built a tiny ReactJS clone from scratch. But React is not the only choice in the modern frontend world, and VueJS is constantly gaining its popularity, so why don’t we look deeper into how it works and maybe create a silly educational VueJS-like framework. Reactivity Like ReactJS, Vue is reactive, meaning that all the changes in the application state..
|
|
Some time ago I wrote a similar post about React, in which with a few lines of code we have built a tiny ReactJS clone from scratch. But React is not the only choice in the modern frontend world, and VueJS is constantly gaining its popularity, so why don’t we look deeper into how it works and maybe create a silly educational VueJS-like framework. Reactivity Like ReactJS, Vue is reactive, meaning that all the changes in the application state..
|
|
Audio on Unix is a little zoo, there are so many acronyms for projects and APIs that it's easy to get lost. Let's tackle that issue! Most articles are confusing because they either use audio technical jargon, or because they barely scratch the surface and leave people clueless. A little knowledge can be dangerous.
|