From unknown Fri Jun 20 07:20:41 2025 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.509 (Entity 5.509) Content-Type: text/plain; charset=utf-8 From: bug#47640 <47640@debbugs.gnu.org> To: bug#47640 <47640@debbugs.gnu.org> Subject: Status: [PATCH v2] Add sqlitebrowser. Reply-To: bug#47640 <47640@debbugs.gnu.org> Date: Fri, 20 Jun 2025 14:20:41 +0000 retitle 47640 [PATCH v2] Add sqlitebrowser. reassign 47640 guix-patches submitter 47640 Allan Adair severity 47640 normal tag 47640 patch thanks From debbugs-submit-bounces@debbugs.gnu.org Wed Apr 07 10:41:14 2021 Received: (at submit) by debbugs.gnu.org; 7 Apr 2021 14:41:14 +0000 Received: from localhost ([127.0.0.1]:45009 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lU9Mn-0004vm-6O for submit@debbugs.gnu.org; Wed, 07 Apr 2021 10:41:13 -0400 Received: from lists.gnu.org ([209.51.188.17]:35776) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lU64r-0005Se-Gh for submit@debbugs.gnu.org; Wed, 07 Apr 2021 07:10:29 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:35282) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lU64r-0006e3-By for guix-patches@gnu.org; Wed, 07 Apr 2021 07:10:29 -0400 Received: from relay7-d.mail.gandi.net ([217.70.183.200]:52895) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lU64o-00068C-VD for guix-patches@gnu.org; Wed, 07 Apr 2021 07:10:28 -0400 X-Originating-IP: 84.213.192.253 Received: from geodata.getinternet.no (cm-84.213.192.253.getinternet.no [84.213.192.253]) (Authenticated sender: allan@adair.no) by relay7-d.mail.gandi.net (Postfix) with ESMTPSA id E09DC20004; Wed, 7 Apr 2021 11:10:22 +0000 (UTC) From: Allan Adair To: guix-patches@gnu.org Subject: [PATCH v2] Add sqlitebrowser. Date: Wed, 7 Apr 2021 13:09:53 +0200 Message-Id: <20210407110953.14809-1-allan@adair.no> X-Mailer: git-send-email 2.31.1 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Received-SPF: pass client-ip=217.70.183.200; envelope-from=allan@adair.no; helo=relay7-d.mail.gandi.net X-Spam_score_int: -25 X-Spam_score: -2.6 X-Spam_bar: -- X-Spam_report: (-2.6 / 5.0 requ) BAYES_00=-1.9, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-Spam-Score: -1.6 (-) X-Debbugs-Envelope-To: submit X-Mailman-Approved-At: Wed, 07 Apr 2021 10:41:12 -0400 Cc: Allan Adair X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.6 (--) --- gnu/packages/databases.scm | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) diff --git a/gnu/packages/databases.scm b/gnu/packages/databases.scm index ce7afa82d0..ca80099254 100644 --- a/gnu/packages/databases.scm +++ b/gnu/packages/databases.scm @@ -48,6 +48,7 @@ ;;; Copyright © 2020 Vincent Legoll ;;; Copyright © 2021 Sharlatan Hellseher ;;; Copyright © 2021 Greg Hogan +;;; Copyright © 2021 Allan Adair ;;; ;;; This file is part of GNU Guix. ;;; @@ -3829,3 +3830,30 @@ PostreSQL, SQLite, ODBC and MySQL.") "FreeTDS is an implementation of the Tabular DataStream protocol, used for connecting to MS SQL and Sybase servers over TCP/IP.") (license license:lgpl2.0+))) + +(define-public sqlitebrowser + (package + (name "sqlitebrowser") + (version "3.12.1") + (source + (origin + (method git-fetch) + (uri (git-reference + (url "https://github.com/sqlitebrowser/sqlitebrowser") + (commit (string-append "v" version)))) + (file-name (git-file-name name version)) + (sha256 + (base32 + "0ray6cscx2qil1dfi7hmpijmq3kba49wn430ih1q4fkz9psjvrz1")))) + (build-system cmake-build-system) + (inputs + `(("qtbase" ,qtbase) + ("qttools" ,qttools) + ("sqlite" ,sqlite))) + (arguments + `(#:configure-flags '("-DENABLE_TESTING=ON"))) + (home-page "https://sqlitebrowser.org/") + (synopsis "DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.") + (description + "DB4S is for users and developers who want to create, search, and edit databases. DB4S uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned.") + (license (list license:gpl3+ license:mpl2.0)))) -- 2.31.1 From debbugs-submit-bounces@debbugs.gnu.org Wed Apr 07 11:56:58 2021 Received: (at 47640) by debbugs.gnu.org; 7 Apr 2021 15:56:58 +0000 Received: from localhost ([127.0.0.1]:45046 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lUAY5-0006lb-PU for submit@debbugs.gnu.org; Wed, 07 Apr 2021 11:56:58 -0400 Received: from mail-wr1-f48.google.com ([209.85.221.48]:42538) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lUAXp-0006l8-KS for 47640@debbugs.gnu.org; Wed, 07 Apr 2021 11:56:56 -0400 Received: by mail-wr1-f48.google.com with SMTP id q26so12834659wrz.9 for <47640@debbugs.gnu.org>; Wed, 07 Apr 2021 08:56:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:cc:subject:in-reply-to:references:date:message-id :mime-version:content-transfer-encoding; bh=Qafcl4q2bh0DM1WFTsxZcsl9twBec2ajgHPg2d/ryKs=; b=BQmSYeqdvOXA+64d+EQ0smhjeL5dQWoXEH8FHihpMfVyDULbEzXYNcj4NE5rl7Mt1B EapYDGjMAkcu2YvEC2V1Ms4XoF5/55xUjtSudQMyTCuAPkRHaM1eXoI0q8Cw85alwp4J 27UpcLLlPrU8CTL8a1pPA0L8DO+t5wJGHrqmTjb2YKDtHCPLLaj2DzojD/BXq6LPdpO3 uNSZWevFmbFXiwn2X+2zAzdWM9T3RsKLOrNegf5X/rlVwLsAMCvA68aLLHhNuCqBJ3/O vLYi3QMYOOliCEuMqHLHkbnrS056kf4rUktCclyroeSxcBPFgUZDt1l0xZe5TFnN+9FN XcHQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:subject:in-reply-to:references:date :message-id:mime-version:content-transfer-encoding; bh=Qafcl4q2bh0DM1WFTsxZcsl9twBec2ajgHPg2d/ryKs=; b=gJG1TxqbKkezrBKLdom6969h+ZKM6HsL16YKw+cUxn88NQoJOENc9tuUlIgUneear3 nFCIv0DX3w74PXn8TJ0MPE14KDPsxX9Doki8xQ04055RK3ITINuBvY6gEWFlG8x8l8td DYGV8Xon8nMbWzXtmgRfte45kBs+sNMyZfcxFD4sFT3t46BKiSP2vdjDRP6x1h4pXvqC +zrEsFWyX8AxdUQ6L5N6VNLSgLp0YoRhpCaeTpdjg1MVnpRcwKCRDJxTTBH1glBF6rY4 Xq/TiNqp9DE98msOJ1CI63OW38ndKsR6FS92Ylk9Ib0vVjd+hth9c8SB0GNiJ7wuMAvz OvIQ== X-Gm-Message-State: AOAM532DmVBv82ZgFjNLsoI0d3jSSDkCRbj8ybkp5lXRRdB0JRKpD4US 1cPQUMVhuuS3/L3LSYKKkjw= X-Google-Smtp-Source: ABdhPJz2mlMIn4FTIvqz7wq9eiJQFdWWmzpvSJqCjtz2KHRDGjV/txLJX4nioizfRSdL3Oh8I+NmZA== X-Received: by 2002:adf:cd0a:: with SMTP id w10mr5183242wrm.39.1617810995588; Wed, 07 Apr 2021 08:56:35 -0700 (PDT) Received: from guixSD (host-79-17-142-89.retail.telecomitalia.it. [79.17.142.89]) by smtp.gmail.com with ESMTPSA id c16sm48937942wrs.81.2021.04.07.08.56.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 07 Apr 2021 08:56:34 -0700 (PDT) From: =?utf-8?Q?Nicol=C3=B2?= Balzarotti To: Allan Adair , 47640@debbugs.gnu.org Subject: Re: [bug#47640] [PATCH v2] Add sqlitebrowser. In-Reply-To: <20210407110953.14809-1-allan@adair.no> References: <20210407110953.14809-1-allan@adair.no> Date: Wed, 07 Apr 2021 17:56:33 +0200 Message-ID: <871rbmnl5a.fsf@guixSD.i-did-not-set--mail-host-address--so-tickle-me> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: 0.0 (/) X-Debbugs-Envelope-To: 47640 Cc: Allan Adair X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) Hi, thanks for the contribution! A few comments below Allan Adair writes: > + (description > + "DB4S is for users and developers who want to create, search, and e= dit databases. DB4S uses a familiar spreadsheet-like interface, and complic= ated SQL commands do not have to be learned.") I think the linter here will complain about the single space after the period, and for the really long line. Did you run ./pre-inst-env guix lint sqlitebrowser ? This should tell you if something is wrong > + (license (list license:gpl3+ license:mpl2.0)))) I see that there are bundled dependencies (under /libs), could you try unbundle them (remove the lib folder with a source snippet) and build using guix dependencies? There are only four of them, two of which (nlohmann-json-cpp and qscintilla) are already in guix. Else it might be needed to fix the licence. There are the cmake flags FORCE_INTERNAL_QSCINTILLA, FORCE_INTERNAL_QCUSTOMPLOT, FORCE_INTERNAL_QHEXEDIT which suggest this should be possible. Thanks, Nicol=C3=B2 From debbugs-submit-bounces@debbugs.gnu.org Fri Apr 09 07:08:05 2021 Received: (at 47640) by debbugs.gnu.org; 9 Apr 2021 11:08:05 +0000 Received: from localhost ([127.0.0.1]:49178 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lUozd-0000rG-Et for submit@debbugs.gnu.org; Fri, 09 Apr 2021 07:08:05 -0400 Received: from relay1-d.mail.gandi.net ([217.70.183.193]:19561) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1lUozb-0000qa-BN for 47640@debbugs.gnu.org; Fri, 09 Apr 2021 07:08:04 -0400 X-Originating-IP: 84.213.192.253 Received: from [192.168.0.9] (cm-84.213.192.253.getinternet.no [84.213.192.253]) (Authenticated sender: allan@adair.no) by relay1-d.mail.gandi.net (Postfix) with ESMTPSA id 7F39124000B; Fri, 9 Apr 2021 11:07:55 +0000 (UTC) Subject: Re: [bug#47640] [PATCH v2] Add sqlitebrowser. To: =?UTF-8?Q?Nicol=c3=b2_Balzarotti?= , 47640@debbugs.gnu.org References: <20210407110953.14809-1-allan@adair.no> <871rbmnl5a.fsf@guixSD.i-did-not-set--mail-host-address--so-tickle-me> From: Allan Adair Message-ID: Date: Fri, 9 Apr 2021 13:07:52 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Icedove/78.9.0 MIME-Version: 1.0 In-Reply-To: <871rbmnl5a.fsf@guixSD.i-did-not-set--mail-host-address--so-tickle-me> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit X-Spam-Score: -0.7 (/) X-Debbugs-Envelope-To: 47640 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.7 (-) Hi Nicolò. On 4/7/21 5:56 PM, Nicolò Balzarotti wrote: > Did you run ./pre-inst-env guix lint sqlitebrowser ? This should tell > you if something is wrong Thanks! I really appreciate this guidance! It was an oversight on my part. >> + (license (list license:gpl3+ license:mpl2.0)))) > I see that there are bundled dependencies (under /libs), could you try > unbundle them (remove the lib folder with a source snippet) and build > using guix dependencies? There are only four of them, two of which > (nlohmann-json-cpp and qscintilla) are already in guix. Else it might > be needed to fix the licence. I have been trying over the past couple of days with some difficulty. I will continue with some more effort next week, but since I am not an expert on the codebase (or cmake!) I may beg for fixing the licenses instead. From debbugs-submit-bounces@debbugs.gnu.org Mon Feb 21 08:56:03 2022 Received: (at 47640-done) by debbugs.gnu.org; 21 Feb 2022 13:56:03 +0000 Received: from localhost ([127.0.0.1]:35441 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nM9AR-0002jc-Dt for submit@debbugs.gnu.org; Mon, 21 Feb 2022 08:56:03 -0500 Received: from mout02.posteo.de ([185.67.36.66]:43907) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nM9AO-0002jE-BZ for 47640-done@debbugs.gnu.org; Mon, 21 Feb 2022 08:55:53 -0500 Received: from submission (posteo.de [185.67.36.169]) by mout02.posteo.de (Postfix) with ESMTPS id A9F00240103 for <47640-done@debbugs.gnu.org>; Mon, 21 Feb 2022 14:55:46 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017; t=1645451746; bh=FW+MIRh/8tlO7eH7vkYVpK6p6AeubLDVSGx82Fmhqeg=; h=From:To:Subject:Date:From; b=CaZjUoU0uwfNCVo/SGQjJIHd6vnMaL1pEmfIgO40V8bTXstt4twFMdYGOhMSvs9vz MZcsLVRHeXPsDh1SQBLx/FNyNTiVpMwDRSmrwS3Cq0j///neMwwzPUkywSfy6zZwOj 6N4R4DHEpboGoZQCN7bphGJDMJEYRJnAqkaGcF5jUWWUAFsbYy23OrYtYikXkyXJND /YqGVgH38LZ5mry4eNa/ZTm9uu5eWIv6PIKwS8I3muSLtK3mwJ3RRzJcGZkLA2uDUM 6jkLdW2lu+QKFwk7QDnQE7r20dPs7uHl6ZY82MqVkLdsTyl5wvtOGJDPuhzrDZfEea 3LR+Hdh3AvHCA== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4K2P2n6mn4z6tp1; Mon, 21 Feb 2022 14:55:45 +0100 (CET) From: Guillaume Le Vaillant To: 34612-done@debbugs.gnu.org, 47640-done@debbugs.gnu.org Subject: Re: Add sqlitebrowser Date: Mon, 21 Feb 2022 13:53:13 +0000 Message-ID: <87a6eks4rj.fsf@kitej> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" X-Spam-Score: -2.3 (--) X-Debbugs-Envelope-To: 47640-done X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) --=-=-= Content-Type: text/plain sqlitebrowser is in Guix (9183b8142b43082fee55a2730399243dea47ad0a). Closing. --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iIUEAREKAC0WIQTLxZxm7Ce5cXlAaz5r6CCK3yH+PwUCYhOZ4A8cZ2x2QHBvc3Rl by5uZXQACgkQa+ggit8h/j8CMwD+MB0FOejjiDXEoJHdpWHzApiTat4obcROCMZw UYHzZ2YA/A20WCXjOQgr/+H508LOFr7rXfXObmhCkJb6pfoceNOe =xs/5 -----END PGP SIGNATURE----- --=-=-=-- From unknown Fri Jun 20 07:20:41 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: Debbugs Internal Request Subject: Internal Control Message-Id: bug archived. Date: Tue, 22 Mar 2022 11:24:06 +0000 User-Agent: Fakemail v42.6.9 # This is a fake control message. # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator