[ Date Index ]
[ Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
Re: [LUG] Libreoffice BASE training/commission
- To: "list" <list@xxxxxxxxxxxxx>
- Subject: Re: [LUG] Libreoffice BASE training/commission
- From: Mark Thurston <mark@xxxxxxxxxx>
- Date: Tue, 12 Jul 2022 15:32:56 +0100
- Arc-authentication-results: i=1; mx.zohomail.com; dkim=pass header.i=mdvthu.com; spf=pass smtp.mailfrom=mark@xxxxxxxxxx; dmarc=pass header.from=<mark@xxxxxxxxxx>
- Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zohomail.com; s=zohoarc; t=1657636383; h=Content-Type:Content-Transfer-Encoding:Cc:Date:From:In-Reply-To:MIME-Version:Message-ID:References:Subject:To; bh=XJQprk1wks2xiEznjX8kJW/Gab4hWK08VJ4R3tE+0Ws=; b=fXwpWMJh1APte/r6pK0yKVU9NVgpEwR2leAmaKaZQEGJLvKCHlReh6SP/PZiEYDlPCY19xbqcajoPPkvtaduMbjjh6yJbufUccsaThnZrrmaRa+rvo/cMtYFD3lOHOwuWnCWu/baILBBQjZIXWPfabGTazDGLGJbRFayuNPbTk4=
- Arc-seal: i=1; a=rsa-sha256; t=1657636383; cv=none; d=zohomail.com; s=zohoarc; b=FvVF8HLhenN5ElZg+IXPq9TiPj67PNVmv68OkATTFpWt3HAM/vcjyEpRZ1AObhZEioag6kL0e2bsMTUhjzxv9TjAI15RGG8K4W2CzuwMJXgwniikfh+xL32Kk8+y6Ku0LVMmuamETlVlIbhvyQtrfSiagVikoxj0TeroF+sJLhY=
- Delivered-to: dclug@xxxxxxxxxxxxxxxxxxxxx
- Dkim-signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=dcglug.org.uk; s=1649667962; h=Sender:Content-Transfer-Encoding: Content-Type:Reply-To:List-Subscribe:List-Help:List-Post:List-Unsubscribe: List-Id:Subject:MIME-Version:References:In-Reply-To:Message-ID:To:From:Date: Cc:Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Owner:List-Archive; bh=2F58+S74pp65BOPMltG2+UlBxZKf9F2fAla7Y0PKZfs=; b=Didj3jJOWlMjJ0MjNCseGRiwpe jD6xRUTmxuuH/X00N2H1nwvRGI340qkS1Vk2aQdcwgJAMPuEPCg1NUpCBcYzaMsFTMqV2c/bzRj8i XlTDpv7E9zehg6FSyNhn7b5/wxEvjK/Y4KgS/2rfc6+UMWZlzgUbSX3EmtoLBNSNrbAg=;
- Dkim-signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; t=1657636383; s=dkim; d=mdvthu.com; i=mark@xxxxxxxxxx; h=Date:Date:From:From:To:To:Cc:Cc:Message-ID:In-Reply-To:References:Subject:Subject:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-Id:Reply-To; bh=XJQprk1wks2xiEznjX8kJW/Gab4hWK08VJ4R3tE+0Ws=; b=RxB/SWJO/EumpEVmTVz6wI473Oh92YNggN4MgurBb34fs99t5BL9ELF4i0SYMVV6 5VELTLJwlB/GfZI4zQYpZKCvCueZNT426X1SWGrp7aiWvuAUYLWq0GlDiblxSRlIN+0 xSeq3wSdKmoqHd+3o0GPNJ6KlGeiAMtXjgnZ9u+c=
> > I have had a little play with BASE, set up a basic schema, linked tables.
> > I am however much happier being led through the next steps rather than wading
> > and
> > fumbling through the documentation...!
> >
> >
> A somewhat academic question, but how to you (or you B.i.L.) propose to interface
> a
> LO Base database with QGIs, where it is likely to expect a more standard RDBMS
> like
> MySQL/MariaDB or PostGresql (or even sqlite!)?
One way to achieve this would be to set up LibreOffice Base as a frontend to a RDBMS
backend. Re backend database servers, I would highly recommend Postgres but MariaDB
is also well regarded. This approach would have the benefit of allowing you to
develop the database schema without initially having much SQL knowledge but would
give you the benefits of an industry standard backend database.
On a slightly related note, I would highly recommend the SQL Zoo tutorials
(https://sqlzoo.net/wiki/SQL_Tutorial) if anyone is looking to progress their DB
knowledge.
Sorry I can't help you with your commercial job: I might have limited time to
provide advice via the list or off list if specific pointers are required.
Best wishes
Mark
--
The Mailing List for the Devon & Cornwall LUG
https://mailman.dcglug.org.uk/listinfo/list
FAQ: https://www.dcglug.org.uk/faq/