1
However, I think that it'd be interesting to build things on top of Excel that basically improve on top of the main pain points.
With that said, I wanted to ask y'all what's the most painful thing you find yourself needing to do in Excel right now and maybe what have you tried as an alternative that may/may have not worked.
Would love to hear your thoughts on this! :)
So a couple of weeks ago I was building a chrome extension for crawling data and uploading it somewhere online for further exploration. I found myself struggling a lot with this as I found every solution I tried hard to implement (Firebase, Mongo Atlas, EC2). I mean I only needed a simple endpoint in which I was able to set and get JSON data with some key. In the end I made a small CRUD using Mongo, Sinatra, Puma, and Nginx. Then Chrome complained that my endpoint (raw IP) was not HTTPS so I bought a cheap domain and configured an SSL certificate into my server. I found this to be a repetitive yet time consuming process and I decided to solve this problem by myself.
With that said I created Pandora, a platform that allows you to create key-value stores in a very quick way. More specifically with Pandora you can:
- [Create | Delete] services (key-value storage). Each service is logically isolated from each other. You can interact with a service by its own URL (db-<service_id>.not-a-db.com).
- Associate some custom URL to a service. Let's say you own example.com, then you can use that to interact with some service. SSL certificate is generated and renewed automatically on the background.
- [Create | Retrieve | Update | Delete] a JSON value associated to some key (unique per service).
You can find the complete API reference here: https://www.notion.so/Pandora-Server-API-875a7902c00d4f29969c24d7770c95ec
Also, I created a guess user in which you can try Pandora:
- Email: guess@not-a-db.com - Password: helloguess123
There's also this CLI for admin operations (not interacting with a service) that you can try too: https://github.com/pandorakv/pandoractl
As you can see this is still in a very early stage and I'd be more than happy to know what feedback do you have. Also, let me know through the comments if you want to get a custom user as right now I don't have a signup page.