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@xxxxxxxxxxxxxxxxxxxxxxxxxx
http://lists.squeakfoundation.org/listinfo/seaside
|
Try Searching:
servers, voip, java, networking, microsoft ...
|
|
|
|