SQLite vs MySQL for a first database, which hill are you dying on?

I read on a dev blog that SQLite actually handles up to 281 terabytes of data, read that number twice because it sounded like a joke. Meanwhile every tutorial keeps pushing MySQL for beginners like we're all building Twitter 2.0 from day one. So for someone learning to code, is it smarter to start with the simpler tool that scales way past what you'll need, or should you fight through the real server setup just to feel legit?

1 comments

1 Comment

wade_young861mo ago

I burned a whole weekend fighting MySQL on my old MacBook before I realized SQLite was already there and just worked, so I built my first app on SQLite and never looked back. Start with what gets you coding, the hype about "real" databases can wait until you actually need a server.