News for hackers. Stuff that matters.

jlongtine

Re:Why I Built Litestream on Thursday February 18, 2021 @12:38PM (#26182888)
This is an interesting idea... It'd be really cool to have these as SQLite extensions. I could see that being powerful (in part because of language agnosticism). Granted, a bit harder to build/install. https://sqlite.org/loadext.html
Re:Sharding Pinterest: How we scaled our MySQL fleet on Wednesday August 19, 2015 @04:01PM (#10088058)
I don't think that the schema here allows you to do this kind of query even in MySQL. They are throwing everything in that blob, which makes it pretty difficult to sort on anything that's in the blob. So, I think they would have to do what you are describing, denormalize everything... or get all the data and do the sort in the app. Which is precisely what would be required with Cassandra or another NoSQL system. Am I missing anything that would invalidate what I've just said?
I have a friend who is in a similar situation, and he was able to negotiate the total down quite a lot with the IRS. I'd definitely recommend finding a tax attorney or CPA who can help you with that.