On 23.11.2009, at 11:27, Andreas Pflug wrote: > Lukas Smith wrote: >> On 20.11.2009, at 22:45, Albert Santoni wrote: >> >> >>> Hi guys, >>> >>> (Disclaimer: This is mostly me thinking out loud...) >>> >>> Apparently I didn't read the fine print that says SQLite doesn't >>> support concurrent multiple writer connections, and so the new library >>> code is semi-broken at the moment. To the best of my understanding, we >>> have two options for solving this: >>> >> >> >> another alternative .. though potentially painful is switch to firebird: >> http://en.wikipedia.org/wiki/Firebird_(database_server) >> >> "Optional single file embedded version for creating CD-ROM catalogs, single >> user or evaluation versions of applications" >> >> firebird also supports a lot more sql features. >> if this is considered to be a worthwhile option to explore i can try to put >> you guys in touch with some firebird developers. >> > I don't know whether firebird will be able to support multiple > connections when embedded either; I wouldn't be surprised if not. > Why not use a normal database server? Of corse, I'd suggest PostgreSQL > for that.
postgresql would be very much oversized. and yes firebird does support concurrent threads: http://kinterbasdb.sourceforge.net/dist_docs/firebird-client-library-thread-safety-overview.html regards, Lukas DJ Suicide Dive [email protected] ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Mixxx-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mixxx-devel
