I have no prior experience with a database, and am trying to figure out
which one to go with.
I was going to go with MySQL (rather than Postgres, which seems to be
considered superior) because it had more documentation and my app is
very basic, but I read that it only allows for 1 index per table, which
worried me -- although I don't know if it's actually something to be
That's absolute bollocks. what you might have read and misinterpreted is than when a given query is executed, no more than one index will be used per table.
For example if you had an address book app and you had one index on say state and one index on occupation and you execute a query against that table then mysql will use either the index on state or the index on occupation (or neither if neither one helps) but never both indexes (although you can create an index on both columns)
So all in all, are Postgre's advantages worth it even if my knowledge is
very limited and my app very basic? Thank you for any help.
Use what you're most comfortable with.