En route home from a night out, I decided to grab a few shots of NYC at night to see how the Sony RX100 fares in dim street light. Overall, I’d say it does admirably for a compact, but still pales in comparison to most DSLR’s (note the blue noise in the shadows).
You can bump your low light performance a bit by setting your camera to Shutter Priority Mode (or full manual) and setting the shutter to 1/40 or even 1/30 (though the latter will give you a 360° shutter, which has a very “video” look to it).
Overall, the main reason this camera is cool is because I can have it with me at all times. The bigger “pro” cameras are great for controlled environments and paid gigs, but in recording daily life, it’s all about convenience. If it doesn’t fit in my pocket, it usually stays home. You miss 100% of the shots you don’t take.