From owner-freebsd-questions@FreeBSD.ORG Tue Jul 2 11:55:40 2013 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 946403F9; Tue, 2 Jul 2013 11:55:40 +0000 (UTC) (envelope-from feld@feld.me) Received: from out1-smtp.messagingengine.com (out1-smtp.messagingengine.com [66.111.4.25]) by mx1.freebsd.org (Postfix) with ESMTP id 6928D1858; Tue, 2 Jul 2013 11:55:40 +0000 (UTC) Received: from compute3.internal (compute3.nyi.mail.srv.osa [10.202.2.43]) by gateway1.nyi.mail.srv.osa (Postfix) with ESMTP id 8B36B20C24; Tue, 2 Jul 2013 07:55:39 -0400 (EDT) Received: from frontend2.nyi.mail.srv.osa ([10.202.2.161]) by compute3.internal (MEProxy); Tue, 02 Jul 2013 07:55:39 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=feld.me; h= content-type:to:subject:references:date:mime-version :content-transfer-encoding:from:message-id:in-reply-to; s= mesmtp; bh=NivpzufMp8RQupvuyCxfZl1ElxA=; b=TOV6GfZ8Qdyoc8wKavCvB mvrU5JLfzQJl+oUkkGztHW9FwMooAANOofjeGLzkJg1zgh2M9g3GOkZzNuzT77we t4gNZclJ6IV9c5bX1Cd8Z9gRAIefdPc6kqIGaKdGY1i0X0lhSYkfUBPBr18dKFs9 YMNJhERcWwaUXm9PeSu/5Q= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=content-type:to:subject:references:date :mime-version:content-transfer-encoding:from:message-id :in-reply-to; s=smtpout; bh=NivpzufMp8RQupvuyCxfZl1ElxA=; b=SPXA WuWfOKDqr86NfYR0ddPZHlQRoMjKHutMfJ+P5YXVKWdw7OJXBJ9qNqa3h1BP2YP3 DP7BQ9TTaaeZPbO5QOJHD9bNQwMrzaQFjZ2i2CvnawrMErZqoHBFm+ptSDQPtaZ0 yFMhor9dUiuEtuV/k1LaXHy/FPfs72f6JUKhw2g= X-Sasl-enc: HK2rAJkQ/tfOlS/O67tH/hMNlJ8/Mr2Rk+l7AHUoXsQo 1372766139 Received: from tech304.office.supranet.net (unknown [66.170.8.18]) by mail.messagingengine.com (Postfix) with ESMTPA id 507FE68023F; Tue, 2 Jul 2013 07:55:39 -0400 (EDT) Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes To: freebsd-questions@freebsd.org, "Ivan Voras" Subject: Re: sleepycat db VS MySQL or postgres References: <51D1E68B.5050508@paz.bz> Date: Tue, 02 Jul 2013 06:55:39 -0500 MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: "Mark Felder" Message-ID: In-Reply-To: User-Agent: Opera Mail/12.15 (FreeBSD) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Jul 2013 11:55:40 -0000 On Tue, 02 Jul 2013 05:45:47 -0500, Ivan Voras wrote: > Well, this is essentially a bikeshed thread... so why not chip in I disagree; all of these databases have distinctly different uses. MySQL/PostgreSQL: pick your poison. Relational databases. Will you have multiple users connecting to the database? Will there be lots of updates to the data? These are what you want. If you care about data integrity, I'd choose Postgres. SQLite: Do you want a relational database without needing a daemon to be running and will only have a single user/process accessing the database at one time? This is what you want. NoSQL: Do you want to dabble with the mess that is NoSQL so you can build your "cloud"? Don't care if other nodes aren't guaranteed to get the latest copy of the data? This is what you want. SleepyCat/BerkleyDB: Is your data WORM? (Write Once Read Many) If so, this is *ABSOLUTELY* what you want. If twitter was built upon a WORM database instead of MySQL they could host the entirety of twitter on a handful of servers instead of the gross MySQL+Cassandra mess they're fighting with today.