Re: PostgreSQL vs Firebird feature comparison finished

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Stephen Ince" <since(at)opendemand(dot)com>, "Dave Page" <dpage(at)postgresql(dot)org>
Cc: "Tony Caduto" <tony_caduto(at)amsoftwaredesign(dot)com>, "Greg Smith" <gsmith(at)gregsmith(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL vs Firebird feature comparison finished
Date: 2007-08-27 20:48:19
Message-ID: D425483C2C5C9F49B5B7A41F89441547010008BC@postal.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

There are some limitations to SQL Server Express:
http://www.microsoft.com/sql/downloads/trial-software.mspx

Download SQL Server 2005 Express Edition
Complete a SQL Server Express download, free. There are no time limits
and the software is freely redistributable (with registration). With a
database size limit of 4 gigabytes (GB) and support for 1 CPU and up to
1 GB of RAM, the SQL Server 2005 Express download provides software that
is suitable for application embedding or lightweight application
development.

I have never used the CE version and I do not know what the limitations
are.
They are not made clear from the download page:
http://www.microsoft.com/downloads/details.aspx?familyid=B9B12312-FE57-4
817-A4BC-69992802732D&displaylang=en

This document:
http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed7
4b404e542/sqlservercompactdatasheet_final.doc

mentions a maximum database size of 4 GB (like the Express version), but
the other limits are not clear.

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Stephen Ince
> Sent: Monday, August 27, 2007 1:30 PM
> To: Dave Page
> Cc: Tony Caduto; Greg Smith; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] PostgreSQL vs Firebird feature comparison
finished
>
> Dave,
> Thx I will take a look. I was trying to port a postgres schema to a
> database that had embedded capability. I could not find any
non-commerical
> databases that supported triggers, sequences, udf function, and stored
> procedure. I as I remembered firebird has pretty weak UDF function
> capability(only C/C++) and the name size limitation was a killer.
>
> Steve
>
> >
> >
> >> ------- Original Message -------
> >> From: "Stephen Ince" <since(at)opendemand(dot)com>
> >> To: "Tony Caduto" <tony_caduto(at)amsoftwaredesign(dot)com>, "Greg Smith"
> >> <gsmith(at)gregsmith(dot)com>, pgsql-general(at)postgresql(dot)org
> >> Sent: 27/08/07, 17:02:21
> >> Subject: Re: [GENERAL] PostgreSQL vs Firebird feature comparison
> finished
> >>
> >> Postgres can't be embedded or serverless. Firebird has the embedded
> >> feature.
> >> Most of the databases have this capability (hsqldb,
derby,oracle,mysql,
> >> firebird, and db2). Derby and hsqldb are the only free embedded
> databases
> >> for commercial use.
> >>
> >
> > SQL Server CE is also free for commercial use iirc.
> >
> > Regards, Dave
> >
> > ---------------------------(end of
broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
> >
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Schumacher 2007-08-27 20:48:34 Is this a bug? Insert float into int column inserts rounded value instead of error.
Previous Message Andrew Sullivan 2007-08-27 20:41:29 Re: Tables dissapearing