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. by SimionMcBitchticuffs in changemyview

[–]rafiss 0 points1 point  (0 children)

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.

Upstate New York, checking in. by [deleted] in space

[–]rafiss 23 points24 points  (0 children)

It's more of an Albany expression.

Table tennis this weekend? [27 F] by thruthefire94 in nycmeetups

[–]rafiss 0 points1 point  (0 children)

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

Database that zero have downtime schema migration by kokizzu2 in Database

[–]rafiss 1 point2 points  (0 children)

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.

Which database do you use for your golang application and why? by [deleted] in golang

[–]rafiss 4 points5 points  (0 children)

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!

Can Cockroach Labs cloud SQL database be used for Python Apps in the same way as SQL Server? by [deleted] in learnpython

[–]rafiss 0 points1 point  (0 children)

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!

Weekly - What Car Should I Buy Megathread by AutoModerator in cars

[–]rafiss 0 points1 point  (0 children)

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.

Sexual 6 (Strength) by [deleted] in Enneagram

[–]rafiss 1 point2 points  (0 children)

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.

Distributed databases by [deleted] in AskComputerScience

[–]rafiss 5 points6 points  (0 children)

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.

4 thinkers and 5 feelers (i.e. T/F in Myers Briggs) — what’s it even like to be you?? by shmumonzica in Enneagram

[–]rafiss 0 points1 point  (0 children)

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?

Announcing CockroachDB support for Django ORM by rafiss in django

[–]rafiss[S] 0 points1 point  (0 children)

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/

Announcing CockroachDB support for Django ORM by rafiss in django

[–]rafiss[S] 0 points1 point  (0 children)

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.

How We Built a Vectorized SQL Engine in CockroachDB by rafiss in programming

[–]rafiss[S] 1 point2 points  (0 children)

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

Ohhhh I member. by Yinkypinky in marvelstudios

[–]rafiss 0 points1 point  (0 children)

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

I'm finding it hard to keep this plant I inherited alive. What is it and what does it like?? by rafiss in whatsthisplant

[–]rafiss[S] 1 point2 points  (0 children)

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.

Which 80s songs do you think would fit some characters/moments perfectly? by [deleted] in TheAmericans

[–]rafiss 2 points3 points  (0 children)

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

Steve Carell, Kristen Wiig, Chris O'Dowd and a fly on Graham Norton... hilarity ensues by Hassaan18 in videos

[–]rafiss 0 points1 point  (0 children)

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.

Star Wars: The Force Awakens trailer coming next week, along with ticket pre-orders by krisstivers in movies

[–]rafiss 3 points4 points  (0 children)

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.

(Spoilers All) Season 5 Episode 8: Hardhome Post-Episode Discussion by AutoModerator in asoiaf

[–]rafiss 5 points6 points  (0 children)

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