PostGIS would get you up and running, but is not particularly quick unless you have a budget and the knowledge to tune it. It is however probably the most mature, and will be able to do anything you need.
If you need read speed, check out Clickhouse, or something in memory, like Tile38. Clickhouse in my experience is at least 50-100x faster for a point in polygon than Postgis out of the box.
Debunked how? It seems the consensus is that it’s just as secure as using a username and password and allowing the user to reset via email. It’s been discussed here a few times.
You have zero control over how their email is handled - and you're providing a way to login, no questions asked, with just access to their email.
The usual "argument" about email resets is irrelevant - a password reset (a) doesn't have to be fully automated, (b) doesn't grant invisible access to an attacker (c) should leave an obvious audit trail
The most used one is probable the Interactive Brokers API, I am using python and running the algos from VPS, for books on how to get started and data sources, please check my previous posts... Cheers.
I'm not the original parent but I'm doing the same. I'm using Oanda for forex data and building my platform in Elixir. I'm able to get historical pricing from Oanda for currency pairs so I'm able to eventually backtest that way.
Got the work through a family friend, it's his business. I had to learn COBOL (managed through Visual Studio these days thank god) and have ended up contributing to the main application, converting Microsoft c++ and c# examples into COBOL, e.g Gdi32 printing, windows forms, wpf and so on.
Luckily as it's Managed COBOL and based on .NET you can call classes written in C++/C# so I've been doing that where possible!
Good fun and completely different to my usual line of Web Dev.