>>26
Yes.
From wikipedia:
BDB can support thousands of simultaneous threads of control or concurrent processes manipulating databases as large as 256 terabytes, on a wide variety of operating systems including most Unix-like and Windows systems, and real-time operating systems.
They're both comparable in speed, but BerkleyDB is more oriented toward serious enterprise-level applications and provided functionality there that SQLite can't match. The trade-off being that it's larger, more complicated and less flexible.
SQLite can only handle one thread writing to a database at a time because of it's coarse, database-wide locking mechanism. If you only have one or two threads writing to the database at a time, it's manageable, since each write only takes a few milli-seconds, but that certainly won't work in an enterprise environment.