Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMVQR-002YnT-55 for pgsql-general@arkaria.postgresql.org; Thu, 20 Jul 2023 15:18:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qMVQP-00AK57-Bh for pgsql-general@arkaria.postgresql.org; Thu, 20 Jul 2023 15:18:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMVQP-00AK4z-0l for pgsql-general@lists.postgresql.org; Thu, 20 Jul 2023 15:18:41 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMVQK-000fg2-4M for pgsql-general@lists.postgresql.org; Thu, 20 Jul 2023 15:18:40 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id E6FDF5C01A8; Thu, 20 Jul 2023 11:18:33 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Thu, 20 Jul 2023 11:18:33 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm2; t= 1689866313; x=1689952713; bh=K0yt0bN3UXwUEjjRzGkC9Vqk2bglTGFhFwx mFaqBBhw=; b=BKS+BmEsmk+Dv+u+eKD8ZuZ33A2LOJ3UW+G35sngO4pw9zVNb9w DK8z/BUE+pwpzCjrJxnp9x+SD4GWNdSXviy71Px1hAhuc178X7yyBSmn8Pa0n1QF GjNdKDtXZWmUdoLXjsCOIrJ/9sKJUR3SbYIwPzmVrHJQeCdQzjiICNUBQdn2jqXN fJns96WrHAGztF021/oYAcptsMqdPKD7LLJz7hq69IoOLEQj2zbKeU7n5TRAVmhw 1vdZrVLJiUqCCUJ31KjnW2FVq61kPf5VV89P05Jblw7A1iWlavFF4L0AwTj2xiAX AusRIWx5swq0gP7qEOBqV8EktuGUryArwqQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1689866313; x=1689952713; bh=K0yt0bN3UXwUEjjRzGkC9Vqk2bglTGFhFwx mFaqBBhw=; b=fGrCtIq8sSfZCAjkIOtJ+K/MFBBT8/GUvAxx5n3gg9vgFo8ssyS BCJka2MwrwArD9f5VkS3VoTEGhCQBH2jyQfpJOI0GRKBfCXcgxx6i3RpHMSchMuB L4xBLfBgv6A/XrO1FI2+FGPMrfpFrO+PFfQTDpjaBzzNw53dk+MWaOYjr1mnlSGy tJr5LxDokYn6wBn8zluU4XFKNoN0KxS2IyFetV4lILkUI2+t49bXgewN7WOHuylQ ZHIjKaUsgPwn61iaPsVPep4XDXAtryQKfdhqof5pQwGv2qf5QzncezZBsHED7zBq qjcbNhuIymJPX7WWAKNCPbCNbyD8mZC31Qg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrhedtgdekiecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtke ertddtfeejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhk lhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhephedugfethf ettdehieevteeukedtjedvhfevkefgudefgeevteduvdeuvdeggeegnecuvehluhhsthgv rhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvh gvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 20 Jul 2023 11:18:33 -0400 (EDT) Message-ID: <8f362bdd-c60c-72cb-e666-936708a4c808@aklaver.com> Date: Thu, 20 Jul 2023 08:18:32 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: My 1st JDBC and PostgreSQL Content-Language: en-US To: Chuck Davis Cc: pgsql-general@lists.postgresql.org References: From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/19/23 18:11, Chuck Davis wrote: > Postgresql is a sophisticated database server.  You can do what you're > attempting with something like Derby at the connection.  But with > Postgresql "you get what you pay for". Not sure what "you get what you pay for" means in this context? My take is you are differentiating between embedded databases such as Derby and SQLite which are tied to a specific client and client/server databases like Postgres and MySQL which stand alone and are connected to by any number of clients. > 1) Insall Postgresql > 2) start the database > 3) use the interface app psql to create a database; > 4) load the JDBC driver in your client and connect. > 5) manipulate the database via the JDBC driver. > > All these steps are explained quite nicely in the Postgresql > documentation you can find at the web site.  The JDBC site is separate > but a Google search will find it for you. > -- Adrian Klaver adrian.klaver@aklaver.com