Avoid the early-model P290 at all costs! Mine originally had a non-restrike trigger that often failed to reset, and magazines frequently popped out under recoil. Some P290's have been fitted with the resriking DAO trigger, and may be OK. I had my P290 so upgraded (at my expense), but the magazines kept self-releasing. After two return trips to SIGARMS, it was replaced with a P290RS which has been totally reliable through nearly 1000 rounds, including 115-, 124-, and (mostly) 147gr. ammo.
SIGARMS may have successfully addressed the P290's problems in the P290RS, but doesn't seem to be pushing the model. Magazines and holsters for it are not commonly seen at the gun shops I visit, where other SIG models seem well supported. The P290 is more compact than most of its competitors, though a bit heavier. Ironically, it is sometimes sold with a SIG-rebranded plastic paddle holster that totally defeats the P290's compact dimensions!
My experience with my unlamented former Kahr PM9, and Beretta Nano were far worse and never resolved, despite two return trips (each)to the manufacturer. SIGARMS made significant modifications to address their initial problems, where Beretta and Kahr refuse to even acknowledge theirs.
Fortunately, I amost never have to resort to carrying less than a Glock 27 similar to those I carried for years as an off-duty and backup piece before retiring from one of the three-letter Federal agencies (no, NOT the TSA!).