This repo contain multiple algorithms to make Hex (Hexagon), Triangle (Triangular), Points, and Rectangle (Rectangular) Grids for PostGIS.
yrh2847189/PostGIS-Grids
PostgreSQL, PostGIS custom algorithms to make Hex Grid, Triangle Grid, Points Grid, and Rectangle Grid.
PLpgSQLGPL-3.0