postgres_dba
The missing set of useful tools for Postgres DBAs and all engineers (by NikolayS)
advent-of-code
https://adventofcode.com/ (by xocolatl)
| postgres_dba | advent-of-code | |
|---|---|---|
| 3 | 3 | |
| 1,194 | 94 | |
| 0.6% | - | |
| 2.5 | 6.7 | |
| 24 days ago | 8 months ago | |
| PLpgSQL | PLpgSQL | |
| BSD 3-clause "New" or "Revised" License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
postgres_dba
Posts with mentions or reviews of postgres_dba.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-06-12.
-
Optimizing Postgres table layout for maximum efficiency
The ever-useful postgres_dba extension (https://github.com/NikolayS/postgres_dba) can help with this. Install the extension, start psql, run :dba and choose option p1 to see how much table space you would save by reordering your columns.
-
How to Get the Most Out of Postgres Memory Settings
This is even handier: https://github.com/NikolayS/postgres_dba
-
Postgres: The Unexpected Find That Freed 20GB of Unused Index Space
In a similar vein, I got good value from these scripts:
https://github.com/NikolayS/postgres_dba
I managed to free 10% a.k.a about 100 GB of storage by reorganizing table column ordering in a big table.
advent-of-code
Posts with mentions or reviews of advent-of-code.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-12-06.
-
Advent of Code 2021 using SQL (PostgreSQL-flavored)
- No schema needed
https://gitlab.com/feike/adventofcode/-/tree/master/2021
Some others doing sql based solutions:
https://github.com/xocolatl/advent-of-code
-
-🎄- 2021 Day 6 Solutions -🎄-
You can also add https://github.com/xocolatl/advent-of-code/ to your list (it's https://twitter.com/pg_xocolatl a pg contributor). He was such an inspiration to me last year.
-
-🎄- 2021 Day 1 Solutions -🎄-
If you want to see really good solutions, check out Vik Fearing! (https://mobile.twitter.com/pg_xocolatl and his repo for advent of code: https://github.com/xocolatl/advent-of-code)
What are some alternatives?
When comparing postgres_dba and advent-of-code you can also consider the following projects:
employee-sample-database - Employee Sample Database for MySQL, Postgres, SQLite
aoc2021 - Solutions to Advent of Code 2021
postgres-aws-s3 - aws_s3 postgres extension to import/export data from/to s3 (compatible with aws_s3 extension on AWS RDS)
advent-of-code - Advent Of Code Solutions
AGE-Machine-Learning - A project that uses Incubating Apache AGE to implment machine learning algorithms
advent-of-code-2021 - zig solutions to advent of code 2021