not bitcoin, but I have some similar experience and thought I could share.
I got into dogecoin literally right after it launched (late 2013). There were zero exchanges that sold it. Hell, there wasn't even a place you could view the price.
The only way was basically had to find random people to trade with on a megathread on r/dogemarket. People would comment something like "Selling 50k doge for 10$" and you would just have to trust them. the "price" of a dogecoin was essentially just what recent listings were offering. Usually, you'd pay them on paypal and they'd transfer you the coins. It was pretty similar to localbitcoins.com if you've used it
In hindsight it was pretty sketchy, but i never got scammed luckily. the community was pretty small, and scammers were quickly outed on reddit
It might be feasible if you use sqlite's in-memory feature, because hitting the disk on each query is way too slow for a real-time application.
Why not just use an r-tree library for the language you're using? It'll be faster and easier to work with. Since scene data is usually hierarchial, sql doesn't seem like a great choice for storing it
What kinds of questions were asked during the interview process? I don't think I'll ever have the chance to work there, but I'm extremely curious about the vetting process for a place with such a notorious hiring bar.
I got into dogecoin literally right after it launched (late 2013). There were zero exchanges that sold it. Hell, there wasn't even a place you could view the price.
The only way was basically had to find random people to trade with on a megathread on r/dogemarket. People would comment something like "Selling 50k doge for 10$" and you would just have to trust them. the "price" of a dogecoin was essentially just what recent listings were offering. Usually, you'd pay them on paypal and they'd transfer you the coins. It was pretty similar to localbitcoins.com if you've used it
In hindsight it was pretty sketchy, but i never got scammed luckily. the community was pretty small, and scammers were quickly outed on reddit