Social-camera buying is different
A camera for Instagram or TikTok does not need the biggest sensor or the longest zoom. It needs to be quick, small, and reliable enough to leave the house. You want a camera that makes mirror photos, restaurant flash, outfit checks, travel details, and casual videos feel different from phone output. That means flash behavior, color, pocket shape, and file transfer matter more than a spec race.
Before buying, decide whether you want an older CCD look or a cleaner later compact. Both can work. A tiny 2007 CCD can give harder flash and rougher files. A later CMOS compact can be easier for video and cleaner daylight. The right answer depends on whether you want a messy nostalgic look or a polished compact-camera look.
Pocketable models to compare
The Canon PowerShot SD780 IS DIGITAL ELPH is a 2009 compact with 12.1 MP effective resolution, a 1/2.3-inch type CCD, SDHC / SD / MMC storage, and NB-4L battery. It is a good example of a small social camera: not too bulky, easy card path, and a compact Canon feel.
The Sony Cyber-shot DSC-T70 is a 2007 8.1 MP effective CCD camera with a folded 3x optical zoom, Memory Stick Duo / PRO Duo storage, and NP-BD1 battery. The Sony Cyber-shot DSC-T90 is a 2009 12 MP effective CCD model with 4x optical zoom and NP-BN1 battery. Both are style-led Cyber-shots, but Memory Stick support must be part of your buying plan.
Fuji has strong style options too. The Fujifilm FinePix Z20fd is a 2008 10.0 MP effective CCD compact with xD-Picture Card / SD / SDHC support and NP-45 battery. If you want a simple Fuji that does not force xD-only storage, this kind of model is easier than many older FinePix bodies.
Useful picks beyond the hype models
The Olympus Stylus 5010 is a 2010 14 MP effective CCD camera with a 26-130 mm equivalent 5x optical zoom, SD/SDHC plus internal storage, and LI-40B / LI-42B battery support. The Panasonic Lumix DMC-FX35 is a 2008 10.1 MP CCD model with a 25-100mm equivalent lens, SD/SDHC/MMC storage, and CGA-S008 battery. Both give a wide-end option that can be useful for friends, rooms, and travel.
If you want a later Canon that is cleaner and easier for everyday use, the Canon PowerShot ELPH 300 HS is a 2011 camera with 12.1 MP effective resolution, SD / SDHC / SDXC storage, and NB-4L battery. It is not the same era as the SD780, but it can be a practical social compact if you care more about convenience than strict CCD character.
Budget alternatives can work if the listing is complete. The Casio Exilim EX-Z75 is a 2007 7 MP CCD camera with SD/MMC/SDHC storage and NP-20 battery, while the Samsung ST60 is a 2010 14 MP CCD compact with SD / SDHC storage and BP70A battery. They may not be the trendy names, but they can be more affordable.
Transfer and posting workflow
For social use, the card path matters every day. SD and SDHC cameras are easiest with modern card readers. Memory Stick and xD cameras can still be fun, but you need the right reader before the camera arrives. Read the transfer photos to your phone guide and the memory card article before buying an odd-card camera.
Think about how the camera fits into a normal night out. If it needs a fragile proprietary cable, a half-dead battery, and a laptop just to post one photo, you will stop carrying it. A slightly less hyped model with a working card reader can create more actual posts than the trendiest camera sitting in a drawer. Convenience is part of the creative tool.
For posts, shoot a few versions: flash on, flash off, closer, farther, and one vertical frame. Old screens can lie, so judge the files after transfer. Keep the edits light. Cropping and slight exposure correction are fine, but if you have to add heavy fake grain to every file, the camera may not be giving you the look you wanted.
Canon PowerShot SD780 IS DIGITAL ELPH: a compact 2009 CCD camera with SDHC / SD / MMC storage.
Next step: compare a small Canon like the SD780 IS with a style-first Sony like the T70, then check card-reader needs before buying.