Daniel Blendea bdaniel7

Dictionary for database `example`

Server: PostgreSQL 216.158.72.53:5432, version 13.7 (Debian 13.7-0+deb11u1)
Local time stamp: 2022-07-20T12:41:43.0051958+02:00
Schema: public

PostgreSQL is Enough

Background and Cron Jobs

A 1000x improvement in performance

We recently had to provide (near) live data to a set of views in our application. After considering the most common ways to build this we decided to go with long polling. Our entire app is event based, so we know if a certain event happed the data might have changed. Lets assume the following types represent what can happen in our application:

type CounterEvent =
  | CounterWasIncremented byValue: int

General Stuff 🤹‍♀️🍲🐤🥗

Practices-slash-Code Architecture 🏗🗽🛕🧱

🗺🐘 1000+ PostgreSQL EXTENSIONs

This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.

F# Advent 2021 Dec 08 - Fast data pipelines with F#6

Thanks to Sergey Tihon for running F# Weekly and F# Advent.

Thanks to manofstick for trying out the code and coming with invaluable feedback. Cistern.ValueLinq is very impressive.

TLDR; F#6 enables data pipelines with up to 15x less overhead than LINQ

There were many interesting improvements in F#6 but one in particular caught my eye, the attribute InlineIfLambda.

	let (\|TakeUntil\|_\|) x xs =
	match List.takeWhile ((<>) x) xs with
	\| y when y = xs -> None
	\| y -> Some(y, List.skipWhile ((<>) x) xs)

	let (\|Split\|_\|) split xs =
	match xs with
	\| TakeUntil split (x1, (_ :: x2)) -> Some(x1, x2)
	\| _ -> None

	internal class DockerMsSqlServerDatabase : IAsyncDisposable
	{
	private const string Password = "!Passw0rd";
	private const string Image = "mcr.microsoft.com/mssql/server";
	private const string Tag = "2019-GA-ubuntu-16.04";

	private static IContainer _sqlServerContainer;
	private SemaphoreSlim semaphore = new(1, 1);
	private readonly string DatabaseName;

	create or replace function companies.search_companies(
	_search varchar,
	_skip integer,
	_take integer
	)
	returns json
	language plpgsql
	as $$
	declare
	_count bigint;

Daniel Blendea bdaniel7

Dictionary for database `example`

Table of Contents

Install a Windows host in an OmniOS bhyve-branded zone

PostgreSQL is Enough

Background and Cron Jobs

A 1000x improvement in performance

General Stuff 🤹‍♀️🍲🐤🥗

Practices-slash-Code Architecture 🏗🗽🛕🧱

🗺🐘 1000+ PostgreSQL EXTENSIONs

F# Advent 2021 Dec 08 - Fast data pipelines with F#6

TLDR; F#6 enables data pipelines with up to 15x less overhead than LINQ

Daniel Blendea bdaniel7

Dictionary for database example

Table of Contents

Install a Windows host in an OmniOS bhyve-branded zone

PostgreSQL is Enough

Background and Cron Jobs

A 1000x improvement in performance

General Stuff 🤹‍♀️🍲🐤🥗

Practices-slash-Code Architecture 🏗🗽🛕🧱

🗺🐘 1000+ PostgreSQL EXTENSIONs

F# Advent 2021 Dec 08 - Fast data pipelines with F#6

TLDR; F#6 enables data pipelines with up to 15x less overhead than LINQ

Dictionary for database `example`