Top 23 Postgi Open-Source Projects

• PostgresApp

  58 7,118 9.2 Makefile

  The easiest way to get started with PostgreSQL on the Mac

  

Project mention: Test Driving a Rails API - Part One | dev.to | 2024-03-11

A running Rails application needs a database to connect to. You may already have your database of choice installed, but if not, I recommend PostgreSQL, or Postgres for short. On a Mac, probably the easiest way to install it is with Posrgres.app. Another option, the one I prefer, is to use Homebrew. With Homebrew installed, this command will install PostgreSQL version 16 along with libpq:

• PHP-CRUD-API

  10 3,530 7.7 PHP

  Single file PHP script that adds a REST API to a SQL database

Project mention: Need something to host a URL that listens for a POST and then talks back to on-prem SQL. | /r/sysadmin | 2023-05-10

For quick dev/arch projects at home, I usually use this: https://github.com/mevdschee/php-crud-api

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• pigsty

  4 2,769 9.6 Shell

  Battery-Included PostgreSQL Distro as a Free RDS Alternative

Project mention: Show HN: OSS PostgreSQL RDS with Supabase,PGML,Vector,Ha,PITR,Monitor,&100 Exts | news.ycombinator.com | 2023-09-24

And the only extension activated (`CREATE EXTENSION`) by default is pg_repack.

The AGPLv3 is infected by the Grafana, MinIO and citus.

https://github.com/Vonng/pigsty/blob/master/docs/PGSQL-EXTEN...

• cartodb

  2 2,721 4.4 JavaScript

  Location Intelligence & Data Visualization tool

  

• martin

  6 1,892 9.7 Rust

  Blazing fast and lightweight PostGIS, MBtiles and PMtiles tile server, tile generation, and mbtiles tooling.

  

Project mention: Martin: Generate and serve vector tiles on the fly from multiple tile sources | news.ycombinator.com | 2023-10-03

• GeoTools

  1 1,636 9.4 Java

  Official GeoTools repository

  

• osm2pgsql

  2 1,436 9.1 C++

  OpenStreetMap data to PostgreSQL converter

  

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• docker-postgis

  5 1,314 5.2 Dockerfile

  Docker image for PostGIS

  

• tegola

  2 1,231 7.3 Go

  Tegola is a Mapbox Vector Tile server written in Go

  

• tasking-manager

  6 491 9.6 JavaScript

  Tasking Manager - The tool to team up for mapping in OpenStreetMap

  

• incubator-baremaps

  8 479 8.5 Java

  Create custom vector tiles from OpenStreetMap and other data sources with Postgis and Java.

  

Project mention: FLaNK Stack Weekly 29 may 2023 | dev.to | 2023-05-30

• laravel-magellan

  2 177 7.4 PHP

  A modern PostGIS toolbox for Laravel

  

• pgstac

  1 125 7.7 PLpgSQL

  Schema, functions and a python library for storing and accessing STAC collections and items in PostgreSQL

  

• simplefeatures

  1 119 8.7 Go

  Simple Features is a pure Go Implementation of the OpenGIS Simple Feature Access Specification

• django-raster

  1 96 3.8 Python

  Django-raster allows you to create tiled map services (TMS) and raster map algebra end points for web maps. It is Python-based, and requires GeoDjango with a PostGIS backend.

  

• parse-hipaa

  2 94 6.6 JavaScript

  HIPAA & GDPR compliant ready parse-server with postgres/mongo, parse-hipaa-dashboard. Compatible with ParseCareKit

  

• xyz

  1 86 9.9 JavaScript

  An open source javascript framework for spatial data and application interfaces.

  

• FastVector

  7 45 0.0 Python

  A PostGIS based Vector Tile server with caching and filtering.

• enmodal

  6 43 3.0 JavaScript

  transit planning & analysis in your browser

• FastGeospatial

  1 29 3.0 Python

  FastGeospatial is a PostGIS geospatial api to enable geospatial analysis on geographical data within a spatial database.

• tilekiln

  1 26 8.4 Python

• NG911GISDataModel

  3 12 5.9 Python

  GIS Data Model templates based on the NENA Standard for NG9-1-1 GIS Data Model (NENA-STA-006.x)

  

Project mention: setting parameters for a custom python tool | /r/gis | 2023-05-22

Here is an example code https://github.com/NENA911/NG911GISDataModel/blob/main/esri_geodatabase/NENA_NG911_Scripts/create_ng911_fgdb.py#L621 and the Toolbox is at https://github.com/NENA911/NG911GISDataModel/tree/main/esri_geodatabase

• FastGeoTable

  1 10 0.0 Python

  FastGeoTable is a PostGIS geospatial api to enable creating/editing geographical tables within a spatial database.

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

Postgis related posts

• Full Stack Chat App with Socket.io

  3 projects | dev.to | 16 Feb 2024

• Building Secure Neon-Infused Web Apps with Auth0, Express, and EJS

  5 projects | dev.to | 18 Dec 2023

• How do I get sql exactly?

  2 projects | /r/SQL | 10 Dec 2023

• Postgres: Opinionated Rules-of-Thumb and Gotchas

  1 project | news.ycombinator.com | 27 Nov 2023

• Postgres.app – the easiest way to get started with PostgreSQL on the Mac

  1 project | news.ycombinator.com | 13 Oct 2023

• Martin: Generate and serve vector tiles on the fly from multiple tile sources

  1 project | news.ycombinator.com | 3 Oct 2023

• SQLite-based databases on the Postgres protocol? Yes we can

  4 projects | news.ycombinator.com | 4 Jul 2023
• A note from our sponsor - SaaSHub
  www.saashub.com | 5 May 2024

  SaaSHub helps you find the best software and product alternatives Learn more →

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com