Im building a web application, which will be deployed for a small area (City) expect 20,000 or more records across 15 or so tables, for a trial period, if successful, it will be launch nationwide (NZ) maybe 200,000 or more records.
Im trying to determine which DBMS, I should use, I have a very limited budget, and don't think SQL server is in that picture.
Ive been looking at options and originally thought MYSQL would be a Good option, but have also tossed up the use of Postgres.
The Database, needs to be fast for inserting, updating and deleting, but its not likely I will use any stored procedures as I prefer to use the application layer.
It will also be likely that the project will be a success, and therefore I will at some stage have to migrate the DBMS to a more comprehensive, Scalable solution.
Im also using ASP/VB.NET so there needs to be good support language wise.
Any feed back welcome, but please justify your comments.
There are hosting providers out there who can provide PostgreSQL, however you will probably find you pay a premium for it. MySQL is easier to get to grips with and doesn't require datatypes defining for stored procedures, although I suspect you're probably quite acqainted with datatypes having used .NET. Still it's a pain to debug...