Viewing profile — aynyc

Please execute my ignorance. And this isn't an attack on anyone, just my own stupid limited understanding. Aren't JellyFin & Plex essentially just a catalog for your local data (mo…

This is about their bond, not that share price. If you are in the US, it's like having low credit score, everything you want to do financially such as leasing or financing a car, b…

NYC owns those lands for water. ADK has forever wild in NYS constitution. They are not gonna get relax for data center because they discharge water and noise and add significant in…

That's the insider joke. Look up NY1-NY4 data centers, they are all in NJ across the river. NYC just dump their shit into NJ is the usually move. But those areas are full now, and …

Don't worry, they'll just build the data centers in NJ and still considered NY 1-20. Sarcasm aside, I don't really know where they would build data centers in NYS. Electricity rate…

I've been reading Alastair Reynolds's books. They are pretty good.

OK. I've read it a few times and still don't understand. Where is the distributed part? You store data in a single transaction into postgres. What/who is notifying the message queu…

I'm wondering. Just wondering? Will they ever support multiple storage engines like MariaDB? Having a storage engine that support OLTP or OLAP or append-only would be cool. I total…

MySQL has Galera cluster for that.

I just came out of an initial interview for a rather senior enterprise position. It was bad. It was bad in a sense that they really didn't know what to do. The senior manager (EVP …

We might be doing something wrong, but we saw significant performance degradation for both ingestion and query when doing compaction when it comes to finance data during trading ho…

When you say compatibility issues, you mean they are more problematic or less? It’s pretty common to read Parquet into Arrow for transport. I'm confused by this. Are you referring …

Yes, but parquet hates small files.

So feather for journaling and parquet for long term processing?

Given the cost of storage is getting cheaper, wouldn't most firms want to use feather for analytic performance? But everyone uses parquet.

I read that. But afaik, feather format is stable now. Hence my confusion. I use parquet at work a lot, where we store a lot of time series financial data. We like it. Creating the …

What's the difference between feather and parquet in terms of usage? I get the design philosophy, but how would you use them differently?

Going back how’s many years? I checked recently and VTI easily out perform in the last 5 years.

You'll be amazed on what the new breed of engineers are using Redis for. I personally saw an entire backend database using Redis with RDB+AOF on. If you redis-cli into the server, …

This belongs to the "shit that never happened" list.

I lost all my college projects due to source forge bullshit decades ago. And old pictures from digital/film cameras. Right now, I run both google/apple photos so I have 2 backups o…

I've seen this type of advice a few times now. Now I'm not a database expert by any stretch of imagination, but I have yet to see UUID as primary key in any of the systems I've tou…

Yes, we have to in order to use a lot of the features. The core issue for us is really the way Django assumes code represents database state. In normal webapp where the application…

Any docs? Django migration is a HUUGE pain point for us.

That’s what we do now. But it gets repetitive and not leveraging Django core features.