Re: Postgres for mobile website?

Andre Lopes wrote:
> Hi,
>
> I have a website using Postgres database. Now I need to develop a
> mobile website, what should I do?
>
> Use the Postgres database or copy the information of the database to a
> SQLite database? Postgres isn't heavy to a mobile website?
>
> The website is update 2 times month. I can easly sincronize the
> databases Postgres to SQLite. What do you think about this solution?
>
> Best Regards.
Typically, for a website, the database is stored on the server and not
the client so it does not matter about the size of the database/dbms.
You can use the same server for both websites. I run both mobile
websites and normal websites from the same database.

Your choice of dbms depends upon the workload/complexity of the data. I
find postgres scales nicely for most workloads.

Howard Cole
www.selestial.com