From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id OOg+FB9vcGOvZgAAbAwnHQ (envelope-from ) for ; Sun, 13 Nov 2022 05:14:23 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id OCwKFB9vcGP6NgAAauVa8A (envelope-from ) for ; Sun, 13 Nov 2022 05:14:23 +0100 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id C8AA739C18 for ; Sun, 13 Nov 2022 05:14:22 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1ou4Nl-00048a-Fw; Sat, 12 Nov 2022 23:14:09 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ou4Nk-00048O-1c for emacs-orgmode@gnu.org; Sat, 12 Nov 2022 23:14:08 -0500 Received: from stw1.rcdrun.com ([217.170.207.13]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ou4Ni-0004sW-2M for emacs-orgmode@gnu.org; Sat, 12 Nov 2022 23:14:07 -0500 Received: from localhost ([::ffff:197.239.5.250]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 00000000000F6120.0000000063706F0E.000064ED; Sat, 12 Nov 2022 21:14:05 -0700 Date: Sun, 13 Nov 2022 05:39:13 +0300 From: Jean Louis To: Jan Ulrich Hasecke Cc: Org-Mode Mailinglist Subject: Re: Tutorials on creating pdfs with org-babel and sqlite Message-ID: Mail-Followup-To: Jan Ulrich Hasecke , Org-Mode Mailinglist References: Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="=_stw1.rcdrun.com-25837-1668312846-0001-2" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.2.7+37 (a90f69b) (2022-09-02) Received-SPF: pass client-ip=217.170.207.13; envelope-from=bugs@gnu.support; helo=stw1.rcdrun.com X-Spam_score_int: -17 X-Spam_score: -1.8 X-Spam_bar: - X-Spam_report: (-1.8 / 5.0 requ) BAYES_00=-1.9, RCVD_IN_SBL=0.141, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1668312863; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post; bh=Lkq8Daj5/QVjvsmDQQXR/5qwt+WeKkiygTBYehbqCSk=; b=tFDw96fZn6L4luqBgAxUo3Q5Wsjgd6os1hGO7RKEjcWhI6uDrVcihhMcDQ94s190slkgtS xFCikAi73ke9QPw9FZjprpWMOvpO9RSrX1kn3HTtoGjAh1h1EpKFT+gD4EsTDtXbu40N8d e6Cw8kNqGawjwCRUM//V3p4xL2zIP677nw+UlNIToR78tW/B+sKIOpfdKe/KsvBTJnazRG +6mzzPmRhq1Ota2jnoZSNzIGaP7/EeOKDc8DZSuOUGsFmahqKYrWib2Wt6Bi6Y5b5f9YR+ ZyvqA+5bYESZmsY6ipROs+kj6y3mACo9WjOl+CQrph88oT6EtODKEdt5EVk5uA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1668312863; a=rsa-sha256; cv=none; b=Wnm0uXy3Zwumoh7MHAi8HEYc5140nMmN9E/pJY+3HcfXt+YgikTKUWDyoQKOr/diSQBqSj v+H3GrPy6UGao2UFlM8l8NbOGD5Dq7XaC0jScsZ3UH4ZCTkzk8lDu3y4OHIL6XKqDIrHjd SzfxEMMcamdndrwXkLoX2FGN1qq6NqAFC5lnxpgm1bYfBtdmoNlcNRhm0P7YdbrC36ihfv gY2dkR1Brflz2sj7TPWTtCyMrqU+AuPT1X1LR4xp3MoniQvhl2yicL8Zod37M6DOXZagIE 8NasQO6PW3/nRx49WxnpRuJ/k27c2Mfc6dHboQKgJDcjaJpMGYeeO848V7Qo6g== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -1.64 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: C8AA739C18 X-Spam-Score: -1.64 X-Migadu-Scanner: scn1.migadu.com X-TUID: d9sTyxHIFjnd This is a MIME-formatted message. If you see this text it means that your E-mail software does not support MIME-formatted messages. --=_stw1.rcdrun.com-25837-1668312846-0001-2 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Jan Ulrich Hasecke [2022-11-12 21:09]: > Dear all, >=20 > I am doing my first steps to do some database publishing with org-babel > and sqlite. So far quite successful, but I am still very new to this, so > I would appreciate if you can recommend a tutorial on this. I am mostly > interested in publishing use cases. Has anybody wrote a book or a report > with org-mode, org-babel and sqlite? What options I have to format the > output so that I can export it to pdf via pandoc and context? Let me say from my experience of 20+ years of publishing and using database: - use PostgreSQL and its rich features, forget SQLite. Single user single computer database is good for you personally, but modifying tables and developing new features is far harder with SQLite. - Separate lightweight markup language LWM from publishing objects table. Make the publishing available for any kind of LWM! - For now I use following "Markup Types" in my `markuptypes' table: 1 Default (Text) 2 Markdown (Discount Markdown) 3 Markdown (Pandoc, espresso) 4 Asciidoc 5 Asciidoctor 6 Markdown (Discount) with Table of Content 7 HTML 8 Kotl 9 Org 10 Org Heading 11 Org Standalone 12 reStructuredText 13 txt2tags 14 Enriched 15 PDF 16 Text with lines joined 17 Org with Markdown TOC 18 PostgreSQL My publishing object references foreign table of markuptypes. That way it becomes known what LWM is used for the text of publishing object.=20 Then I use extra table `markupconversions': Table "public.m= arkupconversions" =E2=94=8C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=AC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=AC=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=AC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=AC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=90 =E2=94=82 Column =E2=94=82 Type = =E2=94=82 Collation =E2=94=82 Nullable =E2=94=82 = Default =E2=94=82 =E2=94=9C=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=BC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=BC=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=BC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=BC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=A4 =E2=94=82 markupconversions_id =E2=94=82 integer = =E2=94=82 =E2=94=82 not null =E2=94=82 nextval('markupconvers= ions_markupconversions_id_seq'::regclass) =E2=94=82 =E2=94=82 markupconversions_datecreated =E2=94=82 timestamp without time z= one =E2=94=82 =E2=94=82 not null =E2=94=82 CURRENT_TIMESTAMP = =E2=94=82 =E2=94=82 markupconversions_datemodified =E2=94=82 timestamp without time z= one =E2=94=82 =E2=94=82 =E2=94=82 = =E2=94=82 =E2=94=82 markupconversions_usercreated =E2=94=82 text = =E2=94=82 =E2=94=82 not null =E2=94=82 CURRENT_USER = =E2=94=82 =E2=94=82 markupconversions_usermodified =E2=94=82 text = =E2=94=82 =E2=94=82 not null =E2=94=82 CURRENT_USER = =E2=94=82 =E2=94=82 markupconversions_name =E2=94=82 text = =E2=94=82 =E2=94=82 not null =E2=94=82 = =E2=94=82 =E2=94=82 markupconversions_markupinput =E2=94=82 integer = =E2=94=82 =E2=94=82 not null =E2=94=82 = =E2=94=82 =E2=94=82 markupconversions_markupoutput =E2=94=82 integer = =E2=94=82 =E2=94=82 not null =E2=94=82 = =E2=94=82 =E2=94=82 markupconversions_emacslisp =E2=94=82 text = =E2=94=82 =E2=94=82 not null =E2=94=82 = =E2=94=82 =E2=94=82 markupconversions_description =E2=94=82 text = =E2=94=82 =E2=94=82 =E2=94=82 = =E2=94=82 =E2=94=82 markupconversions_templates =E2=94=82 integer = =E2=94=82 =E2=94=82 =E2=94=82 = =E2=94=82 =E2=94=82 markupconversions_command =E2=94=82 text = =E2=94=82 =E2=94=82 =E2=94=82 = =E2=94=82 =E2=94=94=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=B4=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=B4=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=B4=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=B4=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=98 That one says how to convert between input markup and output markup. The conversion Lisp snippet I keep in the database `markupconversions_emacslisp' as that way no need to change the source, it remains user's option. Each publishing object references the web `area`foreign table, meaning domain. Each `area' references one main template, but each object can reference separate template. And markup conversion may need separate template before everything is expanded in the object's or area's template.=20 Now we come back to question: > What options I have to format the output so that I can export it to > pdf via pandoc and context? Maybe the above described design pattern may help you figure out how to solve your problem. - You can reference publishing objects to foreign table `website`, in my case it is `area', which means specific domain;=20 - Specific domain can tell how to use default conversion from which markup to which markup, how to publish by default. For example you want by default Org to Markdown to Pandoc output? - Each publishing object, like page, can have its separate reference to markup conversion. Maybe you want Org to Asciidoctor? Reference it from publishing object. If reference is NIL, use the default website's conversion. - Define for each markup type, like ConTeXt how to export it to HTML, PDF, etc. - Use markup conversion table to tell how to convert ConTeXt to PDF, or to HTML or to what? - Make additional table to add additional publishing commands, as single page such as one with Org markup, may end up published as Org, as HTML and as PDF. --=20 Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/ --=_stw1.rcdrun.com-25837-1668312846-0001-2 Content-Type: application/pgp-signature; name="signature.asc" Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- iQEzBAEBCAAdFiEEv9/jXBKLXfDiHl8IErxRIkudxlwFAmNwWNEACgkQErxRIkud xlxLggf/cS4Vb1IJN3ABkCGwrqlxzT16KssTDE3RL2q2VVakRsGGv6XyHa6B492g iI9OmOc5/SQswtJx6COC4g3AXAcJJ4aiTbS9k6XEUy2QAsCTHw/amK1FEghYuk3M 4lC9ArlNLMDLajUcxA9L6aoNW1uckUMN3NQsZPzmsXjuXHETpHDm/GOi5tzTtnFI FX9YKRiO8zEYVsJmCpXcgljR3M1STyiZIV1shLGW1IsegGZhJXuXo23QAuhhKq8F lWNHq6EJjsAMtuNsF0anBocZav15rBKfhKypm3CISY6gR9fUoQFaSQweY9/XzAAy JDRj5AbOloXRsy6TIdtA80oEbKv0TA== =0UKE -----END PGP SIGNATURE----- --=_stw1.rcdrun.com-25837-1668312846-0001-2--