blog
RssDotnet
blog | RssDotnet | |
---|---|---|
11 | 1 | |
9 | 1 | |
- | - | |
6.0 | 1.5 | |
4 months ago | about 1 year ago | |
C# | ||
Creative Commons Zero v1.0 Universal | 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.
blog
- Versioning data in Postgres? Testing a Git like approach
-
A Different Type of SQL Recursion with PostgreSQL
Originally published at https://github.com/vb-consulting/blog/discussions/1
A follow up on this article was written today
[Recursion with PostgreSQL, Follup 1, Perfomances](https://github.com/vb-consulting/blog/discussions/4)
-
Recursion with PostgreSQL Follow-Up 3 - Finding the Right Path
In my previous article, I managed to get some really crazy performances in tree processing by using PostgreSQL recursive procedural-style function.
- Recursive Hierarchical Queries in SQL: A Deep Dive into Employee Level
- Which Way .NET Developer?
-
Recursion with PostgreSQL, Follup 1, Perfomances
I wrote a follow-up on yesterday's article on tree processing and recursion with PostgreSQL. This one: https://github.com/vb-consulting/blog/discussions/1
SQL was never intended for this kind of stuff; I'm sure that Fabian Pascal will tell us all about it.
And indeed, recursive CTEs are awful, confusing, and severely limited ... but they look cool and smart, and smart people use them (I hate them).
In any case, I used a procedural approach to this problem and, with a few smart optimizations, managed to squeeze some really spectacular performances (757K tree records with 20K unique nodes in just 5 seconds without any indexes, so it probably can go even faster).
RssDotnet
-
Newsletters Available?
I've got a list of a few of my favorite blogs / thought leaders in the dotnet / blazor space.
What are some alternatives?
Logidze - Database changes log for Rails
prose - Microsoft Program Synthesis using Examples SDK is a framework of technologies for the automatic generation of programs from input-output examples. This repo includes samples and sample data for the Microsoft Program Synthesis using Example SDK.
pgkit - Pgkit - Backup, PITR and recovery management made easy
azure-devops-dotnet-samples - .NET/C# samples for integrating with Azure DevOps Services and Azure DevOps Server
Architecture-of-consoles - Technical articles about console architecture
spark - .NET for Apache® Spark™ makes Apache Spark™ easily accessible to .NET developers.
developer-handbook - An opinionated guide on how to become a professional Web/Mobile App Developer.
azure-sdk-for-net - This repository is for active development of the Azure SDK for .NET. For consumers of the SDK we recommend visiting our public developer docs at https://learn.microsoft.com/dotnet/azure/ or our versioned developer docs at https://azure.github.io/azure-sdk-for-net.
aquameta - Web development platform built entirely in PostgreSQL
Plotly.Blazor - This library packages the well-known charting library plotly.js into a razor component that can be used in a Blazor project.
pgreplay - pgreplay reads a PostgreSQL log file (*not* a WAL file), extracts the SQL statements and executes them in the same order and relative time against a PostgreSQL database cluster.
SuperADD - 💿 MDT Tool that names a computer, joins to a domain in a specified OU, and adds a description.