plpgsql_check
geometry-api-java
plpgsql_check | geometry-api-java | |
---|---|---|
3 | 2 | |
608 | 689 | |
- | 0.6% | |
8.2 | 4.2 | |
about 2 months ago | about 1 month ago | |
C | Java | |
GNU General Public License v3.0 or later | Apache License 2.0 |
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.
plpgsql_check
-
Supabase Local Dev: migrations, branching, and observability
Finally, while you wait for us to make progress on the Language Server, we’ve added support for linting through the excellent plpgsql_check extension.
- Postgres Invalid objects
- PostGIS – Spatial and Geographic Objects for PostgreSQL
geometry-api-java
-
What should be my go-to programming language for this scenario?
I programmed with graphical interface in the past in Java, too, which is definitely one of the top choices for me cause it gives the code a lot of structure and makes it easier to maintain and on top of that there exists a lot of community run libraries that might serve my purpose, like this one. I mostly have experience in designing games (SuperMario, Space Invaders and similar) with Java.
-
PostGIS – Spatial and Geographic Objects for PostgreSQL
It's good software (I've used it more than a decade), however I found GEOS to be a sticking point. When using it on very large polygons, e.g. 10k to 1 million vertices, memory leaks are not uncommon and performance drops off considerably. Debugging SQL -> C -> C++ is not fun and hacking C++ geometry code when it's not part of your normal work is nigh on impossible. I've found the ESRI geometry API for Java to be by far the best geometry API out there. Harder to use initially and obviously JVM specific but faster and more reliable. It's a very good fit for Hadoop / Spark or other JVM applications. Ignore the brand name, I'm not affiliated and it's FOSS with an Apache license.
https://github.com/Esri/geometry-api-java
What are some alternatives?
pgsentinel - postgresql extension providing Active session history
open-data - Free football data from StatsBomb
pg_show_plans - Show query plans of all currently running SQL statements
geomesa - GeoMesa is a suite of tools for working with big geo-spatial data in a distributed fashion.
orafce - The "orafce" project implements in Postgres some of the functions from the Oracle database that are missing (or behaving differently).Those functions were verified on Oracle 10g, and the module is useful for production work.
docker-postgis - Docker image for PostGIS
stud - Cartography 2019
tds_fdw - A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
solutions-geoevent-java - Custom processors, adapters and transports for geoevent server.
pg_plan_guarantee - Postgres Query Optimizer Extension that guarantees your desired plan will not change
pgaudit - PostgreSQL Audit Extension