[Seaside] GOODS speed

[Brian Brown]

On Dec 15, 2004, at 9:26 AM, danil a. osipchuk wrote:

>
>> I converted it to PostgreSQL running on FreeBSD box - rock solid and
>> much, much faster. Then I needed to deploy the whole app on a laptop 
>> for trade
>> show (On windows), so I converted it once again to SQLite. Rock 
>> solid, but very
>> slow for those same large queries...
>
>
> Postgresql.org announced native server for nt-based systems (although 
> I didn't try it)
> They even provide installer :), see: 
> http://www.postgresql.org/docs/faqs/FAQ.html#1.4
> So I wonder - what advantages have SQLite  against postgres right now?

The main advantage is only if you need to distribute your app lot's of 
places... SQLite has no server process; you basically need one shared 
library and your database file. You have all the capabilities of Squeak 
with file systems to manage your data infrastructure, and don't need 
any kind of admin access to get your database running. It also makes it 
very easy to prototype things for the same reasons.

I would usually prefer the PostgreSQL option for performance and name 
recognition if given the choice.

Thanks for the info, that is good news about the Windoze port!

Brian


>
> wbr,
>    danil
>
> _______________________________________________
> Seaside mailing list
> Seaside at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/listinfo/seaside