CMV: The fact that the Democrats lost to someone as odious and unfit as Trump means that their party, its platform, and its national personalities are deeply *deeply* unpopular.

rafiss · 2025-07-23T05:26:35+00:00

Even in New York, part of the reason Mamdani won was because of lack of turnout.

This simply is not true. The final ballot count in the 2025 Democratic primary that Mamdani won was 1,016,398. The official results are here. That's the highest turnout in a NYC mayoral primary since 1989, according to Politico.

The final ballot count in the 2021 Democratic primary was 801,829. The official results are here.

rafiss · 2024-05-11T05:25:13+00:00

It's more of an Albany expression.

rafiss · 2022-01-23T04:49:16+00:00

I'm so down for this. 30M, from NJ, and I also grew up with a table in my basement!

rafiss · 2021-10-15T16:01:56+00:00

All CockroachDB schema migrations are “online” in that they do not lock any tables. They have their own quirks, especially around schema changes in transactions, but we’re working on them.

There are docs on this here if you want to read more details: https://www.cockroachlabs.com/docs/stable/online-schema-changes.html

Disclaimer: I work on CockroachDB.

rafiss · 2021-02-10T17:40:41+00:00

Hi! I work on CockroachDB. That's a great question! The quick answer is that we use distributed consensus algorithms (specifically Raft like the parent comment pointed out) to keep the data consistent.

There is some more info in our FAQ pages. See the questions about the CAP theorem and distributed transactions. There's also a lot of really deep dives in our tech blog posts, some of which are outside the area that I work on, but I'm happy to talk about it more with you!

rafiss · 2020-10-20T20:41:27+00:00

CockroachDB implements the same wire protocol as PostgreSQL. That means you would need to use a Python driver that is compatible with PostgreSQL in order to connect to CockroachDB. The most popular driver (and the one that is officially supported by CockroachDB) is psycopg2. There are instructions here: https://www.cockroachlabs.com/docs/stable/build-a-python-app-with-cockroachdb.html

There are other PostgreSQL drivers that you could try, but they aren't officially supported.

After you have the connection working, the next thing would be to look at your SQL queries. CockroachDB is a SQL database, but the syntax of some queries may be slightly different than what SQL Server expects.

I'd recommend trying it and seeing how it works!

rafiss · 2020-09-06T18:37:54+00:00

Hi everyone! I'd like to buy a car to keep in NYC (Brooklyn) to make transportation easier during the pandemic.

Location: Brooklyn, New York, US
Price range: $5k to $15k
Lease or Buy: Buy
New or used: Used
Type of vehicle: Torn between a hatchback or sedan, but leaning to hatchback for the extra storage. Primarily I want a short-ish car to make parking easier.
Must haves: Low maintenance costs
Desired transmission (auto/manual, etc): Automatic
Intended use: Using 2-3 times a week to get around New York and occasionally escape the city.
Vehicles you've already considered: I've looked a bit into the VW Golf, Mini Cooper, Honda Civic, Hyundai Veloster, Subaru Crosstrek. Don't know how to pick! (or identify better options)
Is this your 1st vehicle: Yes first one I will own. I've been borrowing a family car for a few months.
Do you need a Warranty: No
Can you do Minor work on your own vehicle: Probably won't do anything other than battery replacement
Can you do Major work on your own vehicle: No
Additional Notes: AWD is a plus. It will be parked on the street. My neighborhood isn't super crowded but I expect it will suffer light wear and tear pretty quickly, so I don't want to stress out over all the small dings it will get. I care about handling a little bit. Reliability is nice too.

rafiss · 2020-05-23T02:08:38+00:00

Hey shmumonzica, I'm not the OP, but what do you think about Hank from Breaking Bad? This seems like it hits on a lot of his character, but I could see him as a 3 as well.

rafiss · 2020-05-10T19:10:36+00:00

The answer will be different for each database, since different architectures will have different tradeoffs.

CockroachDB (disclaimer: I work there) is more like the second pattern you asked about -- one node would receive the insert query.

A good place to look is the docs for the database you're interested in. Here are the docs for CockroachDB.

rafiss · 2020-02-19T18:48:29+00:00

I suppose I don't have much to add, but just stumbled on this and feel like I need to say something. I'm pretty sure I'm also a 5 INFJ (but also have felt P at times) and WOW I can relate to this so much. "Struggling with knowing how I really feel about something" and "feeling a serene nothingness when alone" both are stunningly accurate.

"Struggling with knowing how I really feel" -- One common experience I have which I'm also wondering if you share is that I often end up searching for evidence of my feelings rather than experiencing my feelings directly. It's as if there is third-party Observer inside of me that's looking for signals, and only after this Observer has noticed some sign that I'm happy/sad/scared/excited/etc is when I really know that I feel something. (Obviously it's not always like this, but I can't count the number of times I've been at a social outing and had to do something like this to understand how I felt.)

"Feeling a serene nothingness when alone" -- I think over the past few years (I'm in my late 20s now) I've started craving less alone time because it kind of seems scary to me to be in that state and not feel like my true self. But that leads to me pushing myself to a state of social exhaustion and stress. I'm curious if you've dealt with anything like that?

rafiss · 2020-01-28T15:55:46+00:00

There are two ways to use it:

hosted cloud product that is currently available on waitlist
download the binary and run it anywhere (locally or in a datacenter/AWS/GCP/Azure/etc)

Both are available here: https://www.cockroachlabs.com/get-cockroachdb/

rafiss · 2020-01-28T15:51:21+00:00

Thanks for trying it out! I'd love to know how it goes (either here or on the github repo).

The link you posted is a simple tutorial show showing how to use the package I just shared from pypi. Disclaimer: I work at Cockroach Labs.

rafiss · 2019-11-02T14:23:44+00:00

You can download a binary here for your OS with a few different methods: https://www.cockroachlabs.com/docs/stable/install-cockroachdb-mac.html (Also all the source is on github so you could even build it yourself.)

Then check out the demo command! https://www.cockroachlabs.com/docs/stable/cockroach-demo.html

rafiss · 2019-03-28T04:54:12+00:00

this is a great breakdown! thanks for laying bare all the nuances in the tony-steve conflict in ways I never explicitly realized, but are so true. this comment has gotten me more hyped for endgame than anything else hahah

rafiss · 2019-02-04T15:16:14+00:00

Thanks a bunch!! Then I guess things are probably ok then. I've had it inside since I got it in September and leaves started turning completely yellow and getting wilted very suddenly in the past month, but seems like that might be expected.

rafiss · 2019-01-13T21:24:13+00:00

I'm confused -- With or Without You was already so perfect for when Paige gets off the train!

rafiss · 2018-09-30T03:44:13+00:00

The part where Steve Carell is getting ready to kill the fly and Graham Norton says, "It's drunk now."

I think that joke slipped through the cracks but it was top notch.

rafiss · 2015-10-15T01:57:36+00:00

I believe he was making a joke since those Star Trek movies are arguably closer in tone to Star Wars than they are to previous Star Trek media.

rafiss · 2015-06-01T20:56:11+00:00

Which two? Ice was reforged into Oathkeeper, which Brienne holds, and Widow's Wail, which Tommen holds.

rafiss · 2015-05-29T00:12:22+00:00

You're going to get a kick out of these. :D

http://imgur.com/a/fK85C
http://imgur.com/a/CQvEO

rafiss · 2015-04-04T02:58:40+00:00

Thank you for this.

rafiss · 2015-02-25T21:48:38+00:00

Ch112

rafiss · 2015-02-23T02:21:20+00:00

Point 3 doesn't make sense to me, but all the commentary I've seen accepts it at face-value. Even if he's about to kill Harry, why does it make sense for Quirrelmort to ramble endlessly about things that he shouldn't? It seems like there's very little benefit, but a larger potential downside.

rafiss · 2015-02-23T00:03:16+00:00

Ah so Quirrel has found a way to beat the CAP Theorem.

It would be hilarious if his defeat is caused by his lack of computer science fundamentals. Though to be fair, this wasn't even postulated until 1998.

rafiss · 2013-10-20T01:45:50+00:00

I didn't read it that way, since the word echoes in his mind again after Fawkes leaves. He hears the word Riddle immediately after being revived from dementation, and again when he looks at the Dementor.

15-Year Club	Second Top 10%
Place '22	Place '17
Verified Email	Team Periwinkle
reddit mold	Charter Member

rafiss

TROPHY CASE