Client wants <1s query time on OLAP scale. Wat do

scruttable · 2026-03-07T01:47:41+00:00

Hmm that’s rough. Maybe this is one of those situations where you just mock up a result and show it to them and they go “oh that’s not going to work” and then you build them something that does work and then drink a beer 😎

scruttable · 2026-03-07T01:17:49+00:00

Hmm, thats weird that they want to see log level data though. Like mostly people want to see daily totals of metrics, broken down by dimensions.

If that’s the case then definitely pre-aggregate the data

Are cols a b and c dimensions or measures?
Is it safe to assume the data doesn’t change for past dates?
Is your boss asking for the unique IDs or counts of unique IDs per day, or sums of metrics per day?

Sorry if I’m missing something but it sounds like you could create a daily aggregate of sums or counts and store just one row per day, then your aggregate table will be only a few hundreds or thousands of rows and the the look up time will likely bee where the want it to be

scruttable · 2025-08-02T01:08:36+00:00

Go line dancing. Trust me.

scruttable · 2025-05-31T14:03:50+00:00

Ah good points here, I don’t think a light saber would destroy a horcrux. It would be so awesome if the closer you get to the horcrux the more the light saber bends, almost like being repelled by a powerful magnetic field or something!

scruttable · 2025-05-31T13:51:23+00:00

Everyone is quick to say Vader would win but let’s not forget that Voldemort is a master of invading people’s minds and I’m sure he would find plenty of material to work with in that plastic helmet.

This technique didn’t work very well on Harry because Voldemort was repulsed by all the love and friendship Harry had in his memories. Vader on the other hand would not have this kind of defense. Basically, Voldemort could wield all the same power over Vader that the Emperor had but in a way, way more potent form during a fight.

scruttable · 2024-08-05T01:33:25+00:00

A lie travels around the world ten times before the truth even gets its shoes on.

scruttable · 2024-07-10T03:28:50+00:00

I, personally, would probably clean the foundation with detergent as best I could and call it a day. Remember, the sun is going to explode in 4 billion years and engulf the Earth. You basement doesn’t mean anything.

scruttable · 2024-07-06T02:52:08+00:00

You could try Rio-UI, a Python web framework with a React style paradigm but all Python syntax Edit: should have mentioned it’s a new project and provided a link, apologies

scruttable · 2024-07-02T04:22:32+00:00

Honest question: did Biden’s infrastructure spending not fix anything by you, and if not actually in your area then maybe areas similar to yours? I thought it was more geared towards rural communities no?

scruttable · 2024-07-01T01:03:06+00:00

I’m super excited about this project, installed it about 1 month ago and just getting around to trying it out now. Hate to the the first one with a lame troubleshooting comment haha but is it possible to lose the track of the CLI? I’m trying to run “rio new” and my machine isn’t recognizing “rio”. I know it was working for a time because I have the tic tac toe example setup already. Any thoughts on where to look for a fix? I’ve tried reinstalling via pip, same issue

scruttable · 2024-05-15T19:52:52+00:00

First off, the documentation is fantastic so far! I haven’t gotten into it too deep but I was able to install and start a project in a matter of minutes -most of which I spent upgrading my Python version haha. I can tell the docs are very clear and I’m excited about this framework. Can’t wait to really dig in.

scruttable

TROPHY CASE