1,783 karma · joined April 5, 2011
A friend of mine built an app using aggregations - they are hard to work with and understand imho, I'd rather convert them to simpler Python operations. Fetch some rows, join them to some rows from another table, etc.
I've done mostly consulting for 3rd parties under that Hexcloud name, I haven't released a product before using it.
Yeah, the space is crowded, I think with a lot of these products you end up in the enterprise sales pipeline in some sort of subscription. I'm aiming to keep it self-serve and simple, aimed at engineers, and api-driven.
And I'm still studying the market and surface area - I have a lot of work to do re positioning and what problems this solves. I can't say I know exactly where I'll end up with it yet; very much in the conception stage.
https://ismycertexpired.com/check?domain=objects.githubuserc...
https://ismycertexpired.com/check?domain=objects.githubuserc...
The master/worker thing that nginx / gunicorn et al do is pretty neat, but relies on signals; so seems pretty messy and error prone to write yourself.
If it's sorting and sifting and clicking a bunch of stuff in the console, that's not painfully simple. If it's some easy cli commands, I think that's in the ballpark...
I do wonder however if they'd be better off using less l33t tech - do almost everything on Postgres vs consul and vault, etc. Scaling, failover, consistency, etc is a more well-known problem and there are a lot of people who've ran other DBs at tremendous scale than the alternatives.
Simplicity is the key to reliability, but this isn't a simple product, so idk.
I did a project in college for a VLSI minor where we implemented a 16bit multiplier - after we got the chips back we were supposed to do scan testing, but I just wrote up a little program in an fpga, wired up my chip to test, and swept all the possible inputs verifying the output. I think I could only run this at 10MHz, and you had to shift in the operands one bit at a time, but it still only took on the order of an hour or two to complete.
I also verified this setup by capturing some cycles on a logic analyzer - then pulled together a little awk script to turn a dump of that into the actual numbers I could check. Fun project.
I've been using psycopg2 directly with a thin layer for managing connections and transactions using thread-locals for a long time - RealDictRow and some adapters for jsonb and a few other types make it really easy to work with.
Generally speaking, if you're on a modern OS - like recent Ubuntu LTS or MacOS you're getting 3.8 -> 3.10 and compatibility is very good in these releases.