On Tue, Apr 28, 2009 at 12:29 PM, <[email protected]> wrote: > On Tue, 28 Apr 2009 09:26:21 +0200, Stefan de Konink <[email protected]> > wrote: >> [email protected] wrote: >>> On Tue, 28 Apr 2009 08:02:30 +0100, Shaun McDonald >>>> SQLite isn't designed for huge databases like OpenStreetMap. You could > >>>> get away with a city or small region, but more than that, you will get > >>>> the slowness that you are seeing. >>>> http://www.sqlite.org/faq.html#q19 and some other FAQs on that page. >>>> You are much better using Postgres, or even MySQL. >>> >>> Is there ANY embedded database out there that can handle the planet? >>> Anything that does not require the (unskilled) user of a program to >>> install a local database-server first? >> >> MonetDB can be running in embedded mode ;) > > From what I can see at > http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Embedded-Server.html#Embedded-Server > the "embedded"-mode is still a server, just for > embedded systems. > I was talking about having the database as a library > be a part of the program. > Nothing to install or to start separately.
You could always make your program embed/start the database server regardless of whether it's a library or a server. It would just mean e.g. shipping the postgresql binaries with your program and doing some magic in your program that ensures that the server is started when the program is. _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
