Обсуждение: postgreSQL enquiry

Hi
I was on your website trying to look up information on PostgreSQL and the information that I needed was hard to get or just couldnt find it. Can you please clarify whether these requirements are covered by postgreSQL product:

- data stored in the database includes text, numbers, pictures and even video clips
- avoids vendor 'lock ins' --> open DBMS
- allows for a web-based end (web 2.0)
   - fully searchable by anyone from anywhere and allows for heavy traffic
   - compatible with web-based applications on mobile devices etc
   - allows for a custom version of this site for managers where they can perform internal functions (e.g. billing, commission etc)
- 2 main users in different cities
- with approximately $250,000 budget for hardware and software
 
Thankyou

---

Download the new Windows Live Looking for a place to manage all your online stuff?

On Tue, May 18, 2010 at 2:12 PM, Charo Carino <charo_carino@hotmail.com> wrote:
> - data stored in the database includes text, numbers, pictures and even
> video clips
> - avoids vendor 'lock ins' --> open DBMS
> - allows for a web-based end (web 2.0)
>    - fully searchable by anyone from anywhere and allows for heavy traffic
>    - compatible with web-based applications on mobile devices etc
>    - allows for a custom version of this site for managers where they can
> perform internal functions (e.g. billing, commission etc)
> - 2 main users in different cities
> - with approximately $250,000 budget for hardware and software

That looks like requirements specification for a web application. You
can use PostgreSQL as the DBMS for this application.

1. text, numbers, pictures can be stored
2. No vendor lock in (open DBMS)

Other requirements are not directly related to database.

Best regards,
Ma Sivakumar

மா சிவகுமார்
எல்லோரும் எல்லாமும் பெற வேண்டும்
http://masivakumar.blogspot.com

On 18 May 2010 09:42, Charo Carino <charo_carino@hotmail.com> wrote:
> Hi
> I was on your website trying to look up information on PostgreSQL and the
> information that I needed was hard to get or just couldnt find it. Can you
> please clarify whether these requirements are covered by postgreSQL product:
>
> - data stored in the database includes text, numbers, pictures and even
> video clips

Please see: http://www.postgresql.org/docs/current/static/datatype.html

> - avoids vendor 'lock ins' --> open DBMS

http://www.postgresql.org/docs/current/static/intro-whatis.html

> - allows for a web-based end (web 2.0)
That's less to do with the database system and more to do with
whatever you're building your web-based interface with.  Pretty much
all languages have support for PostgreSQL.

>    - fully searchable by anyone from anywhere and allows for heavy traffic

Again, who it's searchable by and from where isn't really to do with
the database system.  You'd be the one setting that up.  And "heavy
traffic" is a bit vague, but it is certainly used by many companies in
high traffic environments.

>    - compatible with web-based applications on mobile devices etc
>    - allows for a custom version of this site for managers where they can
> perform internal functions (e.g. billing, commission etc)

Nothing to do with databases themselves really.  They'll all do this
if you write something to do it.

> - 2 main users in different cities
> - with approximately $250,000 budget for hardware and software

PostgreSQL is completely free and runs extremely well when configured
appropriately for your hardware and the types of data/queries you'll
store/use in it.

Regards

Thom

On 18/05/2010 4:42 PM, Charo Carino wrote:
> Hi
> I was on your website trying to look up information on PostgreSQL and
> the information that I needed was hard to get or just couldnt find it.
> Can you please clarify whether these requirements are covered by
> postgreSQL product

It sounds to me like you want a web content management / document
management system. While such a product will *use* a database, tht's
only a part of what it does.

You can build something like that with PostgreSQL (though I'd store big
files in the file system and only paths in Pg) but PostgreSQL does not
do all those things by its self.

--
Craig Ringer