developer-handbook
blog
Our great sponsors
developer-handbook | blog | |
---|---|---|
2 | 11 | |
5,752 | 9 | |
1.7% | - | |
0.0 | 6.0 | |
2 months ago | 3 months ago | |
MIT License | Creative Commons Zero v1.0 Universal |
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.
developer-handbook
-
100+ Must Know Github Repositories For Any Programmer
6. Developer Handbook
- Questions in Front-end Interview
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).
What are some alternatives?
front-end-interview-handbook - ⚡️ Front End interview preparation materials for busy engineers
Logidze - Database changes log for Rails
The-complete-guide-to-modern-JavaScript - A comprehensive, easy-to-follow ebook to learn everything from the basics of JavaScript to ES2022. Read more on my blog https://inspiredwebdev.com or buy it here https://www.amazon.com/dp/B09FNNVY1Y?ref=inspiredwebde-20. Get the course here https://www.educative.io/courses/complete-guide-to-modern-javascript?aff=BqmB
pgkit - Pgkit - Backup, PITR and recovery management made easy
Project-Ideas-And-Resources - A Collection of application ideas that can be used to improve your coding skills ❤.
Architecture-of-consoles - Technical articles about console architecture
JavaScript-es6-and-beyond-ebook - A comprehensive, easy-to-follow ebook to learn everything from the basics of JavaScript to ES2020. Read more on my blog https://inspiredwebdev.com or buy it here https://leanpub.com/completeguidetomodernjavascript2020. Get the course here https://www.educative.io/courses/complete-guide-to-modern-javascript?aff=BqmB [Moved to: https://github.com/AlbertoMontalesi/The-complete-guide-to-modern-JavaScript]
aquameta - Web development platform built entirely in PostgreSQL
cdnjs - 🤖 CDN assets - The #1 free and open source CDN built to make life easier for developers.
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.
tech-stack - Underrated Developer Handbook
RssDotnet - A list of my favourite dotnet RSS feeds