DEV Community: h2L

How should I go about making multiple concurrent api calls from FastAPI ?

h2L — Fri, 04 Dec 2020 04:58:08 +0000

I am currently supporting an API that generates a report for my team using the python framework FastAPI. One of my endpoints makes a call to function called generate which in turn makes 4 calls to the same service to get different pieces of data for the report being built. The extract function is synchronous and takes about 10 - 15 seconds per call to get data.

For now, I would like to keep my '/report' endpoint synchronous but I would like to concurrently make those 4 calls in the generate function below to speed up response times. How should I got about achieving this in FastAPI. Should I spawn threads? Should I use something within the framework to achieve this ?

@app.route('/report')
def fetch_report():
    return report.generate()


 def generate():
  #would like to call these at the same time essentially
  data1 = reporting_datasource.extract(r1)
  data2 = reporting_datasource.extract(r2)
  data3 = reporting_datasource.extract(r3)
  data4 = reporting_datasource.extract(r4)

  return { 
    'part1' : data1,
    'part2' : data2,
    'part3' : data3,
    'part4' : data4
  }

Python Pattern Design Help!!!

h2L — Tue, 15 Sep 2020 13:53:50 +0000

I am developing a service at work that generates a report on a weekly basis. The api I use to get the data can take a while so rather than blocking, the api returns a new url to the soon-to-be-completed report that I have to poll until the data returns. To generate my report, I have to make 5 calls to this api. In addition, data from 3 of the calls are related as they have to be combined and massaged to create a particular section of the my report. The data from the other 2 api calls can be copied to the report as returned. I was wondering what type of pattern should I use here. Async polling?

Good sources (courses, books, sites) on database design and data modeling?

h2L — Wed, 29 Jan 2020 15:37:19 +0000

Hi, everyone! Hope everyone is well. I am new to the community! I am currently in search of some sound resources on database design and data modeling. It would be nice to find some sources that include both theory and a couple of case studies showcasing the implementation of good data modeling design practices/patterns. Anything helps! Thanks in advance!

Database management and use among multiple developers?

h2L — Thu, 11 Jul 2019 02:43:26 +0000

A couple of friends and I started developing an application and we are currently using a MySQL database. It's really just for practice, but we were wondering how would you go about creating a database and sharing the database with my other teammates so we can all use the same dummy data to test and develop with.

Should I execute mysqldump command and source the generated sql script? With that, how would I manage credentials?

Or should I just create a low-cost development database on some cloud platform to remove the dependency all together?