Newbie: getting started with database, local computer, host

well this may very well be a super easy one, but I can’t seem to find an
answer. I think it’s really neat that ruby on rails has so many things
built in like multiple databases for production, testing.

if i create a database on my local machine, and create my rails app
locally… will everything get synced with my webhost when i use
capistrano? or do i need to log-in to the server and constantly be
editing files and databases there? i’d rather work on my local machine,
and then upload with (moderatly) stable builds of the site.

so do i have to create the databases locally and on the host? also what
happens to the data when I deploy with capistrano?


I haven’t used capistrano, but I would think the answer should be in
their docs somewhere…