[symfony_]

Well... maybe you could go old-school and just put down a physical server in your local network which hosts the DB?

So basically you have the same setup as with your AWS instance, minus the network latency.

Everyone wants to go fancy and host everything in the cloud nowadays, but a local server for development can be very useful still!

[douche]

We're mostly a MS shop, so we tend to use MS SQL Express instances on our dev machines. For the bulk of what we need to do day-to-day, this is exactly the same as if we were dealing with a full SQL server instance, a SQL cluster, or an Azure SQL database instance.

One of the few times I will use a cloud database instance in development is to doublecheck performance of database queries, as the cloud instances will have considerably more latency than you'd ever see running a local database on a beefy workstation.

[raviojha]

Yeah, we are trying to have a local machine to which everyone can connect to. Actually, some developers also work from home and hence we thought let's keep a local database in every machine. So, I'm exploring what everyone else is doing.