For now, I have been working on a local PostgreSQL database built on my own machine with OpenStreetMap data that I downloaded and osm2pgsql.

I would like to outsource the computing of my code, namely using Google Colab. I would need access to the database.

I could recreate the database on Google Cloud but this solution would cost me money. I was wondering if there exists an online database, preferably PostgreSQL but any would do, that I could use for free?

  • It seems you have multiple questions: 1) How to optimize performance of your query (you believe Google Colab is the solution, but that seems to be an assumption); 2) How to work with OSM data in PostgreSQL in Google Colab without incurring costs?; 3) How to call the Overpass API from Google Colab? The stackexchange format works best if you focus on a single question at a time, show any research you've done so far, and indicate where you could use help. Could you perhaps edit your question to focus on one of the three things? Jun 28 at 12:45
  • what size is your database? Supabase has a free (but limited) tier supabase.com/pricing
    – Mapperz
    Jun 28 at 14:13
  • @SaaruLindestøkke : my code is, to my knowledge and the knowledge of my colleague, not optimizable so I'm just gonna turn to multiprocessing to run it faster. I will edit to remove the Overpass reference. Question really is the number 2 in your list: How to work with OSM data in PostgreSQL in Google Colab without incurring costs?
    – DianeS
    Jun 29 at 9:03
  • Ok, thanks for the edit. This does seem less related to GIS, but to cloud computing, but I'm not familiar enough with gis.se to know if that's relevant or not. Could you indicate what size of database you are talking about as that narrows down the free options that are available. Also, you indicate that your code is not optimizable, but is the bottleneck in your code or in the database? I.e. does the (free) postgres database need high performance as well? Jun 29 at 9:26
  • Relevant question on SO: stackoverflow.com/questions/61030755/… Jun 29 at 9:28


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.