From owner-freebsd-questions@freebsd.org Thu Apr 6 20:41:49 2017 Return-Path: Delivered-To: freebsd-questions@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id CD2AAD3203B for ; Thu, 6 Apr 2017 20:41:49 +0000 (UTC) (envelope-from freebsd@edvax.de) Received: from mailrelay10.qsc.de (mailrelay10.qsc.de [212.99.163.152]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "*.antispameurope.com", Issuer "TeleSec ServerPass DE-2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 416A4775 for ; Thu, 6 Apr 2017 20:41:48 +0000 (UTC) (envelope-from freebsd@edvax.de) Received: from mx01.qsc.de ([213.148.129.14]) by mailrelay10.qsc.de; Thu, 06 Apr 2017 22:41:40 +0200 Received: from r56.edvax.de (port-92-195-127-117.dynamic.qsc.de [92.195.127.117]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mx01.qsc.de (Postfix) with ESMTPS id 2B4E63CC42; Thu, 6 Apr 2017 22:41:38 +0200 (CEST) Received: from r56.edvax.de (localhost [127.0.0.1]) by r56.edvax.de (8.14.5/8.14.5) with SMTP id v36Kfcat003806; Thu, 6 Apr 2017 22:41:38 +0200 (CEST) (envelope-from freebsd@edvax.de) Date: Thu, 6 Apr 2017 22:41:38 +0200 From: Polytropon To: Ernie Luzar Cc: Chuck Swiger , FreeBSD - Subject: Re: Is there a database built into the base system Message-Id: <20170406224138.b212d361.freebsd@edvax.de> In-Reply-To: <58E69E59.6020108@gmail.com> References: <58E696BD.6050503@gmail.com> <69607026-F68C-4D9D-A826-3EFE9ECE12AB@mac.com> <58E69E59.6020108@gmail.com> Reply-To: Polytropon Organization: EDVAX X-Mailer: Sylpheed 3.1.1 (GTK+ 2.24.5; i386-portbld-freebsd8.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-cloud-security-sender: freebsd@edvax.de X-cloud-security-recipient: freebsd-questions@freebsd.org X-cloud-security-Virusscan: CLEAN X-cloud-security-disclaimer: This E-Mail was scanned by E-Mailservice on mailrelay10.qsc.de with 8C5C268346F X-cloud-security-connect: mx01.qsc.de[213.148.129.14], TLS=1, IP=213.148.129.14 X-cloud-security: scantime:.2889 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 06 Apr 2017 20:41:49 -0000 On Thu, 06 Apr 2017 16:00:25 -0400, Ernie Luzar wrote: > Chuck Swiger wrote: > > On Apr 6, 2017, at 12:27 PM, Ernie Luzar wrote: > >> Looking for a simple database thats comes with the base system, is there one? > > > > There's likely an old flavor of BerkeleyDB around if you just need a key-value store. > > > > If you're looking for a SQL database, start with SQLite (cf databases/sqlite3 port), > > and then look towards MySQL or Postgres. > > > > Regards, > > BerkeleyDB sounds like something to look at. Did a "locate Berkeley" cmd > and nothing popped out. Is it called something else? Check "man db" (or "man dbopen") for introduction. The header file /usr/include/db.h has additional details. > Writing csh scripts [...] No. Just no. Don't write C shell scripts. I did it. Once. It was terrible (and the result still works). ;-) More details here: http://sc.tamu.edu/help/other/CshProgrammingConsideredHarmful.html > [...] manipulating text files containing lists of IP > address. If your data has a more or less specific format (like CSV), you could use awk for that task. But maybe a database tool like the BerkeleyDB is better in many aspects. > Don't want any port as a required dependent. Good approach for dealing with firewall-related programming (which is a "OS-mostly" thing). > I though I > remembered that BerkeleyDB came with the base system, but can not find > what its named. It's basically an API to system libraries, not a specific program called by the user. -- Polytropon Magdeburg, Germany Happy FreeBSD user since 4.0 Andra moi ennepe, Mousa, ...