Graphhopper
pg_cron
Our great sponsors
Graphhopper | pg_cron | |
---|---|---|
26 | 20 | |
4,660 | 2,545 | |
2.0% | 3.5% | |
9.2 | 6.1 | |
7 days ago | about 14 hours ago | |
Java | C | |
Apache License 2.0 | PostgreSQL License |
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.
Graphhopper
-
The Open Source GraphHopper Routing Engine 8.0 Released
Well I think what he means is that we dropped the explicit support of Android and the example app with offline maps (Mapsforge), see this issue: https://github.com/graphhopper/graphhopper/issues/1940
But offline routing should still work on Android. But as you need JDK 1.8 support this will exclude a few older Android versions and devices, I think.
- Seeking a Simple and Cost-Effective Tool for Calculating Distances and Travel Times in Node.js Backend
-
A software that will plan the most efficient routes for visiting address from my work location
Graphhopper. It has an Android client that uses its web service. You can also try out the web app.
-
Dangerous pedestrian crossing
This is now fixed and deployed. See the route here and the specific fixed examples here. Note that you can still find the dangerous spots via clicking the "stop" icon below the route information multiple times. But this is likely a result of the bad cycling infrastruture as cycle.travel contains these short dangerous parts too and if you do such longer routes for Germany it does not happen.
-
I Made A Way To Find Gravel Roads!
I'd suggest refactoring to use a self hosted version of Graphhopper (https://www.graphhopper.com/open-source/ - they have a docker image you can use and pass in an OSM file to build a graph on) or OpenRouteService to limit your cost exposure to google.
-
The New GraphHopper Maps Route Planner
Open Source. The routing server is open source too and geocoding too.
-
How The Post is replacing Mapbox with open source solutions
Valhalla is great (I've contributed a few patches and run it for a while)!
Also check:
http://project-osrm.org/
https://www.graphhopper.com/open-source/
- API to get the name of the cities/locations/districts between two geographical points?
-
Self-hosted schedulers?
if you attached a geolocation to each meeting that should be possible. either using the google maps API or a self-hosted graphHopper instance
-
Map matching GPX -> GPX?
I just improved the documentation for the map matching a bit. Maybe this also helps a bit.
pg_cron
-
Supabase Beta May 2023
[Postgres Extensions] pg_cron 1.5.2 (new projects only) now supports sub-minute schedules. PR
-
🏺Database Architecture - History Over State
(Your PostgreSQL installation might already have pg_cron available, but if not, you would need to install it)
- Edge Functions or Database Functions?
-
Upgrading to PostgreSQL 15 on Mac OS
I’d set up citusdata/pg_cron in 14, so I’ll need to set that up in 15 as well.
-
PostgreSQL Functions in Typescript
Functions can be executed via a database query or on a regular schedule. Trigger functions are a special type of function that are covered in a previous article. They provide a way to execute an action based on a database event.
-
Pulling Cloud API data to PostgreSQL server (Supabase)
* extraction and loading: the psql-http PostgreSQL extension which is available in Supabase (but not all services like AWS RDS). Not sure how it works with OAuth but something to look into. * automation: use pg_cron to automate the ingest. * transformation: leverage Postgresql JSON functions.
- How to : trigger a MV refresh after another MV refreshed ?
-
Is it conventional to use Redis in an authentication service?
A low-level alternative is using a PostgreSQL-side facility like https://github.com/citusdata/pg_cron - this, however, requires installing a PostgreSQL extension.
- Como agendar execução de consultas e comandos pelo PostgreSQL no RDS
-
Do you know of a robust library that handles persistent job scheduling and queuing using PostgreSQL
If you just want scheduling queries, you can use this https://github.com/citusdata/pg_cron
What are some alternatives?
valhalla - Open Source Routing Engine for OpenStreetMap
pg_timetable - pg_timetable: Advanced scheduling for PostgreSQL
Traccar - Traccar GPS Tracking System
pg_dbms_job
openrouteservice - 🌍 The open source route planner api with plenty of features.
pg_background - pg_background
GeoTools - Official GeoTools repository
Spring Boot - Spring Boot
OsmAnd - OsmAnd
docker-pg-cron - Dockerfile with extension pg_cron
OpenRailwayMap - An OpenStreetMap-based project for creating a map of the world's railway infrastructure.
Express - Fast, unopinionated, minimalist web framework for node.